Perhaps an employee no longer works at the salon and there are dozens of future appointments that need to be changed to a different employee's name.You could create a(n)________ that changes the name of the employee for all future appointments from the employee who left to the a employee.
A)make table query
B)delete query
C)append query
D)update query

Question

Quizplus · Accepted Answer

An update query is used to modify existing data. In this scenario, an update query can be used to update the employee name for all future appointments from the employee who left to the new employee. The other options are not suitable for this scenario - a make table query creates a new table from existing data, a delete query is used to permanently remove data, and an append query adds new data to an existing table.

Perhaps an Employee No Longer Works at the Salon and There