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.
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.
Here's the complete list of the Total Access Analyzer reports documenting the tables in your MS Access database. Click on the hyperlinks for more information. Rather than overwhelm you with every report, we've provided a subset of the most interesting reports for you to review. The others show similar data but use different sort orders or filters.
Simple lists to gain a quick understanding of all the tables in your database and their relative size
Examine fields lists for each table, or for each field which tables its in, along with their properties
Look at all the properties of a field the way you would in the table designer or see a property value across all the fields that have them.
Examine indexes and their fields and properties
Detailed listing of each table, its properties, indexes, fields, etc.
Version 16.1 for
Microsoft Access 2016
Version 15.6 for
Microsoft Access 2013
Version 14.6 for
Microsoft Access 2010
Version 12.96 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 for Access 2002 and 2000