Others

Rename or Map Table Fields with Microsoft Access Queries

Rana GarciaRana Garcia Nov 18, 2026 869 views

Question details

The user needs to use different field names for imported report data or map fields between Access tables.

Product
Microsoft Access
Device & OS
not provided
Scenario
An imported report has field headings that differ from the client's required headings, or its data needs to be copied into a destination table.
Observed behavior
The source and required destination field names differ, so the query must provide the correct headings or field mapping.
Before you start

Identify the source fields and the required output or destination field names. If copying or updating records, check the destination field types and the key used to identify matching records.

Solution 1Recommended

Use a SELECT query to display fields with different headings

Use aliases when you only need the client's headings for a report or export, without copying or changing table data.

1
Open SQL View

In Access, select Create > Query Design, then switch to SQL View.

2
Enter field aliases

Enter a query such as SELECT [FieldA] AS [FieldX], [FieldB] AS [FieldY] FROM [MyTable]; replacing the table and field names with your own.

3
Run and save the query

Select Run to check the headings and results, then save the query. Use the saved query as a report source or export its results.

Use a SELECT query to display fields with different headings
Aliases do not rename table fields: The original field names and data remain unchanged. Run the saved query again after importing a new report with the expected source fields.
Free Microsoft Office alternative

Work with exported Access report data in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with exported spreadsheet data. It does not run Access queries, but you can export query results from Access and open them in WPS Spreadsheets for further editing.

Review and edit exported report headings in WPS SpreadsheetsOpen and save Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does a SELECT alias rename the field in the original table?

No. An expression such as [FieldA] AS [FieldX] changes the heading in the query results, not the field name in the source table.

When should I use an Append query instead of an Update query?

Use Append to add new records to a destination table. Use Update to change field values in records that already exist.

Can I reuse the query after importing another report?

Yes. Save the SELECT query and run it again after importing the new report, provided the query can still find the expected source table and fields.

Will appending records delete them from the source table?

No. An Append query copies selected records into the destination table; it does not remove the source records.

Can WPS Office run my Access query?

WPS Office does not run Access queries. Run the query in Access, export its results to an Excel file, and then open that file in WPS Spreadsheets.