I need help with setting up an attendance register

[Brucear]

I have 10 classes that I see for 1, 2 or 3 hours per week.
Each class has about 30 students.
I have set up tables for the student details (FirstName, LastName,
ClassGroup, etc (personal details, etc....). What I want to do is set up an
attendance register that brings up the classes (determined by the day of the
week), capture the date, record who was present, absent (or Late but
attended) and then append this data to the master attendance table.
At the moment, I just cant see the "wood for the trees". Can anyone give me
a few pointers?

 

[Klatuu]

Hopefully you will have the following tables:
Student - Info on each student is will be taking any class
Class - Info on each class you offer
Session - One record for each time a class is offered, (date, time,
location, etc)
Attendance - Intersection of Student and Session.
Should have:
StudentID
ClassID
SessionID
Status (attended, late, absent, left early, etc)

Now you can create a query based on the Attendance table. This should be
the record source for your form. You will probably want to include the
Student and Class tables so you will have the names for each. Now you will be
able to view, modify, add, or delete records for the Session table.

 

[Brucear]

Sorry about that - I realised the minute I sent the post that I had forgotten
to include the rest of the tables! Age catches up!
I have the following tables set up:
Student data (Name, class, personal details.....)
Classes
ClassDayPeriod
TeachingDays
I am just having a little difficulty putting it all together.
How do I creat the intersection of student and session?
Thanks!

 

[Klatuu]

It would be an additional table as I described in my previous post.
What are the ClassDayPeriod and TeachingDays tables for?

 

[Brucear]

The ClassDayPeriod table shows what classes I have on each day and the time
slot allocated is call the Period.
The Teaching days table lists all the days we are actually at school.

 

[Klatuu]

Okay, neither of those would be involved in this.

 

[Brucear]

I don't know enough to be able to comment here.
Can you give me an example of the fields that would be in Session?
Can you do the same for Status?
Regards

 

[Klatuu]

This would be a layout for the table:
Session - One record for each time a class is offered, (date, time,
location, etc)
Not knowing for sure how your ClassDayPeriod is layed out, it may be that it
would be related to the Attendance table.
Attendance - Intersection of Student and Session.
Should have:
AttendanceID (primary key - autonumber)
ClassDayPeriodID (foreign key - primary key of ClassDayPeriod)
StudentID (foreign key - primary key of Student table)
Status (attended, late, absent, left early, etc)

The Status field will tell you whether the student attended the class that
day, was late, was absent, and whatever other info you want to take for the
students.