Content

• Steps
• Tips
• What do you need

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

1. 1 Start Microsoft Access and open the database.
2. 2 Go to the "Queries" tab in your database.
3. 3 Click on the New button and then select Design to start building your query in design mode.
4. 4 Select the tables or other queries you want to run.
5. 5 Select fields from table / query.
   • As with other queries, you will have to specify criteria to get the results you want.
6. 6 Run your query to make sure your query contains the results you want.
7. 7 Now you need to change the request type. In the center of the screen, click on the "Request type" button.
8. 8 Select "Create Table".
9. 9 Provide a name for the new table if it will be created in the database you are currently working in or in another database.
   • If you are creating a table for a separate database, then you will need to specify its location.
10. 10 Complete your 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.
11. 11 Save your query. All is ready!

Tips

• Newbies in this area should first preview the request before modifying the request-action.

What do you need

• Microsoft Access
• Database
• Data to be consolidated into a new table