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)

 

[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

 

[mratchford]

John Gentile,
'In order to do the relationships, you need to determine (i.e. on paper) the business rules for your application. This requires a bit of relational db knowledge. For example, can each employee be working on many work sections? can each work section be related to many employees? can each employee be working on one competency at a time or many at a time? can a work section belong to one competency? many competencies? In other words, you need to establish the 1-M or M-M relationships. Then you invoke the 'relationships' tool of Access that will help you define the relationships among the tables, etc.

Well, it's not that trivial, however, that is how it works.

Melva.