|There are four different
types of action queries. The first one is called the “Update Query”. This
type is used to change more than one record at a time in a query. Using this
type of query saves the user from having to perform multiple operations to
update records in a query.
The second type of action query is known as the “Append Query”. This type takes the records from one table and adds them to another table.
The third type is known as the “Delete Query”. The user designates specific data in a record or query that they want deleted, and the Delete Query deletes the information from a table based on this criteria.
The fourth and final type of Action Query is known as the “Make-Table Query”. This type uses records in an existing table to create a new table in a different format, which is specified by the user.