Creating Queries  «Prev  Next»

Lesson 6 Creating a query in Design view
Objective Create a query in Design view.

Creating Query in Design View

Now that you have been introduced to the Query Design view, it is time to try creating a query using Design view.
Generally you will use Query Design view to create a query that combines fields from different tables. You may also add criteria to the query so that you see a subset of all records. However, as I mentioned earlier, if you want to calculate summary data, you will find that the Simple Query Wizard is the best way to go--at least until you learn about grouping in Design view. After you create a query in the Design view, you will view it in the query datasheet.
Creating a query in Design view is similar to using the Advanced Filter/Sort feature. To create a simple query there are only two steps:
  1. Add the tables you need to the query.
  2. Put the fields you want to see in the design grid.

This Simulation takes you through the creation of a simple query:
Creating Query in Design View
Learn the different ways to save a query design.

Creating Query in Design View - Exercise

Try your hand at creating a query in Design view.
Creating Query in Design View - Exercise