Total Access Analyzer Version X.8 : New Features for Microsoft Access
2003, 2002, and 2000
NOTE: Version X.9 is the latest
version for Total Access Analyzer for Microsoft Access 2003
Details
FMS is pleased to provide a major update to Total Access Analyzer for
Microsoft Access 2003, 2002, and 2000. Total Access Analyzer is the
world's most popular Access product.
The X.8 versions of Total Access Analyzer include many new features and
enhancements to help you create and maintain Microsoft Access databases
better than ever! These new versions are now available:
New Versions
Total Access Analyzer version X.8 is an upgrade from version X.7. These
are the new versions:
| Access 2003 |
11.8 |
11.7 |
| Access 2002/XP |
10.8 |
10.7 |
| Access 2000 |
9.8 |
9.7 |
If you have a version prior to the X.7 version, click here
to see the features that were added in X.7, which are also part of the
X.8 version.
New Features and Enhancements
Total Access Analyzer X.8 builds on its heritage of helping Access
enthusiasts create better Access solutions with a wide range of new
features. We've added many enhancements based on our experiences and the
recommendations of our customers. Thank you very much! We hope you like
the results:
Main Screen Redesign
Main screen shows the context of the currently documented database and
your ability to view, search, and print reports for it.
You can also open it without closing your current objects.
New, Sleek, More Modern User Interface
- Completely redesigned user interface to support the sleeker
Windows Vista/XP color schemes, and look and feel
Reporting Enhancements
Individual or multiple reports can be exported to formats such as
HTML, Snapshot, Text, or RTF to a folder you specify:
Reports can be sent to the new Report View which supports your ability to
filter the results interactively
New Reports
There are 336 professional quality reports. Here are some of the 24 new
reports:
- Import Export Specifications
- Objects with Identical SQL and RecordSource
- Several reports for unused objects and code including:
- Unused forms
- Unused reports
- Unused queries and tables
- Unused forms, queries, reports, and tables
- Enhanced Database Summary reports
- Table field property slice reports to see a property across
multiple tables and fields:
- Validation Rule and Text
- Input Mask
- Format
- RowSource and Type
- Required
- Default Value
- Table field report showing all the General tab properties
- Table field report showing all the Lookup tab properties
- References to form and reports controls in VBA code
After documentation, reports without data are not listed to make
it easy to see what's available.
Viewing Results (Documentation Explorer)
- One click loading of the current object in design view.
Whether it's from the Diagrams, XREF, Errors, Suggestions, or
Performance Tips tabs, you can press Alt+D and put it in design
mode to immediately review the object or module for the changes
to make.
- Significantly improved performance when viewing results, and
looking at detailed property lists for one object or across all
objects of one type
- Improved maximized mode with splitter bar between panes
New Suggestions and Performance Tips
Total Access Analyzer detects 270 specific types of errors, suggestions,
and performance tips for your database. Here are some new ones
- Eliminate/Consolidate duplicate queries: Identical SQL Analysis to
determine if the same SQL string is used across multiple queries, or the
record source and row source of forms and reports
- Unused forms and reports
- Module analysis:
- Use of old constants from pre-Access 97 syntax
- Procedures with exits in the middle of its body which could bypass
cleanup code at the end of the procedure
- Date fields with input masks (the Format property should handle
this)
- Forms with the Moveable property set to No
- Forms with unnecessary scroll bars
Here's a complete list of
Best Practices detected by
Total Access Analyzer.
Search Enhancement
Search lets you find any string among the documented objects,
macros, and modules. While viewing the search results, you can put
the object in the current record into design mode by pressing Alt+D
or the Design button:
New Module VBA Documentation
- Detects table and query references from the open command of
ADODB recordsets and adds this to the Object XREF views and
reports
- Detects explicit control references from code (e.g.
Form_MyForm.txtValue) with new Object XREF reports
Improved Documentation Wizard
When creating new documentation, the Documentation Wizard lets you work
more efficiently. It:
- No longer requires your code to be compiled (with a warning)
- Adds a Finish button so you can skip the last two pages after you
select your objects to document
New Installation and Storage Locations
Total Access Analyzer addresses the limitations imposed by Vista
and User Access Control. Rather than storing output databases for
your documentation in the Total Access Analyzer folder by default,
it now stores it in your Application Data folder.
For a quick overview of Total Access Analyzer,
Take the Tour.
Pricing and Access Versions
Due to the different features in each Access version, Total Access
Analyzer has a separate versions corresponding to each version of Microsoft
Access.
Additional Resources
All Our Microsoft Access Products
Single
