Tracking competencies with Access 2007

[John Gentile]

I'm trying to create a (I think) simple db to keep track of a list of
employees in different work sections and when they pass several
different competencies. The employees can take the competency tests
several time and will have to pass it yearly.
I created a list of: employees, work sections and competencies, but
can't figure out the relationships. Does anyone have a template that
might accomplish this small feat?
--
John Gentile MS, M(ASCP)
Laboratory Information Mgr.
VA Medical Center
Providence, RI
(e-mail address removed)

 

[Steve]

You need the following tables:

TblSection
SectionID
Section

TblEmployee
EmployeeID
FName
LName
SectionID
etc

TblCompetency
CompetencyID
Competency

TblEmployeeCompetency
EmployeeCompetencyID
EmployeeID
CompetencyID
DateTested
Passed (Yes/No)

Join all "ID" fields to the same "ID" field in the appropriate table.

Steve
(e-mail address removed)

 

[Fred]

John,

Your application looks both simple and specialized to you.

Posing it as a "template" question is probably the wrong route.

 

[Keith Wilby]

I'm trying to create a (I think) simple db to keep track of a list of
employees in different work sections and when they pass several different
competencies. The employees can take the competency tests several time and
will have to pass it yearly.
I created a list of: employees, work sections and competencies, but can't
figure out the relationships. Does anyone have a template that might
accomplish this small feat?

Any mileage in this for you:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

Keith.
www.keithwilby.co.uk