.


:




:

































 

 

 

 





7.1. . . , , , .

" " . , . ; . - , , ( 13), , : [] / [].

, [Shift] + [ F2 ], . . " ".

7.2. , . .

( ) .

1) " " . .

2) , - .

3) .

4) :. Count ( 14), , .

 

13. MS Access

+ [] + []
- Date() - 7
* [] * [ ]
/ [] / 12.55
\ [] \ 2 . ,
Mod [] Mod 12 . , 15 Mod 12 3
^ ^ () []
< 1 < 100
<= 1 <= 1
= 1 = 100
>= 100 >= 1
> 100 > 100
<> 1 < > 100
And   ( )
Or   ( )
Not  
Eqv  

 

14. MS Access

Avg() , "", " Memo" " OLE" ,
Count()
Max() , "", " Memo" " OLE"
Min() , "", " Memo" " OLE"
Sum() , "", " Memo" " OLE"

 

5) ( ). ; , 3 [ Enter ], OK.

6) " " . .

7) , - .

8) .

9) :. Sum ( 14), .

10) . ; , 3 [ Enter ].

11) , , " " . ; .

12) : :Count([])

: :Sum([])

13) . ; , 3 [ Enter ]. , Access.

14) .

 





:


: 2016-10-06; !; : 522 |


:

:

.
==> ...

1733 - | 1527 -


© 2015-2024 lektsii.org - -

: 0.012 .