Ms Access 2010 tutorial:make table append query


Make table and Append query

X. Make Table Query

Make Table query is a type of the select query (a query that displays data in datasheet and does not make the data change) that allows you to make a table. For example, you want to create a table name TblNewBook that contains BookID, PubName, Title, and ISBN. To do so, follow the steps below:

Suppose you are in an opened database

- Click Create tab

- Click Query Design in the queries group

A Show Table dialog box appears

- Click the table(s) that you will use its field(s) to create a new table, and then click Add button

- Drag and drop or double-click the fields for the new table into the query design grid



Microsoft Access 2010 make table

- Click Microsoft Access 2010 make table icon query icon

A Make Table dialog box appear:

Microsoft Access 2010 make table dialog box

- Type or select the table's name in the combo box of Table Name

- Click Ok

- Click Microsoft Access 2010 create table to create a table

Note: You use the Make Table query in the current database to create a new table in another database. Click another database option and then click Browse button to look for the database file that you want to create a table in.

XI. Append Query

Append query is a type of action query (a query that makes the data change) that allows you to insert data into an existing table. For instance, you want to append two records (Cate001, Cate002) from TblCategory to TblCategory1. To do so, do the following steps:

Suppose you are in an opened database

- Click Create tab

- Click Query Design in the queries group

A Show Table dialog box appears

- Click the table(s) that you want to use its records to append to another existing table, and then click Add button

-Drag and drop or double-click the fields that you want to append its records to an existing table into the query design grid

- Click Microsoft Access 2010 append query query icon

A Append dialog box appear:

Microsoft Access 2010 append dialog box

- Type or select the table's name in the combo box of Table Name that you want to append records to

- Click Ok

- Type the two records that you want to append to the table in the Criteria in query design grid. See the figure below:

Microsoft Access 2010 append query

- Click Microsoft Access 2010 append records to append the record

To see the result open the table that you had appended the records to.

Note:You use the Append query in the current database to append record(s) to an existing table in another database. Click another database option and then click Browse button to look for the database file that you want to append the record(s) to. If you want to append the records to only one field of an existing table, drag and drop or double-click a field to the query design grid.




Comments




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.