Training records

[David French]

I am my company's Computer Systems Trainer.
As such I teach a variety of Classes.
I will teach these classes many times at our different offices.
These same classes are repeated and held on scheduled dates.
Many employees will register for a particular class in a particular location
held on a particular date.
This is one part of the database I'd like to create.
I'd like to have both the ability to have a form that shows each class and
the students that attended and either separately or from that form be able
to show a form of the student and the classes they have taken. Perhaps
tabbed subforms for classes and the tests.

The other part could get even more complex than what I have described above.

Each employee has a job description.
That Job Description has a set of computer skills standards assigned to it.
When an employee is assigned that Job there is a set of tests to determine
their current skill set.
Once completed, these tests will determine what classes they should take.
*** This is what I think will be complicated! ***
If that employee changes jobs, I want the tests and the classes taken to
stay with the employee...NOT the Job Description.

If anyone has a database created that closely resembles this I'd be
interested in it.
I'd really rather not recreate the wheel.

Dave French
(e-mail address removed)

 

[Allen Browne]

Hi David.

I did one of these recently, and here's the relationships I used:
http://allenbrowne.com/temp/StaffTrack.jpg

Essentially, one staff member can have many positions (over time.)
One positon can require multiple skills
One skill can be needed in different positions.
One skill can have many training programs (over time.)
One staff member can attend many training programs.

Armed with that information, you can derive the skills that a staff member
should have, and determine whether they have attended a training session for
that skill recently.

Obviously there's still a lot of work for you to do to develop that, but
hopefully it gets you on the right track for both parts of your question.

 

[David French]

Allen,
Thank you so much for your reply.
I am trying something different with my training records so I hope this will
be less taxing on my brain.

Here it is:
I have many tests.
tblTests
Word 1
Word 2
Excel 1
Excel 2
Each of these have many questions so I created questions table.
Multiple-Field Primary Key
TestID-TestQuestion and then QuestionDetail is the final field.

Now here's the request.
Many employees may take the same test or many tests multiple times.
I have attempted to create a results table but i'm not sure I have it right.
I know I will need to get the EmpID in there but I think I may have fouled
things up by using the Multi-Field PK.
Help if you can.

Dave French

 

[Allen Browne]

Yes, the test will be further tables, in addition to those suggested
previously.

You will have a Test table (one record per test) with fields:
TestID Autonum primary key
TextName Text name of this test.

Then a TestQuestion table (one record for each question in a test:
TestID Number relates to Test.TestID
QuestionID Number order of questions in this test.
QuestionText Text the text of the question.

Then an EmployeeTest table (one record each time an employee sits a test):
EmployeeTestID AutoNum primary key
EmployeeID Number relates to Employee.EmployeeID
TestID Number relates to Test.TestID
TestDate Date/Time the date this employee sat this test.

Then an EmployeeTestAns table (one record for each answer given in an
employeetest):
EmployeeTestID Number relates to EmployeeTest.EmployeeTestID
QuestionID Number relates to Test.QuestionID
Answer ??? the answer given to the question.
Score Number 0 for wrong answer, or the value of the
answer.

If the test consists of multiple-choice questions, there could also be a
TestQuestionAnswer table.

For an example of this kind of database, it would be similar to Duane
Hoolom's sample database for handling surveys. Download from:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'