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.

• Close the login dialog form.

 

• 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.

 

• Unmark the show row box in the ship city column of the design grid.

• Then type Delhi in the criteria row.

 

• Click run tab on the design tab.

• Press CTRL+S to save the query.

• Then open the save as dialog box.

 

• In the query name box, type Delhi orders query, and then click ok.

 

• We open home tab and then click view button and select design view.

• On the design tab, click make table in query type group.

 

• In the make table dialog box, in the table name box, type Delhi orders, and then click ok.

 

• After this process we click the run in design tab.

• In the confirmation dialog box, click yes to confirm.

 

• The new table is created, and the table appears in the navigation pane.

 

• After this process we click the run in design tab.

• A warning dialog box open and we click no button and dismiss the dialog box.

 

Ask Your Question

Got a programming related question? You may want to post your question here

Programming Answers here