CCNC/CCNC Module 5/Retrieving data with queries/Query Operations/Saving Query
Save the new query
Saving the query
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.
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
To open a query right-click of the query to run and select open. This will run the query and present the 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
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