Another component of this never-ending attendance system must allow staff to tick off who attended their sessions. Until now they have been using a Google form so I would like to replicate this somehow.

Generally they will fill in the sessions of that week starting with the week beginning entered at the top of form.

I envision a continuous form showing the days and then subjects on each day and then students registered for these sessions.

Two unbound controls will flag where students have attended and if there are any relevant notes to include. (This can quite simply be added to the session log with some VBA). My trouble is that I can't figure out how to best present the data to show the sessions of the week - something like the structure below.

Also enclosed database with my started (messed-up) form to look at!

Ps. This is the relationship between sessions - in case it is not simple to understand.

Generally they will fill in the sessions of that week starting with the week beginning entered at the top of form.

I envision a continuous form showing the days and then subjects on each day and then students registered for these sessions.

Two unbound controls will flag where students have attended and if there are any relevant notes to include. (This can quite simply be added to the session log with some VBA). My trouble is that I can't figure out how to best present the data to show the sessions of the week - something like the structure below.

Also enclosed database with my started (messed-up) form to look at!

Ps. This is the relationship between sessions - in case it is not simple to understand.