, . .
1. . .
1. ,
(Back Color).
, .
2. . (...) . . .
, . , .
3. .
, .
. , (ReportHeader) (Detail), .
, . , , <Shift> . .
. , . . 11.1 , .
11.1. ( )
, | (Text Align) | . , Access . , . , , |
(Text box) | (Format) | , Access , , . (. . " " 7), Access , . , (, ). . " " 2 |
(Text box) | (Can Grow) | , Access , . , , . , Access |
(Report) | (Default View) | , , . |
11.1 ()
|
|
(Report) | (Page Header) (Page Footer) | (All Pages), . , |
(PageHeaderSection), (PageFooterSection), (ReportHeader), (ReportFooter) | (Display When) | . , , |
(Detail) | (Force New Page) | (None), Access , . (Before Section) , . |
(Detail) | (Keep Together) | , Access . , Access |
, . , , . ( ). , , . (=), .
. , , . , =Date(), Access .
. , 7. , , , .
, . , , . . " " 7, & , . :
|
|
=FirstName & " " & LastName
7, , , , , .
, . . ( Access .)
. 11.17. : . : Access
, . .
, (. 11.17).
.
#Error ?
#Error , . Access , .
, . , . , . , , , , , Access .
Access , , . , :
;
,' , , ;
;
, , , =UnitsInStock+UnitsOnOrder UnitsInStock, Access . ( UnitsInStockCalculation) . ( .)
. . Boutique Fudge. , , , , , - , , . .
.
■ . . , ,
. ( . " " 7) .
|
|
■ . . . .
■ . , . .
Access. Access 2007 , . , .
.
1. .
2. , . , .
ProductCategoryID ( ), , ProductCategorylD. . ( ProductCategories, , CategoryName. , .)
, Access , . ProductCategoryID , , , . ProductCategoryID , Access CategoryName .
3. , , (, (Sort A to Z) (Sort Smallest to Largest)).
, .
4 , , (Group On). Access .
. 11.18 11.19 , .
. 11.18.
, , , . . . , ( ). . 11.18 ( . 11.19 , .) , , (. . " ' ).
|
|
. ProductCategoryID, 'ProductCategoryID' (ProductCategoryID Header), Access (. 11.20). , . , .
, . - Access .
. 11.19. . , , , ( ) , . . , 11.20