Create A Query

Click the Queries tab


    The Sales table disappears.

Click


    Access displays the New Query window which provides you with several options to create a query.

We will create a query with the Design View option.

Click


    Access displays the Show Table window.

When creating a query, Access requires a data object which can be a table or query in your database. We will use the Sales table as our data object.

Click


    Access adds a     field list to the Select Query window.

Click


    The upper section of the Select Query window contains field lists. The lower part contains areas to select: fields, sorting options, and criteria.

Now you try it!