Verifying audit data

You should always verify the completeness and validity of the data you are going to work with before performing any analytical work. Even a small amount of invalid data in a table can invalidate all your subsequent data analysis.

Operation	Description
Verify	Tests the validity of values in character, numeric, and datetime fields
Count	Counts the number of records in a table You can compare the result to a control count
Total	Totals one or more numeric fields You can compare the result to control totals