Quick Find: Search for:
Total Access Analyzer  

Microsoft Access 2007 Version
is Shipping!

Versions also
available for Access
2003, 2002, and 2000!

Access 97 Version


View all FMS products for Microsoft Access All Access Products

 Analyzer Info:

Total Access Analyzer Brochure (2 pages)
PDF Fact Sheet
(426K)

Take a Tour

Best Practices (Errors, Suggestions, and Performance Tips)

List of Reports

Finding Unused Objects and Code

FAQs


Best Access Add-In
Rave Reviews

 Why Analyzer?

for Users, Developers & Consultants

Compare with Microsoft's Documenter

Convince Your Boss

 


"Total Access Analyzer is an amazing product that I’ve relied on and recommended for years. It’s a huge time saver."

Sal Ricciardi
Programming Writer, Microsoft Corporation

More Reviews

 Additional Info:

Press Release

Check for Updates

License Terms

  

 

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.

Contact Us  l   Web questions: Webmaster   l   Copyright © 2009 FMS, Inc., Vienna, Virginia

Celebrating 23 Years of Software Excellence