graphc1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.3 Utilize Calculated Fields and Grouping Within a Query: Add Calculated Fields (Concatenation)

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

graphic2
 

pic1