Access
, . .
- . . . (, 09, .)
- Access (, ), ( ). , [Household Inventory] Household Inventory . , Visual Basic (VBA), . , : True, False, Yes, No Null.
: , . , , Access.
- . , - . , Date (), , .
- (+, -, *, /) . Basic. Access SQL, Between Like. , .
Access : , , , , .
, , , , . , , .
. 1 Access.
1.
+ | [] + [] | |
- | Date () - 7 | |
- () | -12345 | |
* | [] * [ ] | |
/ | [] / 12.55 | |
\ | [] \ 2 | . , |
Mod | [] Mod 12 | . , 15 Mod 12 3 |
^ | ^ [] |
|
|
(=), .
, (=). , =Now() , . , = , , .
(True False), . , , VBA. . 2 Access.
2.
< | 1 < 100 | True | |
<= | 1 <= 1 | True | |
= | 1 = 100 | False | |
>= | 100 >= 1 | True | |
> | 100 > 100 | False | |
<> | 1 <> 100 | True |
() :
- And ( );
- Or ( );
- Not ;
- ;
- Eqv ;
- Imp .
, True, False Null. . , Not .
. 3-5 Access .
3.
A=True B=False | A=True B=True | A=False B=False | A=False B=True | |
A And | False | True | False | False |
A Or | True | True | False | True |
Not A | False | False | True | True |
True | False | False | True | |
A Eqv | False | True | True | False |
A Imp | False | True | True | True |
, Imp, Null Null.
4. Imp Null-
A=Null B=False | A=Null B=True | A=False B=Null | A=True B=Null | A=Null B=Null | |
A Imp | Null | True | True | Null | Null |
, , (True, False, Null), - (. 5).
5.
=1 =0 | 6=1 =1 | =0 =0 | =0 =1 | |
A And | ||||
A Or | ||||
Not A | ||||
A Eqv | ||||
A Imp |
|
|
()
SQL, (&), , (+), : . (+) , .
: "Visual" & "Basic" "Visual Basic". , : "VisualBasic".
( "!"), ( "."):
- !
- !.
- !.()
- .
- .().
, , .
:
- Forms!, Tables! ;
- MyTextbox.Caption = " !" MyTextbox , a Caption ;
- ! [ ] " " (CustomerlD) "" (Customers).
(, , Caption ).