Table Field Definitions, Sorted by Field Name

This powerful report shows where and how each field in your Microsoft Access table is defined across multiple tables.

In this example, the data is sorted by field name (Address, Birth Date, CategoryID). Within each grouping, you can see the list of tables which with this field. For instance, there is an Address field in the Customers, Employees, and Suppliers tables.

The data here is identical to the Table Fields, Sorted by Table Name report, but is sorted by Field Name. This shows all the tables with identically named fields. This is a great tool for verifying consistency of field definitions. It can also help you find field names that are spelled slightly differently which should be identical.

Field Consistency Analysis

A good programming practice is to make sure identically named fields are defined the same way (same data type and data size). Total Access Analyzer performs field consistency analysis to determine if the same field name is defined with different data types or sizes in different tables. If it finds any, a report under Suggestions called "Table Fields with Different Types" is created.