Summary List of Reports Generated by Total Access Analyzer for Your Microsoft Access Databases

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

You can customize the header and footer of the reports from the Options button. 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:

• Database Summary
• Cross Reference Analysis
• Diagrams
• Errors, Suggestions and Performance Tips
• Module Analysis
• Basic Documentation

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

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

---

Database Summary

An overview of what's in your database.

• Database Summary

---

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

• Where are my fields used and referenced?
• Where are my tables used and referenced?
• Where are my queries used and referenced?
• Where are my macros used and referenced?
• Where are my Temporary Variables (TempVars) used and referenced?

---

Database Flow Diagrams

Hierarchical diagrams visually revealing 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 Flow Diagram

Data Diagram

Object Diagram

More information on Diagram Displays and Reports

---

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:

• Table Fields with Different Types
• Identical SQL and RecordSources

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.

---

Module Analysis

Module Printouts

Total Access Analyzers offers two reports to print your modules. The first is the standard display of your code as is, the second formats your code to indent the logic loops and show brackets around loops and exit arrows from them:

Standard Module Printout with Procedure Index

Bracketed and Formatted Module Printout

Module VBA Code Analysis

• Module Analysis Summary (across all documented forms, reports, and standard modules)
• Single Module Overview
• Procedure Lists
  • Sorted by Module and Procedure
  • Sorted by Procedure Order
  • Sorted by Procedure Name (Procedure Dictionary)
• Procedure Usage
  • Procedure Calls - What each Procedure Calls
  • Procedure Usage - Where Procedures are Called From
  • Procedure Usage - Non-Event Procedures only

Plus many other reports on module contents such as VBA functions, labels, variables, DoCmd, constants, compiler conditions, etc.

---

Basic Documentation

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

Form and Report Blueprints

Quickly see what each form and report looks like with each control annotated:

Form Blueprint

Report Blueprint

Table Documentation

• Table List, Sorted by Table Name
• Table List with Sizes, Sorted by Number of Records
• Table List with Sizes, Sorted by Table Size
• Table Fields, Sorted by Table Name (see all the fields for each table)
• Table Fields, Sorted by Field Name (see all the tables with the same field name)
• Table Field General Properties (field information on the General tab)
• Table Field Lookup Properties (field information on the Lookup tab for combo boxes)
• Table Field Property Slice Format (see all the fields with a Format property)
• Table Field Property Slice Input Masks (see all the fields with an InputMask property)
• Table Indexes, Sorted by Table Name
• Table Dictionary

Query Documentation

• Query Dictionary

Form Documentation

• Form Dictionary

Report Documentation

• Report Dictionary

Macro Documentation

• Macro Dictionary listing all macro lines with indentations for IF..ELSE..ENDIF loops
  (available for standard and embedded macros in forms and reports)

Additional Reports

Many other reports cover these areas:

• Database
• Object Inventory
• ActiveX Controls and where they are used
• Import Export Specifications
• Relationships
• Workgroup and Security
• Command Bar
• Data Access Page
• System Reports
• ADP Documentation
  • Database Diagrams
  • Stored Procedures
  • Views

for more information, visit the Entire list of reports available in Total Access Analyzer