Работа с базами данных в среде Microsoft Access 2002. Горбаченко В.И - 27 стр.

UptoLike


ÈãÒ© vp{kpl|ve Ò ijv¡jjsk ~È}¯ºËä ÒÈ㺺
Ë º}Óº Ëã}Óm ÓÈ }Óº¹}Ë
~È}¯©
 iºÈmãËÓÓ©Ë ÈãÒ©
¹º«m«°« m º}ÓË zºÓ°¯}º¯È Ïȹ¯º°ºm º°¯Ë°mºä }ºäÈÓ©
iºÈmÒ ÈãÒ
ÒÏäËÓ
~ȹ¯º°
äºÎÓº°ÓºmÈº}¯© ÒÈ㺺
Ëº}Óº
iºÈmãËÓÒËÈãÒ©
Ò¹º¹ºãÓÒ °¹Ò°º}ÈãÒ Ïȹ¯º
°È
|}Óº zºÓ°¯}º¯È Ïȹ¯º°ºm ¯ÈÏËãËÓº ÓÈ mË È°Ò {
m˯²ÓË® ¹ºãºmÒÓË ÓȲº«°« º}ÓÈ ÈãÒ °º °¹Ò°}ÈäÒ ¹ºãË®
«}Èκ® ÈãÒ©ºº¯ÈÎÈË°«m°¯º}ËÏȺãºm}ÈÈ}ººº}
ÓÈ¯Ò°º°ÈmãËÓÒÒÏȹ¯º°ÈÓÈº°ÓºmËÓË°}ºã²ÈãÒ äËÎ
ÓÒäÒÓ˺²ºÒäº°ÈÓºmÒ °m«ÏÒÏÈÈmºÓºËÓÒ«äËÎ¹º
ã«äÒ { ¹¯ºÒmÓºä°ãÈË ¯ËÏãÈm©¹ºãÓËÓÒ« Ïȹ¯º°ÈäºÎË
º}ÈÏÈ°«ÓË}º¯¯Ë}Ó©ä{¯È°°äÈ¯ÒmÈËäºä¹¯Òä˯ËºÓºËÓÒ«
äËÎ ÈãÒÈäÒ ÎË ÏÈÈÓ© ¹ºªºä ¹¯Ò ºÈmãËÓÒÒ ÈãÒ
ºÓÒ¹º«mã«°«mº}ÓËÓ°¯}º¯È Ë°Ë°º°m«Ï«äÒ
sÒÎÓ«« ¹ºãºmÒÓÈ zºÓ°¯}º¯È Ïȹ¯º°ºm ¹¯Ë°Èmã«Ë °º
º®ãÈÓ}Ïȹ¯º°Èm}ºº¯ºä°º°mËÓÓºÒ¹¯ºÒÏmºÒ°«˺¹º
°¯ºËÓÒËiÈãÓË® ¯ÈϯÈº}Ïȹ¯º°È¯Ë}ºäËÓË°«m©¹ºã
Ó« m°ãËË®¹º°ã˺mÈËãÓº°Ò
x
ºÈmãËÓÒË¹ºãË®mÏȹ¯º°
x
°ÈÓºm}È}¯Ò˯ÒËmºº¯ÈÏȹҰˮ
x
°º¯Ò¯ºm}ÈÏȹҰˮ
iºÈmÒ ÓÎÓ©Ë¹ºã«mãÈÓ}Ïȹ¯º°ÈäºÎÓº¹Ëä¹Ë¯Ë
È°}ÒmÈÓÒ« Ò² ÒäËÓ ÒÏ °¹Ò°}È ¹ºãË® ÈãÒ ÓȲº«Ò²°« m
m˯²ÓË® È°Ò º}ÓÈ zºÓ°¯}º¯È m °¯º} ãÈÓ}È
ºãË
 pË
