Saving a Query

To save a query, you click the Save button on the toolbar. The Save As dialog box appears (see Figure 3.22). After you provide a name and click OK, Access saves the Structured Query Language (SQL) statement underlying the query. It does not save the result of the query.

Figure 3.22. The Save As dialog box.

graphics/03fig22.jpg

graphics/book_icon.gif

The industry standard for naming queries is to prefix the name with qry.




    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics