Form using Students & Classes

[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.

 

[Guest]

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 tableChild of Session - related by Class & Session)
Class
Session
Student
Present

4. A Student TableChild 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