Creating an Append Query in Microsoft Access

Append queries are a quick and easy way to copy or “move” records to a table in Access. In this clip from TrainSignal, I show students how to add a sale price to select books in our sample database for Picaroon Publishing and copy only those sale books to an existing (yet blank) table. This is just one of many uses for an append query. Enjoy!