, . , .
, .
8.
.
8.1. . :
, .
8.2. <>.
8.3. :
, -.
, .3. . .
9.
, .
9.1. <> 3 4.
! I-, <>, <I- >.
9.2. 3.
, .
. , , , , - -.
, Excel . .
10.
. , jurnal.xls.
10.1. , : , , .
10.2. 3 :
:=':\RV\[ jurnal.xls ]'!3
':\RV\[ jurnal.xls ]' - jurnal.xls <>. . .
10.3. 4 . , .. .
11.
I- (..6.3.).
12.
<> < >, (. . 8.1 8,2).
13.
, <>. .
14.
<> , I- 5,4,3 :
14.1. <> 10 : " 5:"
14.2. 17 24.
|
|
14.3. 17 " 4:", 24 " 3:".
14.4. 5 I-.
14.5. 11- .
14.6. , , .
14.7. , 3 4 (.5).
14.8. , : , , .
<>, :
2.09 | 9.09 | 16.09 | 23.09 | I- | |||
5: | |||||||
2.09 | 9.09 | 16.09 | 23.09 | I- | |||
4: | |||||||
3: | |||||||
.5
15.
work7.xls.
16.
<> . , , [] - .
17.
:
: [1] 1-638 c, [2] 1- 432 c.
: [8] c.
:
1. .
2. .
3. .
4. Excel?
5. .
6. ?
7. ?
:
1. jurnal.xls work7.xls;
2. <> work7.xls.
5.
: Access. . . (2 ).
- , .
. Access - (). , , , . Access (, , ..). Access , . Access - . , . . Access , , , Paradox Dbase. Access Excel.
|
|
, , , , , , Access 97 . . . . , , , , , .. , , , , . , 64 . , . , . Access . . . Access .
( ) | , , ( 255 ) |
, | |
/ | 100 9999 |
, , 15 4 | |
MEMO | ; 65535 |
, Access . | |
(TrueFalse, /) | |
OLE | (, Microsoft Excel, Microsoft Word, , ), Access |
, . : , ; ( UNC) ( URL). , , | |
, , . , |
1
.
1. .
2. .
3. .1.
4. .
.1.
/ | ||
:
:
1. Access, ;
|
|
2. " " ( ) ( ), . Access db1, - Access. , , ;
3. <>.
4. :
5. , <>;
6. " " <>. (. 1), .
7. :
8. ;
9. " " . , Access.
.1. -
10. :
, ;
"" ',
<>.
2
.
1. , ""; , .
2. , "".
3. "" .
4. <>; .
5. . 2 "".
6. .
7. .
8. : 450 , 470 .
9. " " ,
10. "" "".
11. , .
2
. | ||||||||
23.10.54 | 110-44-68 | 890. | ||||||
25.07.40 | 312-21-40 | 1200. | ||||||
05.12.67 | 260-23-65 | 760. | ||||||
12.02.72 | 234-85-69 | 450. | ||||||
16.02.51 | 166-75-33 | 890. | ||||||
30.05.66 | 210-36-98 | 790. | ||||||
30.07.48 | 166-75-33 | 890. |