What is a common use for append queries?
combining two databases together
mailing payment information to employees
archiving data from live tables to archive tables
sending customers receipts that show their orders
You use an append query when you need to add new records to an existing table by using data from other sources. If you need to change data in an existing set of records, such as updating the value of a field, you can use an update query.
