MS-Access Object Documenter

Introduction

We usually prepare Reports on processed or raw data and take printouts to share the information with others.

But, sometimes we need details of the database Objects: Tables, Queries, and Scripts (Macros) or VB Modules and other objects. We can take a detailed listing of Objects, like Table Fields and their Properties, Data Types and Sizes, or the Control Names on Forms/Reports and their properties, User-Level & Group-Level Permission Settings, and so on.

Table Properties Listing

We will take a listing of a Table with Field Names, Data Type, Size of each field, and the Index information. I have used the Employees Table for our example, but you can try this with any Table in your Database. The sample listing is given below:

Click to Enlarge

1. Select Tools - - > Analyze - - > Documenter.

2. Click on the Tables Tab.

   

   Click to Enlarge

3. Put Check Mark on any of your Tables.

4. Click on the Options button to open the Options Dialog Control.

   

5. Change the settings as shown above and click OK to close it.

6. Click OK on the first Dialog control to format the Listing based on selected options and open it in Print Preview.

Note: Each type of Object has its own option settings, which produce detailed information based on their selections.

• Custom Menus and Tool Bars
• Calendar and Toolbars
• Animated Floating Calendar
• Startup Screen Design
• Control Screen Menu Design