Jump: Search for: 

Total Access Analyzer

Microsoft Access 2007 Version
is Shipping!

New X.8 Versions
available for Access
2003, 2002, and 2000!

Access 97 Version


View all FMS products for Microsoft Access All Access Products

Analyzer Info:

Why Analyzer?

 

"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:

 

 

 
Microsoft Access Database Documentation and Analysis: Total Access Analyzer Microsoft Access documentation Download the trial version of the premier Microsoft Access documentation program

Verifying Consistent Definitions of Identically Named Fields Across Microsoft Access Tables

A fundamental Best Practice of database design is to make sure identically named fields represent the same data and are defined the same way (same data type and data size).

Assuming you want to do this, it's important to verify identically named fields are defined the same way. Failure to do this may cause data loss (truncated data) as information moves from one table to another, or inconsistent search results.

For instance, a FirstName text field should always be the same length anywhere it's defined. Not 30 characters in one table and 50 in another. Similarly, a numeric CustomerID field should not be an Integer in one table, a Long Integer in another, and a Double in another.

Field Consistency Analysis

As part of its analysis, Total Access Analyzer examines all the fields in your MS Access database, compares identically named fields in multiple tables, and flags the field names that are not identically defined. If it finds any, the results are presented in the Suggestions report: Table Fields with Different Types.

The report shows for each field with an inconsistency in Data Type and Size, all the places where the field is defined. You can then determine if and where you need to make the changes.

In this example, you may want to change the City field from a size 40 to 50 in the tblCustomer table, and modify the Comments field in the IncidentItems table from a Text to Memo:

Microsoft Access Tables with Inconsistent Field Definitions

Additional Best Practices for Microsoft Access Database Development

Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright © 2010 FMS, Inc., Vienna, Virginia
Celebrating 24 Years of Software Excellence