In your query, set up the relationships between your tables and query just as you would between tables. Access really doesn't treat the queries any differently than it treats tables when running queries.
When you click on "Show tables", click on the second tab to add queries.