Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / June 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cynthia P. - 21 Jun 2006 23:09 GMT
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 - 21 Jun 2006 23:50 GMT
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.

> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.