Training Certification tracking database

[Guest]

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.

 

[strive4peace]

Hi Cynthia,

you will need a table for Employees, a table for
Certifications, and a table for EmployeeCertifications

in the EmployeeCertifications table, you will have EmpCertID
(autonumber), EmployeeID, long integer, related to
EmployeeID autonumber in employees), and CertID, long
integer, related to CertID autonumber in Certifications) --
in this table, you will also store Date1 (start date for
certification) and Date2 (end date for certification)

If certain certifications are required for particular types
of employees, you will need to track the EmpTypeID in
Employees and have an EmployeeTypes table where EmpTypeID is
an autonumber. You will also need a table for
EmployeeTypeCertifications with EmpTypeCertID (autonumber),
EmpTypeID (long integer) and CertID (long integer)


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*