| Advantage Series: Microsoft® Access 2002 Sarah Hutchinson-Clifford Glen Coulthard
Creating Advanced Queries
Learning ObjectivesAfter 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 |
|