The difficult I do immediately, the impossible takes a little bit longer.
Data Model ~ Training with Attendance...
This data model was designed to handle tracking of Training and/or Attendance and/or Classes. (Note, there only tables included in this database the balance is up to you! Some tables contain sample data, see below.)
...have exams to grade
...have many Students
...will be absent
...take multiple Courses
...instruct one or more Courses
Download Sample (Access 2007 and up and an Unzipping program needed)
...have attendance to track
...take exams and be graded
...have a limited number of *seats*
...happen in more than one Semester
...be taught by an Instructor
...may be assigned via Department
...will have multiple Activities
I set up the tables so that after logging in the Instructor would have access to their Courses and their Students but will still be able to see all Students. (If you want to avoid the typical log in you can use the Instructors Network ID which you could capture silently.) It might also be a good idea to set up the Main Menu with an Administrative area to handle the *Look up* tables, ie: tblActivityCodes.