Setting up a database for training

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jan Buckley" wrote in message
...
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.