Document Access Tables to Excel

Document your Access database tables to Excel! Make a list of all the tables and a data dictionary. and more.

* Download from MsAccessGurus
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.

0:04 don't remember what the data is? This code is for you!
0:30 presentation with Maria Barnes at end of this month, August 2021
1:32 To run this code, you'll need 3 modules:
1:37 1. the module with Document_Tables2Excel
1:41 2. and you'll also need a module to handle Properties
1:45 3. a module that has a function to GetDataType,
2:01 activate the Document_Tables2Excel module
2:09 run launch_Document_Tables2Excel
2:49 The file prefaced with TableSummary has data structure and statistics
3:04 The first sheet is a ListOfTables
3:10 You can also see how many records are in each table,
3:13 how many fields each table has,
3:16 and an estimated record width for standard data types.
3:22 hyperlink to the data structure
3:59 The basics for a Data Dictionary are tablename, fieldname, data type, and size
4:21 Description, Format, and DefaultValue.
4:32 In Excel, when you press Ctrl-G for the Goto box, the default reference is the last ActiveCell address
5:06 Everybody is a contact -- all the students, teachers, janitors, landscape artists, and so on.
5:34 I have 2 contact management systems you can download for free
6:40 InputMask, ValidationRule, and ValidationText
6:51 Unicode Compression.
9:16 Table names in Access can be 64 characters.
9:31 Do you like what this code does? Let me know in the comments.

* Presentation for AccessUserGroups -- free to attend
31 August 2021, 12 noon Central Time
Access Lunchtime – Tips and Shortcuts for the Beginning Access Developer, Part 3
by Maria Barnes and Crystal Long
https://accessusergroups.org/lunch/event/access-lunchtime-3-2021-08-31/

* My Contacts - light version of contact management system
http://msaccessgurus.com/tool/MyContacts.htm

* Contact Template for Access - full version, split into FE and BE
http://msaccessgurus.com/Contacts.htm

* For more extensive documentation, you can get the free Analyzer here:
http://msaccessgurus.com/tool/Analyzer.htm

Share your comments, thanks.

kind regards,
crystal

Remote Training and Programming
Let's connect and build your application together!
http://msaccessgurus.com/training.htm
email Training AT msaccessgurus.com