| | |
|
|
|
Attendance |
|---|
| message from =?Utf-8?B?QWFyb24=?= on 29 May 2004 |
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?
Please help!
Thank you.
Aaron
|
| Arvin Meyer replied to =?Utf-8?B?QWFyb24=?= on 29 May 2004 |
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.
"Aaron" <anonymous@discussions.microsoft.com> wrote in message
news:F7E3DC93-992D-4C2C-9CC6-8CEF33590F17@microsoft.com...
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).
relationships be and how can I make a checkbox input date information into a
particular record field?
|
| =?Utf-8?B?QWFyb24=?= replied to Arvin Meyer on 30 May 2004 |
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 replied to =?Utf-8?B?QWFyb24=?= on 2 Jun 2004 |
Oh no what was the answer to you question I am doing the
same sort of attendance. PLease help
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).
|
|
Archived message: Attendance (MS Access Forms)
