Question

what is a difference between select query and action query ?☺️☺️

Answer 1

Select query retrieves data from one or more tables and displays the record set in a datasheet. You can also use a select query to group data, and to calculate sum, count average, and other types of total.
Action query creates a new table or alters your data or database by adding deleting, updating and appending data from it.

Answer 2

A select Query retrieves information from one or more tables (depending on your criteria) and displays it in a data sheet. By adding or updating data, a query that performs an operation creates a new table or alters your data or database.

About Select Query :

• A select Query retrieves information from one or more tables (depending on your criteria) and displays it in a data sheet.
• A select query is a database item that presents information in Datasheet view.
• A query does not save data; rather, it displays information from tables.

About action query :

• By adding or updating data, a query that performs an operation creates a new table or alters your data or database.
• Multiple records can be added, updated, or deleted simultaneously using action queries.
• Access allows you to preview the query results before performing it, which is a nice feature.