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 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
Get step-by-step solutions from verified subject matter experts
