Add or remove a table or query in the query design grid (MDB)

Microsoft Office Access 2003

previous page next page
  1. Open a query in Design view.
  2. On the toolbar, click Show Table Button image.
  3. In the Show Table dialog box, click the tab that lists the objects whose data you want to work with.
  4. Click the name of the object you want to add to the query. To select additional objects one at a time, hold down CTRL while you click each object name. To select a block of objects, click the first name in the block, hold down SHIFT, and then click the last name in the block.
  5. Click Add, and then click Close.

    ShowTip

    You can also add a table or query to a query by dragging the table or query name from the Database window to the upper part of query Design view.

ShowRemove a table or query from a query

  1. Open a query in Design view.
  2. In the upper part of query Design view, select the table or query you want to remove by clicking anywhere in its field list, and then press the DELETE key.

    Fields that you have dragged from the field list to the design grid are also removed from the query. The table or query is not deleted from the database, however.

previous page start next page