Test the Query

How does this look when you Run the Query and see the Customers' Names?

 

4. Try it: Test the Query

The Query is 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 a new Field called FullName that combines the First Name and Last Name Fields.

 

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