Take Control: Q&A Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

 

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. You can double click each field in the table to add it to the grid, or you can use the asterisk (*) above the Primary Key in the table.

 

Sort the customers by last name.

Test your query.

 
View -> Design -> Query Design

 

  Microsoft Access 2007 Exam 77-605 Topic: 4.  Creating and modifying queries 

  4.1. Create queries       

  4.1.1.   Create queries based on single tables: Add all fields from a table to a query