Customize the table and query names in a query

Rename a table or query that's added to a query

Note   Renaming copies of a table or query in a query doesn't rename the underlying table or query.

1. Open a query in Design view.
2. Click anywhere in the second copy of the field list for the table or query, and then click Properties on the toolbar to display the property sheet.
3. In the Alias property box, type a new name for the table or query.

Show or hide table names in the query design grid by default

1. On the Tools menu, click Options.
2. Click the Tables/Queries tab.
3. Select or clear the Show Table Names check box.

Note   This setting applies to new queries only.