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.
Step 1. Start Microsoft Access and open the database
Step 2. Go to the "Queries" tab in your database
Step 3. Click on the "New" button and then select "Design" to start creating a query in design mode
Step 4. Select the tables or other queries you want to run
Step 5. Select fields from table / query
As with other queries, you will have to specify criteria to get the results you want,
Step 6. Run your query to make sure your query contains the results you want
Step 7. Now you need to change the request type
In the center of the screen, click on the "Request type" button.
Step 8. Select "Create Table"
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
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.
Step 11. Save the query
All is ready!