I'm attempting to put together a Training Records database that will keep track of our employees' skill sets.
Essentially, I want to keep track of each employee individually with a list of all possible skill sets, and levels of those skills (i.e. Untrained/Unqualified, In-Training, Qualified, Certified). The difference between Qualifed and Certified is that to be "certified" they are evaluated, and it would be nice to put the date they are "certified" for that particular task.
One of the other uses would be that if a certain job where to be coming up, we could browse "reports" to see which technicians are qualifed and/or certified for that specific skill.
And, of course, to be able to print out that one employee's overall "training record" with all skills with their levels.
So I ask for a little guidance and assistance if you will. I'm assuming that I would build a table for the employees, with items such as first/last name, employee #, contact info, etc. Another table would have "the list" of all the different skill sets.
Any help or guidance?
Thanks!