Test These Changes, Too 6. Try it: Test the Query, Again The Query is still open in Design View. Go to Query Tools ->Design->Results->Run. What Do You See? The Query Results will open in Datasheet View. There should be two new concatenated Fields: LastNameFirst and CityStateZip. Try This, Too: Return to the Design View Go to Home->Views->View. Choose a View: Design View. Keep going... Query Tools ->Design->Results->Run Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Calculated Fields: Concatenation