This report shows each Microsoft Access table with its fields and definitions. This is among the most basic documentation you need to understand the tables in your database.
For each table, see a list of fields with its properties: data type, size, description, whether it's part of the primary key, and whether it's part of a secondary index.
Here's the complete list of the Total Access Analyzer reports documenting the tables in your MS Access database. Click on the hyperlinks for more information. Rather than overwhelm you with every report, we've provided a subset of the most interesting reports for you to review. The others show similar data but use different sort orders or filters.
Simple lists to gain a quick understanding of all the tables in your database and their relative size
Examine fields lists for each table, or for each field which tables its in, along with their properties
Look at all the properties of a field the way you would in the table designer or see a property value across all the fields that have them.
Examine indexes and their fields and properties
Detailed listing of each table, its properties, indexes, fields, etc.
Version 16.7 for
Microsoft Access 2016
Version 15.7 for
Microsoft Access 2013
Version 14.7 for
Microsoft Access 2010
Version 12.97 for
Microsoft Access 2007
Version 11.95 for
Microsoft Access 2003
Version 10.8 and 9.8 forr
Access 2002 and 2000
"Total Access Analyzer is an amazing product that I've relied on and recommended for years. It's a huge time saver."
Sal Ricciardi, Programming Writer, Microsoft Corporation