Tracking Training

[Bill HR Specialist]

I have a table of employees, I have a table of mandatory classes each employee must take, included in that table are classes that have to be done annually. I need to track what classes are needed to be completed for each employee. Now I have done this before but it was clunky and I know it can be more efficient. Part of my problems with my old system was if I was given a new mandatory class I would have to manually add it to each employee, I should be able to add it and it should show up on every employees mandatory list. Though I love to puzzle out things in access this one has taken me to long to come up with a better system so I am asking for any suggestions, thanks in advance!

 

[spikepl]

Your issue is not new. Using google you can search AWF like this:

site:www.access-programmers.co.uk YourSearchTerms

where search terms could be

training
GMP

Essentially, training requirements are normally bound to the specific position that an employee fills, but training history is bound to the employee. It becomes a little more tricky when the validity period of some training expires, or the same training has to be redone, because the given SOP has appeared in a new version.

 

[Rx_]

Spikepl - responded whilst I searched. He is absolutely right, it does get tricky for many reasons and it has been done before. That is why I was looking for a demo to show you examples.

http://www.databasedev.co.uk/student_courses_data_model.html
It is only a proposed data model (listed above) that might be of interest to you

Did a quick search to see if there was something free do download to give you an example. Did a small project like this in Graduate school in PASCAL. It is going to require at least one table for Students, another table for Courses, and a third table with 2 foreign keys for the first two.

But, during my search, came across these.
This is not a recommendation. But, it never hurts to review other people's demo before starting on your own project.

http://www.5schools.com/css/prod01.htm
Here is a MSAccess for Charter Schools student - class tracking.
It is probably overkill, but the documentation might be useful to you for table design.

Not a recommendation:
http://www.5schools.com/css/ If I was designing something for a company, it might be worth checking on the license fee. They claim the source code is included.
If it is $50 to $100 and you could modify the source code - it might be worth your time?

Just came across these licensed shareware:
http://www.sharewareconnection.com/software.php?list=Access+Student+Database
Have not idea about them. But, between the three, it looks like it has been done and packaged.