4. . .
.4.
. .
, , .
Microsoft Access :
.
\ . , , (.4). . .
- ( ), : , , ( ) ).
. .
1 255 .
. , .
: @ ; & ; < ; > . , ;. , , .
:
0 0 9; 9 - ; # , , ; L (A...Z, ...);? ; ; ; & ; ; :; - / , ; < ; > ;! ; \ .
|
|
0, , L, & . , .
( ) , . , , , .
. ( ), . , .
, , . . , , , , .
:
< | |
<= | |
> | |
>= | |
= | |
<> | He |
IN | ; , |
BETWEEN | , ; AND |
LIKE |
: Is Null Or >0 And <800 , (Is Null) 0 800; >50 And <100 BETWEEN 50 And 100 50 100; In (, , Los Angeles) IN ; #15.01.94# , (#); LIKE *##* , .
. : , , . , .
. , . Access : , , . Null, , . . , , . , () Null. " = ", Null, . , , Sum () Avg ( ). Null, NULL IsNull. , (""), , , . . . , . , Access , , , , Null. , Access , "" , .
|
|
: , , , , .
, . , Access, .
. Microsoft Access 2000 , MEMO (Unicode). , , . , MEMO , Access.
, (Unicode Compression) . , MEMO . , , 0, . , .
, , , , .
: 0 255; 32768 32767; -2147483648 2147483647; (4 ) 3.4028238 3.4028238; (8 ) 1.7976931348623208 1.7976931348623208; (GUID) 16 .
:. ;, ; 0 , ; # ; $ ; % ; . : , , , .
. : # ##0,00
, , . , , 123456,789 : 123 456,78
|
|
. , , , . :
#[]; -#[]; 0[]; ' "
, ? -, - ( !), , , . -, , , .
/
/ , :
( ) | 15.04.94 05:30:10 |
15 1994 | |
15--94 | |
15.04.94 | |
17:30:10 | |
05:30 | |
17:30 |
, , . . . , . , , : # ###$.
. , , . -, . -, . Access : . , . , , . (1, 2, 3, . .), , . , (, 1193517479, 442230790, 1742918387, . .). , , , , . , , . , , , .
: . Access : / /. , , . , , , (). . , , .
, .
|
|
, . , , UNC URL .
.
OLE
OLE (Object Linking and Embedding) . : . , , OLE- . , , . . . , . OLE.
OLE-, , , . . . , . , , , . , , . , Word , , , , Access, . , , , . . , , Windows, Access.
. , , . Access , . , . , . Access , . , .
""
. .
.5.
, . . TAB, - SHIFT+TAB. ( : ), . ( , , ).
: "", , . " ", .
: , , . "" "" : , ( , ) , DELETE.
:
,
() ,
,
: , SHIFT , ( ).
|
|
.
( ) Windows:
;
"" ;
- ( TAB),
"" .
1.