Table Setup

[Guest]

I’ve been given the task of building an Access database to track quality
control for the employees in my department. Our department performs
various job functions (tasks) and each of these tasks has specific
requirements for quality, usually 5 or 6 specific items and the criteria for
quality is Yes it was done or No it was not. I’m concerned because each
task’s quality topics are different. I’m not sure how best to set up my
tables. Any help you can give me is certainly appreciated.

 

[Guest]

I have never heard of 'track quality control for the employees' only
productivity or performance. Productivity can be measured in parts per hour,
discounting rejects. If someone produced a perfect item but only one per day
then is that better than the guy that made 500 with 7 rejects?

You have QC of products or services but not people.

Maybe if you explained you method a little more then a scheme for tables and
data reduction could be devised.

 

[ploddinggaltn]

Hi Karl,

Let me try to explain this better. I have a group of people, they are
listed in tblEmployees. This department is responsible for various
functions, these functions are listed in tblTasks. Each task has a procedure
that includes numerous and various steps. These steps are either done
correctly or not done correctly. I'm not sure how to list the steps
associated with each task. Each task has approximately 12 steps and each
task has different steps associated with it. My list of steps for all tasks
is 132 different steps. Any ideas?

 

[Jeff Boyce]

Based on your description,

* you have a list of persons, a list of functions/tasks/procedures, and a
list that shows which steps are related to which function/task/procedure
* one function (task/procedure) can have many steps
* one person (and only one person) performs a complete
function/task/procedure (and hence, the related steps)
* that one person performs each related step correctly or incorrectly

One way to approach this using a relational database like Access would be
with tables like (untested):

tblPerson
PersonID
LName
...

tblTask
TaskID
TaskTitle
TaskDescription
...

trelTaskStep
TaskStepID
TaskID
StepTitle
StepDescription
...

trelAssignment
AssignmentID
PersonID
TaskStepID
AssignmentDate
CorrectlyPerformed (a Yes/No field)
...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP