What does an Append Query do?

What does an Append Query do?

• A. Adds new records
• B. Updates existing data
• C. Deletes records
• D. Creates a brand new table

Answer: (A)

An Append Query is used to add new rows to an existing table. It takes data from another table or query and inserts those rows into the destination table without changing or removing any of the existing records. It’s like an INSERT operation that adds data rather than updating or deleting what's already there. This is handy when you’re consolidating data from multiple sources or importing additional records into a master table. It differs from updating data (which changes existing values), deleting records (which removes rows), or creating a brand new table (that would be a Make-Table operation).

An Append Query is used to add new rows to an existing table. It takes data from another table or query and inserts those rows into the destination table without changing or removing any of the existing records. It’s like an INSERT operation that adds data rather than updating or deleting what's already there. This is handy when you’re consolidating data from multiple sources or importing additional records into a master table. It differs from updating data (which changes existing values), deleting records (which removes rows), or creating a brand new table (that would be a Make-Table operation).