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.)  To download the Data Model click here.
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
...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
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: tlkpActivityCodes.
The difficult I do immediately, the impossible takes a little bit longer.
Data Models
Tips (Main)
Home
Templates
Restaurant Reservations
Property Management
DVD's
Jobs (or Work Orders)
Complaints
Products (Shoes of Clothing)
Tasks
Publications
Clubs (or Associations)
Purchase Order with Inventory
Hotel Bookings
Real Estate
Recipes
Grocery List Maker
Recipes with Grocery List Maker
Inspections
Parking Lot
Appointments (i.e. Salon)
Damage Investigations
Call Center
Access Basics
Data Modeling 101
Utter Access - Design Strategies
Naming Conventions
Modeling Human Relationships
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.