MS Access Append Query


MS Access Append Query
 

  • We use Append Query in Microsoft Access so that we can transfer the records of one table to another table.
  • We must have at least two tables to use append query in MS access.
  • We will apply MS Access Append Query to the student and student_info table.

 

Step 1: Open the MS Access Database.

Step 2: After this, click on the Create button on the top, and then click on the query design.

 

MS Access Append Query

 

Step3: After this, we will get the table in which we will select the student table.

 

MS Access Append Query

 

Step 4: After selecting the student table.

 

MS Access Append Query

 

Step5: Now we will click on the append button.

 

MS Access Append Query

 

Step6:  This will display the following dialog box, select the table name from the drop-down list and click Ok.

 

MS Access Append Query

 

Step7: According to you, select in which field of the student_info table you want to display the data of the field in the student table.

 

MS Access Append Query

 

Step 8: Let us now run your query & you will see the following confirmation message. Click Yes to confirm your action.

 

MS Access Append Query

 

Step 9:   When you open the student_info table, you will see all the data is added from the student to the student_info table.

 

MS Access Append Query