I doubt you will be able to achieve that desing aim given the nature of the business problem
Im expecting you to have a list of employees
a list of courses
list of which curses an employee is taking
when you get to recording attendance you need to record which employees attended a specific course.
so the problem, is how do you know which employees have attended a specific course?
using Access you'd probably pull up the employees in a form on a one by one row. there is njothign stopping you clicking to identify that an employee has attended the course.
if you wanted to say, ferisntace that all employees registered for that course had attended the course then you coudl poiut a button on the form to say such.
that button woudl then trigger a piece code which updtaed the underlying recordset.
providing you can identify what rows should be processed then you can do that processing using a 'WHERE' clause. the WHERE clause acts as a filter and says limoit the action to rows that match the following criteria
I'd rather be riding on the Tiger 800 or the Norton