Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Session 3.1 Quick Check
Review
1. What is a select query?
2. Describe the field list and the design grid in the Query window in Design view.
3. How are a table datasheet and a query datasheet similar? How are they different?
4. The is the “one” table in a one-to-many relationship, and the
is the “many” table in the relationship.
5. is a set of rules that Access enforces to maintain consistency
between related tables when you update data in a database.
6. For a date/time field, how do the records appear when sorted in ascending order?
7. True or False: When you define multiple sort fields in Design view, the sort fields
must be adjacent to each other.
8. A(n) is a set of restrictions you place on the records in an open
datasheet or form to isolate a subset of records temporarily.
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
Session 3.2
Defining Record Selection Criteria for Queries
Matt wants to display employer and position information for all positions with a start date
of 07/01/2006, so that he can plan his recruitment efforts accordingly. For this request,
you could create a query to select the correct fields and all records in the Employer and
Position tables, select a StartDate field value of 07/01/2006 in the query datasheet, and
then click the Filter By Selection button to filter the query results to display only those
positions starting on July 1, 2006. However, a faster way of displaying the data Matt needs
is to create a query that displays the selected fields and only those records in the
Employer and Position tables that satisfy a condition.
Just as you can display selected fields from a database in a query datasheet, you can
display selected records. To tell Access which records you want to select, you must specify
a condition as part of the query. A condition is a criterion, or rule, that determines which
records are selected. To define a condition for a field, you place the condition in the
field’s Criteria text box in the design grid.
A condition usually consists of an operator, often a comparison operator, and a value.
A comparison operator asks Access to compare the value in a database field to the condi-
tion value and to select all the records for which the relationship is true. For example, the
condition >15.00 for the Wage field selects all records in the Position table having Wage
field values greater than 15.00. Figure 3-19 shows the Access comparison operators.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.
Figure 3-19
Access comparison operators
Operator
Meaning
Example
=
equal to (optional; default operator)
=“Hall”
<
less than
<#1/1/99#
<=
less than or equal to
<=100
>
greater than
>“C400”
>=
greater than or equal to
>=18.75
<>
not equal to
<>“Hall”
Between ... And...
between two values (inclusive)
Between 50 And 325
In ()
in a list of values
In (“Hall”, “Seeger”)
Like
matches a pattern that includes wildcards
Like “706*”
 
Search JabSto ::




Custom Search