لطفا منتظر باشید ...
Total Access Analyzer
FMS, Inc. also produces Total Access Analyzer. Its uses include database documentation and analysis. Total Access Analyzer allows you to quickly and easily generate documentation for tables, fields, indexes, relationships, queries, views, database diagrams, stored procedures, forms, reports, controls, data access pages, macros, modules, command bars, users, groups, security, and more! You can view the documentation onscreen in a Tree view, or you can easily output it to a printer.Total Access Analyzer also performs extensive analysis of your database to generate cross-reference information showing where your objects, fields, and code are used. The hierarchical diagrams are particularly powerful for understanding a database. It also detects a wide variety of problems to help you find more than 100 types of bugs, and provides suggestions and performance tips for debugging. For instance, queries or forms might use a field that no longer exists, or you might want to know which queries or variables aren't used so that you can delete them. The field consistency analysis is also helpful to make sure that you define the same field name identically across all your tables. FMS has incorporated much of its "Best Development Practices" into Total Access Analyzer so that you can find and fix problems quickly. In fact, many organizations insist on running Total Access Analyzer against their databases before they deploy them. After all, why let your users experience a crash when Total Access Analyzer can detect the crash before it occurs?I find that clients are impressed and comforted when I provide them with detailed documentation about the applications that I build. Total Access Analyzer is an easy-to-use tool that quickly generates documentation sure to impress just about any boss or client.Total Access Analyzer features a Documentation Wizard that simplifies that documentation process. Figure 31.4 shows the first step of the Documentation Wizard. In this step, you select the objects that you want to document. The second step of the wizard, pictured in Figure 31.5, allows you to designate all your documentation options. Options include what cross-references you want to generate, as well as whether you want to document database security. I am particularly impressed with the cross-reference features available in Total Access Analyzer. My favorite feature is the capability to generate detailed cross-references between the Visual Basic for Applications (VBA) code in a database. The final step of the wizard, pictured in Figure 31.6, allows you to perform the documentation process, or schedule it for a later time.
Figure 31.4. The first step of the Documentation Wizard allows you to designate the objects you want to document.
Figure 31.5. The second step of the Documentation Wizard allows you to designate documentation options.
Figure 31.6. The final step of the Documentation Wizard allows you to perform the documentation process or to schedule it for a later time.
I find the completed documentation to be professional and easy to work with. Figure 31.7 provides an example of the completed documentation on screen. Notice that you can view a summary, the code, a cross-reference, reported errors, suggestions, and a performance analysis for the selected procedure. Figure 31.8 shows an example of a printed report that provides a modules reference of what each procedure calls. This report is invaluable when debugging a complex application.
Figure 31.7. The onscreen documentation provides you with a plethora of information.
Figure 31.8. The printed reports are numerous. Each one provides you with invaluable information.
