Microsoft Access Append Query Examples and SQL Syntax

We've enhanced our Microsoft Access Query Help Center with a new paper describing Microsoft Access Append (Insert) Queries, and how to use them to add multiple records or a single record to a table.

We also discuss why rather than using a Make Table query, it's preferable to use an existing table, empty it, then fill it with an Append query.