18 min read
Building a Select Query in Design View
Add tables from Show Table, double-click fields into the grid, run to see the result, and save it with a descriptive name so it can be rerun any time.
You will learn: the Query Design grid and Show Table dialog. You will do: create a query on Members. run it and save as AllMembers.
Open Query Design
Goal
Create a blank query in Design View.
The grid is where you pick fields before you save the question.
Open the database
Where
Do this
You should see
- The Navigation Pane lists tables and other objects.
Verification
Check your work
You are correct if all of these are true:
- An empty query grid appears behind the Show Table dialog.
If something looks wrong
Fix
Add Members
Goal
Add the Members table to the query.
The table box lists every field you can add to the grid.
Add Members
Where
Do this
You should see
- A Members table box appears in the top pane.
Verification
Check your work
You are correct if all of these are true:
- FullName and City appear in the design grid with empty Criteria.
QUERY DESIGN
| Grid — AllMembers | ||||
|---|---|---|---|---|
Grid Rows
| Design grid rows | |
|---|---|
Run and Save
Goal
Run the query and save it as AllMembers.
Saved queries appear under Queries in the Navigation Pane.
Run the query
Where
Do this
You should see
- Every member row appears in the result datasheet.
Verification
Check your work
You are correct if all of these are true:
- The result shows FullName and City for all five members.
- The query object is saved inside the database file.
SOURCE DATA
| Members | |||
|---|---|---|---|
RESULT
| Result: AllMembers | |
|---|---|
Practice
Swipe or use the arrows to move between questions.
1 / 2
Field Notes: The Design Grid
Goal
Build a Select Query in Design View.
Design View lets you build the underlying question visually, without writing SQL by hand.
Open Query Design
Do this
Verification
Check your work
You are correct if all of these are true:
- Press Ctrl+S to save the query with a descriptive name, so you can rerun it any time by double-clicking it in the Navigation Pane, without rebuilding it from scratch.
More lessons in Microsoft Access · Next: Adding Criteria to Filter Results · Previous: What Is a Query?