2
.
Excel , , , , . , Excel. , , INTERNET. , Excel. , Excel . MS Office, MS Query.
.
1. Excel, . , MS Access. Tovar2000.mdb. : , , , , , . . , , N. N=0.
- Microsoft Query. , . 1 .1.1. ( MS Access MS Access Database) OK. Tovar2000.mdb.
. 1.
. 1.1
2. (. . 2) MS Query . , . , ( ) , . . . (. .2).
. 2.
. 3.
3. ( ) ( , , 0. ). MS Query. , . (. . 3). - , . . , . . () . - , . 4. , , .
|
|
.4.
, , ( ). , . , MS Query . , ( ). .
MS Query. . , ( . 3).
, .
4. - SQL. . , SQL . , , , . , , . .
5. MS Query. - MS Excel. , A1 . . 5. . Excel . - , .
. 5.
6. . , . .6.
. 6.
, . , , 7 .8.
.7
6.1. . . . - . . 2 1, 3 2. , 3 . (). 1 .
.8
6.2. , . F E. F1 , E1 . F2 =(H2). F2
___MS_Access_Database3[[# ];[ ]],
Enter, . 2 =G2*D2.
|
|
___MS_Access_Database3[[# ];[]]*___MS_Access_Database3[[# ];[ ]].
, . - - .
6.3. ( 1), - . . . : 16, . . . A1:I1. . - - . .
, . , . .
, . .