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

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

ShowAdd a table or query to a query

  1. Open a query in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  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

ShowRemove a table or query from a query

 
 
Applies to:
Access 2003