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.

   

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.

   

Add a Field to a Query

1. Open the query in Design view.

2. Drag a field to a Field cell.

   

TIP

To add every field from a table to a query’s results, drag the asterisk from the table’s box in the table area to a Field cell in the Query design grid.

TIP

To enable a query with more than one table to return meaningful results, the two tables must be linked by a relationship.

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.

   

7. Drag fields to the design grid.

8. Click the Save button.

9. Type a name for the query.

10. Click OK.

    

TIP

To remove a table from the design grid, right-click the table’s title bar and then click Remove Table.