Asked By Jori via AccessMonster.com
21-Nov-09 07:31 AM
I am a novice Access user. I would like to set up my current training
database in the most efficient way to run reports showing which employee
needs what training classes and by what date. I am basically having a hard
time deciding when I should have data in a separate table or generate it from
a query. I am afraid I am duplicating information where it should not be.
My goal is to run reports stating Employee A needs classes 1, 2, 3, 6, 9.
Class 1 is due by 12/31/09. The problem is I have employees characterized by
job title (e.g., Engineer) who need class 1 & 2 but not the rest and so on.
I'd prefer to make the training classes tied to the individual, not the job
description. Otherwise I have to create numerous job descriptions (Eng. A,
Eng. B, etc.). As I add new classes the original "training requirements for
Eng. A) is now not applicable to that entire group of folks so then I have to
re-do that group (example: the person may now need effective communications
training but the rest of the folks in Eng. A group do not).
I have the following separate tables so far:
Table 1 (Employee table): EE ID#, First, Last Name, Active (yes/no box),
training category
Table 2 (Department numbers): Autonumber, Dept #
Table 3 (Classes): Class Number, Class Name, Req. Frequency,
Table 4 (Class Attendance): EE ID#, Class Number, Date Attended, Date Expired
Initially, I added "training categories" to the employee table and then made
a separate table as follows:
Table 5 (Training Category Directory): TrainingCategory#, Training category
(from Table 1), and then I have a bunch of yes/no columns defining each
training category (maintenance would have Electrical, Compressed Gas, etc.).
This was so I could remember how to define the training categories.
Bottom line, I want to know the correct way to create a training needs
assessment by individual in Access.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200911/1