Agee Software, Inc.

Data Integrity Form Special Features

Data integrity form to find and correct Microsoft Accesss errors - dupe, missing, orphaned, incorrect recs

Calc recounts problems in each query
Calc1 recounts problems with current query
SQL shows window with raw SQL of query
Each query describes problem in technical terms and suggests a fix
Sel selects problem recs for the query and opens form to show only those sel recs
Export problem recs to CSV, HTM, MDB, TXT or XLS
View shows problem recs read-only on screen
Fix uses SQL to resolve problems that can be fixed with a query

MS Access Data Integrity form with Fix button to correct data errors with SQL

Data integrity queries let you clean up data that may have been entered before complete information was available. Required fields stop workflow and missing and invalid data cause problems in reports.

Common Data Integrity Queries:

Missing related recs (Invoice without details)
Orphaned recs (Invoice without valid customer)
Duplicate recs (Contact recs with same name)
Dates out of expected range (Future date of birth)
Values out of expected range (High commission rate)
Similar recs (Business with similar names)
Incorrect calculated fields (Invoice total <> sum of details)
Missing files (PDF missing from archive)
Missing data (Phone or email missing)
Typos in converted data (smith not Smith)
Unused combo values (Make=Edsel)
Things to fix later (Race=Unknown)
Violation of policy (Listing Agent and Buyer Agent)