Setting up a database for training

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

 

[Allen Browne]

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.