, , . Access , , . , Access , , , , . . . .
, , . , .
■ . .
.
, ,
. ,
. ,
.
■ . , . . , , . , , , - .
■ . . Boutique Fudge, Customers Orders, OrderDetails. ( ).
■ . : , , , . , , (, ).
, (front end) . , , , , .
, Access . , . , . .
|
|
1. , .
Products Boutique Fudge.
, , . Categories ( Products), , . 13.
2. → → (Create → Forms → Form).
. (. 12.1). , (. 12.2).
. 12.1. Products . Access , ( ProductCategoryID) (, Discontinued). (, Description) , ,
, . , ( , . " "
2), , . .
. 12.2. Customers Access , .
, Access , . . , (. . " " 3).
, . , | → → (Form Layout Tools | Formatting → Controls → Add Existing Fields). . <Delete>. , , , , , .
3. , , .
, , , 10, , . (. 12.3).
|
|
4. .
, Access .
. 12.3. . Access . Price ProductName. Access ,
. 12.4. Description . , . Products
, . , , .
, . . . 12.4 .
, , , , . , , . " " .
5. ,
.
ProductCategoryID Category.
6. , , .
, ( ) | → (FontForm Layout Tools | Formatting → Font). Access . . " " 10, .
, . , . . 12.5 .
<Ctrl>, . .
( ), Access, , . | → (Form Layout Tools | Formatting → AutoFormat) ( , ).
7. .
, Office → (Office → Save). , Access .
. 12.5. (, Price) , . Price, UnitsinStock UnitsOnOrder. , Price ,
|
|