Access gives you several ways to create select queries. The easiest and fastest are the Query Wizard and Design view.
The Query Wizard
automates the process of setting up your query's structure. You select a record source, choose sorting and filtering options, and the wizard does the rest. You can also use the wizard to create other types of queries, such as crosstab and action queries.
gives you more control over your queries. After you select your record source, you drag the fields you want to a grid. You can also enter any selection criteria
for filtering your data, and formulas for performing calculations.
We'll start with the wizard.