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.