Allison wants to add text in the Comment field of every customer record with a particular set of characters in the Email field. What type of query should she create?
A) Make-Table
B) Crosstab
C) Append
D) Update

Question

Quizplus · Accepted Answer

Allison wants to update the Comment field of customer records, so she should create an Update query. The Update query allows her to change existing data in a table based on certain conditions, such as finding records with a particular set of characters in the Email field. The other query types mentioned (Make-Table and Crosstab, and Append) are not relevant to updating existing data in a table.

Allison Wants to Add Text in the Comment Field of Every