Question: 2. Some customer telephone numbers are missing area codes. Create a query that lists all those customers. Show the CustomerID, FirstName, LastName, StreetAddress, City, State,

 2. Some customer telephone numbers are missing area codes. Create a

2. Some customer telephone numbers are missing area codes. Create a query that lists all those customers. Show the CustomerID, FirstName, LastName, StreetAddress, City, State, Zip, and Telephone. Sort the data in ascending order by State, then by City. Save this as Query2 3. The staff will contact customers about their missing zipcodes or phone area codes. For convenience, create a query that combines and shows customers who are missing either the zip code or their area code.|The list must include the following fields: CustomerID, LastName, FirstName, StreetAddress, City, State, Zip, and Telephone. Sort the data in ascending order by State, then by City. Save this as Query3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Accounting Questions!