Access . . Access .
5.1.1 .
, .
, . , , _ , _ . . .
5.1.2
, , . , . . . Access , .. , :
5.1 -
. , . . , . : , , , /, , , , OLE, , . .
, , ( 255). ( 65535 ). - , . - ( 1), . . OLE - (, Excel, Word, , ), .
.
: ( 5.1 ), . , , , - , - : 999-99-99. :
|
|
|
, , .
, , ,
.
(Indexed) . , . , . , λ , . . , _, , .
(Indexed) :
| ( ). | |
| ( ) | . . |
| ( ) | . . |
, , . , , . .
OLE .
5.1.3
. , : , , , . , . , . . 5.2 .
5.2 -
, . Access: , ( ) ..
(). () .
5.2.1
: , , , , .
, . . , .. . , . . , .
|
|
|
5.2.2
, . :
| , ; | |
| , . |
.
, , / . . ( ), . , _, . _, AVG () .
5.2.3
, . .
, . , Access . , (, 1:∞). , .
. / . , . .
5.2.4
/ , . .
, , () . , . , , .
/ . Access . . , . .
, Access . , . . , .
DELETE
: , FROM, WHERE.
, (__=0). .
|
|
|
DELETE .*, ., .__
FROM
WHERE (((.)="") AND ((.__)=0));
5.2.5
. /. . . . , . - , , , .
UPDATE
: , .
.
10 % , 15.
UPDATE _ SET _. = []*1.1
WHERE (((_.)<15));
5.2.6
, .
/ SQL .
TRANSFORM
: (, , , ). , , .
, . , .
TRANSFORM Sum(._) AS [C___]
SELECT .
FROM INNER JOIN ( INNER JOIN ( INNER JOIN ON . = .) ON ._ = ._) ON ._ = ._
GROUP BY .
PIVOT .;
Access. , . : , , ..
5.3.1
: , , , . .
5.3.2
, . :
- ( );
- (, );
|
|
|
- ( ).
.
. - , .
Access :
- ,
- ,
- ,
- ,
- ,
- ,
- ,
- ,
- ,
- ,
- .
, , - , - , .
(Toolbox), 5.3 ( Access 2000-2002), ( 5.4)
5.3 -