ºÒÓ°¹º°ººÈmãËÓÒ«Ü ®Óº®Ëãº}¹ºÒäËÓÒ¹ºã«
˯m©ä¹ºäË°Òäm°¯º}
ºãË
¹ºãËnÈäÒãÒ« ÈãÒ©
vips°ã˺äÏÈÓÒäÜ ¹ºãË¯¹¹È ÒÏº®ÎËÈãÒ©jÏ
ÈãÒ© ijv¡jjsk ¹Ë¯ËÓË°Ëä m ãÈÓ}Ïȹ¯º°È ¹ºãË sÈ
ÏmÈÓÒË Ò ÓÈ}ºÓË Ü ¹ºãË |ËÓ ÒÏ ÈãÒ©
vp{kpl|ve
«ÈãËÓÒ«¹ºã«ÒÏãÈÓ}È Ïȹ¯º°È°ãËËºäËÒ }º
ãºÓ}m}ºº¯º®ºÓºÓȲºÒ°«ÒÓÈÎÈ }ãÈmÒ
'HO
ÒãÒm©
¹ºãÓÒ }ºäÈÓ
ÈãÒ °ºã©
ÒÏäËÓ
¯Èm}È
º©È
ãÒ ÒÏÏȹ¯º°ÈÈãÒÓȺ°ÓÈÈãÈºäËÒ ËËmm˯²ÓË®È°
ÒÓ°¯}º¯È Ïȹ¯º°ºmm©¹ºãÓÒmËãº}ÓÈÒäËÓÒãººÒÏ
ËË¹ºãË®ÈÏÈËäÓÈÎÈ }ãÈmÒ
'HO
ÒãÒm©ÏmÈ }ºäÈÓ
È
ãÒ
ÒÏäËÓ
¯Èm}È
º°ãËªººÈmºäÈÒË°}ÒÈãËÓ©
ˆÈ­ãÒ© vp{kpl|v‘e Ò ijv¡jjsk ~È}¯ºËä ÒÈ㺺
mºË º}Óº Ëã}ӂm ÓÈ }Óº¹}Ë ~È}¯©ˆ  iº­ÈmãËÓÓ©Ë ˆÈ­ãÒ©
¹º«m«ˆ°« m º}ÓË zºÓ°ˆ¯‚}ˆº¯È Ïȹ¯º°ºm º°¯Ë°ˆmºä }ºäÈÓ©
iº­Èm҈ ˆÈ­ãÒ‚ ÒÏäËÓ ~ȹ¯º° äºÎÓº°ÓºmȺˆ}¯©ˆ ÒÈ㺺
mºËº}Óºiº­ÈmãËÓÒˈȭãÒ© Ò¹º¹ºãÓ҈ °¹Ò°º}ˆÈ­ãÒ Ïȹ¯º
°È
      |}Óº zºÓ°ˆ¯‚}ˆº¯È Ïȹ¯º°ºm ¯ÈÏËãËÓº ÓÈ mË È°ˆÒ {
m˯²ÓË® ¹ºãºmÒÓË ÓȲº«ˆ°« º}ÓÈ ˆÈ­ãÒ °º °¹Ò°}ÈäÒ ¹ºãË®
jä«}Èκ® ˆÈ­ãÒ©ºˆº­¯ÈÎÈˈ°«m°ˆ¯º}ËÏȺãºm}ȈÈ}ººº}
Óȁ¯Ò°º°ˆÈmãËÓÒÒÏȹ¯º°ÈÓȺ°ÓºmËÓË°}ºã }Ò²ˆÈ­ãÒ äË΂
ÓÒäÒ Ó˺­²ºÒäº ‚°ˆÈÓºm҈ °m«ÏÒ ÏÈÈm ºˆÓº ËÓÒ« äË΂¹º
ã«äÒ { ¹¯ºˆÒmÓºä °ã‚ÈË ¯Ëς㠈Ȉ m©¹ºãÓËÓÒ« Ïȹ¯º°È äºÎˈ
º}ÈÏȈ °«ÓË}º¯¯Ë}ˆÓ©ä{¯È°°äȈ¯ÒmÈËäºä¹¯Òä˯˺ˆÓº ËÓÒ«
äË΂ ˆÈ­ãÒÈäÒ ‚ÎË ÏÈÈÓ© ¹ºªˆºä‚ ¹¯Ò º­ÈmãËÓÒÒ ˆÈ­ãÒ
ºÓÒ¹º«mã« ˆ°«mº}ÓËzºÓ°ˆ¯‚}ˆº¯È mäË°ˆË°º°m«Ï«äÒ
      sÒÎÓ«« ¹ºãºmÒÓÈ zºÓ°ˆ¯‚}ˆº¯È Ïȹ¯º°ºm ¹¯Ë°ˆÈmã«Ëˆ °º
