Microsoft Office Tutorials and References
In Depth Information
• Type Fort Stewart as the
parameter value in the Enter City
text box and then click the OK
button (Figure 2–22).
• Try other characters between the
square brackets. In each case, view
the results. When ﬁ nished, change
the characters between the square
brackets back to Enter City.
only clients located
in Fort Stewart are
Each time you use this query, you will be asked to enter a city. Only clients in the
city you enter will be included in the results.
To Save a Query
In many cases, you will want to repeatedly use the queries you construct. By saving the query, you eliminate
the need to repeat all your entries. The following steps save the query you just have created and assign it the name
• Click the Save button on the Quick
Access Toolbar to open the Save
As dialog box.
Can I also save from Design view?
Yes. You can save the query when
you view it in Design view just
as you can save the query when
you view the query results in
• Type Client-City Query in
the Query Name text box