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
UPDATE Query SQL Syntax Update Query Examples There are several ways to use Update Queries Update th... View full answer
Get step-by-step solutions from verified subject matter experts
