The difficult I do immediately, the impossible takes a little bit longer.

Data Models

Data Model ~ Training with Attendance...
Purpose...
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.)
Business Rules...

...have exams to grade

Students will...

...have many Students

...will be absent

...take multiple Courses

Main Entities...

Instructors

Students

...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

Instructors will...

Courses

Courses will...

...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

Design Tips...

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.

aaaaaaaaaaaaiii