| Total Access Analyzer | |
|
Microsoft
Access 2007 Version
Versions also |
|
| Analyzer Info: | |
|
Best Practices (Errors, Suggestions, and Performance Tips) Finding Unused Objects and Code
|
|
| Why Analyzer? | |
|
for Users, Developers & Consultants |
|
|
|
|
| Additional Info: | |
|
|
|
|
|
|
|
Learn and Apply Best Practices for Microsoft® AccessTotal Access Analyzer helps you create better, more robust, and faster Microsoft Access databases with more control and fewer errors!
Integrated within Your Access EnvironmentOpen your database and launch Total Access Analyzer from your Add-ins menu. The main menu of Total Access Analyzer appears letting you:
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 AnalysisTotal 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 ParserTotal 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 ApplicationsTotal 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 ExplorerThe 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:
Property SlicesThe 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 all forms:
You can also see property values across all form controls. Similarly, for Tables and Queries, you can choose object level or field/column level properties. Cross-Reference: XREFThe XREF tab shows for each object, where it's used throughout your application including references from other objects, macros, and modules. Issues: Errors, Suggestions and Performance TipsErrors, 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 review status is preserved. You can even filter on the Reviewed status to see any new issues from your last run.
Search Your DocumentationYou can also search the documented properties, macros, and modules for any word or phrase, and see all the places that it's used. The results are presented to you and you can immediately open the current object in Design mode with a keystroke:
Simplify Your Development EffortsAs 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 ItTotal 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 AvailabilityDue to the differences between Access versions, there is a separate version of Total Access Analyzer for each version of Microsoft Access.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
NOW
AVAILABLE FOR MICROSOFT OFFICE ACCESS 2007
