Query the Customer Table

Your Customer table—tblCustomers—has names and demographics.  You need that information to create a receipt, mail merge labels, and marketing.

 

Try it: Query the Customer Table

Go to the Create Ribbon

Click on Design view.

 

Choose tblCustomers from the Show Table window.

 

Select all of the fields from the Customer table at the top of the Query.

 

Sort the customers by last name.

Test your query.