Need to track and report when training is done and due

[JaciSiehl]

I have to track safety training and have inherited an Excel program - which is ok for tracking but not for planning. I have 2 companies that use the same training. The variables are employees, various subjects, date a subject is completed, and various required time frames (annual, bi-annual, as needed, etc). Ultimately, I want to report by employee, by company, by subject, or by what is due at a particular time. If I can get my tables & queries set I know I can do the reporting, but what I am having trouble with is where to enter the date a subject is done and how to calculate when it is due again so I can run the report on each person, subject, or as a company what is due.

My tables are:

EE
ID, Name, DateStart, DateTerm, Company

Subject
ID, Title, Frequency (drop list)

Frequency
UponHire, Annual, 12Mo, Bi-Annual, 3Yrs, AsNeeded, and Heat



Thanks,

[June7]

Do you care about history of training or just want the latest attendance on record?

Need another table for records that associate employee with training subject.

EmployeTraining
EmployeeID
TrainingID
AttendDate

That will document history of training attended.

If all employees must have the same training, db is relatively simple. However, if requirements vary per employee, gets complicated. This type of db has been topic of several threads. Did you search?

[JaciSiehl]

Unfortunately, I do have to keep track of history. 99% of the training will be general information for everyone - but there will be some things that only some people need, and some subjects are not required but fall into the "other safety training" but we do need to be specific.

I did a search on the threads but did not find this topic under the searches I was doing. I'll try again and I will add the date table and see if I can massage it to do more than Excel does.....thanks

[June7]

So now maybe you need another table that identifies the training required for each employee. Is the training required because of job description? Or will training program be tailored for each employee?