attendance

[Bill H.]

I'm trying to develope an application that can track attendance at various
classes of varying times and dates. So, looking for some ideas.

I've got the tables for the classes and their dates (start/stop, and dates
for each meeting, which can change, be added to or removed from the original
schedule). Also have registration tables showing which student is
registered for what class.

I'd like to be able to call up a course from the course list, and see all
those registered, and be able to mark attendance, like in a spreadsheet,
where the names are on the left, and each column on the right represents
each meeting date. If they come, they check a checkmark, if not, no
checkmark.

And of course a way to handle those that register after class has started
(so they start showing up in the attendance form).

Thanks.

 

[Duane Hookom]

This all depends on your table structure(s). Assuming you have a main form
with the class information and a subform with separate records for each date
of the class. You could run an append query that would add records to an
attendance table of Class, Dates, and StudentIDs. You can then delete the
students who didn't attend the class.