, . ( ), . .
( , ), . ! , , . accdb ( ; ). Windows, , Access, Office → → (Office → Manage → Back Up Database) (. . " " 1).
, , .
, . . , , ( │ → (Query Tools │ Design → Query Type)).
Access :
■ ;
■ ;
■ ;
■ .
.
. , Access , . . . , CategoryID. ( , ). 10% .
|
|
, , (. . "" 2). , .
Products Products Categories Boutique Fudge ( . " " 5). Beverages (), 10%. , "Missing CD" Web- www.missingmanuals.com.
.
1. , → → (Create → Other → Query Design).
(Show Table).
2. , , (Add) ( , , ). (Close).
, , . (, . " " 6). , - .
Products ProductCategories.
3. , | → → : (Query Tools | Design → Query Type → Update).
, . (Sort) (Show) ( ) , , (Update To).
4. ( ), (Criteria).
, Access. , , .
CategoryID CategoryName. CategoryID, (ID) . CategoryName, .
, . , , . 8.1. , .
. 8.1. Beverages
|
|
5. ( ), .
Price, , .
6. , .
. , . , Access .
, . , 7 , . , Price 10%:
[Price]*1.10
(. . " " 7). Access , , (, ).
7. , .
, , , (, , , , ). , , , , , ProductName.
, . Access , . ProductName, - . [ ProductName ]. Access ProductName ProductName. , Access , ProductName .
. 8.2 .
8. (Datasheet View) , (. 8.3).
, , . , , , , , , .
. , , . , .
9. ( (Design View)). ,
, | → → (Query Tools | Design → Results → Run) .
. 8.2. 10%
. 8.3. . Beverages . ,
: .
|
|
, Access , (. 8.4). (Yes) .
. 8.4. : Access , . , , Access . ( ). : Access . , . , Access
, Access . , , , , ( ). , , . ( , .)
10. <Ctrl>+<S> ( ). .
, , . , , UpdateProductPrices ( ). . (. 8.5).
, , . ( - ) .
. 8.5. , . , , , , . ( )
.