Microsoft Office Tutorials and References
In Depth Information
2
Click the OK button to save the
query (Figure 2–24).
name of saved
query replaces
Query1 in
object tab
3
Click the Close ‘Client-City Query’
button to close the query and
remove it from the screen.
Close ‘Client-City
Query’ button
Other Ways
1. Right-click tab for
query, click Save on
shortcut menu
2. Press CTRL + S
Figure 2–24
To Use a Saved Query
Once you have saved a query, you can use and manipulate it at any time in the future by opening it. When you
right-click the query in the Navigation pane, Access displays a shortcut menu containing commands that allow you
to open and change the design of the query. You also can print the results by clicking the Offi ce Button, pointing to
Print on the Offi ce button menu, and then clicking Quick Print on the Print submenu.
The query always uses the data that is currently in the table. Thus, if changes have been made to the data since
the last time you ran the query, the results of the query may be different. The following steps use the query named
Client-City Query.
1
Show the Navigation pane.
Right-click the Client-City Query to
produce a shortcut menu.
Navigation pane
Enter Parameter
Value dialog box
Client-City
Query
Click Open on the shortcut menu
to open the query and display the
Enter Parameter Value dialog box
(Figure 2–25).
position to
enter city
What would have happened if
there were no parameters?
You would immediately see the
results without needing to furnish
any additional information.
OK button
Figure 2–25
2
Type Fort Stewart in the Enter City text box, and then click the OK button to display the results using Fort Stewart as
the city as shown in Figure 2–24.
Click the Close ‘Client-City Query’ button, shown in Figure 2–24, to close the query.
 
Search JabSto ::




Custom Search