Form using Students & Classes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with a Students and Classes table along with the
Many-to-Many table called StudentsClasses.

I want to create a form where I can go in and list if a student was
present during a particular day. So what I need is a form that displays the
class with the appropriate session along with all the students' names. Next
to the students' names I am thinking I have checkboxes for each class time?

I think I have my thought process correct, but I don't know how to do this
in Access.

Any help you can provide me would be much appreciated.
 
Let's start with the database design. You never have many to many relations.
Logically, yes, but physically, no. Any time you truly have a many to many
situation, you have to design a table that sits between the two to resolve
the many-to-many.
This is not one of these situations.
What you need:

1. Class Table:
Type of Class
Any other info you need to know specific to the class

2. A Session table: (Child of Class - related by Class)
Class
Session
Date of Session
Time of Session
Location (or any other info you need to know about the session)

3. A Student Attendance table:(Child of Session - related by Class & Session)
Class
Session
Student
Present

4. A Student Table:(Child of Session - related by Class & Session & Student)
Student Name
Any other info you need about a student

This will require a form and subforms.
Form for the class & session - This should be a query to return the class
and session info.

Sub Form for Attendance - This should be a datasheet showing all the
students assigned to the class and session. Your Present field can be a
check box.

You also need a form/subform to set up a Class and its sessions.
You also need a form to enter student info.

Good Luck
 
Back
Top