Thanks for you input Jason.
Here's what I would do salaroche , if I were to record the attendance of a class for a year.
Each day (or session) , have a form as described earlier, to log the attendance of the class, by date, checking attendance against each student name.
(with a class of 30, for example, this would insert up to 30 rows into your attendance table, but you only need to do it once per session.
Over time, you build up the attendance history of each student.
You could then query this attendance table, filtering by student name or date parameters or whatever other criteria you need, to find out who attended and when.
Hope this helps