UPN_ST 3 : , , , 1-1.
( )
1.
2.
3.
/
A)
1. : , , //, , ( )
a. 3-
b. 2-
c.
d. , . ; /. , .
.
/ . , ,
:
i.
ii. Shift F2
iii.
( )
4.
:
a. ( / )
b. ( )
i. , , ( 3 ). )
ii. . / .
iii. :
1.
2. Sum
. , . :
1. ,
2. ,
3.
4. .
Access 2000 .
: , ( )
, . , , . .
, 1- 20%
|
|
.
1. , ,
2. . , .
3. , . . .
, .
, 4- . , / /, . . .
9.3 . .
, ( )
. .
.
:
!!! ( )
/
B)
. Microsoft Access.
: 7 . , , . . , , Excel.
1. . :, , \ , ,, .
2. _
. : , . , , , . , , , - . - /
3. :
i.
ii. _
iii.
|
|
4. _ . .
5. , .
i.
ii. VBA ( Visual Basic for Application): -
iii.
"[]=" & Me![1]
& "and" & "[]=" & "'" & Me![] & "'"
. - stLinkCriteria = "[]=" & Me![1] & "and" & "[]=" & "'" & Me![] & "'"
C)
1
2.
D)
1. -
E)
1. Autoexec .