Microsoft Office Tutorials and References
In Depth Information
The purpose of the Internet Assignments is to challenge you to find information on the
Internet that you can use to work effectively with this software. The actual assignments are
updated and maintained on the Course Technology Web site. Log on to the Internet and
use your Web browser to go to the Student Online Companion for New Perspectives
then navigate to the assignments for this tutorial.
Use the Internet to find
and work with data
related to the topics pre-
sented in this tutorial.
SAM Assessment and Training
If your instructor has chosen to use the full online version of SAM 2003 Assessment and
Training, you can go beyond the “just-in-time” training provided on the CD that accompa-
nies this text. Simply log in to your SAM account ( http://sam2003.course.com) to launch
any assigned training activities or exams that relate to the skills covered in this tutorial.
Quick Check Answers
1. a general query in which you specify the fields and records you want Access to select
2. The field list contains the table name at the top of the list box and the table’s fields
listed in the order in which they appear in the table; the design grid displays columns
that contain specifications about a field you will use in the query.
3. A table datasheet and a query datasheet look the same, appearing in Datasheet view,
and can be used to update data in a database. A table datasheet shows the permanent
data in a table, whereas a query datasheet is temporary and its contents are based on
the criteria you establish in the design grid.
4. primary table; related table
5. Referential integrity
6. oldest to most recent date
2. in the same Criteria row; in different Criteria rows
4. A calculated field appears in a query datasheet, form, or report but does not exist in a
database, as does a table field.
5. a function that performs an arithmetic operation on selected records in a database
6. Group By