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...

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.2. Manage source tables and relationships: Remove  a Table

Query Tools ->Design->Show Table