In Access, what does the 'Append' button do in a query?

The 'Append' button in Access is designed to add new records to an existing table. When you use this feature in a query, it allows you to select data from one or more tables and insert that data as new rows into another specified table. This is especially useful when merging datasets or consolidating information from different sources without altering the original data. By executing an append query, you facilitate the growth of your database by bringing in new information that wasn't previously part of the target table.

Understanding this functionality emphasizes the efficient data management capabilities of Access, as it enables users to organize and expand their data systematically. Users can filter and select specific records to append, ensuring that only relevant new information is added.