McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Glossary
Data Files
Buzz in IT
Learning Objectives
Chapter Outline
Prerequisites
Multiple Choice Quiz
Short Answer
True or False
Case Problems
Hands-On Exercises
Feedback
Help Center


Advantage Series MS Office XP Access 2002
Advantage Series: Microsoft® Access 2002
Sarah Hutchinson-Clifford
Glen Coulthard

Creating Select Queries

Learning Objectives

After completing this chapter, you will be able to:

1.

Create a select query using query Design view

2.

Modify a query by adding and deleting tables and fields

3.

Specify search criteria using conditional statements and logical operators

4.

Create, modify, and print a multi-table query

5.

Enhance a query by sorting, filtering, and hiding results

6.

Analyze and summarize your data using calculated fields and summary queries




McGraw-Hill/Irwin