, , . 14 , , , . , .
. 15.1. . , . , Access ,
, . , .
, , , . , .
1. → →.
. .
, (). , (. 15.1). .
.15.2. (), , . , ,
2. .
Access , . , , . 15.2. (nble).
, Access . (. . " " ) , Access .
. 15.3. , . , ( , ). , , , , . ,
3. (. 15.3) .
|
|
. (nble) ,
Access, . .
(nble) .
o , . . .
o . , , . . (, , , .)
o , . (Edit) , (Read Only) (Add) . .
, , (Command Builder wizard). , , , . .
4. , .
(, , " Products"). . , , , .
5. 24 .
. ( Access 999 .) , Access , .
(GoToRecord). , .
( , 3, ). (Record) (Offset) , .
( (Previous)), ( (Next)), ( (New)), ( (Go To)), ( (First)) , , ( (Last)). , , , 5, 5- .
|
|
. (GoToRecord). , , , , . , .
, ? (MsgBox), . (Message). , , : " ". ( (Title)), ( () ) ( ()).
. , ; . . Access .
6. <Ctrl>+<S> .
ShowTheLastProduct ( ). , Access .
. , , . (Tables and Related Views), Access , (Unrelated Objects).
, . , . , .
, , . Access .
■ . . , .
, | → → (Macro Tools | Design → Tools →Run).
, , . → → (Database Tools → Macro → Run Macro). .
, , , <Ctrl>+<F>. , , . " " .
. , . . " " .
|
|
. 15.4. ShowTheLastProduct. Access Products ( , ) , , ,
■ . . . . " " .
. | → → , . 15.4 .
, . , .
, , . , , . 15.5.
. 15.5. ,
, , , . , , . 15.5, - (. . ) - ( ), . , , , .
, , , , Access , , . , , .
. 1. .
. , , , .
2. | → → (Macro Tools | Design → Tools → Single Step).
(Single Step) -, . . . , . ( , , , . , .)
3. | → → .
. . Access . . 15.6 , .
|
|
. 15.6. , , ProblematicMacro. , . ( , )
4. , , : , .
□ . , Access . . , , . 15.7.
□ . , , .
. 15.7. , . Access ( , Microsoft), . ,
□ . "" , , Access . , . , .
, , . , . , , .