How can I track employees and their Training Certs. in Access?

[Cynthia P.]

How can I track employees and their Training Certificates in Access? I work
in a Hospital and I need to track our Employees Training Certificate and the
expiration dates such as: competencies, certifications, licensure, training,
continued Education credits. Please advise.

 

[KARL DEWEY]

You might search the WEB for a template.

You need multiple tables.
Employee records with all the particulars.
Course with CourseID, Title, Requirement (OSHA, Management, etc.), Interval
(a zero for one-time, 1 for monthly, 12 for annually-12 months, etc.).
Class - ClassID, CourseID, Instructor, date, etc.
A junction table with EmployeeID and ClassID. Required checkbox (maybe
position not require training but sat in anyway)

Use a query to determine who is due by calculating interval months after
last class date for individual.

Your database may be audited to paper copy also. You should have a new
record for each training requirement and have a date field indicating when
the training was accomplished. With a date it is easy to go to training
attendance roster to find where the employee signed in. If OSHA is looking
at your training records you do not want the employee to be able to say they
did not receive the training.