Create queries using Design view as shown on
figure 2-2 on AC2-4.
Include fields in the design grid a in figure 2-5 on AC 69.
Use text and numeric data in criteria
as in figure 2-6 on AC 70 – AC 78.
Save a query and use the saved query as shown on
AC 71 – AC 74
Create and use parameter queries as in figures 2-18 – 2-22 on AC 76.
Use compound criteria in queries
as in figures 2-27 – 2-30 on AC 80.
Sort data in queries as shown on AC 84 figures 2-32, 2-33, 2-34.
Join tables in queries as shown in figure
2-42 on AC 89- AC 93.
Create a report and a form from a query as on
AC 94 – AC 96.
Export data from a query to another application as on AC 97.
Perform calculations and calculate statistics in queries as on
AC 102 – AC 106 and figures 2- 63, 2-64, 2-65 – 2-75.
Create crosstab queries as in figure
2- 79 – 2-84 on AC 108 – 111
Customize the Navigation Pane as on AC 111 – AC 113.