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

  

 

Microsoft Access Database Documentation and Analysis: Total Access Analyzer

Summary of Reports in Total Access Analyzer

Total Access Analyzer includes 350+ reports, making it the most powerful documentation and analysis program for Microsoft Access professionals.

You can customize the header and footer of the reports, and many of the reports allow you to filter the objects or issues. Each database's documentation is stored separately, so you can always go back to your previously documented data.

The reports are organized into these major categories:

This page features a subset of reports with links to images and details.

Click here for a complete list of all of Total Access Analyzer's documentation reports.


Database Summary

An overview of what's in your database.


Object Cross Reference Analysis

Cross-Reference reports show where and how objects are used. Knowing this information is critical before making modifications to individual objects


Diagrams

Hierarchical diagrams visually reveal how objects reference each other through multiple levels.

  • Application Flow Diagram showing procedure and event flow for the entire database
  • Data Diagram showing how data flows from tables into queries, forms, reports, etc.
  • Object Diagram showing what objects are referenced by a form, report, or query.
Application, Data Flow, and Object diagrams can be redrawn to show the hierarchy of a single object. The redrawn diagram can also be printed from the Documentation Explorer, allowing you to print a report of a single object's diagram.

Application Diagram

The Application Diagram shows the hierarchical flow of your entire application. It starts with the Startup form or Autoexec macro, then shows what procedures and objects it calls, along with the same for the called objects. Every form, report, or procedure that is not called by another object starts its own tree. This provides a visual overview of all your procedure calls, macro calls, and form and report events, and is the most detailed of the three diagrams.


Sample from Northwind.mdb

Data Flow Diagram

The Data Flow Diagram shows how your database's tables are used across your application. See where the data flows from a table into a query, into a report, etc. The Data Flow Diagram illustrates the entire family of objects related to each table.


Sample from Northwind.mdb

Object Diagram

The Object Diagram shows all the objects a form, report, or query is dependent on. You can quickly see a form, its subforms, and the queries, tables, and macros they use. Whether it's used in the RecordSource or combo box RowSource, the referenced object is displayed here. The Object Diagram is almost like the Data Diagram in reverse. Rather than seeing how data flows from a table, the Object Diagram reveals what flows into an object.

Unlike the Application Diagram, the Object Diagram includes form and report use of tables and queries, and excludes procedure calls. This significantly simplifies the diagram.


Sample from Northwind.mdb

 


Errors, Suggestions, and Performance Tips

Total Access Analyzer detects a wide range of issues to help you create better Access applications by flagging items that will cause it to crash, and offering suggestions to improve your application and performance. A list of issues detected is available here.

Error Reports

Errors are problems that will most likely cause your Access application to crash. For instance, references to objects that were deleted or renamed crash when the user encounters them. When Total Access Analyzer detects these errors, you should examine them carefully and fix them before deploying your database.

Suggestion Reports

Suggestions incorporate our knowledge of Best Development Practices for creating professional Access applications. Suggestions cover items that are not necessarily going to cause your application to crash or perform poorly, but may make it easier to maintain, support, and appear more polished.

For instance, we may note that certain objects or code are unused, but that doesn't mean you have to delete them. Most suggestion reports are lists of issues. These two powerful reports are the results of analysis that you should review them to determine next steps:

Performance Tips

Performance tips are ideas where you may be able to enhance the speed of your application. Certainly, many tips are not relevant because you've already implemented the most efficient solution. Nonetheless it's helpful to consider these ideas or objects that may be made more efficient.


Basic Documentation

There are a large number of reports for each Access object type. Here are some examples.

Table Documentation

Query Documentation

Form Documentation

Report Documentation

Macro Documentation

Module Documentation

Additional Reports

Many other reports cover these areas:

  • Database
  • Object Inventory
  • * Import Export Specifications
  • Relationships
  • Workgroup and Security
  • Command Bar
  • Data Access Page
  • System Reports
  • ADP Documentation
    • Database Diagrams
    • Stored Procedures
    • Views

For the entire list of reports available in Total Access Analyzer, visit here.

* Added in Total Access Analyzer 2007


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

Celebrating 22 Years of Software Excellence