Microsoft Access Queries: What Does the File As Field Mean?
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.

- 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.
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.
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.
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.
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.
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.
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.

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.

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.




