, , ? ( ), , . ( ), .
, , , , . ( , 480 .) , , .
8. , ? (Yes, include row sums).
. , , , (. 9.8).
. 9.8. , ( )
9. .
. . , . .
10 .
, . , .
1. → → (Create → Other → Query Design). Access .
2. (Show Table) , , .
AdventureWorks, (Queries) Orderedltems.
, , .
3. | → → : (Query Tools | Design → Query Type → Crosstab),
Access . . (Crosstab) (. 9.9).
|
|
. 9.9. , , : , . , , , ( , , )
4. , . .
□ . (Row Heading) .
, , . , . , , , .
□ . (Column Heading) .
. , .
. , ( Sum, Count, Avg . .), (Value) .
. , , . , , . 9.1 9.2, Revenue: [UnitPrice] * [OrderQty] .
, , . . 9.10 , .
. 9.10. , OrderQty . , . , . Total Of OrderQty ( )
□ . (Where) ( ) (not shown) . . (. . " " 6.)
|
|
, . , , , . , .
. 9.10 , (. . 9.8).
, Access . , , . .
■ . . () , .
■ . , . .
■ . , , , . , , .
■ . , . , , .
■ . , , .
Access , . , , (, Microsoft Excel). , , , , .