Help in Student Absence Form

[Nokia N93]

Good Day everyone
I have a small school for training
Each student has more than one class
i want a tracking way to track the absence of each student in each class
And then a daily and weekly report for each student to be shown

I did the tables and relations for this, but i don't know it is true or not
CAn you help me please?
and what do you think the forms should be ?

attached is the file i made
StudentAttendance.zip

thanks in advance

[ranman256]

You need tblStudentClassAttend, to show his attendance in the tblStudentClass (simpler name)
tblStudentClass fields:
------------
StudentClassID
StudentID
ScheduleID

tblStudentClassAttend fields:
------------
StudentClassID
DateOfClass
Present

tStudent	student info: name,address,city
tClasses	classes taught
tClassSched:	classes taught for the year and their date/time taught
tStudentClass:	Classes a student takes
tStudentClassAttend:	attendance for the class a student takes

[cbende2]

Hi Nokia,

I created a little DB for fun, let me know if I can help anymore.

SchoolAttendance.zip

[Nokia N93]

thanks alot ranman256

[Nokia N93]

Hi Nokia,

I created a little DB for fun, let me know if I can help anymore.

SchoolAttendance.zip

I love little Db for fun , thanks cbende2 but the file didn't open ( Unrecognized database format) I don't know WHY ?