Which action query would you use if you wanted to change the name of a manager from "Smith" to "Jones" for all selected records?
A) Delete
B) Update
C) Append
D) Make-Table

Question

Quizplus · Accepted Answer

The Update query is used to modify existing data in a table, so it is the best choice for changing the name of a manager from "Smith" to "Jones" for all selected records. The Delete query is used to remove records from a table, the Append query is used to add new records to a table, and the Make-Table query is used to create a new table based on the data in an existing table.

Which Action Query Would You Use If You Wanted to Change