Microsoft Office Tutorials and References
In Depth Information
A query doesn’t store data; it just pulls data from tables and puts it in query
datasheets for you to look at. A query is dynamic; as you add to or change
your data, the result of the query also changes. When you save your query,
you’re not saving the table that the query produces; you’re just saving the
query design so that you can ask the same question again.
You don’t have to save a query. Often, you create queries on the fly to
answer a question. There’s no need to clutter your database with queries
you’re unlikely to need again.
That said, you can certainly save a query design when you need to. Use one
of the following methods:
✦ In Design or Datasheet view, click the Save button or press Ctrl+S. If
you haven’t saved the query yet, Access asks you for a name for the
query. Type the name in the Save As dialog box and then click OK.
Close the query. (Clicking the Close button is a popular method.) If
you’ve never saved the query, or if you’ve changed the query design
since you last saved it, Access asks whether you want to save the query.
Click the Yes button to save the query. If you’ve never saved the query,
give it a name in the Save As dialog box and then click OK.
Give your new query a name that tells you what the query does. That
way, you won’t have to open one query after another to find the one you’re
If you want to create a query similar to one you already have in your
database, select or open the query, and choose File ➪ Save As to save the query
with a new name. You keep the original query and make changes in the new
If you want to save the query dynaset, export the data to its own file, using
one or more buttons in the Export group on the External Data tab of the
Ribbon. For more information about exporting data, see Book II, Chapter 4.
If the query you need is in another Access database, or if you create a query
that you want to use in another database, simply import or export it. For
information on importing and exporting objects, see Book II, Chapter 4.