If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tracking competencies with Access 2007
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 |
#2
|
|||
|
|||
Tracking competencies with Access 2007
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 "John Gentile" wrote in message news:2009102920463916807-yjgent@nospamcoxnet... 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 |
#3
|
|||
|
|||
Tracking competencies with Access 2007
John,
Your application looks both simple and specialized to you. Posing it as a "template" question is probably the wrong route. |
#4
|
|||
|
|||
Tracking competencies with Access 2007
"John Gentile" wrote in message
news:2009102920463916807-yjgent@nospamcoxnet... 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/f...osts.asp?TID=3 Keith. www.keithwilby.co.uk |
Thread Tools | |
Display Modes | |
|
|