Attendance

[Guest]

I am designing a students' attendance system using Microsoft Access
My current design is

tbl_Student
______________________
Student_ID(Primary Key
Nam

tbl_Attendanc
______________________
Student_ID(Foreign Key
Dat

What I would like to do is store attendance information for students in my classes. I would like to be able to do this with a form which displays the students names in a list for a particular class with an input for DATE and a checkbox input for present(tick)/absent(blank)

What is the best structure for the tables and what should the relationships be and how can I make a checkbox input date information into a particular record field

Please help
Thank you

Aaron

 

[Arvin Meyer]

You may wish to also add the class information, thusly:

tbl_Students
_______________________
Student_ID(Primary Key)
First_Name
Last_Name

tbl_Attendance
_______________________
Student_ID(Primary Key)
Class_ID(Primary Key)

tbl_Classes
_______________________
Class_ID(Primary Key)
Date

You shouldn't need a checkbox, since if there is no record of a student for
that date, that student was absent.

I am designing a students' attendance system using Microsoft Access.
My current design is:

tbl_Students
_______________________
Student_ID(Primary Key)
Name


tbl_Attendance
_______________________
Student_ID(Foreign Key)
Date

What I would like to do is store attendance information for students in my

classes. I would like to be able to do this with a form which displays the
students names in a list for a particular class with an input for DATE and a
checkbox input for present(tick)/absent(blank).

What is the best structure for the tables and what should the

relationships be and how can I make a checkbox input date information into a
particular record field?

 

[Guest]

Thanks for the advice
The reason I need the checkbox is to mark students that are absent/present and later present it in a list form containing all the student names (whether they are absent/present), their attendance status(absent/present) and the date(at the headings)
Please advice
Thank you.

 

[Mike Abair]

Oh no what was the answer to you question I am doing the
same sort of attendance. PLease help

-----Original Message-----
Thanks for the advice.
The reason I need the checkbox is to mark students that

are absent/present and later present it in a list form
containing all the student names (whether they are
absent/present), their attendance status(absent/present)
and the date(at the headings).