Training database

Is there any way to put this into plain english I am much better at visual
instruction, I to am trying to build a training data base that can generate
reports of who has been trained and be able to assign certain training
modules to certain job functions. Here is what I want. 1. A list of employees,
what location they work at, what they have been trained on, what they still
need to be trained
on, who trained them, when they were trained, and when they are due to be
retrained. It would be nice to be able to have several employees enrolled in
every class. I have tables set up as follows

tbl 1. employee list (all employees)
Emp ID (primary key)
all pertinent employee info address,name,city,state etc.
tbl 2. locations (all locations over 60)
location code (primary key)
all pertinent info address, manager, etc.
tbl 3. training modules (all training offered)
module code (primary key)
module name
instructor id (im thinking i dont need this as all instructors can
teach all the training)
tbl 4. training sessions
session id (primary code)
module name
start date
end date
instructor id
test score
employee id
location code (not sure if I need this here)
module code
training man hours
tbl 5. Instructors
instructor id (primary key)
instructor name
phone #
tbl 6. job functions
id (primary key) auto number
job name
tbl 7. completed training (called students & classes in CRM templat)
completed class id (primary key)
employee id
module code
grade
tbl 8. results (not sure if needed but it was in the classroom mgmt template)
looks redundant to me
results id
employee id
session id
grade

I am unsure of how to set up the relationships to the tables correctly and
reports and querys. I
would like to use the structure in the classroom management and Events
template. any
help would be appreciated. And no I do not want to purchase one. I want to
learn how to build it.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1