Learn and Apply Best Practices for Microsoft Access
Total Access Analyzer helps you create better, more robust, and faster Access databases with more control and fewer errors!
SHIPPING FOR MICROSOFT ACCESS 2016
- Supports Access 2016 32-bit and 64-bit versions
- New Suggestion: Incorrect Link to Subforms
- New Suggestion: Relationship Field Cross-Reference and Field Type Comparison
- Enhanced Cross-Reference of Aliased Tables in Queries
- Pass-Through Queries are Not Cross-Referenced
- Windows 10 Support
- New Help File and User Manual
- And more...
New versions are also available for Access
Discover why so many Microsoft Access users and developers rely on Total Access Analyzer to deliver great Access solutions for over 20 years!
Total Access Analyzer examines all your database objects to provide extensive documentation,
code analysis, object cross-reference, and diagrams with over 390 presentation-quality
reports. It detects 300+ types of errors, suggestions, and performance tips, so you can
learn and apply Best Practices to fix problems, improve your design, and speed up your Access applications.
Integrated within Your Access Environment
Open your database and launch Total Access Analyzer from your Add-ins
The main menu of Total Access Analyzer appears:
Main Menu of Total Access Analyzer
From here, you can easily:
- Create new detailed documentation for your database
- For previously generated documentation on this or another database:
- View the results
- Search for any string across the object properties and code
- Preview, print, or export reports to file
- Generate simple "quick" documentation for your objects
Because Total Access Analyzer runs within Access, it leverages the power of Access to document and present the results in Access
forms and reports. In many places, it also offers the ability to look at the results and jump into design mode for the current
record's object with a single keystroke. This lets you easily examine the results and apply the suggestions.
Comprehensive Database Analysis
Total Access Analyzer performs detailed analysis of your Access database
objects individually and as a whole. By examining your entire database,
it discovers complex relationships among
objects, hidden problems, and even unused objects. Take control of
your databases by understanding how they work. Total Access Analyzer
not only generates cross-references between your objects, it also
creates diagrams of your application and data flow to show multi-level
relationships. If you want to understand what's really going on in
your database or need to get up-to-speed on databases created by
others, Total Access Analyzer is your solution.
Comprehensive Module Analysis with Our Exclusive Code Parser
Total Access Analyzer includes our proprietary Microsoft Visual Basic for Applications (VBA) code parser that
understands your module code to generate detailed analysis of your code in modules,
classes, and behind forms and reports. Know where each
procedure and variable is used. Discover unused code, unreferenced
variables (assigned but not used), references to missing objects,
variable name conflicts, scoping issues, and much more! Total Access
Analyzer pinpoints issues in your code to teach you how to be a
better Access/VBA programmer.
Create Better and Faster Access Applications
Total Access Analyzer helps you apply the 'Best Practices'
principles that we've learned at FMS. Perform the same analysis on your
databases to see what you can improve. For instance, eliminate
potential data loss with the field consistency analysis that ensures
identically named fields across tables are defined consistently. Find
forms with duplicate hotkey letters, reports without a NoData event,
unused objects and code, procedures that should be private, short
combo boxes, and much more.
Integrated Documentation Explorer
The documentation results are shown in the powerful Documentation
Explorer, that lets you easily browse the most complex Access databases
through an intuitive hierarchical treeview. Look at summary and detail
information on any documented object:
The power of Total Access Analyzer comes with its ability to show data
across all objects. The Property Slice feature lets you choose a property
name and see all the objects' values for that property. Simply select a
folder and see a property across all the objects like the RecordSource for
You can also see property values across all form controls. Similarly, for
Tables and Queries, you can choose object level or field/column level
The XRef tab shows for each object, where it's used throughout your
application including references from other objects, macros, and modules.
Here you can see each table and what objects and controls are referencing
Issues: Errors, Suggestions and Performance Tips
Errors, Suggestions and Performance tips are displayed in their tabs. By pressing Alt+D,
you can open the current object in design mode to examine and
make the recommended changes. Check the "Reviewed" box for items you don't
want or need to change, so the next time the database is documented, your
Reviewed status is preserved. You can even filter on the Reviewed status to
see any new issues from your last run.
Search Your Documentation
You can also search the documented properties, macros, and modules for
any word or phrase, to see all the places it's used. The results are
presented to you and you can immediately open the current object in Design
mode with a keystroke:
Extensive Documentation Reports
Total Access Analyzer contains 390+ reports ranging from top level
overviews to individual object details. All the reports can be
customized with your
headers, footers, and colors so you can deliver professional documentation
of your work. Many of the reports can also be filtered and you can define
your own batch of reports as a set that can be easily retrieved again.
Sample Reports: 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
Sample Reports: Form and Report Blueprints
Quickly see what each form and report looks like with each control annotated:
Examples of Additional Microsoft Access Documentation Reports
Simplify Your Development Efforts
As your databases grow in complexity, they become harder and harder
to understand. Total Access Analyzer generates the information you
need to maintain control and efficiency. From simple table structure
lists, to field dictionaries (for each field name, see every table
containing that field name), to property listings, object cross-reference, flow diagrams,
and code printouts, Total Access Analyzer gives you the data and
reports you need to manage your systems.
Save Your Reputation: Don't Ship Without Running It
Total Access Analyzer provides the most comprehensive Access
error detection for your databases. Find errors that can cause your
application to crash before you ship! For instance, a form may have a
combo box that references a table or field that was renamed. It will crash
when your user opens it. Total Access Analyzer finds these hidden
errors. Think of the time and embarrassment you'll save!
Discover why so many organizations run Total Access Analyzer as part
of their final quality assurance check before deploying any Access database.
Versions and Availability
Due to the differences between Access versions, there is a separate version of Total Access Analyzer for each version of Access. It can
analyze all the database formats that its Access version supports. For instance, if you are using Access 2016,
Total Access Analyzer 2016 runs in Access 2016 and supports Access MDBs and ACCDB database formats
created with earlier Access versions that can be opened in Access 2016. Note that Access 2013 and 2016 do not support ADPs, so if you want to analyze ADPs, use
Total Access Analyzer 2010 or earlier.
Simply choose the Total Access Analyzer version for the MS Access version you are running.