Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.2 Modify a Query: Modify a Query

Know Your Data: CustomerNameSQ We want to display the customer's name and address on the screen after we look up the phone number. We already have a Query that combines (concatenates) these Fields.Let's see if it meets our needs.   2. Try it: Review the Customer Query Go to All Access Objects ->Queries. Open a Query: CustomerNameSQ.   Try This, Too: Change the View Go to Home->Views->View. Select a View: Design View.   What Do You See? The Query has one Table: tblCustomers. In addition to the CustomerID, FirstName and LastName. there are three Fields which combine (concatenate) the name and address: FullName LastNameFirst CItyStateZip   Keep going... All Access Objects ->Queries