How to Create a Make-Table Action Query in Microsoft Access

You can use a Make-Table action query in Microsoft Access to create a new table from all or part of the data in one or many tables. For example, you may want to use records from various tables to create a new table that will be exported to a different database. These instructions apply to MS Access 97.

Things You'll Need

• Microsoft Access

Instructions

1. Open the database window (use the F11 key), then click on the Query tab.

2. Click New, then Design View.

3. Click OK.

4. Create a query with the tables or queries you want to use to create the new table. Select Make Table from the Query menu.

5. Use the Table Name box to name the table you want to create.

6. Use Current Database or Another Database to indicate where you want to put the new table.

7. Click OK.

8. Drag the fields you want to use from the field list into the design grid.

9. Type your criteria (all dates after 1/1/00, for example) in the Criteria cell.

10. Preview the new table by switching to Datasheet view.

11. Return to Design view and create the new table by clicking Run on the toolbar.