Home > Sample chapters > Microsoft Office > Access

Creating Queries in Access 2010

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

Open a Query for Editing

  1. Display the queries in your database.

  2. Right-click a query.

  3. Click Design View.

    httpatomoreillycomsourcemspimages613720.jpg

Add a Table to a Query

  1. Open the query in Design view.

  2. Click the Show Table button.

  3. Click the table to add.

  4. Click Add.

  5. Click Close.

    httpatomoreillycomsourcemspimages613722.jpg

Add a Field to a Query

  1. Open the query in Design view.

  2. Drag a field to a Field cell.

    httpatomoreillycomsourcemspimages613724.jpg

Create a Query in Design View

  1. Click the Create tab.

  2. Click Query Design.

  3. Click the first table or query you want to add.

  4. Click Add.

  5. Repeat steps 3 and 4 to add all the desired tables.

  6. Click Close.

    httpatomoreillycomsourcemspimages613726.jpg
  7. Drag fields to the design grid.

  8. Click the Save button.

  9. Type a name for the query.

  10. Click OK.

    httpatomoreillycomsourcemspimages613728.jpg