Microsoft Access 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.

|