Microsoft Access Table Field Definitions, Sorted by Field Name

This powerful report shows where and how each field in your Microsoft Access table is defined across multiple tables.

In this example, the data is sorted by field name (Address, Birth Date, CategoryID). Within each grouping, you can see the list of tables which with this field. For instance, there is an Address field in the Customers, Employees, and Suppliers tables.

The data here is identical to the Table Fields, Sorted by Table Name report, but is sorted by Field Name. This shows all the tables with identically named fields. This is a great tool for verifying consistency of field definitions. It can also help you find field names that are spelled slightly differently which should be identical.

Field Consistency Analysis

A good programming practice is to make sure identically named fields are defined the same way (same data type and data size). Total Access Analyzer performs field consistency analysis to determine if the same field name is defined with different data types or sizes in different tables. If it finds any, a report under Suggestions called "Table Fields with Different Types" is created.

Microsoft Access Table Field Definitions documentation report sorted by field name


Total Access Analyzer Reports for Microsoft Access Tables

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.

Basic Table Lists

Simple lists to gain a quick understanding of all the tables in your database and their relative size

Table Properties

  • Table Properties, Sorted by Table Name
  • Table Properties, Sorted by Property Name

Table Fields

Examine fields lists for each table, or for each field which tables its in, along with their properties

  • Table Fields, Sorted by Table Name (Portrait and Landscape versions)
  • Table Fields, Sorted by Field Name (Portrait and Landscape versions)
  • Table Fields, Sorted by Data Type and Size Summary
  • Table Fields, Sorted by Data Type and Size Detail
  • Table Field Properties, Sorted by Table Name
  • Table Field Properties, Sorted by Field Name
  • Table Field Properties, Sorted by Property and Table
  • Table Field Properties, Sorted by Property and Field

Table Field General 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.

Table Indexes

Examine indexes and their fields and properties

  • Table Indexes, Sorted by Table Name
  • Table Indexes, Sorted by Fields
  • Table Index Properties, Sorted by Table Name
  • Table Index Properties, Sorted by Property and Table
  • Table Index Properties, Sorted by Property and Index

Table Dictionaries

Detailed listing of each table, its properties, indexes, fields, etc.

Table Cross Reference


Free Product Catalog from FMS