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

UptoLike


|¯ÈÓÒËÓÒ«Ë㺰Óº°Ò°ÈÓÈmãÒmÈ¯ËÎÒä©}È°}ÈÓº
º ºÓºmãËÓÒ« Ò}È°}ÈÓºº ÈãËÓÒ« °m«ÏÈÓÓ©²¹ºãË®°ÓºË
ºÓºmãËÓÒËºÏÓÈÈËº¹¯ÒÒÏäËÓËÓÒÒËmºº¹ºã«ãÈmÓº®
ÈãÒ©ËÎËÏÓÈËÓÒ«¹ºãÈmÓËÓÒËÒ°m«ÏÈÓÓ©²ÏÈ
¹Ò°Ë® ºË¯ÓË® ÈãÒ© zÈ°}ÈÓºË ÈãËÓÒË °m«ÏÈÓÓ©² ¹ºãË®
ºÏÓÈÈËº¹¯ÒÈãËÓÒÒÏȹҰÒmãÈmÓº®ÈãÒËÈã«°«Ò
Ë°m«ÏÈÓÓ©ËÏȹҰÒm¹ºÒÓËÓÓº®ÈãÒË
Ë}°ã«ÎË°Ë°mË®ÈãÒ©äºÎÓº°ºÏÈ ÒÓ
°¯}ÒË®
&5($7( ,1'(;

ÒÏäËÓÒ ÈãÒäºÎÓºÒÓ°¯}Ò
Ë®
$/7(5 7$%/(
jÓ°¯}Ò«
'523
Èã«Ë °Ë°m
ÈãÒ ÒÏ ÈÏ© ÈÓÓ©² ÒãÒ Èã«Ë °Ë°mÒ® ÒÓË}° ÒÏ
ÈãÒ©
'523^7$%/(lZ[ebpZ!_,1'(;bg^_dk!21lZ[ebpZ!`
¯ËÎËËäÈãÒ ÈãÒÒãÒÈãÒ ÒÏÓËËÒÓË}°ÓË
º²ºÒäºËËÏÈ}¯©z¯ºäËººã«ÈãËÓÒ«ÒÓË}°ÈÒÏÈ
ãÒ©äºÎÓºÒ°¹ºãϺmÈ ÒÓ°¯}Ò
$/7(57$%/(
~ȹ¯º°ÓÈ°ºÏÈÓÒËÈãÒ©ÒÏ¯Ò²ÈãÒ
È°º¯ËË°«°ºÏÈ ÈãÒ°ºÏÓÈËÓÒ«äÒm©¯ÈÓÓ©
äÒÒÏºÓº®ÒãÒÓË°}ºã²ÈãÒÈ}ÒËË®°mÒ«äºÎÓº¹¯º
ÒÏmË°Ò ° ¹ºäº Ïȹ¯º°È ÓÈ °ºÏÈÓÒË ÈãÒ© ÒÓ°¯}Ò«
6(/(&7«,172
jÓ°¯}Ò«m¹¯º°ˮˮÁº¯äËÒäËË
6(/(&7ihe_B!>ihe_B!>@@,172
gh\ZyLZ[ebpZ!>,1\g_rgyy;ZaZ>Zgguo!@
)520bklhqgbd!
jÓ°¯}Ò« °ºÏÈË Óºm ÈãÒ ° ÒäËÓËä
gh\ZyLZ[
ebpZ
!p°ãÒÈãÒÈ °È}ÒäÒäËÓËäÎË°Ë°mË $FFHVV ÏÈ
¹¯ÈÒmÈË¹ºm˯ÎËÓÒË ÓÈ ËË ÈãËÓÒË { Óºm ÈãÒ }º
¹Ò¯°« ¹ºã« ° ÒäËÓÈäÒ
ihe_B
!
ihe_B
!è vºã© Óº
® ÈãÒ© ¹ºãÈ ²È¯È}˯ҰÒ}Ò Ò¹ºm ÈÓÓ©² °ºãºm
}ÈÏÈÓÓ©²m°¹Ò°}Ë¹ºãË®|°ÈãÓ©ËȯäËÓ©
\g_rgyy;Z
aZ>Zgguo
! Ü ¹ } mÓËÓË® ÈÏË ÈÓÓ©²
bklhqgbd
! Ü Ò°
ºÓÒ} ÒÏ }ºº¯ºº ºÒ¯È°« ÏȹҰÒ wº äºÎË © ºÓÈ
ÈãÒÈÓË°}ºã}ºÈãÒ ÒãÒÏȹ¯º°
{ºËäËÏȹ¯º°ÓÈ°ºÏÈÓÒËÈãÒ©ÒäËËËÎËȯ
äËÓ© º Ò Ïȹ¯º° ÓÈ m©º¯} sȹ¯Òä˯ °ºÏÈÒä Óºm
     |¯ÈÓÒËÓÒ«Ë㺰ˆÓº°ˆÒ‚°ˆÈÓÈmãÒmÈ ˆ¯ËÎÒä©}È°}ÈÓº
º º­ÓºmãËÓÒ« Ò }È°}ÈÓºº ‚ÈãËÓÒ« °m«ÏÈÓÓ©² ¹ºãË® zÈ°}ÈÓºË
º­ÓºmãËÓÒ˺ÏÓÈÈˈˆº¹¯ÒÒÏäËÓËÓÒÒ}ã Ëmºº¹ºã«ãÈmÓº®
ˆÈ­ãÒ©ˆËÎËÏÓÈËÓÒ«¹ºã‚È ˆmÓË ÓÒË}ã Ò°m«ÏÈÓÓ©²ÏÈ
¹Ò°Ë® º˯ÓË® ˆÈ­ãÒ© zÈ°}ÈÓºË ‚ÈãËÓÒË °m«ÏÈÓÓ©² ¹ºãË®
ºÏÓÈÈˈˆº¹¯Ò‚ÈãËÓÒÒÏȹҰÒmãÈmÓº®ˆÈ­ãÒË‚Èã« ˆ°«Ò
m°Ë°m«ÏÈÓÓ©ËÏȹҰÒm¹ºÒÓËÓÓº®ˆÈ­ãÒË
     jÓË}°ã«‚ÎË°‚Ë°ˆm‚ Ë®ˆÈ­ãÒ©äºÎÓº°ºÏȈ ÒÓ
°ˆ¯‚}ÒË®&5($7( ,1'(;ÒÏäËÓ҈ ˆÈ­ãÒ‚äºÎÓºÒÓ°ˆ¯‚}Ò
Ë® $/7(5 7$%/( jÓ°ˆ¯‚}Ò« '523 ‚Èã«Ëˆ °‚Ë°ˆm‚ ‚
ˆÈ­ãÒ‚ ÒÏ ­ÈÏ© ÈÓÓ©² ÒãÒ ‚Èã«Ëˆ °‚Ë°ˆm‚ Ò® ÒÓË}° ÒÏ
ˆÈ­ãÒ©
'523^7$%/(lZ[ebpZ!_,1'(;bg^_dk!21lZ[ebpZ!`
     ¯ËÎËËä‚Èã҈ ˆÈ­ãÒ‚ÒãÒ‚Èã҈ ÒÏÓËËÒÓË}°ÓË
º­²ºÒäº ËË ÏÈ}¯©ˆ  z¯ºäË ˆºº ã« ‚ÈãËÓÒ« ÒÓË}°È ÒÏ ˆÈ­
ãÒ©äºÎÓºÒ°¹ºã ϺmȈ ÒÓ°ˆ¯‚}Ò $/7(57$%/(

       ~ȹ¯º°ÓÈ°ºÏÈÓÒˈȭãÒ©Òϯ‚Ò²ˆÈ­ãÒ

      È°ˆºˆ¯Ë­‚ˈ°«°ºÏȈ ˆÈ­ãÒ‚°ºÏÓÈËÓÒ«äÒm©­¯ÈÓÓ©
äÒÒϺӺ®ÒãÒÓË°}ºã }Ò²ˆÈ­ãÒ‘È}ÒËË®°ˆmÒ«äºÎÓº¹¯º
ÒÏmË°ˆÒ ° ¹ºäº  Ïȹ¯º°È ÓÈ °ºÏÈÓÒË ˆÈ­ãÒ© ÒÓ°ˆ¯‚}Ò«
6(/(&7«,172 jÓ°ˆ¯‚}Ò«m¹¯º°ˆË® Ë®Áº¯äËÒäËˈmÒ
6(/(&7ihe_B!>ihe_B!>@@,172
          gh\ZyLZ[ebpZ!>,1\g_rgyy;ZaZ>Zgguo!@
)520bklhqgbd!
      jÓ°ˆ¯‚}Ò« °ºÏÈˈ Óºm‚ ˆÈ­ãÒ‚ ° ÒäËÓËä gh\ZyLZ[
ebpZ! p°ãÒ ˆÈ­ãÒÈ ° ˆÈ}Òä ÒäËÓËä ‚ÎË °‚Ë°ˆm‚ˈ $FFHVV ÏÈ
¹¯È ÒmÈˈ ¹ºˆm˯ÎËÓÒË ÓÈ ËË ‚ÈãËÓÒË { Óºm‚ ˆÈ­ãÒ‚ }º
¹Ò¯‚ ˆ°« ¹ºã« ° ÒäËÓÈäÒ ihe_B! ihe_B!è vˆºã­© Óº
mº® ˆÈ­ãÒ© ¹ºã‚È ˆ ²È¯È}ˆË¯Ò°ˆÒ}Ò ˆÒ¹ºm ÈÓÓ©² °ˆºã­ºm
‚}ÈÏÈÓÓ©²m°¹Ò°}˹ºãË®|°ˆÈã Ó©Ëȯ‚äËӈ©\g_rgyy;Z
aZ>Zgguo! Ü ¹‚ˆ } mÓË ÓË® ­ÈÏË ÈÓÓ©² bklhqgbd! Ü Ò°
ˆºÓÒ} ÒÏ }ºˆº¯ºº ºˆ­Ò¯È ˆ°« ÏȹҰÒ  wˆº äºÎˈ ­©ˆ ºÓÈ
ˆÈ­ãÒÈÓË°}ºã }ºˆÈ­ãÒ ÒãÒÏȹ¯º°
      { º­Ëä mÒËÏȹ¯º°ÓÈ°ºÏÈÓÒˈȭãÒ©ÒäËˈˆËÎËȯ
‚äËӈ© ˆº Ò Ïȹ¯º° ÓÈ m©­º¯}‚ sȹ¯Òä˯ °ºÏÈÒä Óºm‚