Creating a Make-Table Query
IIHE  |  Education  |  Getting Started With Microsoft Access  |  Creating a Make-Table Query

The type of queries that you first learned about in Access are called Select Queries. That's because they are used to select certain records in the database.

Another type of query is the Make-Table Query. It copies the records that extensively match the query specifications to a new table. A Make-Table Query is useful when you need to work with a subset of a larger table and don't need the records updated to the latest changes.

Important: The data in the new table will not be updated when data in the original table is changed.

To create a Make-Table Query, create a normal query that selects the records you want. We are going to use the query that we designed in the Making a Query lesson. When you are through designing the query, choose the Make-Table Query option from the Query menu.

The Make Table dialog box appears:

Here, you enter the name for the new table.

Important: The name for the Table must be unique. It the name is the same as any table, query, form, report, etc., Access will ask if you want to overwrite the data when you run the query. Don't give it the same name as your query.

Optionally, you can save the new table to a different database by clicking on the Another Database button and filling in the name of the database.

We are going to name our query "DNW 1Q97 Visits.." So, type

	DNW 1Q97 Visits

and press the OK button. That completes the design of the query.

To create the table, click the Run button located on the toolbar. If you are running a Make Table query for the second time or if a table already exists with the name you gave in the Make Table dialog, you see:

If you're sure that the table should be overwritten, click on the Yes button. Next you are asked:

Here, you are being asked if you are sure you want to add the data to the table. Click on the Yes button.

The design mode of the query is displayed. It kind of looks like nothing happened. Actually, the table was created. Save and close the query. Click on the Table tab in the Database window and finally double click on the table we just created, DNW 1Q97 Visits:

 

 

Whenever you run the query in the future, it will overwrite the data in the new table.

Adding Math Functions to a Query  |  Getting Started With Microsoft Access  |  Linking Tables in a Query