How to create an action request in Microsoft Access

Table of contents:

Queries in a database management system (DBMS) can do much more than just provide answers to the questions you ask. In fact, they can perform various actions on data from your database. An action request is a request that you can add, modify, or delete multiple records at once. An added benefit is that you can preview the query results in Access before you run it. Microsoft Access provides four types of action queries: create table, add, update, and delete. In this article, we are dealing with a query-form table.

Steps

Create Action Queries in Microsoft Access Step 1

Step 1. Start Microsoft Access and open the database

Create Action Queries in Microsoft Access Step 2

Step 2. Go to the "Queries" tab in your database

Create Action Queries in Microsoft Access Step 3

Step 3. Click on the "New" button and then select "Design" to start creating a query in design mode

Create Action Queries in Microsoft Access Step 4

Step 4. Select the tables or other queries you want to run

Create Action Queries in Microsoft Access Step 5

Step 5. Select fields from table / query

As with other queries, you will have to specify criteria to get the results you want,

Create Action Queries in Microsoft Access Step 6

Step 6. Run your query to make sure your query contains the results you want

Create Action Queries in Microsoft Access Step 7

Step 7. Now you need to change the request type

In the center of the screen, click on the "Request type" button.

Create Action Queries in Microsoft Access Step 8

Step 8. Select "Create Table"

Create Action Queries in Microsoft Access Step 9

Step 9. Specify the name of the new table if it will be created in the database in which you are currently working or in another database

If you are creating a table for a separate database, then you will need to specify its location

Create Action Queries in Microsoft Access Step 10

Step 10. Complete the request

You are about to run a query that will make changes to the overall structure of the database, then Microsoft Access will ask you if you want to cancel the operation.
Click the "Yes" button to close the dialog box. Create a new table and return to Query Builder.