2_Queries_presentation_l1_v1

Queries

What is a query?

A query is actually the name for any database manipulation operation.
The most commonly used type is a select query, which is a way of selecting what fields in what records are to be displayed.

Types of queries you can create in Microsoft Access

Select queries
Crosstab queries (actually a special kind of select query)
Action queries
Make-table queries
Delete queries
Update queries
Append queries)

In addition, any of these types can be designed to prompt the user for information, in which case it is called a parameter query.

Creating a query

You can create only very simple queries by using the Query Wizard.
We’ll create all our queries using the Design View for queries.
Once designed, the results of a query can be displayed in Datasheet View.