Make Table Queries

Create a Make Table Query

1. Click the Create tab on the ribbon.
2. Click the Query Design button.
   

   The Query Design window and Show Table dialog box both appear. Here you need to select the tables and/or queries containing the data you want to include in your new table.

3. Double-click the tables and queries you want to add and click Close.
   

   Now add the fields you want to use in your new table.

4. Select the fields that you want to include and click Close.
5. Add any limiting criteria.

   Now you need to change the query type to make it a Make Table query.

6. Click the Make Table button on the ribbon.
   

   Access displays the Make Table dialog box. Here you need to tell Access the name of the new table.

7. Enter a name for your table and click OK.

   In the Table Name box, you can also choose to replace an existing table instead of creating a new one. To do this, click the Table Name list arrow and select a table. If the table you're replacing is in another database, first select the Another Database option and browse to the database.