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.

 

Microsoft Office Access 2010: Example of the QBE grid