student absence database in Access

J

J M Vincent

How do I set up a one teacher use, multiple class, 3 lessons of different
durations per week for 10 weeks database?
 
D

Duane Hookom

Start by creating more complete requirements. Then build your normalized
tables. Then build your queries, forms, and reports.
 
J

J M Vincent

I guess my problem is selecting the correct entities to create normalised
tables. The rest is fine.
 
D

Duane Hookom

I would expect the student absence table to have fields like:

tblStudentAbsence
==================
StudAbsID autonumber primary key
StudentID related to tblStudents.StudentID
AbsenceID related to tblAbsenceCodes.AbsenceID
AbsenceDate
AbsenceComment
 
Top