graphic2
graphic1

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

Use a Query in a Query

This Query is linked to tblCustomers. We have a Query that already combines the name and address Fields. We can use that Query instead of tblCustomers.

 

Before You Begin: Delete a Table

Select a Table: tblCustomers.

Click DELETE on your keyboard. Bye bye.

 

6. Try it: Add a Query

Go to Query Tools ->Design->Show Table.

Go to Queries.

Select a Query: CustomerNameSQ.

Click Add.

Close the Show Table Window.

Keep going...

Query Tools ->Design->Show Table