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