Others

Microsoft Access Queries: What Does the File As Field Mean?

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

The user wants to understand what “File As” means in a Microsoft Access query and whether it is related to the SQL AS keyword.

What Does the File As Field Mean in a Microsoft Access Query?
Product
Microsoft Access
Device & OS
not provided
Scenario
Interpreting a field name or expression displayed in an Access query.
Observed behavior
The meaning depends on whether “File As” is a source field, a column alias, or an application-specific label; the complete query is needed to confirm.
Before you start

Locate the query and note exactly where “File As” appears: in the results, the query design grid, or the SQL statement. You will need the field expression and its source table to determine its meaning.

Solution 1Recommended

Check the query definition to distinguish a field name from an SQL alias

Use the query’s Design View and SQL View to identify what “File As” represents in your database.

“File As” is not a universal built-in Access query field. It could be a field defined by the database, an alias assigned to a query column, or a label used by the application.

The SQL keyword AS assigns an alias to a field or expression. A field named [File As] is not itself an SQL keyword; the brackets allow Access to handle the space in its name.

1
Open the query in Design View

In the Access Navigation Pane, right-click the query and select Design View. Find the column associated with “File As” and inspect its Field and Table rows.

2
Read the SQL statement

With the query open in Design View, use View > SQL View. Look for [File As], AS [File As], or another expression that creates the displayed column.

3
Interpret the field or alias

If the query selects [File As] from a table, inspect that table in Design View to check the field’s definition and description. If the SQL contains an expression followed by AS [File As], “File As” is the output column’s alias. For example, SELECT Lastname & ", " & Firstname AS Fullname FROM tblPeople; displays the combined name under Fullname.

4
Gather context if the meaning remains unclear

Copy the query text from SQL View and identify where “File As” appears. Share the relevant SQL and field definition, removing personal data, so the label can be interpreted in context.

Check the query definition to distinguish a field name from an SQL alias
An alias names the query output: AS changes the output column’s name; it does not rename the underlying table field. In Access Design View, a calculated alias may appear as Fullname: Lastname & ", " & Firstname.
Free Microsoft Office alternative

Review Exported Access Query Results in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility for easy migration of spreadsheet workflows. Export your Access query results to an Excel workbook, then use WPS Spreadsheet to review them. WPS does not replace Access for inspecting database queries or opening Access database files.

Review, sort, and filter exported query results in WPS Spreadsheet.Open and edit Microsoft Excel .xlsx and .xls files exported from Access.Use a familiar spreadsheet interface for an easy transition from Excel.Work with a free, lightweight Office suite for everyday spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Is File As a standard field in every Access database?

No. Its meaning depends on the database or application. Right-click the query in the Navigation Pane, select Design View, and inspect the Field and Table rows to find its source.

What does AS do in an Access SQL query?

AS assigns a name to an output column. For example, SELECT Lastname & ", " & Firstname AS Fullname FROM tblPeople; labels the calculated column Fullname without renaming the table’s original fields.

Why does [File As] have square brackets around it?

Access uses square brackets to delimit identifiers such as field names containing spaces. [File As] refers to a name, while AS outside the brackets is the SQL alias keyword.

How can I tell whether File As is stored or calculated?

Open the query in Design View and switch to View > SQL View. A reference to a source-table field named [File As] indicates stored data; an expression followed by AS [File As] creates a named query output. If the source is another query, inspect that query too.

Can WPS Office open my Access query directly?

WPS Office does not open Access .accdb or .mdb databases to inspect their queries. In Access, select the query and use External Data > Excel to export its results, then open the exported .xlsx file in WPS Spreadsheet.