Generate Documentation for the Student Table Review the Options and Verify That the Documentation

Learn and Utilise Best Practices for Microsoft Access

Total Access Analyzer helps you create meliorate, more robust, and faster Admission databases with more command and fewer errors!

Winner of Every All-time Access Add-In Accolade Since 1994

Discover why so many Microsoft Access users and developers rely on Total Access Analyzer to deliver cracking Access solutions for over 25 years!

Full Admission Analyzer examines all your database objects to provide all-encompassing documentation, code analysis, object cross-reference, and diagrams with over 400+ presentation-quality reports. Information technology detects 300+ types of errors, suggestions, and performance tips, and then you can acquire and employ Best Practices to fix problems, better your design, and speed upward your Access applications.

Integrated within Your Access Surround

Open your database and launch Total Admission Analyzer from your Add-ins menu:

SHIPPING FOR MICROSOFT Admission 2019/Part 365

Enhancements:

Ribbon Analysis
Data Macro Analysis
New Errors and Suggestions
15 New Reports
Written report proper noun filter
SQL Cross-Reference and Validation of Subform References
View Explorer Enhancements
Most Box has Check for Updates
Improved User Interface
Revised User Manual and Help File
And more...

Overview of Principal Form

The principal menu of Total Access Analyzer appears:

Main Carte du jour of Full Access Analyzer

From here, you can easily:

Create new detailed documentation for your database
For previously generated documentation on this or another database:
- View the results
- Search for any cord across the object backdrop and code
- Preview, print, or export reports to file
Generate simple "quick" documentation for your objects

Because Total Access Analyzer runs inside Access, it leverages the ability of Admission to document and nowadays the results in Access forms and reports. In many places, it likewise offers the power to look at the results and jump into design style for the current record'southward object with a single keystroke. This lets yous easily examine the results and apply the suggestions.

Comprehensive Documentation

Database Analysis

Total Access Analyzer performs detailed analysis of your Access database objects individually and equally a whole. Past examining your entire database, information technology discovers circuitous relationships among objects, hidden bug, and even unused objects. Have control of your databases by agreement how they work. Full Access Analyzer non only generates cross-references between your objects, it too creates diagrams of your application and data menstruation to bear witness multi-level relationships. If you desire to understand what'south really going on in your database or demand to get upwardly-to-speed on databases created by others, Full Access Analyzer is your solution.

Module Assay with Our Sectional Code Parser

Total Admission Analyzer includes our proprietary Microsoft Visual Basic for Applications (VBA) code parser that understands your module lawmaking to generate detailed analysis of your code in modules, classes, and backside forms and reports. Know where each process and variable is used. Discover unused code, unreferenced variables (assigned but not used), references to missing objects, variable name conflicts, scoping bug, and much more than! Total Admission Analyzer pinpoints issues in your code to teach y'all how to be a better Access/VBA developer.

Create Improve and Faster Access Applications

Total Access Analyzer helps you apply the 'Best Practices' principles that nosotros've learned at FMS. Perform the same analysis on your databases to encounter what you tin can better. For instance, eliminate potential data loss with the field consistency analysis that ensures identically named fields across tables are defined consistently. Find forms with indistinguishable hotkey letters, reports without a NoData event, unused objects and code, procedures that should be private, short combo boxes, and much more.

Database Period Diagrams

Hierarchical diagrams visually reveal how objects reference each other through multiple levels.

Data Diagram

How information flows from tables into queries, forms, reports, etc.

Object Diagram

What objects are referenced by a form, report, or query

For detailed assay and comprehension, select an item and redraw the hierarchy of a single object. The redrawn diagram can be printed from the Documentation Explorer, allowing you to create a report of a unmarried object'southward diagram.

Integrated Documentation Explorer

Documentation Explorer

The documentation results are shown in the powerful Documentation Explorer, that lets yous hands browse the most complex Access databases through an intuitive hierarchical treeview. Look at summary and detail information on any documented object:

