Action Queries make changes to or move many records in just one operation. That is, Action Queries make bulk changes to your database each time they are run.
Before we even talk about the types of Action Queries – A WORD OF WARNING.
Action Queries irreversibly CHANGE your database data each time they are run!
So, if you are in the habit of double-clicking a query in the Navigation Pane to open it,
be warned that opening an Action Query in this way
will make changes to your database data.
And, you won’t be able to Undo any changes made by an Action Query.
There are 4 types of Action Queries
Update – Makes global changes to a group of records in one or more tables.
Append – Adds a group of records from one or more tables to the end of one or more tables.
Make Table – Creates a new table from all or part of the data in one or more tables.
Delete – Deletes a group of records from one or more tables.