PROJECT STEPS

City Tours Ltd$.$ needs to update the database on a regular basis. As a customer service manager for the company, you need to add new customers and confirmations, update basic costs, delete confirmations, and so on$.$ In Query Design view, create an Update query based on the Tours table.

a$.$ Select the TourNumber and BasicCost fields from the Tours table.

b$.$ Add criteria to select only those records where the TourNumber field value equals w$001.$

c$.$ Update the BasicCost field with $24$ as the new field value.

d$.$ Save the query using UpdateBasicCost as the name, run it$,$ and then close it$.$ The query should update one record.