With all large database systems, it is not possible to enforce all the business rules through referential integrity and data entry validation. I've found it's useful to have a set of Queries that check the data integrity. This gives confidence to everyone in the database.
This code automates the running of those queries and for those queries that return records (potential problems), it emails the details to a designated person.

There's flags for Weekly and Monthly processing, but the process could be run at any interval.

Demo of Audit Queries [arriving soon]
Forms and Code [arriving soon]