An action query changes data or copies data. Action queries include append, delete, make-table, and update queries. In contrast, a select query doesn't copy or change data; it asks a question and returns a set of records.
| Action query type | Description |
|---|---|
| Append | Adds the records in a query's result set to the end of an existing table. |
| Delete | Deletes a set of rows that match the criteria you specify. |
| Make-table | Creates a new table from the result set of an existing query. |
| Update | Changes a set of records according to criteria you specify. |