graphic2
graphic1

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

Add the Customer Data

We need to add the Customer Table and create the name and address Fields that are needed in a Mail Label or Mail Merge.

 

Before You Begin: Change the View

Go to Home->Views->View->Design View.

 

8. Try it: Add a Table

Go to Query Tools ->Design->Query Setup.

Click on Show/Table.

 

What Do You See? The Show Table window will prompt you to choose a Record Source.

Select a Table: tblCustomers.

Click Add.

Click Close.

Keep going...

Query Tools ->Design->Query Setup->Show/Table