Others

How to List All Field Names in Microsoft Access Tables

Steven ParkerSteven Parker Nov 4, 2026 870 views

Question details

The user needs to generate or view a complete list of all field names (columns) across specific tables in a Microsoft Access database.

How to List All Field Names in Microsoft Access Tables
Product
Microsoft Access
Device & OS
not provided
Scenario
Documenting database structures, analyzing table schemas, or preparing to migrate databases where a comprehensive list of table fields is required.
Observed behavior
The user requires a streamlined method to extract and display all column names from Access tables without having to manually open and inspect each table individually.
Before you start

Ensure you have full design permissions for the Microsoft Access database to view table structures and access the built-in database tools.

Solution 1Recommended

Use the Built-in Access Database Documenter

The Database Documenter tool is the quickest and most straightforward way to generate a comprehensive report of your table structures, including all field names.

Microsoft Access includes a native documentation tool that can automatically scan your database and print out the schemas of any tables or queries you select. This method requires no coding.

1
Open the Database Documenter

Open your database in Microsoft Access, navigate to the 'Database Tools' tab on the top ribbon, and click on 'Database Documenter'.

2
Select the Tables

In the Documenter dialog box, select the 'Tables' tab. Check the boxes next to the specific tables for which you want to list the field names.

3
Adjust Print Options

Click the 'Options' button to customize the report. To get a clean list of just field names, minimize the properties, indexes, and permissions selections, then click 'OK'.

4
Generate the Report

Click 'OK' again to generate the report. Access will create a printable document detailing the selected tables and listing their respective field names.

Use the Built-in Access Database Documenter
Export the Report: Once the report is generated, you can use the Print Preview ribbon to export the documentation directly to a PDF, Excel, or Text file for easier sharing.
Free Microsoft Office alternative

Manage Exported Database Reports Easily with WPS Office

While Microsoft Access is a specialized tool for managing relational databases, you will often need to export those field lists, tables, and reports for further analysis, formatting, or sharing. WPS Office is a lightweight, completely free alternative that seamlessly handles exported Access data in Excel and Word formats.

  1. 1. Export Your Access Data: In Microsoft Access, export your generated field list or Database Documenter report to an Excel (.xlsx) file format.
  2. 2. Open WPS Spreadsheet: Launch WPS Office on your computer and open the Spreadsheet module.
  3. 3. Analyze and Share: Open the exported file to quickly format, filter, and analyze your database field lists easily and for free.
Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) formats for analyzing exported Access reports.Lightweight and lightning-fast installation compared to heavy database and office suites.Familiar user interface makes it incredibly easy to format your database field lists without a learning curve.Completely free to download and use for all your everyday spreadsheet and document needs.
microsoft office alternative - wps office

Frequently Asked Questions

Can I export the Access Database Documenter report to Excel?

Yes. After generating the documentation report in Access, you can use the 'Export' group located on the Print Preview ribbon to send the output directly to an Excel file, PDF, or text file for further editing.

How do I list fields from a specific query instead of a table?

The process is identical to listing table fields. In the Database Documenter dialog box, simply select the 'Queries' tab instead of the 'Tables' tab. Check the queries you want, and the documenter will generate a list of field names for them.

Is there a faster manual way to view field names without running reports?

Yes. The fastest manual way to view a single table's field names is to right-click the table in the Navigation Pane and select 'Design View'. This view provides a straightforward, vertical list of all column names along with their assigned data types and descriptions.

Why are system tables missing from my database documenter list?

By default, Microsoft Access hides internal system tables. To view them, right-click the top of the Navigation Pane, select 'Navigation Options', and check the box for 'Show System Objects'. You will then be able to select these tables in the Database Documenter.