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 cr

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.