MS Access Simple Query Wizard

The easiest way to create a query may be to use the Simple Query Wizard (although you may find the Query Design view easy to use also). The Simple Query Wizard makes it easy to select fields from multiple tables, and is, by far, the easiest way to create summary calculations. On the other hand, the Simple Query wizard does not give you the chance to apply criteria to your query (although you can add criteria later using the Query Design view).
This Simulation takes you through the creation of a query with the Simple Query Wizard. The query it creates will calculate how many hours have been worked on each project.

Once the wizard has finished, you cannot use it to make further changes in the query. You can either run the wizard again from the beginning to create a new query, or you can edit the query the wizard created using Design view. The wizard is a good way to get started with a query, especially if you want to group and summarize data.
You will be introduced to the Query Design window.

Queries allow you to ask questions of your data. The answer is called a dynaset. This is nothing more than a term to describe the set of records that the query returns in response to the question asked of the data. Without queries data would be useless, because they allow the distillation of a large quantity of data into easy to understand statements. A query of student test scores would show the students that correctly answered questions 2 and 10. Another might display the number of students with perfect attendance. Just remember, the most important thing you get from queries are dynasets or as most individuals call them, solutions.

Now try creating a query in the Consulting database.
Simple Query Wizard - Exercise