How To Use Make - Table In Access 2010

In this article I am going to explain How To Use Make-Table In Access 2010.
  • 3117
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.

messagebarinaccess2010.jpg

  • Close the login dialog form.

  loginboxinaccess2010.jpg

  • Then we enter create tab, and click query design in query group.

  • Select the order details and orders table in show table dialog box.

 showtabledialogboxinaccess2010.jpg

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

 tablefielddatainaccess2010.jpg

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

  • Then type Delhi in the criteria row.

 createcriteriainaccess2010.jpg

  • Click run tab on the design tab.

  • Press CTRL+S to save the query.

  • Then open the save as dialog box.

 saveasboxinaccess2010.jpg

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

 querynameinaccess2010.jpg

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

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

 clickmaketabletabinaccess2010.jpg

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

 tablenameinaccess2010.jpg

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

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

 confirmationdialogboxinaccess2010.jpg

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

 navigationpaneinaccess2010.jpg

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

 warningdialogboxinaccess2010.jpg

Ask Your Question

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

Programming Answers here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.