Table Setup

[SITCFanTN]

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.

 

[KARL DEWEY]

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.