Action Queries: Update, Append, Delete, Make-Table

- Update Query — changes the values of existing records that match your criteria, such as increasing every product's price by 5%. - Append Query — copies matching records from one table into another, useful for archiving old data into a separate table. - Delete Query — permanently deletes every record matching your criteria, all at once. - Make-Table Query — creates a brand-new table out of a query's results, useful for taking a snapshot of data at a specific moment in time.

Build an Action Query starting exactly like a Select Query, then go to Query Design and click the corresponding button — Update, Append, Delete, or Make Table — to convert it, fill in the extra details Access asks for, and click Run.