Question

State the main advantages of an Action Query.

Answer 1

In MS Access and other DBMS systems, queries can do a lot more than just displaying data, but they can actually perform various actions on the data in your database. Action queries are queries that can add, change, or delete multiple records at one time. ... You can use an Append Query