Total Access Analyzer
2007: New Features
The
world's most popular Access product is now available for Microsoft
Office Access 2007. Total Access Analyzer 2007 builds on its heritage of
helping Access enthusiasts create better Access solutions with a wide
range of new features.
Microsoft made a big investment to create Access 2007 and added a lot of
great new features with significant changes to objects, properties, VBA
code, the user interface, an entirely new database format, with new
field types and embedded macros.
So we now support MDB, ADPs, and the new ACCDB database formats. The
user interface can be in tabbed view or traditional windows. Layer on
top of that the differences between Windows XP and Vista, and you'll
quickly see the number of permutations our developers and QA staff
needed to address.
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:
Supports Microsoft Access 2007
- Supports the new ACCDB (Access 2007) database format in addition to
the MDB and ADP formats
- Documents and cross-references the new embedded macros in Access
forms and reports
- Supports new macro commands
- Supports new VBA commands
- Supports new property values
- Documents saved import/export specifications
- Documents links to SharePoint
- Documents the use of variables tied to the TempVars object
- Documents a variety of new properties, Access options, and many
other settings including localization of property values to your version
of Access
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
Office/Access 2007, Vista/XP color schemes, and look and feel
- Support for your database's Document Windows Options set to
traditional overlapping windows or the new tabbed object display
- Resizable forms for either Windows option
- Alternating row colors for datasheets
- The use of transparent buttons with graphics
- Support for datasheet filtering throughout the application
from selecting objects to document, reports to print, or viewing
results
Reporting Enhancements
Individual or multiple reports can be exported to formats such as
Adobe PDF, HTML, Snapshot, Text, RTF, or XPS 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 353 professional quality reports. Here are some of the 24 new
reports:
- New Access Options reports (completely different from the
Access 2003 options under Tools, Options)
- Import Export Specifications
- Embedded macro listings
- Objects embedded macros cross-reference
- TempVars assignments and cross-reference
- Objects with Identical SQL and RecordSource
- Unused forms, reports, and code
- Enhanced Database Summary reports
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 285 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
- Check and recommend the settings of the new Access options like
tabbed view, Search Bar, datasheet design change option, etc.
- Forms with navigation bars should have a custom Navigation Caption
- Command Buttons should show the Hyperlink Hand on mouse hover.
- Datasheet and continuous forms should take advantage of the new
alternating background color option
- 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
- New Access option for database picture property storage to reduce
database size
- 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
- Documents the TempVars object definition and usage
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.
Additional Enhancements
Plus many other documentation and performance enhancements to make Total
Access Analyzer better than ever! There's even a new 164 page,
professionally printed user manual.
For a quick overview of Total Access Analyzer 2007,
Take the Tour.
Pricing and Access Versions
Total Access Analyzer comes in versions specific to each version of
Microsoft Access.
Additional Resources
All Our Microsoft Access Products
Single
