Access (. 6) . True False, . , , , True, , False.
6. , Access
Between | Between (-100) And (100) | , |
Is | Is Null Is Not Null | Null , Null Not Null |
In | In ("", "", "-") | , |
Like | Like "*" Like "db??" | , ( Like "*" "?") |
Like. "*" , "?" , Like "*" True "", "", "". "dbl" "dbl00" Like "db??" False, "dbl0" "dbXX" True. "*" "?" . :
- Like "*ms*.?*" True , "ms", ( , ) , (.);
- Like "?1???*" True , , "1".
Access , . , ( } , . ( ), ( ) ( "!" ".").
: SQL , Access "!", . "!" ".".
, , .
|
|
. Visual Basic (VBA). , Access , .
Access : , .
- , , , (+) (-), (.) , , () (). (+) .
: 12345; -12.345; -6.76-23.
- , Chr$ (), . Chr$ (} ANSI, Windows. , , , , "@", "~" . ., , <>, , <Enter> . . , , Access , .
:
Chr$(9) & "" & Chr${10)& Chr$(13)& " "
Chr$ (9) <Tab>; Chr$ (10), ; Chr$(13), . .
- / Access #. , Access, .
: #26/04/75#, #22--74#, #10:35:30#.
, , . , , , NOW () . , . , . .
Access ( , , (Expression Builder)).
- VBA.
- . , str (), val ().
- : , , , , . , CurrentDB () Database, Access .
- . , DateDiff , Date () .
- (DDE) Windows (OLE) (, DDE() DDESendO) . , OLE, Microsoft Office, GetObject () CreateObject (), .
- SQL . SQL , . VBA , , SQL Recordset.
SQL, , , .
|
|
SQL stDev(), DStDevf). .
- , , . , Error () . , , , , .
- Microsoft Excel . , Rate () , .
- VBA . , Commando , VBA.
- / , /. inputBox () Dir ().
- , " ...?". , IsNumericf() True, , False ; IsObject() True, OLE Automation, False .
- . .
- IIf (Expr, Truepart, Falsepart) Truepart, True, Falsepart, False. , , Truepart, Falsepart. , IIf (). , , , , , , .
- Choose () , . Switch () , , True.
- Choose () Switch() Select Case VBA Basic.
- ( ) , Log () Sin ().
- . , Trim() , , .
|
|