If you want to add records from one table to a backup table,create a(n)Append query.

Append Query

In databases, a type of query that adds records from one or more sources to the end of a table.

Backup Table

A copy of a table in a database created for the purpose of data recovery or archival.

Add Records

A process in databases where new data entries are inserted into a table.