To start creating queries, you will need to be in the Queries
section of the database. If you are not there by now, you need to click on
the Queries tab in the Database Objects window. A screenshot is shown
below
When the Queries tab is active (as shown above) the tab has a sunken effect to it. This means nothing except that you are in the queries part of the database window. At first, you will only see two items: Create query in Design View and Create query by using wizard. This is due to the fact that you have not created any queries yet.
You can create a query using one of two ways.
1. You can create the query using Query Design View
2. Using the query wizard, you can easily create your queries (I'd suggest you do this at first until you are comfortable with creating a query).
If you decide to create a query with the query wizard, you will
come up with this screen

From here on, you choose which table to base your query on (later on, you'll be able to base your query on another query. For now, you can only choose a table). In order for you to have the wizard create your query, you MUST choose at least one field. You can either select all of the fields that are in one of your tables or you can select just a few.
After you have chosen the fields that you want in your query,
the last query wizard dialog box will come up
See the highlighted query name in the query title box below? Access names queries by default based on the tables that the queries are based on. However, you can specify a different name for your query if you want to do so