Access Employee Certification Database

Question

I am needing to build a database to track employee license and certifications. Does anyone know of a template that could be modified to meet my need? I am needing to be able to keep track of each employee's CPR certification, and state license certifications and would like to be able to set it up to alert me when they are nearing the expiration date for each certification. Any help with this will be greatly appreciated.

Answer 1

This should be a fairly easy database. If the only requirement is to track the license and certs. it can be done with three tables.

tblEmployees

EmpID (PK Autonumber)

Firstname

LastName

other info about employees tht you need to capture.

tblCerts

CertID (PK Autonumber)

CertName

ExpirationPeriod

tblEmpCerts

EmpCertID (PK autonumber)

EmpID (FK)

CertID (FK

LastDateCertified

You would use a form to enter the data and a query to caluclate the Expire date byt adding the EXpirationPeriod to the LastDateCertified.

Answer 2

There are quite a few databases here.