Create a Select Query

Microsoft Access has a Query Wizard that goes through the process of choosing a Record Source (a Table or another Query) and then selecting the Fields you want. This is a good way to get started.


1. Try it: Create a Select Query

Go to Create ->Queries-> Query Wizard.


What Do You See? The Query Wizard has four templates:

Simple Query Wizard

Crosstab Query Wizard

Find Duplicates Query Wizard

Find Unmatched Query Wizard


Select: Simple Query Wizard.

Click OK.Keep going...

Create ->Queries-> Query Wizard

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Create a Select Query