"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
|
|
All Reports in Total Access Analyzer for Microsoft Access
 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:
Featured reports are highlighted below with linked images and details.
Field Cross-Reference
- Field References, Sorted by Object Name
- Field References, Sorted by Field Name
- Field References by All Objects
- Field References by Queries
- Field References by Forms
- Field References by Reports
- Field References by Data Access Page
Object Cross-Reference
- Table References, Sorted by Table Name
- Table References, Sorted by Calling Object
- Query References, Sorted by Query Name
- Query References, Sorted by Calling Object
- Form References, Sorted by Form Name
- Form References, Sorted by Calling Object
- Report References, Sorted by Report Name
- Report References, Sorted by Calling Object
- * Control References in Code, Sorted by Calling Object
- * Control References in Code, Sorted by Referenced Control
- Macro References, Sorted by Macro Name
- Macro References, Sorted by Calling Object
- CommandBar References, Sorted by CommandBar Name
- CommandBar References, Sorted by Calling Object
- Hyperlinks
- Data Access Page References, Sorted by Page Name
- Data Access Page References, Sorted by Calling Object
- Database Diagram References, Sorted by Diagram Name
- Database Diagram References, Sorted by Calling Object
- Stored Procedure References, Sorted by Procedure Name
- Stored Procedure References, Sorted by Calling Object
- View References, Sorted by View Name
- View References, Sorted by Calling Object
Module Cross-Reference
- Module Analysis Summary, Sorted by Module Type
- Module Analysis Summary, Sorted by Module Name
- Module Overview
- Procedure List, Sorted by Module and Procedure
- Procedure List, Sorted by Line Number
- Procedure List, Sorted by Procedure Name
- Procedure List with Comments, Sorted by Mod. and Proc.
- Procedure List with Comments, Sorted by Proc Name
- Procedure Usage - Where Procs are Called From
- Procedure Usage, Non-Event Procedures only
- Procedure Calls - What each Procedure Calls
- Library Declarations, Sorted by Module Name
- Library Declarations, Sorted by Procedure Name
- VBA Functions, Sorted by Calling Object
- VBA Functions, Sorted by Function
- DoCmd, Sorted by Module and Procedure
- DoCmd, Sorted by Action
- Enum Declarations, Sorted by Module
- Enum Declarations, Sorted by ENUM Name
- Events Defined by Module
- Events Raised, Sorted by Module and Procedure
- Events Raised, Sorted by Module and Event
- Labels, Sorted by Module and Procedure
- Labels, Sorted by Label Name
- User Defined Type Declarations, Sorted by Module
- User Defined Type Declarations, Sorted by Type Name
- Variable List, Sorted by Module and Procedure
- Variable List, Sorted by Variable Name
- Variable References, Sorted by Module and Procedure
- Variable References, Sorted by Variable Name
- Variable Constants, Sorted by Module and Procedure
- Variable Constants, Sorted by Constant
- Variables Defined WithEvents
- Variables of Class Module, Sorted by Module
- Variables of Class Module, Sorted by Class Module
- Variables of Enum, Sorted by Module
- Variables of Enum, Sorted by Enum Name
- Variables of User Defined Type, Sorted by Module
- Variables of User Defined Type, Sorted by Type Name
- * TempVars, Sorted by Calling Object
- * TempVars, Sorted by TempVar Name
- Classes Implemented, Sorted by Calling Module
- Classes Implemented, Sorted by Implemented Class
- DefType Statements
Hierarchical diagrams visually revealing how objects reference each other through several 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
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
These are problems that will most likely cause your Access
application to crash. For instance, references to objects that were
deleted or renamed will 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. A variety of reports with
different sorting and filters are available:
- Summary of Errors by Type
- Summary of Errors by Type with Descriptions
- By Error Type, All
- By Error Type, Table
- By Error Type, Query
- By Error Type, Form
- By Error Type, Report
- By Error Type, Macro
- By Error Type, Module
- By Error Type, Command Bars
- By Error Type, Security
- By Error Type, Data Access Pages
- By Error Type, Database Diagram
- By Error Type, Stored Procedures
- By Error Type, View
- By Object Name, All Errors
- By Object Name, View Errors
- By Object Name, Table Errors
- By Object Name, Query Errors
- By Object Name, Form Errors
- By Object Name, Report Errors
- By Object Name, Macro Errors
- By Object Name, Module Errors
- By Object Name, Command Bars Errors
- By Object Name, Security Errors
- By Object Name, Data Access Page Errors
- By Object Name, Database Diagram Errors
- By Object Name, Stored Procedure Errors
- Object Reference Errors
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. A variety of reports with different sorting and
filters are available:
- Summary of Suggestions by Type
- Summary of Suggestions by Type with Descriptions
- Table Fields with Different Types
- * Identical SQL and RecordSources
- By Suggestions Type, All
- By Suggestions Type, Table
- By Suggestions Type, Query
- By Suggestions Type, Form
- By Suggestions Type, Report
- By Suggestions Type, Macro
- By Suggestions Type, Module
- By Object Name, All Suggestions
- By Object Name, Table Suggestions
- By Object Name, Query Suggestions
- By Object Name, Form Suggestions
- By Object Name, Report Suggestions
- By Object Name, Macro Suggestions
- By Object Name, Module Suggestions
- Unused Tables
- Unused Queries
- Unused Macros
- * Unused Forms
- * Unused Reports
- * Unused Tables and Queries
- * Unused Forms and Reports
- Module Procedures Unused
- Module Properties Unused
- Module Procedures that Should be Private
- Module Procedures without Error Handling
- Module Functions without Return Type
- Module Variable Unused
- Module Variable Conflicts
- Module Variables that Should be Type Cast
- Module Constants without Explicit Type
- Module Unused User Defined Types
- Module Debug & Stop References
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. A variety of reports with different sorting and filters are
available:
- Summary of Performance Tips by Type
- Summary of Performance Tips by Type with Descriptions
- By Performance Type, All Items
- By Performance Type, Table Items
- By Performance Type, Query Items
- By Performance Type, Form Items
- By Performance Type, Report Items
- By Performance Type, Module Items
- By Object Name, All Items
- By Object Name, Table Items
- By Object Name, Query Items
- By Object Name, Form Items
- By Object Name, Report Items
- By Object Name, Module Items
Database Documentation
- Database Properties
- User Defined Properties
- * Access Options, Sorted by Option Name
- * Access Options, Sorted by Option Type and Name
- All Errors, Suggestions, and Performance Tips
- Database VBA Library References
- * Ribbons
Object Inventory
- Sorted by Object Name
- Sorted by Object Type
- Sorted by Creation Date
- Sorted by Last Updated Date
- Database Containers, Documents, and Properties
* Import Export Specifications
- * Summary, Sorted by Name
- * Summary, Sorted by Type
- * Detail, Sorted by Name
- * Detail, Sorted by Type
Table Documentation
Note: Table Fields with Different Types is part of Suggestions
- Table List, Sorted by Table Name
- Table List, Sorted by Table Type
- * Table List, Sorted by Number of Records
- * Table List with Estimated Sizes, Sorted by Number of Records
- * Table List with Estimated Sizes, Sorted by Tables Size
- * Table List Details, Sorted by Table Type
- Table Properties, Sorted by Table Name
- Table Properties, Sorted by Property Name
- Table Indexes, Sorted by Table Name
- Table Indexes, Sorted by Fields
- Table Keys, Sorted by Table Name
- Table Keys, Sorted by Fields
- Table Index Properties, Sorted by Table Name
- Table Index Properties, Sorted by Property and Table
- Table Index Properties, Sorted by Property and Index
- Table Fields, Sorted by Table Name (Portrait)
- * Table Fields, Sorted by Table Name (Landscape)
- Table Fields, Sorted by Field Name (Portrait)
- * Table Fields, Sorted by Field Name (Landscape)
- * Table Fields, Sorted by Data Type and Size Summary
- * Table Fields, Sorted by Data Type and Size Detail
- Table Field Properties, Sorted by Table Name
- Table Field Properties, Sorted by Field Name
- Table Field Properties, Sorted by Property and Table
- Table Field Properties, Sorted by Property and Field Name
- * Table Field General Properties (as seen on the Table Designer's General tab)
- * Table Field Lookup Properties (as seen on the Table Designer's Lookup tab)
- Table Field Property Slice Reports to see all the assignments of that property
across all the tables and fields. Great for quickly reviewing for consistency and problems:
- * Format
- * InputMask
- * DefaultValue
- * Required
- * RowSource and Type
- * Validation Rule and Text
- Table Dictionary
- Table Dictionary with Field Properties
Relationships
- Individual Relationships
- Relationships Filtered on Primary Table
- Relationships Filtered on Foreign Table
- Relationships Window
Query Documentation
- Query List, Sorted by Query Name
- Query List, Sorted by Query Type
- Query List with SQL, Sorted by Query Name
- Query List with SQL, Sorted by Query Type
- Query List Action Queries, Sorted by Query Name
- Query List Action Queries, Sorted by Query Type
- Query Properties, Sorted by Query Name
- Query Properties, Sorted by Property Name
- Query Tables, Sorted by Query Name
- Query Tables, Sorted by Table Name
- Query Columns, Sorted by Query and Column Order
- Query Columns, Sorted by Query and Column Name
- Query Column Properties, Sorted by Query Name
- Query Column Properties, Sorted by Property and Query
- Query Column Properties, Sorted by Property and Column
- Query Joins
- Query Fields Referenced
- Query Parameters, Sorted by Query Name
- Query Parameters, Sorted by Parameter Name
- Query Dictionary
Form Documentation
- Form List, Sorted by Form Name
- Form List, Sorted by Number of Controls
- Form List with Record Source, Sorted by Name
- Form List with Record Source, Sorted by Record Source
- Form Properties, Sorted by Form Name
- Form Properties, Sorted by Property Name
- * Form Embedded Macro Properties
- * Form Embedded Macro Dictionary
- Form Subforms, Sorted by Form Name
- Form Subforms, Sorted by Subform Name
- Form Section Properties, Sorted by Form Name
- Form Section Properties, Sorted by Property and Form
- Form Section Properties, Sorted by Property and Section
- Form Controls, Sorted by Form Name and Control Name
- Form Controls, Sorted by Form Name and Control Type
- Form Controls with Associated Labels
- Form Control Properties, Sorted by Form and Control Name
- Form Control Properties, Sorted by Form and Control Type
- Form Control Properties, Sorted by Property and Form
- Form Control Properties, Sorted by Property and Control
- Form Shortcut Keys
- Form ActiveX Controls, Sorted by Form Name
- Form ActiveX Controls, Sorted by OLE Class
- Form Dictionary
- Form Dictionary with Properties
- Form Blueprint
Report Documentation
- Report List, Sorted by Report Name
- Report List, Sorted by Number of Controls
- Report List with Record Source, Sorted by Name
- Report List with Record Source, Sorted by Record Source
- Report Page Setup, Sorted by Report Name
- Report Page Setup, Sorted by Orientation
- * Report Embedded Macro Properties
- * Report Embedded Macro Dictionary
- Report Properties, Sorted by Report Name
- Report Properties, Sorted by Property Name
- Report Subreports, Sorted by Report Name
- Report Subreports, Sorted by Subreport Name
- Report Section Properties, Sorted by Report Name
- Report Section Properties, Sorted by Property and Section
- Report Section Properties, Sorted by Property and Report
- Report Controls, Sorted by Report Name and Control
- Report Controls, Sorted by Report and Control Type
- Report Controls with Associated Labels
- Report Control Properties, Sorted by Report and Control
- Report Control Properties, Sorted by Report and Control Type
- Report Control Properties, Sorted by Property and Report
- Report Control Properties, Sorted by Property and Control
- Report ActiveX Controls, Sorted by Report Name
- Report ActiveX Controls, Sorted by OLE Class
- Report Group Levels, Sorted by Level Number
- Report Dictionary
- Report Dictionary with Report Properties
- Report Dictionary with All Properties
- Report Blueprint
Macro Documentation
- Macro List, Sorted by Macro Name
- Macro List, Sorted by Number of Lines
- Macro Dictionary
- * Embedded Macro Properties
- * Embedded Macro Dictionary
Module Documentation
Workgroup and Security Documentation
- Users
- Groups
- Container Permissions for Groups
- Container Permissions for Users
- Object Permissions for Groups
- Object Permissions for Users
Command Bar Documentation
- Command Bar List
- Command Bar Properties, Sorted by Command Bar Name
- Command Bar Properties, Sorted by Property Name
- Command Bar Controls
- Command Bar Control Properties, Sorted by Command Bar
- Command Bar Control Properties, Sort by Property and Command Bar
- Command Bar Control Properties, Sort by Property and Control
ADP Database Diagram Documentation
ADP Stored Procedure Documentation
- Stored Procedure List
- Stored Procedure List with TSQL
ADP View Documentation
- View List, Sorted by View Name
- View List with TSQL, Sorted by View Name
- View Properties, Sorted by View Name
Data Access Page Documentation
Not part of the Access 2007 version since Access 2007 doesn't
support Data Access Pages. These reports are available in earlier
versions:
- Data Access Page List
- Data Access Page Properties, Sorted by Page Name
- Data Access Page Properties, Sorted by Property Name
- Data Access Page Element Properties
- Data Access Page Dictionary
- Data Access Page Field Properties
System Reports
- Total Access Analyzer Output Databases
- Total Access Analyzer Report List
- * Report List with Export File Names, Sorted by Category
- * Report List with Export File Names, Sorted by File Name
- List of All Errors, Suggestions, and Performance Tips Detected
- * New Errors, Suggestions, and Performance Tips
- Total Access Analyzer List of Errors Detected
- Total Access Analyzer List of Suggestions Detected
- Total Access Analyzer List of Performance Tips Detected
* Added in Total Access Analyzer 2007
|
|
All Our Microsoft Access Products
