Help with Multiple Class Sign-In

[JeremySun]

All, I'm really new with access. I have Access 2010. I am wanting to create a sign-in sheet for the 6 classes I teach. Where I am lost is, I know I need one table for student information, but will I need 6 tables for the classes? What I'm looking for in the end is to be able to report on how many students I taught in each class, Report on the class(es) that the student has attended as well as the dates of the class. Any guidance will help. Thank you in advance.

 

[welshgasman]

No.
I believe you will need three tables.
tblClasses
tblStudent
tblClassStudent

The tblClassStudent is the one that will do all the work. From that you select the class, and the user and each record will link class and student.

So tblClasses
ClassID - Primary key
ClassName

tblStudent - Primary key
StudentID
StudentFName
StudentLName

tblClassStudent
ClassStudentID - Primary key
ClassID - Foreign key
StudentID - Foreign key
AttendedDate

Add any extra fields that you require for each table.

I would have combo boxes for both Class and Student. Source for each comes from their respective tables.
Populate the Class and Student tables with simple forms bound to each table.

HTH