Make Table Queries

How to Create Make Table Queries in Access

Make Table Queries

Create a Make Table Query

  1. Click the Create tab on the ribbon.
  2. Click the Query Design button.
    Create a Make-Table Query

    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.
    Create a Make-Table Query

    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.
    Create an Make-Table Query

    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.

    Create a Make-Table Query

Preview and Run a Query

Now you're ready to have the Make Table query create the new table. Preview the results of the query first.

  1. Click View to preview the query in Datasheet View.
    Create a Make-Table Query

    The Make Table query displays the records it will use to create the new table.

  2. Click View to return to Design View.

    Now you can run the query to create the new table.

  3. Click the Run button on the ribbon.

    Access asks you to confirm the creation of the table.

  4. Click Yes.
  5. Create a Make-Table Query

Access creates the new table based on the results of the Make Table query.

FREE Quick Reference

Click to Download