Creating Queries in Access 

Creating a Query from database Tables

1.      First, a relationship has to be made with the tables. Close all tables. 
You should be at the Database window.

2.      Click on the Relationship  button on the toolbar.

3.      Click on the Show Tables  button.

4.      Select a table and click Add.  
Repeat to show two or more tables. Click Close.

5.      Now click and drag a field from one table to a field that is the same or related in another table.  The Edit Relationships box will appear.  Click Create to create the relationship.  A line will then appear connecting the two tables by those fields.

6.      Close the Relationship window and save it.

7.      Now, click Queries in the Database window.  Queries can be created via Design View or Query Wizard.

Creating a Query via the Design View

1.      Click on the  button. Then select Design View and OK.

2.      The Design View will open with the Show Table window.

3.      Select and Add the tables you want to use in your query. Then Close the Show Tables window.

4.      To select the fields you want in the query, click in the first Field cell below the tables. Click the down arrow to select your first field. Click in the second Field cell, then click the down arrow to select your second field. Repeat for more fields.

5.      You can click in any of the Sort cells to sort by that field.

6.      Type in a criteria for the query or click the Build  button to build an expression for the criteria.

7.      Click the Run  button to run the query.

Creating a Query via the Simple Query Wizard

1.      Click on the  button. Then select Simple Query Wizard and OK.

2.      The Simple Query Wizard window appears.

3.      Choose a table, then double click on any of the fields you want in your query. 
Repeat for other  tables. Click Next.

4.      Keep Detail selected or choose Summary for calculations to be done. Click Next.

5.      Name your Query, then click Finish.