Re: [MSAccessProfessionals] Create a Data Dictionary for your Access database

Thanks, Crystal! This is such a useful tool, especially when inheriting a database that needs a lot of work to make usable. It's nice to have every detail in an easy-to-read spreadsheet.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
https://wrmosca.wordpress.com

-----Original Message-----
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Wednesday, August 25, 2021 8:16 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Create a Data Dictionary for your Access database

hi everyone,

Create a Data Dictionary for your Access database, and write the results to Excel

video:
Document Access Tables to Excel (10:16)
https://youtu.be/r6LRurruI44

code:
VBA > Document > Tables to Excel
http://msaccessgurus.com/VBA/Code/Document_Tables2Excel.htm

Creates an Excel workbook with the documentation. The first sheet, ListOfTables, gives you the Table name, number of records, number of fields, and also an estimated record width for the standard data types.

The DataDictionary sheet lists Table name, Field number, Field name, Data Type, Size (byte), Description, Format, Caption, Default Value, Expression, Input Mask, Validation Rule, Validation Text, Required, Unicode Compression, and Estimated Width.

kind regards,
crystal

Remote Training and Programming
connect to me - let me help your project be a great success









-=-=-=-=-=-=-=-=-=-=-=-
Groups.io Links: You receive all messages sent to this group.
View/Reply Online (#116037): https://groups.io/g/MSAccessProfessionals/message/116037
Mute This Topic: https://groups.io/mt/85153347/3568969
Group Owner: MSAccessProfessionals+owner@groups.io
Unsubscribe: https://groups.io/g/MSAccessProfessionals/leave/6606618/3568969/577250336/xyzzy [sugeng.panjalu.access@blogger.com]
-=-=-=-=-=-=-=-=-=-=-=-