How to List All Field Names in Microsoft Access Tables
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.

- 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.
Ensure you have full design permissions for the Microsoft Access database to view table structures and access the built-in database tools.
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.
Open your database in Microsoft Access, navigate to the 'Database Tools' tab on the top ribbon, and click on 'Database Documenter'.
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.
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'.
Click 'OK' again to generate the report. Access will create a printable document detailing the selected tables and listing their respective field names.

Use Access VBA to Enumerate Fields
For users comfortable with coding, VBA can be used to loop through tables and print a clean, customizable list of fields directly to the Immediate Window.
Create a Custom Form with List Boxes
You can build an interactive database interface where users select a table from one list to automatically display its fields in another.
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. Export Your Access Data: In Microsoft Access, export your generated field list or Database Documenter report to an Excel (.xlsx) file format.
- 2. Open WPS Spreadsheet: Launch WPS Office on your computer and open the Spreadsheet module.
- 3. Analyze and Share: Open the exported file to quickly format, filter, and analyze your database field lists easily and for free.

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.




