Q23
Which of the following is not an action query?
A.
add
B.
delete
C.
make-table
AnswerD.
update
Answer: Option C
Solution
Answer: Option C
Solution:
In Microsoft Access, an action query is a type of query that performs an action on the data in a database, such as adding, deleting, or updating records. Each of the provided options represents a type of action query except for Option C: make-table.Option A: Add action query is used to add new records to a table in the database.Option B: Delete action query is used to remove records from a table in the database.Option C: Make-table is not an action query. It's actually a query type that creates a new table based on the results of a query. It doesn't directly modify or affect existing data like the other action queries do.Option D: Update action query is used to modify the data in existing records within a table.Therefore, the correct option is Option C: make-table. It is not considered an action query in Microsoft Access as it doesn't perform actions on existing data but rather creates a new table based on query results.