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 Advanced Queries

Learning Objectives

After completing this chapter, you will be able to:

1.

Set inner and outer join properties for table relationships

2.

View and edit a query in SQL view mode

3.

Enter complex expressions in select queries

4.

Use the Find Duplicates, Find Unmatched, and Crosstab query wizards

5.

Create a parameter query for applying dynamic criteria

6.

Use action queries to update and delete records, make tables, and append records to tables




McGraw-Hill/Irwin




Copyright2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.