. ' ; ' .
1. ? .
2. .
3. .
4. ?
5. .
6. .
7. .
8. .
1. . '. MS Excel MS Access ' , .
. . . 44.
44
ϲȪ CCT Ͳ 2001 p.*
譺 | - () | , | , | % | ||
12.03.01 | 15000.00 | 14000.00 | ||||
12.03.01 | 12000.00 | 12500.00 | ||||
13.03.01 | 23000.00 | 26000.00 | ||||
14.03.01 | 17000.00 | 10000.00 | ||||
16.03.01 | 8000.00 | 9200.00 | ||||
18.03.01 | 16000.00 | 24000.00 |
. 44
譺 | - () | , | , | % | ||
16.03.01 | 10000.00 | 7500.00 | ||||
12.03.01 | 12500.00 | 16000.00 | ||||
13.03.01 | 18100.00 | 20000.00 | ||||
14.03.01 | 8200.00 | 6000.00 | ||||
20.03.01 | 9800.00 | 7100.00 | ||||
21.03.01 | 1400.00 | 12500.00 |
|
|
2. . MS Excel .
. , . 4546.
45
в*
/ | ʳ | ֳ | ||
20.05.2001 | 15,00 | |||
21.05.2001 | 38,00 | |||
18.05.2001 | 26,00 | |||
21.05.2001 | 65,00 | |||
18.05.2001 | 42,00 | |||
19.05.2001 | 18,00 | |||
ʳ | 15.05.2001 | 6,00 | ||
' | 13.05.2001 | 4,00 | ||
17.05.2001 | 46,00 | |||
' | 10.05.2001 | 10,00 | ||
22.05.2001 | 35,00 | |||
21.05.2001 | 52,00 | |||
15.05.2001 | 45,00 | |||
19.05.2001 | 27,00 |
46
в"
/ | ʳ | ֳ | ||
21.05.2001 | 35,00 | |||
23.05.2001 | 46,00 | |||
21.05.2001 | 53,00 | |||
19.05.2001 | 46,00 | |||
' | 14.05.2001 | 6,00 | ||
ʳ | 19.05.2001 | 10,00 | ||
22.05.2001 | 48,00 | |||
23.05.2001 | 24,00 | |||
' | 15.05.2001 | 6,00 | ||
19.05.2001 | 35,00 | |||
23.05.2001 | 48,00 | |||
16.05.2001 | 35,00 | |||
23.05.2001 | 60,00 | |||
23.05.2001 | 34,00 | |||
' | 14.05.2001 | 15,00 | ||
19.05.2001 | 60,00 | |||
24.05.2001 | 46,00 | |||
26.05.2001 | 48,00 |
*
3. , - . '. MS Excel MS Access ' , .
² Ͳ. 2001 . - . , . 47.
47
-ί IJҲ
ϲȪ
|
|
² *
. 2001 p., | 40 000 | 42 000 | 42 000 | 45 000 | |||
. 2000 p., | 35 000 | 48 000 | 40 000 | 42 000 | 39 000 | ||
.. : | |||||||
1) | |||||||
2) | |||||||
3) | |||||||
4) | |||||||
5) | |||||||
6) | |||||||
7) | |||||||
8) | |||||||
9) | |||||||
10) | 10 800 | ||||||
. 2001 p., |
*
4. , . '. MS Excel ' , .
. 19992001 . (. 48)
48
̲ Ѳ ί 19992001 . ( . )*
/ | |||||||||||
2001 () |
5. Q . 1 ., . (Z), ^
(X), (X), () (t).
'. MS Excel ' , .
/. . 49 ' . , =0.25 () ( 2001 .)
, ' . ֳ , ' . , 䳿, . - ' , .
|
|
49
-ί IJҲ ϲȪ ² в*
. 2001 p. (0 | |||||||
1 . 2000 p. (C) | 2,00 | 1,95 | 2,01 | 1,98 | 2,00 | 1,98 | |
. 2000 p. {K} | 20,0 | 20,1 | 21,0 | 20,9 | 21,9 | 20,0 |
' : , , , , . ' ' , ' .
' 1 MS Excel
' . ' . ' . , , - .
, . , , , . .
- . :
(, ) = ((, ) / /7(, )) ■ 100,
,
,
,
,
.
' , . 50.
, .
' : -, , , .
- (MRF) : -, , ( ) , , , (), .
346
50
²̲ в
/ | % | ||||||||
. | % | ||||||||
: |
' MS Excel.
|
|
1. , . 51.
2. Format Cells ( > ) ' . Alignment () Merge Cells ().
3. .
3.1 G3, D15, F15, G15 , , . SUM ().
3.2 ³ .
51
ϲȪ CCT ̲
D | F | G | |||||
2001 . | |||||||
, | , | % | |||||
: |
4. .
4.1 Data Form ( > ) Excel . 51.
4.2 Data () Sort (). . , 볭 ( ) Ascending ( ) Descending ( ). , Excel . , . 51 . Ⳮ Sort () . , . Excel , . 52.
52
ϲȪ ̲,
ϲȪ *
, | , | % | ||||
12.03.01 | 96,00 | |||||
14.03.01 | 170,00 | |||||
18.03.01 | 66,67 | |||||
16.03.01 | 133,33 | |||||
21.03.01 | 112,00 | |||||
/ Total | 69000 | 66500 | 103,76 | |||
13.03.01 | 90,50 | |||||
14.03.01 | 136,67 | |||||
20.03.01 | 138,03 | |||||
2 Total | 36100 | 33100 | 109,06 | |||
12.03.01 | 107,14 |
. 52
, | , | % | ||||
13.03.01 | 88,46 | |||||
16.03.01 | 86,96 | |||||
12.03.01 | 78,13 | |||||
3 Total | 89,72 | |||||
Grand Total | 101,63 |
*
4.3 , . Data () Subtotals (), , . 1 Total, 2 Total, Total, Grand Total . G7, G11, G16, G17 .
4.4 ³ .
' 1 MS Access
MS Access . .
|
|
1. MS Access.
2. :
File ();
New Database;
New Blank database;
;
File > New database ' , , -..
Create.
2. :
Tables;
New;
New Table Design View;
;
;
Field Name ;
Data Type ;
Primary Key ;
;
, ;
Save as .
, (.53).
53
ֲ ֲ
- | |
, -- | |
:
AutoNumber;
Text;
Text;
Number;
Text.
:
♦ Number;
♦ Text.
:
♦ Auto-Number;
♦ Text;
♦ Text.
:
♦ Date/Time;
♦ ;
♦ Number;
♦ Number. :
♦ Number;
♦ Date/Time;
♦ Number. - :
♦ - Number;
♦ - Date/Time;
♦ Number;
♦ Number.
- :
♦ - Number;
♦ Number;
♦ Number;
♦ ʳ Number;
♦ ֳ Currency.
3. ' :
♦ Relationships;
♦ Relationships Show table Add;
♦ ' ;
♦ Relationships.
ϳ ' Relationships (.39).
4. :
♦ Queries;
♦ New;
♦ New Query Design View;
♦ ;
♦ , , Add ;
♦ ;
♦ Run ;
♦ , ;
♦ , View Design View .
:
♦ 孺 - -;
♦ -, -- ;
. 39. '
;
.
- :
-;
-;
;
.
- :
[ -]![ʳ ]* [ -]![ֳ ].
- :
-;
.
- . .
:
[ -]'[ʳ ]* [ -]![ֳ ].
:
;
;
.
.
%
([ ]'.[ ]/[ ]! [ ])* 100.
, :
;
;
;
.
% :
([ ]! [ ]/[ ]![ ])* 100.
, :
♦ ;
♦ ;
♦ . Design View 3. 5.
♦ Forms;
♦ New;
♦ Form Wizard, ;
♦ Form Wizard ;
♦ Available Fields Selected Fields;
♦ Next;
♦ ;
♦ Next;
♦ ;
♦ Next;
♦ ;
♦ Finish.
. :
♦ . , .
♦ . .
♦ . . Combo box, . Combo box .
♦ -. - -,
Ի, ( , subform) - ( Subform). Combo box
([ʳ ]*[ֳ ]).
6. :
Report;
New;
Report Wizard;
;
;
Available Fields Selected Fields;
Next;
;
Next
;
Next;
, ;
Next;
;
Next;
;
Finish.
, :
;
;
.
2
. MS Excel.
1. :
. 4546;
;
;
.
2. .
3. , Data > Form ( > ).
4. Data > Pivot Table (Pivot Table), . . 䳿:
, . , ;
Data - Pivot Table ( > );
5.
(Step 1 of 4) .
:
- ; Microsoft Excel data base ( Microsoft );
; External data source ( );
; Multiple consolidation ranges ( );
; Another pivot table ( ).
6. (Step 2 of 4)
Next ():
(Where is the data that you want to use?).
Next.
7. (Step 3 of 4)
,
.40:
. 41.
8. : Page (), Row (), Column (), Data (). ; Row, Column, ʳ Data. Next.
9. (Step 4 of 4):
, (Existing Worksheet), (New Worksheet);
Finish.
10. . sum, count .
sum, count. . Data.
Data > Pivot Table Field ( > ) Pilot Table Field ( ). , sum count. .41.
-, . . , .
3 5
г . , , . , , , , , .
, , , . -
, . ( ). . .
, . , , ᳭ .
. ' .
: -, - [13].
- .
Xj} ('-) '- ,
_ ,
xj '- , , .
. .
7. :
8. j-ro .
.
1. . - rnvrrn / .
38j '- , .
- . - .
:
;
;
( ) ;
;
;
;
.
. .
143*
³ . ( < Q,x > 0)
, , Z -0 . ,
(, , ..). ' (. 54).
54
²̲ ² Ѳ в в
/ | ( ) | |||||||
min | max | |||||||
" , .
' :
♦ ' ;
♦ ;
♦ ;
♦ ;
♦ .
' () -, , . :
♦ ();
♦ ;
♦ - ;
♦ ;
♦ ;
♦ ;
♦ ;
♦ .
() ' .
() -. .
() .
, - , , , , .
3 .
55, 䳿:
1. .
2. (Z)
(Z2) 2 F2 D3:D11 :11.
3. AVERAGE
(), D13
. -
14*
F12 D12. () D12. D13 .
4. D18.D21 .
5. . 2.10 .
6. ³ .
5 1 3 8.
55
Ѳ ² Dz в (1 . 2001 .)
. 55
4 .
1. (. 56).
56
Ѳ ² Dz в
. 56
1. .
2. ' , , .
3. ' ( , , , , ) MS Excel, ( 쳭 ).
˲
1. : / . . . . . .: , 1998. 400 .
2. . ., . , . . . .: , 1999. 350 .
3. . . . .
.:, 1988. 57 .
4. . . - . .: , 1976. 191 .
5. . Internet . .: BHV , 1997. 400 .
6. ., . Excel Windows 95. .: ij, 1996. 576 .
7. . . . ., . 1. .:, 1972. 335 .
8. . . . : , 1984. 256 .
9. . . .: Microsoft Press, 1999.
10. . ., 䳺 . . : . .: , 1998. 224
11. . . . . 2-, .
.: : . . . . ., 1987. 552 .
12. . . . .: , 1982. 200 .
13. . . , , . , 1991. 101 .
14. 2874-94. . . .: . 1995. 32 .
15. 2938-94. . . . .: . 1995. 32
16. 2940-94. . . . .: . 1995. 28
17. . ., . . : . . : , 1999. 272 .
18. 2567 02.10. 2 // ³ . . 1992, 48.
19. 80 05.07.94 // ³ . . 1994, 31.
20. . .: , 1978. 218 .
21. / . . . . .: , 1996. 272 .
22. . ., ˳ . ., . . . .: , 1999. 800 .
23. . . - . .: , 1988. . 64-71.
24. .