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

  

 

Field References Sorted by Field Name

This powerful report shows where and how each field is defined or referenced across the entire database. Knowing where your fields are used is certainly important before changing them.

In this example, the data is sorted by field name (Address, Birth Date, CategoryID). Within each grouping, you can see where the field is used. For instance, the Address field is used in a Query named Invoices, which is used by a control in the Invoice Report.

The data shown here is similar to the Table References, Sorted by Table Name, but it's sorted by Field Name to show all the tables where identically named fields are used. This is a great tool for verifying consistency of field definitions. A good programming practice is to make sure identically named fields are defined the same way (same data type, data size, and description)


 

NOTES

  • The Resolved? column shows whether the field reference is valid (if an object references a field that no longer exists, that's flagged as an error and appears in the Error reports).

  • If your module code references a field name with a variable, it's listed here and the Variable? column is checked.

Contact Us  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 22 Years of Software Excellence