Tracking competencies with Access 2007


J

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)
 
Ad

Advertisements

F

Fred

John,

Your application looks both simple and specialized to you.

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

Keith Wilby

John Gentile said:
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
 
Ad

Advertisements

Joined
Jun 12, 2014
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top