Question: 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

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. Select the TourNumber and BasicCost fields from the Tours table. Add criteria to select only those records where the TourNumber field value equals W001. Update the BasicCost field with 24 as the new field value. Save the query using UpdateBasicCost as the name, run it, and then close it. The query should update one record.

Step by Step Solution

3.34 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

UPDATE Query SQL Syntax Update Query Examples There are several ways to use Update Queries Update th... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!