Microsoft Office Tutorials and References
In Depth Information
Tutorial 3
Tutorial 3
Querying a Database
Retrieving Information About Employers and Their Positions
Northeast Seasonal Jobs International (NSJI)
At a recent company meeting, Elsa Jensen and other NSJI employees discussed the importance of regularly moni-
toring the business activity of the company’s employer clients. For example, Zack Ward and his marketing staff
track employer activity to develop new strategies for promoting NSJI’s services. Matt Griffin, the manager of
recruitment, needs to track information about available positions, so that he can find student recruits to fill those
positions. In addition, Elsa is interested in analyzing other aspects of the business, such as the wage amounts paid
for different positions at different employers. You can satisfy all these informational needs for NSJI by creating and
using queries that retrieve information from the Northeast database.
| Objectives
| SAM Training Tasks
• Add a table to the
Design View query grid
• Create a multi-table
• Create a one-to-many
relationship using the
Relationships window
• Create a query in
design view
• Enforce referential
integrity in a one-to-
many relationship
• Filter datasheet by form
• Filter datasheet by
• Include all fields in a
Session 3.1
• Learn how to use the
Query window in
Design view
• Create, run, and save
• Update data using a
• Define a relationship
between two tables
• Sort data in a query
• Filter data in a query
• Include criteria in a
query for a field not in
the results
• Order records in
datasheet view
• Resize panes and
field lists in Query
Design view
• Restrict records in a join
• Sort a query on
multiple fields in
Design View
• Sort records in a
• Specify referential
integrity options
• Use filter by form
Session 3.2
• Specify an exact match
condition in a query
• Change a datasheet’s
• Use a comparison
operator to match a
range of values
• Use the And and Or
logical operators
• Use multiple undo
and redo
• Perform calculations in
a query using calculated
fields, aggregate
functions, and record
group calculations
• Add a calculated field
to a Select query
• Build summary queries
• Create calculated fields
• Create queries using
• Create queries with
AND conditions
• Create Select queries
using the Simple Query
• Format a table or query
datasheet for display
• Format results displayed
in a calculated field
• Use aggregate functions
in queries to perform
• Use date and memo
fields in a query
• Use text data in criteria
for a query
• Use the AVG function
in a query
• Use Undo and Redo
For a complete list of the Data Files needed for this tutorial, see page AC 2.
Student Data Files
Search JabSto ::

Custom Search