­º®­ãÈÓ}Ïȹ¯º°Èm}ºˆº¯ºä°º­°ˆmËÓÓºÒ¹¯ºÒÏmº҈°«Ëº¹º
°ˆ¯ºËÓÒËiÈã ÓË® ‚ ¯Èϯȭºˆ}‚Ïȹ¯º°È¯Ë}ºäËÓ‚ˈ°«m©¹ºã
Ó«ˆ m°ãË‚ Ë®¹º°ã˺mȈËã Óº°ˆÒ
     x    º­ÈmãËÓÒ˹ºãË®mÏȹ¯º°
     x    ‚°ˆÈÓºm}È}¯ÒˆË¯ÒËmºˆ­º¯ÈÏȹҰˮ
     x    °º¯ˆÒ¯ºm}ÈÏȹҰˮ
     iº­Èm҈ ӂÎө˹ºã«m­ãÈÓ}Ïȹ¯º°ÈäºÎÓº¹‚ˆËä¹Ë¯Ë
ˆÈ°}ÒmÈÓÒ« Ò² ÒäËÓ ÒÏ °¹Ò°}È ¹ºãË® ˆÈ­ãÒ ÓȲº«Ò²°« m
m˯²ÓË® È°ˆÒ º}ÓÈ zºÓ°ˆ¯‚}ˆº¯È m °ˆ¯º}‚ ­ãÈÓ}È  ºãË pË
ºÒÓ°¹º°º­º­ÈmãËÓÒ«Ü mº®Óº®Ëãº}¹ºÒäËÓÒ¹ºã«
     Ë¯m©ä¹ºäË°ˆÒäm°ˆ¯º}‚ºãË ¹ºãËnÈäÒãÒ« ˆÈ­ãÒ©
v‘ips‘°ã˺äÏÈÓÒäÜ ¹ºãË€¯‚¹¹È Òψº®ÎˈȭãÒ©jÏ
ˆÈ­ãÒ© ijv¡jjsk ¹Ë¯ËÓË°Ëä m ­ãÈÓ} Ïȹ¯º°È ¹ºãË  sÈ
ÏmÈÓÒË       Ò ÓÈ}ºÓË Ü ¹ºãË  |ËÓ}È             ÒÏ ˆÈ­ãÒ©
vp{kpl|v‘e
     iã« ‚ÈãËÓÒ« ¹ºã« ÒÏ ­ãÈÓ}È Ïȹ¯º°È °ãË‚ˈ ºˆäˈ҈ }º
ãºÓ}‚ m }ºˆº¯º® ºÓº ÓȲº҈°« Ò ÓÈÎȈ }ãÈmÒ ‚'HO ÒãÒm©
¹ºãÓ҈ }ºäÈÓ‚Èã҈ °ˆºã­©ÒÏäËÓ           ¯Èm}È ˆº­©‚È
ã҈ ÒÏÏȹ¯º°ÈˆÈ­ãÒ‚ÓȺ°ÓÈÈãȺˆäˈ҈ ËËmm˯²ÓˮȰ
ˆÒzºÓ°ˆ¯‚}ˆº¯È Ïȹ¯º°ºmm©¹ºãÓÒmËãº}ÓÈÒäËÓÒã ­ººÒÏ
Ë˹ºãË®ÈÏȈËäÓÈÎȈ }ãÈmÒ ‚'HO ÒãÒm©ÏmȈ }ºäÈÓ‚È
ã҈ ÒÏäËÓ ¯Èm}ȁº°ã˪ˆºº­‚‚ˆÈmˆºäȈÒË°}Ò‚ÈãËÓ©