G Guest Apr 17, 2007 #1 How do I set up a one teacher use, multiple class, 3 lessons of different durations per week for 10 weeks database?
How do I set up a one teacher use, multiple class, 3 lessons of different durations per week for 10 weeks database?
G Guest Apr 17, 2007 #2 Start by creating more complete requirements. Then build your normalized tables. Then build your queries, forms, and reports.
Start by creating more complete requirements. Then build your normalized tables. Then build your queries, forms, and reports.
G Guest Apr 18, 2007 #3 I guess my problem is selecting the correct entities to create normalised tables. The rest is fine.
G Guest Apr 18, 2007 #4 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
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
