Query Checks for Date in Column Header

I've got an attendance form set up for each of my church's Sunday School classes. I was wondering if it would be possible to set it up so that their is a check box for each Sunday of the current month, and then each week when I add the attendance to the records, the query would look at each check and add it to the attendance table (if not previously added). I'm just trying to think of the future and if someone else takes my place I want to make sure they can complete this task even if they've only had the bare minimum experience with computers.



Is that possible?



I would prefer to do this in Macros (haven't touched coding in Access yet).



Thanks in advance (and sorry for the run-on).

Query Checks for Date in Column Header