Make something (form, query with parameters, VBA, that's up to you) that fills a 'work table' with the students from the specified class or year group from the student table. Personally I would use a form to fill in the needed data, with an OK button that executes one or more queries linked to the data entered on the form (forms!myform!myfield). The table should consist of identification (student number, name, activity code and a yes-no field filled with no - I don't like Boolean fields with null in it).
Make a form that's based on this table (or, better, on a query with some specified sort order based on this table) and uses a multi-record view.
When all the relevant checkboxes (the representation on the screen of the yes-no-fields) are checked, there should be an OK-button on the form that copies the contents of this table (checked records only!) to the big history table used for analysis and reporting, then empties the work table to make it ready for the next activity. A query (or, equivalently, a SQL-statement) suffices for both.
Of course, the thing you write to fill the work table should start with emptying it also. That's fail-safe programming.
So you need only rather basic Access skills: queries and forms with buttons and some VBA to check the data entered and call the SQL's or queries.
You might want to include a single record add-to-history-table form in your application for late attendees.
It sounds simple. I could make something good-looking and reliable in a about a day, given exact and detailed requirements, I think. This, of course, does NOT include the maintenance of the students file, the maintenance of the clubs/activities and the analysis and report parts of the application, just the screen(s) used in the after school clubs.
Forum rules don't allow me to solicit for paid work, so you've got to do it yourself or find someone who can do it for you.
Hope this helps.
Kees
okay. i need some help with a database (suprise suprise) im being asked to create some kind of Attendance register for after school clubs at my work place. the db needs to pull up a list of students names by searching by form class or year group (i can do that bit) and it needs to bring up a tick box next to every students name to be ticked if theyre present. the data needs to be recorded so that it can be found out who went to what club on what day, how many people overall attended clubs on specified dates and what clubs are most popular.
basically im stumped...
any Suggestions ???

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic