Training

[Guest]

Hi guys......
I am trying to design this database to capture the different trainings that
this organization does. What I am stuck on is how to create it so that it
will Track each employees training under different categories...For example

Ransom had an initial training in Sexual Harassment and a quarterly training
on mandated reporting.....so when I run my report I will just see the dates
of training and the type of training I had, ie initial in sexual harassment
or quarterly in mandated reporting or even an annaul training in employee
practices....HELP..my brain hurts......

 

[Jason Lepack]

You require three tables at least.

The first is the employees table. This tracks all the information that
is specific to that employee. Name, DOB, SSN, etc.

The second is the Training Elements table. This has a list of all the
training items and details that are specific to those.

The third is the Training Matrix. This table will have at least three
or four fields but probably no more. The fields will be the employeeID
(primary key from employee table), trainingID (Primary key from
training elements table), and a date. Every time that an employee is
trained or retrained in a task a new record gets added to this table.

So at any point if you wanted to see what Joe Blow was trained in you
could run a query using these three tables. Set the criteria for Name
to "Joe Blow", include the date from the Matrix, and the Training
Element Name and voila.

Cheers,
Jason Lepack

 

[Guest]

THANK YOU....I was just getting ready to create a training elements field and
go from there.....I will keep you posted ...and bug you for more help if
needed.....