Query: The Query Tools

3. Try it: Review the Query Tools

The Query Tools include the following:

Results

Query Type

Query Setup

Show/Hide

 

There are several types of Queries.

Select and Cross Tab Queries show the data in the Tables.

 

Make Table, Append, Update and Delete are all Action Queries that change the data in the Tables.

 

We will create each Query Type in the Intermediate and Advanced lessons.

 

This lesson will look at the options in a simple Select Query that has only one Table. Keep going...

Query Tools ->Design

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.1. Construct queries: Edit a Select Query in Design View