Microsoft Office Tutorials and References
In Depth Information
Session 3.2
The queries you’ve created and saved will help Elsa, Zack, Matt, and other employees
to monitor and analyze the business activity of NSJI’s employer customers. Now any NSJI
staff member can run the queries at any time, modify them as needed, or use them as the
basis for designing new queries to meet additional information requirements.
Session 3.2 Quick Check
1. A(n) is a criterion, or rule, that determines which records are
selected for a query datasheet.
2. In the design grid, where do you place the conditions for two different fields when
you use the And logical operator? The Or logical operator?
3. To perform a calculation in a query, you define a(n)
containing a
combination of database fields, constants, and operators.
4. How does a calculated field differ from a table field?
5. What is an aggregate function?
6. The
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
operator divides selected records into groups based on the val-
ues in a field.
Tutorial Summary
In this tutorial, you learned how to create queries in Design view, and how to run and
save queries. You also learned how you can use the query datasheet to update the data
contained in the underlying database table. This tutorial presented one of the most impor-
tant database concepts—defining table relationships. You learned how to define a one-to-
many relationship between two tables in a database, and how to enforce referential
integrity as part of the relationship. After defining this relationship, you created a query
based on data in the two tables. You learned how to sort and filter query results to view
records in a particular order and to view different subsets of the displayed records. Using
record selection criteria, you specified an exact match in a query, used a comparison
operator to match a range of values, and used the And and Or logical operators to meet
various requests for data retrieval. Finally, you created a calculated field in the Expression
Builder dialog box to display the results of an expression in a query, and you used aggre-
gate functions and the Group By operator to calculate and display statistical information
in a query.
Key Terms
aggregate function
And logical operator
calculated field
cascade deletes option
cascade updates option
comparison operator
design grid
exact match
Expression Builder
field list
Filter By Form
Filter By Selection
Group By operator
join line
logical operator
nonunique sort field
one-to-many relationship
Or logical operator
orphaned record
primary sort field
primary table
query by example (QBE)
referential integrity
related table
Relationships window
run (query)
secondary sort field
select query
Sort Ascending button
Sort Descending button
sort field
unique sort field
Zoom box
Search JabSto ::

Custom Search