How to Delete Query in Access

by Lysis

Overview

A Microsoft Access database is a file used to create tables, queries and reports. The software is used in small- to medium-sized businesses. The tables in Access are used to hold the data, and the queries are used to retrieve, insert or delete data in the tables. After you've created a query, you can use it to retrieve data. However, if you no longer need the query, deleting it clears it from the list of queries in the file and frees up resources. Deleting a query in Access is accomplished in the Query menu on the main menu.

Step 1

Double-click the Access file on your hard drive to automatically load Microsoft Access along with the database.
Step 2

Click the "Queries" menu item in the main window. This opens a window that lists all the queries programmed into the Access database.
Step 3

Use the mouse to click on the query you want to delete. In the toolbar at the top of the window, click the "X" image. This image is the "delete" toolbar button.
Step 4

Click the "Save" button to save the changes to the database file. You can close the file if you are finished. The next time you open the database, the query is removed.

2
If you have any reports that use the deleted query, they need to be edited as well.
If you have any reports that use the deleted query, they need to be edited as well.

References & Resources