|
1.
|
Open Microsoft Access 2003. |
|
|
|
|
2.
|
Open 3-2 Sample from the Exercise
Files folder.
|
|
|
|
|
3.
|
On the Queries section of the database
window, click New.
|
|
|
|
|
4.
|
In the Query wizard, click
Crosstab Query Wizard.
Click
OK.
|
|
|
|
|
5.
|
In the first step of the wizard, choose
Transactions for
the table type.
Click
Next.
|
|
|
|
|
6.
|
For the row headings, choose
Transaction Description.
Click the right-facing arrow (>)
to add it to the Selected Fields list.
Click
Next.
|
|
|
|
|
7.
|
For the column headings, choose
Transaction Date.
Click
Next.
|
|
|
|
|
8.
|
Choose to group the information by
Quarter.
Click
Next.
|
|
|
|
|
9.
|
For the calculation field, choose
Withdrawal Amount.
For the function, choose
Avg.
Click
Next.
|
|
|
|
|
10.
|
Name your query Monthly Summary.
Click
Finish.
|
|
|
|
|
11.
|
Your query will then open.
|
|
|
|
|
12.
|
Close the open query.
Open the query from the database window in
design mode.
|
|
|
|
|
13.
|
Take a look at how the query is built.
|
|
|
|
|
14.
C |
Close Microsoft Access 2003. |
