Data Comparison Options

A variety of options are available for comparing data in tables and queries, and the results to generate.

Compare data in Microsoft Access tables and queries sequentially or with a unique idenfier or virtual key field
First of Five Tabs of Data Comparison Options

Options include:

  • Handling non-keyed tables and all queries by using the first field as a unique identifier
  • Comparing identical field names and types, or by field name only, or field order
  • How much to document for different memo fields
  • How to show differences in expanded or compact mode
  • Minimum numerical level of accuracy to define differences