Data Reviewer will help you scrub or normalize your data.

It will assist you in:

• Seeing at a glance all distinct entries in any field.
• Seeing at a glance how many times all entries occur.
• Changing all forms of an entry (replace inconsistent entries) to a single form.
• Deleting (replace with nulls) any unneeded or undesired entries.

Click here to view image of Data Reviewer

Data Reviewer will help you understand the data in your database, by giving you a report which shows,

• how many entries in each field.
• what are the 5 most common entries in each field.
• how many times the most common entries occur.

Click here to view image of report

Data Reviewer will work on all tables in or linked to Access databases.

  This includes, but is not limited to the following types of tables.

• Microsoft Access
• Paradox
• dBase
• Microsoft FoxPro
• ODBC Databases (Including)

• Oracle
• Microsoft SQL Server
• Sybase

This page was last updated on 10/18/04.