Why you Need Total Access Analyzer

As your Microsoft Access databases grow, they become harder and harder to understand. Look at the following problems and see how Analyzer solves them for you:

• My database is too complex!
• The built-in Microsoft Access documenter is not very useful.
• I can't figure out how my database works any more
• I just inherited an Access database. Help!
• I don't have time to find all the errors in my Access application.
• How can I find out which objects in my database are no longer used?
• I want to make my application run faster. Can Total Access Analyzer help?
• I'm about to deliver my application. But the client wants documentation!
• I need a solution that is simple and quick.

My Database is too complex!

Many Access database projects start out simple and rapidly devolve into complex collections of related and unrelated objects. There is simply no way to keep track of which object calls or uses which object, how data is related to forms and reports, etc. 

Solution: Total Access Analyzer solves this problem by scanning your entire database and coming up with a complete and easy-to-use set of documentation and analysis. It finds problems, suggests improvements, and recommends performance enhancements. It even highlights unused objects and code. Total Access Analyzer lets you take back control of your Access databases.

The built-in Microsoft Access Documenter is not very useful

The built-in Access documenter looks at each object separately. For each object type, only a single report is available. Additionally, Access provides no analysis, cross-reference reporting, or detection or errors and performance problems.

Solution: Total Access Analyzer also documents individual objects, but in addition it provides a wealth of information and reporting options. More importantly, it "analyzes" your entire database, giving you the information you need to understand how objects relate to each other. It also provides extensive module analysis so you know more about your code and where and how it is used. The diagrams for application flow, data flow, and objects reveal the hierarchical relationship across code and objects and provide an excellent overview of how a database works.

Total Access Analyzer also uncovers truly critical information such as broken or missing references to objects, unused objects (tables, queries, procedures, variables, etc.), inconsistent field types among identically named fields, plus many other useful suggestions.

Total Access Analyzer includes over 300 presentation quality reports with options to filter the data and customize the headers so you can make a permanent record of your database on paper. A wide range of reports is available including different sort options to reveal different relationships. For instance, Total Access Analyzer includes a report that shows each table's fields, including their type and description, sorted by the table name. In addition, the product includes a field report that shows the same data sorted by field, so you can see which table each field is in.

Other reports include the bracketed module printout (all lines are numbered and indented properly with each loop bracketed), object cross-reference reports, module listings for procedures, variables, etc., application flow diagrams, and detailed "dictionary" reports for each object and its properties.

I can no longer figure out how my Access application "works"

As your database grows with more objects, relationships, and complex dependencies, you'll have trouble determining how it works (or doesn't work).

Solution: Total Access Analyzer documents object and code cross-referencing so you can easily determine where and how an object is used.

More importantly, Total Access Analyzer takes this information even further by revealing complex multi-level relationships. Not only can you see what an object references, but you can see what the referenced object references as well! The Application Flow, Data Flow, and Object Diagrams provide an excellent overviews of your database.

The Application Flow Diagram reveals how your application starts and what events, code, or macros get called, and what those call. See the entire hierarchical tree of your application flow.

The Data Flow Diagram shows how data "flows" through your application, from tables to queries to forms and reports. Complex, multi-query relationships are clearly revealed.

I just inherited a big Access project. Help!

Research indicates that over 80% of Access database projects lack documentation of any kind. If you inherit even a mildly complex Access project, you'll spend weeks just figuring out how it works.

Solution: Only Total Access Analyzer offers the comprehensive set of tools that give you the jumpstart on an inherited project. Cut your ramp-up time from weeks to days with Total Access Analyzer's full set of reports and view tools.

I don't have time to try and find all the errors in my application.

As your deadlines loom closer, the time you have to proactively detect and fix errors dwindles. How to you ship an Access database application with a reduced error count?

Solution: Total Access Analyzer performs sophisticated analysis on your database application to find a wide range of errors and potential errors, including missing objects, unused objects and code, inconsistencies, etc.

How can I find out which objects in my database are no longer used?

As you do development work in your Access project, you end up with lots of unused objects. Temporary objects, copies of objects, and backups all combine to add bloat to your database. But because you can't find out whether the objects really aren't used, you're afraid to delete a questionable query, macro, or procedure. 

Solution: Total Access Analyzer reveals unused objects and code in your database so you can determine what should be deleted.

I want to make my application run faster. Can Total Access Analyzer help?

Access makes it easy to add objects and link them together. However, Access also makes it too easy to create data sets and forms and reports that simply run too slowly. You don't have time to dig through your application and find all the potential performance bottlenecks.

Solution: Total Access Analyzer provides a complete and comprehensive list of performance suggestions that will make your application run faster.

I'm about to deliver my application. But the client wants documentation. What do I do?

Documentation is often the last part of a project. If you have a limited amount of time, you may get to the end of development and find only a small amount of time to document the hundreds of objects in your Access database.

Solution: Total Access Analyzer provides presentation quality documentation with over 295 reports. You can provide your end-user or client with all the documentation they desire with the click of a button.

In fact, many consultants recoup the cost of Total Access Analyzer many times over by charging their clients for such technical documentation on every project they deliver!

I need a solution that is simple and quick

The last thing you have time for is manually documenting and analyzing your database. You need a solution that takes no time on your part.

Solution: Total Access Analyzer runs as an Access add-in. Simply open your database and launch Total Access Analyzer. Its step-by-step wizard lets you easily select the objects to analyze and the analysis to perform. When it's complete, you can view and print/preview the results. All the results are stored in tables in a separate Access database.