【 Create Elimination Query in Access 】 Step by Step Guide ▷ 2022

When working on a such as those that can be developed in, it is very common that they end up handling a great deal of data, so it can be quite tedious or complicated having to delete a large amount of data because have gone bad or simply because you no longer need them.

To carry out this type of habitual activities you can make use of what are delete querieswhich will allow you quickly delete a lot of data or a data set. This is because this type of tool allows the user to specify criteria that allow them find and delete the data needed quickly.

All of this can undoubtedly be translated into a saving time and better performance when working in this program. Furthermore, each of the queries applied you can use them again as long as it has been stored. That is why we are going to teach you next how to create a quick and easy delete query in microsoft access.

What is a delete query and what is it for in Access?

Delete Queries are those queries that are responsible for eliminating a data table everybody records that meet a search criteria that has been previously specified. In other words, this type of function allows the data deletion massively in just a few seconds.

Therefore, this tool is recommended to be used whenever you want to delete different records quickly. Thus, it is recommended to use it especially when working with many data and it only takes remove some of themsince here you can set the criteria necessary for it to be carried out the search and subsequently the deletion of all corresponding data.

Also, delete queries have been created with the aim of helping users to save time when working in Accessthis is how each of the queries applied They may be saved to be reused later if necessary. Now in case you just want delete one or two recordsyou shouldn’t necessarily apply this tool.

Keep in mind that these queries are applied for the purpose of save time and work when having to dispose of a large amount of data or data sets. Finally, it is important to mention that before get rid of a lot of data it is recommended to apply a backup that allows you recover the information in case something goes wrong.

What are the advantages of using delete queries in a database?

As has been mentioned in the post, delete queries certainly offers a series of advantages to users when they have to work with lots of data in a database.

That is why here we are going to show you the main advantages that you can obtain when applying this type of tool:

allows you to carry out deleting a lot of data through a set of criteria that has been previously specified.
To the delete a lot of information simultaneously you may save time and increase your performance at the time of work in Access.
It is recommended to use it only when you want undo many records.
Each of the queries applied They may be stored to be again applied later in case they are necessary.
It becomes an ideal tool for when you are working with quite a large database.
Let deleting a lot of data much easier than having to do it manually.

Learn step by step how to create a delete query in an Access database

It is important to mention that this process can be carried out either through a delete query or an update query, This means that the first thing to do is to know what query type should be applied. In the case of delete queries apply when needed remove entire records in rows from a table or from two tables that are related at the same time.

While update queries It allows remove individual field values from a table. Therefore, depending on these criteria you must choose which of the two should be used. if you apply the delete query then how results you will get the removal of all data from each field and with the update consultation will facilitate removing values when updating existing values to null.

Before performing a query to remove data from a data table in Access, it is essential to perform the following checks:

The file being used must not be read only. In order to check this you must right click on “Start” and there you select the option to start the “Windows Explorer”. Then you must right click on the file to work and in the drop down menu Choose “Properties”, there you can check if the option “Read only” is enabled, if so you should disable it immediately.
You should also make sure you have all the necessary permissions to delete records from database.
You must ensure that the content of the database is enabled. As usual, Access by default usually locks all action queries, that is, those that allow delete, update and create a table.
Be sure to ask other users of the database that completely close all , queries, tables and reports that use the data you want to delete. This will prevent the generation of a infringement block.
Finally, before doing deletion of records It is advisable run a database backup in case you want to revert the changes you have made.

If in your case a great number of users connecting to the databasethen it is necessary that you have to open it in exclusive mode and not normally.

Let’s see next:

Open database in exclusive mode

In this case you must click on the tab “File, Archive” and then in “Open”.
now you must find the database file with which you want to work and once found and selected you must click on the option “Open in exclusive mode”.

Back up the database

As it has been mentioned previously, it is very important to be able to carry out a backup before deletion of datasince this will give you a backup in case something goes wrong.

To do this, follow these steps:

The first thing in this case is to go to the data sheet “File, Archive” and there select the option “Save as”.
Now you must click on the option “Save Database As” and then select the item “Database Backup”. Automatically Access will close the original file and it will create a backup and reopen the original file.
Now you must click on “Save as” and there set the name and location you want to give to the backup and finally select the button “Save”.

Use the delete query

In order to make use of a delete query eYou need to go to the tab “To create” and then the group “Queries” after that you should go to “Query Design”. in the box “show table” you must double click on each of the tables where you want delete records and finally select the button “To close”.

The table will then appear as a window in the upper section of the query design grid. Here you must click on the * so you can start adding all the table fields to the layout grid.

Use a specific criteria for the delete query

If you want use a criteria to apply said querythen you must double click on the field you want use as criteria for elimination. Now you must write one of the criteria in the query designer criteria row and then disable the “Show” box for each criteria field.

To do this, you will need to perform these steps:

In the design tab you must click on “View” and subsequently “View data sheet”.
Now you must check that the query returned records you want to delete and press the key combination “Ctrl + G” to save the changes to the query.
Finally, to execute the query you must double click on the query in the navigation pane.

Use an update query

If according to your needs you have to use a update Query, then this procedure will be executed for deletion of individual fields in the datatable.

To do this you must follow these steps:

To start you must click on the tab “To create” and then in the query group, and there choose the design of the query you want.
Now you must select the table that contains the data you want to delete, in the case that the table is related, then you must choose the table on the one side of the relationship and click on “Add” and then in “To close”.
Here you need to double click on the asterisk * to add all the table fields to the layout grid. In this case you can add all the table fields that allow the delete query. You can optionally specify criteria for one or more fields in the designer criteria row and then uncheck the box “To show”.
In the group “Results” located in the tab “Design” you must select the option “Watch” and then “Datasheet View”, here you must check that the query returns the records you want to delete.
Finally to execute the query you must select the query in the navigation pane.