Quality Control

[duluter]

Hi, everyone.

I wonder if people could share their experiences with ensuring quality control in data entry.

Specifically, I have a database that office staff enter work order data into. I want to make sure that all of the work orders have been entered correctly. They are usually entering them from a hardcopy of the work order agreement (which may be hand written notes from a meeting with the client).

Here is my thought for a quality control procedure:

1. Staff member #1 enters the work order into the database from the hardcopy.
2. At a later time, staff member #2 (SM2) opens a special form on the database that only shows non-QCed work orders. SM2 compares the work order details to the original hard copy. If everything looks good, they click the "QC Complete" button and move on to the next un-QCed work order.

To implement the above, I was planning on having a yes/no field in the work orders table called "IsQCed". This field gets checked when SM2 clicks the "QC Complete" button.

Seems pretty good to me, but maybe some of you have better methods?


Thanks,

Duluter

 

[HiTechCoach]

A Yes/no field is not very informative.

I would use a Date/Time data type field ("QC Complete Date"). When completed, stamp with Now() (date and Time). I would also use a field for the User ID.


I then calculate the "IsQCed" as a Yes/No value as needed.

Example in a query:

IsQCed: IsDate([QC_Complete_Date])

or

IsQCed: Not IsNull([QC_Complete_Date])


Now you can tell not only if, but exactly when it was actually done.

 

[duluter]

Good advice, HiTech. Thanks!


Duluter