4.
: ; .
:
.
.
3. .
4. .
, , , . . .
( , , ) Access , . , : , . , . Access . , Access , .
, . . , , , .
.1. . . , . QBE (Query By Example ), . , . , ( , ), , Microsoft Access.
, , . , , .
|
|
/ , Access , . .
. , .
. 1.
. .1. , 4 5 .
, . . . . .
, ( QBE), *, . , QBE. * QBE. , , . , , .
, , , . / ( ).
. , ( , ), .
. , , . , cess AND , . , , AND. , AND , ; .
, OR, , . OR . , OR. : . .
|
|
, . , , .
AND OR
|
|
< > 4
.
Between , :
between 10 and 20
I n . :
in (,,)
Like , :
* ( ) ;
? ;
# .
: ,
like *
, #. :
#10 1998#
>#31.12.96#
Access , , :
Day() 1 31
Month() 1 12
Year() 100 9999
. , , . , . .2, , , . , .2,. .2,. , ( 2), .
)
) )
.2. .
1
1. + .
2. , ... , , , , . .
3. , ... .
4. , () 5 .
5. , .
, Access. , , . , *.
Access :
+ .
- .
* .
/ .
\ . .
|
|
^ , .
MOD , .
& . , .
. 3 . : , , .
. 3.
( ), QBE . Access , . , . , , . .
Access , . , .
Access:
Sum .
Avg .
Min , .
Max , .
Count , Null.
StDev .
Var .
First .
Last .
.4 Sum. , .
. 4. Sum
2
- + .
- , , () ().
- , ( ), , .
- , .
- , .
- , .