Access beginner, Database design help!!!!

[SFCMatthews]

I have to track companies, employees and their training they have to attend depending on what category they fall in. (CAT I, CAT II...)
Company can have many employees and employees can only have one company.
A Company can only fall into one Category, but an employ can fall into
its own Category within the company. (Company CAT I, Employ CAT II)
employees can have many training event and training events can have many employs.
I need to be able to take a sign in roster and give a employ credit for attending a training event.
There are many training events that employs have to attend depending on the category a employ falls into.
I also have to track the training task and if it is active or it is no longer a requirement

 

[jdraw]

What have you done so far?
Do you have a data model?

See the first few topics here
Normalization and Entity Relationship Diagramming
http://www.rogersaccesslibrary.com/forum/topic238.html

 

[SFCMatthews]

Well I have;
tblCompany (CompanyID, CompanyName, )
tblEmployee (EmployeeID(SSN), fk_CompanyID, Name, JobPosition, AttendedTraining)
tblTaskList (TaskListID, TaskTitle, TaskCondition, TaskStandards, TaskRef, MaxDAys)
tblTraining (join table for tbltaskList and tblEmployee m:m relationship) (TrainingId, fk_TaskListID, fk_EmployeeID, TrainingDate TrainingComplete)
Any Help will be much appreciated.

 

[jdraw]

see post #4 here for some ideas on the table set up and "roster" vs "attendance"

http://www.accessforums.net/showthr...-the-percentage-of-attendance-Register-System

This isn't exactly the issue you have, but the concepts/ideas are similar (in my view).