|
 
Learn and Apply Best Practices for Microsoft®
Access
Total Access Analyzer helps you create better,
more robust, and faster Microsoft Access databases with more control and
fewer errors!
|
Discover why so many Microsoft Access users and developers rely on Total Access Analyzer
to deliver great Access solutions.
Total Access Analyzer
examines all your database objects to provide extensive documentation,
cross-reference, and application and flow diagrams, with over 350 presentation-quality
reports. It detects 270+ types of
errors, suggestions, and performance tips, so you can
learn and apply Best Practices to improve
and speed up your Microsoft Access applications. |
NOW
AVAILABLE FOR MICROSOFT OFFICE ACCESS 2007
New Features: |
- Supports the Access 2007 ACCDB database
format and new field types, properties, embedded macros, and VBA
- Exports reports to PDF, XPS, Snapshot, HTML and RTF
files
- Duplicate SQL detection
- More context sensitive opening of objects in design
mode
- A
sleek, new
Microsoft Access 2007 user interface
-
and much more...
|
|
Integrated within Your Access Environment
Open your database and launch Total Access Analyzer from your Add-ins
menu. The main menu of Total Access Analyzer appears letting you:
- Create new 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 some of your objects

Total Access Analyzer 2007's Main Menu
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
Code Analysis with VBA Parser
Total Access Analyzer has a proprietary 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 Microsoft 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. Issues
(Errors, Suggestions and Performance tips) are clearly listed, and 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
review status is preserved. You can even filter on the Reviewed status to
see any new issues from your last run.

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 a field name, see every table it is
defined), 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 Microsoft 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.
Version and Availability
Due to the differences between Access versions, there is a separate
version of Total Access Analyzer for each version of Microsoft Access.
|