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

Microsoft Office Access 2003

previous page next page

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 Button image on the toolbar to display the property sheet.
  3. In the Alias property box, type a new name for the table or query.

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

previous page start next page