Microsoft Office Tutorials and References
In Depth Information
Creating a table by using a Make Table query
Create a table by using a Make Table
4 Click Make Table.
5 Type a name for your new table.
6 Click OK. Before clicking the Run button, you can click View to
review the data that will be created in the new table and then
return to design view to execute the query by clicking the Run
7 Click Run to execute the action query.
8 Click Yes to create your new table.
TIP After you have provided the name for the new table, it is
not displayed on the query grid. If you later want to check what
the name is, switch to view the SQL.
TIP After you have created a new table, you might want to
alter the design of the table to add a primary key and set up any