Question

state atleast 3 differences between select query and action query.

Answer 1

Select query and Action Query

The Simple Select Query creates queries that retrieve data from the fields you specify in one or more tables or queries. If you want, the wizard can also sum, count, and average values for groups of records or all records, and it can calculate the minimum or maximum value in a field.
The Action query is a query that makes changes to many records in just one operation. There are four types of action queries: delete, update, append, and make-table.

Answer 2

 a.Action queries allow you to change data, whereas Select queries allow you to view data from multiple tables orqueries. ... Selection queries allow you to select and change data, whereasAction queries allow you to only look at data.