Tracking Training Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently working on overhauling an existing database that is in part
tracking employee training, and this occasionally gets audited by an outside
company.

I am changing their form to have a checkbox to initiate a new training
requirement, when there is a revision to a regulation. I am looking for a
way to decimate the employees who have accomplished their training from a
delinquent training report possibly thru some query expressions. I know I
could do it by another checkbox, but I would like to not count on data entry
to enter that all the time when they are entering employee training data,
snce different people do the data entry. I have no accounting training, and
I was wondering if AR used some slick Macro, or query to match invoices to
payments that could be applied here? Or is there something else that will
work as well, and simply.

P.S. This is a less than one hundred employee company, and they do not want
to use employee numbers. . .
 
Your database may be audited to paper copy also.

You should not be using a checkbox for new training requirement but a new
record 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.
 
Thanks.

KARL DEWEY said:
Your database may be audited to paper copy also.

You should not be using a checkbox for new training requirement but a new
record 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.
Click to expand...
 
Back
Top