Append query can be used if you would like to add new rows of data to an already active table. The process of making an append query follows these steps they are.
? Basic step should be to make a select query
? After selecting the query you require to append the query
? Destination fields should be selected for every column in the query
? Records can be appended by using the function to run.