Operation Manual

5) To the right of this are two choices. Select Display Query.
6) Click Finish.
Using the Design View to create a query
Creating a query using Design View is not as difficult as it may first seem. It may take multiple
steps, but each step is fairly simple.
What fuel economy is our vehicle getting (miles per gallon in the USA)? This question requires
creating two queries, with the first query used as part of the second query.
Step 1: Open the first query in Design View
• Click Create Query in Design View.
Step 2: Add tables
1) Click Fuel to highlight it.
2) Click Add.
3) Click Close.
Figure 239: Add Tables or Query dialog
Tip
Move the cursor over the bottom edge of the fuel table (Figure 240) and drag the edge
to make it longer and easier to see all of the fields in the table.
Figure 240: Fuel table in query
Chapter 8 Getting Started with Base | 249