Editing a Query in Design View

After you create a query, you can modify it by opening it in Design view. In Design view, you can add a table to the Query design area, add or remove query fields, or even add every field from a table in one fell swoop.

Open a Query for Editing

  1. Display the queries in your workbook.

  2. Right-click a query.

  3. Click Design View.

Add a Table to a Query

  1. Open the query in Design view.

  2. Click the Show Table button.

  3. Click the table to ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.