Total Access Analyzer includes 400+ 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:
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.
An overview of what's in your database.
Cross-Reference reports show where and how objects are used. Knowing this information is critical before making modifications to individual objects
Hierarchical diagrams visually reveal how objects reference each other through multiple levels.
How data flows from tables into queries, forms, reports, etc.
For detailed analysis and comprehension, select an item and redraw the hierarchy of a single object. The redrawn diagram can be printed from the Documentation Explorer, allowing you to create a report of a single object's diagram.
List of Issues DetectedTotal 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.
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.
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 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.
Total Access Analyzer 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:
Plus many other reports on module contents such as VBA functions, labels, variables, DoCmd, constants, compiler conditions, etc.
There are a large number of reports for each Access object type. Here are some examples.
Quickly see what each form and report looks like with each control annotated:
Version 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 forr
Access 2002 and 2000
"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