Tabular array Field Dictionary

Meet all your tables and fields in one list. Easily:

Run across and sort all the fields beyond all your tables
Search by field proper name
Filter by field name and see all the tables that use it
Filter past data type to see the tables and fields that utilize information technology
and much more because the results are in a tabular array displayed as a datasheet

Property Slices

The power of Total Access Analyzer comes with its ability to show data across all objects. The Property Slice feature lets you lot choose a property name and see all the objects' values for that holding. Simply select a folder and run across a property beyond all the objects like the RecordSource for all forms:

You lot can as well see holding values beyond all grade controls. Similarly, for Tables and Queries, you can choose object level or field/column level properties.

Cross-Reference Where Objects are Used by Other Objects

The XRef tab shows for each object, where it's used throughout your database including references from other objects, macros, and modules. Here y'all can see each tabular array and what objects and controls are referencing it such queries, RecordSource of forms and reports, RowSource of combo boxes and list boxes, macros, explicit references in VBA code, and lookups in tabular array fields:

Examples of cantankerous-referencing other objects include where a query is used, all the forms a grade is used every bit a subform, where macros are invoked, where functions are used beyond queries, etc.

Bug: Errors, Suggestions and Operation Tips

Errors, Suggestions and Operation tips are displayed in their tabs. By pressing Alt+D, y'all tin can open up the electric current object in pattern way to examine and make the recommended changes. Check the "Reviewed" box for items yous don't desire or need to change, so the adjacent time the database is documented, your Reviewed condition is preserved. You can fifty-fifty filter on the Reviewed status to see any new problems from your last run.

Search Your Documentation

You tin can also search the documented properties, macros, and modules for any word or phrase, to see all the places information technology'due south used. The results are presented to you and y'all can immediately open the current object in Design manner with a keystroke:

Extensive Documentation Reports

Total Admission Analyzer contains 400+ reports ranging from elevation level overviews to private object details. All the reports can exist customized with your headers, footers, and colors so yous can deliver professional documentation of your work. Many of the reports tin also be filtered and y'all can define your own batch of reports as a set that can be easily retrieved again.

Module Printouts

Total Access Analyzer offers two reports to impress your modules. The first is the standard display of your code as is, the 2d formats your code to indent the logic loops and bear witness brackets around loops and go out arrows from them:

Form and Study Blueprints

Quickly see what each form and written report looks like with each control annotated:

Simplify Your Development Efforts

As your databases grow in complexity, they become harder and harder to sympathise. Total Access Analyzer generates the information you need to maintain control and efficiency.

From simple tabular array structure lists, to field dictionaries (for each field proper noun, see every table containing that field name), to property listings, object cross-reference, flow diagrams, and code printouts, Total Access Analyzer gives you the information and reports you demand to manage your systems.

Save Your Reputation: Don't Ship Without Running Full Admission Analyzer

Total Access Analyzer provides the most comprehensive Access fault 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 Admission Analyzer finds these hidden errors.

Think of the time and embarrassment you'll save! Detect why and so many organizations run Total Access Analyzer as part of their final quality assurance cheque earlier deploying any Access database.

Versions and Availability

Due to the differences between Access versions, at that place is a separate version of Total Admission Analyzer for each version of Access. It can clarify all the database formats that its Admission version supports. For instance, if yous are using Access 2016, Total Access Analyzer 2016 runs in Admission 2016 and supports Admission MDBs and ACCDB database formats created with earlier Access versions that can be opened in Access 2016. Note that Admission 2013 and 2016 practise not support ADPs, so if you desire to clarify ADPs, use Total Access Analyzer 2010 or earlier.

The latest version supports Access 2019 and the constantly evolving Access/Office 365 version. As Microsoft introduces new features in Access 365, updates will exist required as we release new versions to support it.

Simply choose the Total Access Analyzer version for the MS Access version you lot are running.

jonescuposer.blogspot.com

Source: https://www.fmsinc.com/MicrosoftAccess/BestPractices.html