This documentation describes the reports generated by
Analyzer_081113_16_9p.MDE
a program by Crystal to analyze databases
 
Crystal_Analyzer_MDE_PPS_ReadMe_Documentation_081113.zip
 
source:
http://www.AccessMVP.com/strive4peace/Dictionary

contains:
 
MDE - Crystal's Database Analyzer
PPS - PowerPoint to show how to interpret Deep Analysis Report
TXT file (what you are reading)
DOC - Word documentation 
 
Crystal's Database Analyzer is an Access 2000 MDE that analyzes external Access databases and stores structure in tables.  Generates the following Reports:

- Table Summary
- Field List
- Data Dictionary with Value Analysis
- List of Table Indexes
- Relationships Report

you will have tables with structure information for every external Access database that you analyze -- and cool reports!

sorry it is an MDE (so you can't look at design) -- if requested, I will work on getting a 97 version of the MDE for you, this is Access 2000
 
If this was not so highly useful for Access, I would not post it because I am not willing to post the code publically (spent years refining it) and Bill gave me special permission to share this MDE with you.

*************************************  Reports

The Reports generated by the Analyzer are:
 
Table Summary, sorted by table name
~~~~~~~~~~~~~~~~~~~~~~~~
- Table Name
- Table Description
- whether it is linked
- Number of Fields
- Number of Records
- Date Modified
- Number of Indexes
 
Field List, sorted by Field Name and then by Table Name
~~~~~~~~~~~~~~~~~~~~~~~~
- Field Name
- Table Name
- Data Type
- Field Size
- # Values Filled
- # Unique Values
- Field Description
 
Deep Analysis: Data Dictionary with Value Analysis,
sorted by Table Name and then Field order
~~~~~~~~~~~~~~~~~~~~~~~~
- Table Name
- Table Description
- Number of Fields
- Number of Records
- Date Created
- Date Modified
~~~~~~~~~~~~~~~~~~~~~~~~
- Field Order
- Field Name
- Field Description
- A if Autonumber
- Data Type
- Field Size
- Maximum Length used (text fields)
- Indexes -- Primary Key, Required, Unique, Foreign Key
- # Values Filled
- # Unique Values
- % Filled
- % Unique
- Default Value
- Minimum Value
- Maximum Value
 
Relationships Report
~~~~~~~~~~~~~~~~~~~~~~~~
- Primary Table
- Foreign Table
- Key field (and Data Type and Size)
- foreign Key Field (and Data Type and Size)
- RI - if Referential Integrity is enforced
- Link - if tables are linked or resident

 
Table Indexes Report
~~~~~~~~~~~~~~~~~~~~~~~~
- Tablename
- # Relationship Indexes
- # Table Indexes
- Number of Records if >0
- Number of fields
~~~~~~~~~~~~~~~~~~~~~~~~
- Index Name
- Key field (and data type and size)
- Foreign Key field (and data type and size)
- # and % filled
- # and % Unique values
- if foreign key, main table and fieldname

I usually export reports to SNP (Snapshot) format to share with others.  If they cannot render files in SNP (snapshot) format, here is a link to the Microsoft site to download the SNAPSHOT viewer for Access:
http://www.microsoft.com/downloads/details.aspx?familyid=B73DF33F-6D74-423D-8274-8B7E6313EDFB&displaylang=en
 
The Deep Analysis Report is especially useful for optimizing a database.  You will see examples of the data in each field as well as fields that are allocated for a much bigger size than they need.  I have attached:

Crystal_Analyzer_DeepAnalysisReport_t_Addr.pps

this is a PowerPoint slide show to show information displayed on the Deep Analysis report since it is not well labeled (look in the page footer).
 
I am interested in your feedback, thank you. 
 
Warm Regards,
Crystal
strive4peace2008@yahoo.com
 
Microsoft MVP, Access
remote programming and training
 
 
 *
   (: have an awesome day :)
 *


 
