How To Use Make - Table In Access 2010
In this article I am going to explain How To Use Make-Table In Access 2010.
Create a new table by using data from other tables- We can use a make table query then we create a new
table from data that is stored in other tables.
Note A make table query
cannot be run in a web browser.
We can build a Delhi order table, and then use the
select query to create a table by using the following procedure.
-
We open the
Northwind database in access 2010.
-
When we click the enable,
then the message will be open.
-
Click No button in message
bar.


-
Then we enter create tab,
and click query design in query group.
-
Select the order details and
orders table in show table dialog box.

-
Close the show table dialog
box.
-
First we select order table,
and double click customer id and ship city both are add in fields to the
design grid.
-
Then we select order details
table, and double click order id, product id, quantity, unit price and
discount both are add in fields to the design grid.


-
Click run tab on the design
tab.
-
Press CTRL+S to save the
query.
-
Then open the save as dialog
box.


-
We open home tab and then
click view button and select design view.
-
On the design tab, click
make table in query type group.


-
After this process we click
the run in design tab.
-
In the confirmation dialog
box, click yes to confirm.



Ask Your
Question
Got a programming related question? You
may want to post your question here
Programming Answers here