Introduction.
Typically, we prepare reports based on processed or raw data and print them for sharing or documentation purposes.
However, there are times when we need detailed information about the database objects themselves, such as Tables, Queries, Macros, VBA Modules, and other elements.
In such cases, we may require comprehensive listings that include:
-
Table fields along with their data types, sizes, and properties
-
Control names and properties on Forms or Reports
-
User-level and group-level permission settings
-
Macro and Module content summaries
These object-level reports can be invaluable for documentation, auditing, or troubleshooting purposes.
Table Properties Listing.
We will generate a detailed listing of a table that includes field names, data types, field sizes, and index information.
In this example, we've used the Employees table, but you can apply the same procedure to any table in your database.
A sample listing format is shown below for reference:
Select Tools - - > Analyze - - > Documenter.
Click on the Tables Tab.
Put a Check Mark on any of your Tables.
Click on the Options button to open the Options Dialog Control.
Change the settings as shown above and click OK to close it.
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.
No comments:
Post a Comment
Comments subject to moderation before publishing.