Queries and Query Design
Queries
ask questions. In a business database, the big question is: Who bought
what? A query looks at all of the data in the Tables and pulls out a
handful of records. Programmers sometimes describe it as getting the red
jellybeans out of the jar. Select Queries look at the Tables and
only return the Fields that you selected. There are Action Queries
as well. An Action Query modifies the data in the Tables. Action Queries
can Update, Append, Delete records. An Action Query can also Make a new
Table.
This lesson
will create a Select Query with the Query Wizard. We will edit the
Query in Design View, too.