student absence database in Access

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

 

[Duane Hookom]

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

 

[J M Vincent]

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

 

[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