Customize the table and query names in a query (MDB)

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.

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.