+ - / * | , , , |
% | (, 5% 0.05) |
^ | (, 2.3 ^ 3 = 12.167) |
= > < | , , |
>= <= <> | , , |
& | () |
() | |
() | |
() |
:
1) .
2) ; = = .
3) , .
4) . : ( ). , .
5) . <Enter>. . .
, ( 8.2).
8.2
# /0! | ||
#! | , : , , .. | |
#! | (, ) | |
#! | ( ) | |
#! | ||
#! | (, ) | |
#/! | , |
Excel , . / //, , ( ) ( ).
|
|
A | B | C | D | |
=A1+B1+C1 | ||||
=A1+A2 |
. 8.4.
. 8.4 A1:C2 , A3 =A1+A2, .. , D1 =A1+B1+C1, .. . . A3 D1 79 56, . , A3 B3 C3, =B1+B2 =C1+C2, .. . D1 D2 =A2+B2+C2, .. , 75.
. A3 =$A$1+A2, D1 = A1+$B$1+C$1. B3 C3 =$A$1+B2 =$A$1+C2, . D2 = A2+$B$1+C$1. ( $), . , ∑ () . , , , , ∑.
Excel , . . , . . , =, . , , :
1) / fx .
2) , (. 8.5).
3) .
. 8.5. ,
SIN(), .
, , . , /. , , , . , , , . . . 8.3. , , . . 8.6 .
|
|
8.3
1 | 2 | 3 | 4 | 5 | |||||||||
. 8.6.
. 8.7.
:
1) , ,
2) ,
3) (. 8.7), ,
4) ( 2 ) ( ) , ,
5) ( , ) , ,
6) , .
. , , .
8.5. , ,
. , , , , /, , , : . , .
- , . (, ), . , ( 8.4). , , .. , , . :
1) , . A22.
2) / (. 8.8).
3) .
4) , A6:E9 .
5) .
6) 4 5 (A11:E14 A16:E19).
7) OK (. 8.8).
8.4
,
A | B | C | D | E | |
1999 . | |||||
, .. | |||||
I | II | III | IV | ||
1 | |||||
2 | |||||
3 | |||||
1 - 3 ( ) | |||||
|
|
. 8.8. , /
- . , . , 8.4 . 8.5.
8.5
A | B | C | D | E | F | |
1999 . | ||||||
I | II | III | IV | |||
1 | ||||||
1 | ||||||
1 | ||||||
1 | ||||||
2 | ||||||
2 | ||||||
2 | ||||||
2 | ||||||
3 | ||||||
3 | ||||||
3 | ||||||
3 |
:
1) / , ( ), ;
2) , ( A3:F15); , ; ;
3) , ; (. 8.9), , I, II, III, IV ; ;
4) , , .
. 8.9.
, ( 8.6), . , () .
8.6
() | ||
I | ||
II | ||
III | ||
IV | ||
I | ||
II | ||
III | ||
IV | ||
I | ||
II | ||
III | ||
IV | ||
I | ||
II | ||
III | ||
IV | ||
I | ||
II | ||
III | ||
IV |
Excel. Word (. 7), . Excel , [ 6 ], Excel [1,2].
|
|
, Excel , . , [1,2] . , (), .
8: Excel; : , , , , , () , ; , ; , , ; , , , ; , , , , ; ; , ; : , , Excel, ; ; : , , ; , , .
9. . Access
9.1.
, .
. , , . , , , , , , . , . , , , . , , , , .
. . 3 . - . , , , : , , . , . . . , (, ..), . .
, , . , -. :
[ , ],
[ , ],
[ , , , , , , , ]
[ , , , , , , ].
, , - , ( ) . . . () . .
|
|
. , , -. , , , , , . , . (1 ¥): . , - , , , , (1 1), .. . - . , , ..
, . , , . , , .
, -. . (relation ) ... 1994 . 25 , .. ( IBM) . , Oracle [14], 1979 . Silicon Valley. Oracle Corporation . / 1985 . Oracle 5. , Oracle, Sybase, Microsoft . / - . . , , . , - SQL (. 9.4) .
( , , ) , , , . , : , , , .. - () , .
, , . , -, , , , - , , -, . , (, , ) . , , , , .
9.2. ()
, , . - , , - . . .
(), , , . .. , .
, , ( , ) , .. . (. 9.1) . , , - . , , , . , , . , - -, , .
, , . , ( ) . , (, ) , , , -, . . , . , , .
[4]. , , . , , , , , , , , , , .
, , . -, (, .), , . -, , , , , . -, , , .
, - , , . . , , . , . , 777, 777, , , , . , , , . , . . . , .
Access, [4] (. 9.1).
9.3. Access
Access . (. . 9.1).
, , .. . Access, /, Ok. (. 2.3). , , .mdb. , , , , (. . 9.1). . 9.2 Access. : , , , Access . , , .
. 9.1.
, , , .. . , . (: ) (), (). . : . 9.3 . , (. 2.2) . . , , . . , . 50 , . , , ( , ). , . , (. . 9.2). . <Enter> - , . <Tab> <Shift>+<Tab>. ,
(. . 9.2).
. 9.2. Access
, , . (. : . 9.3) , , . . . 9.3 , . () () , , . ( ), (/), ( ), () (2). , , 1; 7 , 8 . ( - . 9.4) , , , () . , . , Access . (. . 9.4).
. 9.3. :
, . , , . , , , , , (, , ), (. . 9.4). , . / . , . , (. . 9.4). , , (. 9.2). , , : , , , (. 9.2). . 9.4 , , . .
(), (). , ( ), - , . , . , , . , , , .
. , , , 1 2. , (), (). , , , . 9.4, . , , . , . ( [14]), , . , .
. . 9.5 1998 . . . (), (), - . , , , , , . , ( . 9.5 ) . , /. , , , . Sum, , . , , , .
. 9.5. , Access
Access, . , , , . (SQL). , , Access SQL. . . , , . Access / SQL, , SQL-. / ( ) .
() SQL , .. SQL , . SQL . statement instruction.
9.4. (SQL)
, SQL, SQL-. SQL, . (Oracle, MS SQL Server, Cybase, Informix ) ANSI / ISO SQL (ANSI , ISO ), SQL- . Access. , Access SQL. /, SQL, Oracle 7 [14].
SQL-, . , () SQL. . , : . SQL- SQL , COMMIT, .
SQL: , , , ( ). SQL-, .
(DDL Data Definition Language) SQL, (CREATE), (ALTER) (DROP) (, .). , Objects [ , ]:
CREATE TABLE Objects( LONG CONSTRAINT obj PRIMARY KEY, TEXT(40))
CREATE TABLE (Objects), , . LONG (. 3), CONSTRAINT () (obj) PRIMARY KEY . (), (TEXT) (40). , SQL Access ( ) , SQL.
(DML) SELECT ( ), INSERT ( ), UPDATE ( ), DELETE ( ). SELECT:
SELECT .[ ], ., ., . , ., .
FROM , , ,
WHERE .[ ] = .[ ] AND .[ ] = .[ ] AND .[ ] = .[ ] AND . >= #3/31/98# AND . < #7/1/98# AND .=''
ORDER BY .[ ];
, SELECT, FROM: , .. . , .. . .
FROM .
WHERE . , , () 31.03.98 () 01.07.98 ( #//#). , ( ) . , , , WHERE . (AND), , , . (OR) , .
ORDER BY , () . , , , . . 9.6 , SELECT.
. 9.6. , SELECT
DELETE:
DELETE * FROM - ,
DELETE * FROM WHERE IN (,,) - , , , . , .
:
COMMIT - () ,
ROLLBACK , ,
SAVEPOINT .
:
INSERT
DELETE
SAVEPOINT one
UPDATE
DELETE
SAVEPOINT two
INSERT
UPDATE
:
ROLLBACK TO SAVEPOINT two
SQL- two.
(DCL) . , SQL-. , Oracle 7 [14] . : , .. , , role7, :
SET ROLE role7 IDENTIFIED BY x77y - role7 x77y.
SQL, ( - . ). , Oracle 7 SQL , PL/SQL. SQL : , , . SQL. , , , , . , . PL/SQL SQL . ( 10), PL/SQL , , .. , SQL. . , . SQL, , . , , , . , / , .
SQL , - , SQL .
9: , , ; , , ; , ; ; - ; ; ; , ; ; ; Access , , , , , ; SQL, SQL; ; ; ; ( ); .
10. . Visual Basic for Applications
10.1.
, . , , , , . - . , , , , , , . , , : . ( ) .
, . , , , , . : , , . , .. , . , , . , -, , , -, , , .
VBA Visual Basic for Applications (Visual Basic ). :
VBA , -- (. 2);
VBA , , ;
VBA MS Office Word, Excel, Access, Power Point, OutLook, Binder; VBA Excel, Excel .
. , VBA, VB (Visual Basic), , , , Excel. Excel. VBA. , VB, Delphi ++. , , Excel , VBA - . VBA, , , Excel , , , (. 2), .. , , . , VBA MS Office, .
6.2. , , , , .
10.2.
. Excel