Microsoft Office Tutorials and References
In Depth Information
• Click the OK button to save the
query (Figure 2–24).
name of saved
• Click the Close ‘Client-City Query’
button to close the query and
remove it from the screen.
1. Right-click tab for
query, click Save on
2. Press CTRL + S
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 Ofﬁ ce Button, pointing to
Print on the Ofﬁ 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
• Show the Navigation pane.
• Right-click the Client-City Query to
produce a shortcut menu.
Value dialog box
• Click Open on the shortcut menu
to open the query and display the
Enter Parameter Value dialog box
What would have happened if
there were no parameters?
You would immediately see the
results without needing to furnish
any additional information.
• 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.