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