Microsoft Office Tutorials and References
In Depth Information
To Quit Access
Quick Reference
For a table that lists how
to complete the tasks
covered in this topic
using the mouse, Ribbon,
shortcut menu, and
keyboard, see the Quick
Reference Summary at
the back of this topic, or
visit the Access 2007 Quick
Reference Web page
(scsite.com/ac2007/qr).
You saved all your changes and are ready to quit Access. The following step
quits Access.
1 Click the Close button on the right side of the Access title bar to quit Access.
Chapter Summary
In this chapter you have learned to create queries, enter fi elds, enter criteria, use text and numeric data in queries,
use wildcards, use compound criteria, create parameter queries, sort data in queries, join tables in queries, perform
calculations in queries, create crosstab queries, and customize the Navigation pane. The following list includes all
the new Access skills you have learned in this chapter.
1. Start Access (AC 77)
2. Open a Database (AC 77)
3. Use the Simple Query Wizard to Create a
Query (AC 78)
4. Use a Criterion in a Query (AC 81)
5. Print the Results of a Query (AC 83)
6. Create a Query in Design View (AC 83)
7. Add Fields to the Design Grid (AC 85)
8. Use Text Data in a Criterion (AC 86)
9. Use a Wildcard (AC 87)
10. Use Criteria for a Field Not Included in the Results
(AC 88)
11. Create a Parameter Query (AC 90)
12. Save a Query (AC 91)
13. Use a Saved Query (AC 92)
14. Use a Number in a Criterion (AC 93)
15. Use a Comparison Operator in a Criterion (AC 94)
16. Use a Compound Criterion Involving AND (AC 95)
17. Use a Compound Criterion Involving OR (AC 96)
18. Clear the Design Grid (AC 98)
19. Sort Data in a Query (AC 98)
20. Omit Duplicates (AC 100)
21. Sort on Multiple Keys (AC 101)
22. Create a Top-Values Query (AC 102)
23. Join Tables (AC 105)
24. Save the Query (AC 107)
25. Change Join Properties (AC 108)
26. Create a Report Involving a Join (AC 109)
27. Print a Report (AC 111)
28. Restrict the Records in a Join (AC 112)
29. Use a Calculated Field in a Query (AC 113)
30. Change a Caption (AC 116)
31. Calculate Statistics (AC 118)
32. Use Criteria in Calculating Statistics (AC 120)
33. Use Grouping (AC 121)
34. Create a Crosstab Query (AC 123)
35. Customize the Navigation Pane (AC 126)
36. Quit Access (AC 127)
If you have a SAM user profi le, you may have access to hands-on instruction, practice, and
assessment. Log in to your SAM account (http://sam2007.course.com) to launch any assigned
training activities or exams that relate to the skills covered in this chapter.
 
Search JabSto ::




Custom Search