Methods to create query in Access
Answers
Answered by
0
1.Open your select query in Design view, or switch to Design view.
2.On the Design tab, in the Query Type group, click Make Table.
2.On the Design tab, in the Query Type group, click Make Table.
The Make Table dialog box appears.
3.In the Table Name box, enter a name for the new table.
-or-
Click the down-arrow and select an existing table name to replace that table.
4.Choose whether to place the new table in the current database or in another database.
5.Click OK
6.Click Run,and then click Yes to confirm the operation.
Similar questions