If you are planning to use a query to request data from more than one table, those tables must be joined by a relationship.
  1. From the Queries list, click the New button.
  2. Select an appropriate Wizard and click OK.

The Wizard will guide you through the process, providing you with instructions and prompting you for information. When you have completed a step of the Wizard, click Next. When the process is complete, you will be asked for a name for the query and then you may click Finish. The query is saved automatically.