5
8. !!
! Visual Basic………………………………………… 353
8.1 & ………………………………… 353
8.2 ' ()
A Visual Basic…….……………………………… 355
8.3 ! % !…………………………….. 361
8.4 ! !……………………………… 365
8.4.1 H .............................................................................. 365
8.4.2 +! – …………………………………………. 368
8.4.3 J!
! # ..................................................... 371
8.4.4 ! #!...................................... 374
8.5 ! B ………………………………… 377
8.6 * (#),
, …………….….. 388
8.7 $! # ………………………………….. 398
8.7.1 <# , ! 399
8.7.2 ............................................................................ 405
8.7.3 * , ! ……………………………. 407
8.8 ………………………………………………………. 421
9. *! MS Access………………………….. 431
9.1 $#! *+O@.................... 431
9.2 *! ...................................................................... 435
9.2.1 "...................................................................................... 440
9.2.2 H .......................................................................... 449
9.2.3
........................................................................................ 456
9.2.4 ........................................................................................... 471
9.2.5 B ................................................ 478
9.3 * .................................................................... 485
. 10. ! Visual Basic !
Microsoft Office ..................................................................... 490
10.1 <!
Microsoft Word VBA................................................ 491
10.2 <! ! Microsoft Excel
VBA.............................................................................. 503
10.2.1 *! ! ..... 505
10.2.2 !
% #
! ! ........................................................ 510
10.2.3 ) ! : #
# .............................................................. 517.
* .................................................................................................. 531
@ <.............................................................................................................. 551
@ O.............................................................................................................. 555
@ .............................................................................................................. 560