Programs: Microsoft Access:  Chapter 3, Lesson 3


Lesson 3

Queries

OBJECTIVES

-To learn how to find selected information in your report

  1. Use the Design Grid
  2. See the Dynaset and Select Query
  3. Choose Design View
  4. Choose Datasheet View
  5. Choose SQL View
  6. Learn how to use Relational Operations

-Select information in any way you would like. 

Objective # 1 Design Grid
  • The start of a query.
  • The place where you select information (criteria) that you want displayed in your query.
  • The design grid to the left chose runners from NY, sorted alphabetically by last name.
Objective # 2 Dynaset/Select Query
n
Dynaset
  • Presents the information that you selected in the Design Grid, in a Select Query.

 

Select Query
  • Most frequently used query.
  • Shows data that the Design Grid chooses.
  • In this example, Lutes and Simmons are runners from NY (shown left).
Objective # 3 Design View
Query Design View
  • Contains all of the information that will be shown in the Design Grid.
Field List
  • Shows all of the categories that are in the underlying table
  • Shown Left.
Field Row
  • Shows the name of each field.
  • Shown Left.
Sort Row
  • Allows you to arrange your query in ascending or descending order.
  • Shown Left.
Show Row
  • Is checked off if that part of your query will be shown in the Dynaset.
  • Shown Left.
Criteria Row
  • List the specific information you are selecting to show in your Dynaset.
  • An example can be seen left where friends who live in NY and chose running for a hobby are the criteria.
  • Can be chosen by choosing Design View under the View heading at the top of the screen.

Objective # 4 Datasheet View
  • This view can be chosen to see the Select Query in a different way.
  • Can be chosen by choosing Datasheet View under the View heading at the top of the screen.
 
 
Objective # 5 SQL View
  • Structured Query Language View
  • Displays the same information that you see in the Design View and Datasheet View.
  • The difference between this view and the others is that this is in written form instead of table form.
  • Can be chosen by choosing SQL View under the View heading at the top of the screen.
Objective # 6 Relational Operations
Symbols
  • > Greater Than
  • < Less Than
  • >= Greater Than or Equal To
  • <= Less Than or Equal To
  • <> In Between
Example
  • In the display to the left you can see that the Design Grid selects people less than 20.

Lesson Review

You learned how to....
  • Use the Design Grid to create a Dynaset and Select Query.
  • Look at your query in the 3 different views. 
  • Use relational operations.

 

back to lesson #2

continue to lesson #4

back to menu 


Programs: Microsoft Access:  Chapter 3, Lesson 3