CCNC/CCNC Module 5/Retrieving data with queries/Query Operations/Saving Query

---

Save the new query

Outcomes

Upon completion of this tutorial the learner will be able to: Identify different methods to save a query Name a saved query Open a query Delete a query

Saving the query

Figure 1. File -> Save...

To save the query in design mode select File -> Save... from the menu or close the window and if there are pending changes be prompted by the Save As... dialog.

Figure 2. Save As...

In the Save As... dialog enter a meaningful name. Naming is important, for through time many queries may get built and having a meaningful name will make query identificatrion easier.

Opening the query

Figure 3. Open a query

To open a query right-click of the query to run and select open. This will run the query and present the results.

Figure 4. Query results

Once the result window is open the sort and filter buttons are available allowing further organizing of the data to better suit the results being sought.

Deleting the query

Figure 5. Confirm Delete

There are three methods to delete a query. Right-click on the query object and select Delete from the drop-down menu. Select Edit -> Delete from the application menu or highlight the query and press the delete key on the keyboard. The delete operation will prompt to confirm the delete.

Test your knowledge

Query Management

1. There are three methods to delete a query? TRUE → Absolutely Correct! FALSE → Incorrect, there are three methods. Click here to review the topic. 2. Which activity CANNOT be done in the query results window? (a) Sorting → Incorrect, Aliasing cannot be done from a results window. Click here to review the topic. (b) Filtering → Incorrect, Aliasing cannot be done from a results window. Click here to review the topic. (c) Aliasing → Absolutely correct! (d) None of the above → Incorrect, Aliasing cannot be done from a results window. Click here to review the topic. Your score is 0 / 0