Setting up a database for training

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a database for 6 different types of training that must be taken by all
members of a purchase card program. Some training must be taken annually,
some bi-annually, some 1-time only. I want to show which members have taken
what training, and when they are due to take it again. I am at a loss as to
how to design the tables to reflect all the dates, etc. (I realize I will
probably have to use queries to show when training is due again) I would like
have this all in one table, but it seems pretty difficult. Would I be better
off designing a table for each type of training, then connecting them with a
query? Can anyone help? Thanks.
 
All in one table is completely inadequate.

To get you started, you will need at least these tables:

Trainee: one record for each person
Training: one record for each type of training
Course: one record for each time a training course is offerred.
Enrolment: one record for each person enrolled in a course.

If you want to track who attended each lecture for the course, and whether
they completed the assessments and graduated from the course, you will need
more tables.
 
Back
Top