How to Create Action Queries in Microsoft Access

Step-by-Step Guide

1. 1

   Step 1: Start Microsoft Access and open your database;

   Just like normal queries, you will often have to specify a criterion in your query to get the results you want. ,, In the middle of the screen, click the Query type button. ,, If you are creating the table for a separate database, you will have to specify the location of it. , Because you running an action query that makes changes to your overall database structure, Microsoft Access will ask if you want to cancel the operation.
   
   Click Yes to close the dialog box, create the new table and return to Query Design View. ,
2. 2

   Step 2: Click on the Queries tab of your database.

3. 3

   Step 3: Click on the New button and then select Design View to start creating a query in Design view.

4. 4

   Step 4: Choose the tables or other queries you wish to query

5. 5

   Step 5: Choose the fields from the table/query you want.

6. 6

   Step 6: Run the query to make sure your query contains the results are you are looking for.

7. 7

   Step 7: you need to change the type of query this is.

8. 8

   Step 8: Change to Make-Table.

9. 9

   Step 9: Specify the name of the new table and if it is going to be created in the database you are currently working from

10. 10

    Step 10: or another database.

11. 11

    Step 11: Run the query.

12. 12

    Step 12: Save your query

13. 13

    Step 13: and you're done.

Detailed Guide

About the Author