Database Answers The Beautiful City of Zurich, Switzerland (Click for Zurich Web Site)
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Skills Tracking 
Back to the Data Model
Subject: Skills Tracker database in Access 2007

Question: I have started building a skills tracker database and I already know I need to start over from scratch.

The employees need to be able to enter their name and select areas of performance.

They need to be able to enter for each area of performance a skill level either 0 for no skill, 1 for novice so on
ans so forth.

There may be 20 or areas of performance so there will be a one to many relationship for each employee.

when new projects come in I need to be able to get a report that shows who has the skill to do the project.

I want to be able to print any employee etc.

A. The Things of Interest are :-
A.1 Areas of Performance
A.2 Employees
A.3 Projects
A.4 Skill Levels
A.5 Others to be determined

B. How are they related ?
   B.1 To be determined

Barry Williams

August 26th. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map