Append query can be used if you would like to add new rows of data to an already existing table.

The process of creating an append query follows these steps they are.

Basic step should be to create a select query

After selecting the query you need to append the query

Destination fields should be selected for each column in the query

Records can be appended by using the function to run.