Microsoft Office Tutorials and References
In Depth Information
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)
combination of database fields, constants, and operators.
4. How does a calculated field differ from a table field?
5. What is an aggregate function?
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.
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.
And logical operator
cascade deletes option
cascade updates option
Filter By Form
Filter By Selection
Group By operator
nonunique sort field
Or logical operator
primary sort field
query by example (QBE)
secondary sort field
Sort Ascending button
Sort Descending button
unique sort field