3
:
:
1. .
2. .
3. .
:
1. ?
2. ?
3. ?
4. ?
5. ?
6. ?
7. ?
8. ?
9. ?
10. ?
11. ?
, . .
, . , . MS Access . , MS Access , .
MS Access .
, . : .
1. , :
1. .
2. .
3. (. 2.118), , .
4. . , . , . (. 2.119).
5. , . . , (. 2.120).
6. ( ) ( ). .
7. , , * (. 2.120), . , .
8. , , , . :
|
|
, , ;
;
;
;
.
, . , , .
(. 2.121). MS Access , Enter.
, , : (<), (>=), (<>).
1 (). < 2000 (. 2.122).
. , . , 2000 (. 2.123). . 2.124 , .
And Or
, And Or.
, , MS Access And. , , , .
, MS Access Or. , , , .
Between, In Like
, MS Access , .
Between .
: Between 10 and 20. , >=10 and <=20.
In .
: In (WA, CA, ID) , WA Or CA Or ID.
Like , . :
? ;
* ;
# , ;
! .
.
: [0-9] , , [-] , [!0-9] , 0 9.
2. , 2000 , (. 2.125):
1. .
2. .
3. .
4. >2000.
5. Like *.
6. , 2000. .
|
|
. 2.126.