Access . . Access , .
. , . , .
(Pivot Table) , , → → → (Home → Views → View → PivotTable View).
(. 9.11).
. 9.11. Orderedltems . , . ,
. , , . (, , ).
Access , . :
■ ;
■ ;
■ ;
■ . ( );
■ ,
, .
, , , .
. , , . , OrderedItems AdventureWorks, Web- "Missing CD" www.missingmanuals.com. , .
|
|
? "Missing CD" , .
1. ductCategory (Drop Row Fields Here). , Access (. 9.12). , → (Sort →Sort Descending).
, I -> - (PivotTable Tools I Design -> Show/Hide -> Field List).
. 9.12. , ( ) . , ,
2. Country (Drop Column Fields Here).
, Access . , .
, . , , , . (Add to) ( ).
3. . OrderQty (Drop Totals or Details Fields Here).
( Access , ).
OrderQty , . . ( ) (. 9.13).
4. . OrderQty ( OrderQty)
(AutoCalc).
, , , . ,
→ , , .
. 9.13. OrderQty Orderedltems, . ,
|
|
, , . (Totals) . ( +/-, .) (Delete).
5. OrderQty (Hide Details).
, , (. 9.14).
, , . ( OrderQty) (Data Area). . , . , .
. 9.14. , . ( ),