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

UptoLike


i¯º® °¹º°º °ÈÓºm}Ò ¹Ë¯mÒÓºº ÈÜ m©¯È }ºäÈÓ
ËmºË¹ºãË
ÒÏäËÓ
¯Èm}È
p°ãÒ°º°ÈmÓº® m}ãÈË
ÓË°}ºã}º ¹ºãË® º mÓÈÈãË Ó˺²ºÒäº ËãÒ ªÒ ¹ºã«
˯ÎÒmÈ«ÓÈÎÈº®}ãÈmÒ
&WUO
ÈÏÈËäÓÈÎÈ ÓÈ¹ÈÓËãÒÒÓ
°¯äËÓºm}Óº¹}°ÒϺ¯ÈÎËÓÒËäÈ
«ÓÈ˺¹¯Òä˯ÈmË°mË¹Ë¯mÒÓ©²Ë®ÏÈÈÒä
¹ºã«Ë}È ÈãÒ©vips Ò Ò°Ò¹ãÒÓ© ÈãÒ
© ijv¡jjsk«ÈãÒ©vp{kpl|ve ¹Ë¯mÒ
Ó©®Ë°º°º« ÒÏm²¹ºãË®Ë}È Ò Ò°Ò¹
ãÒÓ©vãËËº¯ÈÒ mÓÒäÈÓÒËÓÈººÏÓÈËÓÒ«ªÒ²¹ºãË®
ÏË° ÓË«mã«°«ÓÒ}ÈãÓ©äÒºÒÓÒºÎË°ËÓ°ÈËª}
ÏÈäËÓ©¹ºäÓºÒäÒ°Ò¹ãÒÓÈääÓºÒË°ËÓ©°Èª}ÏÈäËÓ
¹ººÓº®Òº®ÎËÒ°Ò¹ãÒÓËºªºä¹Ë¯Ë Ëä}ÏÈÈ
°º°ÈmÓº®}ÈÎËä}ÈκºÒÏÓÒ²ã«°mº®°mÈ
Ë}°Ò
¯ºmÈÓÓºË¹ºãË
ÏÓÈËÓÒËiÈiº¹°}È°«°ºm¹ÈËÓÒ«
 vº²¯ÈÓÒ ¹¯ºË}ÈãÒ©
ºººmãËÓÓ©® ¹¯ºË} ÈãÒ© °ãËË °º²¯ÈÓÒ ¹º
°}ºã}ÓÈ˺º°ÓºmËË°¯ºÒ°««ÈãÒÈ«ªº®Ë
ãÒ°ãËËmº°¹ºãϺmÈ°«}ºäÈÓº®
vº²¯ÈÓÒ
äËÓ
nÈ®ã
p°
ãÒÈãÒÈ°º²¯ÈÓ«Ë°«¹Ë¯m©®¯ÈÏ$FFHVV m©mºÒÓÈª}¯ÈÓÒÈ
㺺mºËº}Óº
vº²¯ÈÓËÓÒË
{mËÒËÒä« ÈãÒ©ãÒÓº®ÓËºãËË
 °Òämºãºm ÒãÒ mº°¹ºãÏ®Ë° ÒäËÓËä ¹¯ËãÈÈËä©ä ¹¯º
¯Èä亮
|¯ËÈ}Ò¯ºmÈ ¹¯ºË}ÈãÒ©
¯ºË}ÈãÒ©äºÎÓºäºÒÁÒÒ¯ºmÈmÈ°Óº°Òº
Èmã« Èã«¹ºã«ÒãÒÒÏäËÓ« Ò²¹È¯ÈäË¯©¯ÒªºäË
Ò°¹¯ÈmãËÓÒ«m¹¯ºË}°ãËËmÓË°ÒºÓÈÈãÈÏȹºãÓËÓÒ«ÈÏ©
ÈÓÓ©² ¹º°}ºã} ¹º¹©}È ÒÏäËÓÒ ¹È¯ÈäË¯© ¹ºãË® Ïȹºã
ÓËÓÓº® ÈÏ© ÈÓÓ©² äºÎË¹ºmãË ÏÈ °ºº® ¹º˯ ÒãÒ Ò°}È
ÎËÓÒËÈÓÓ©²
«m°Èm}ÒÓºmºº¹ºã«ÓȺ°ÈÓºmÒ }¯°º¯ÓÈ°¯º}
¹¯ºË}È¹Ë¯Ë }ºº¯º®ºãÎÓÈ© mmËËÓÈÓºmÈ«°¯ºÒÓÈ
ÎÈ °ººmË°m }Óº¹}ÓÈ¹ÈÓËãÒÒÓ°¯äËÓºmÒãÒm©
ÏmÈ }ºäÈÓ
v¯º}Ò
ÒãÒ
ºãË¹º°ÈÓºmº}
ÒÏäËÓ
{°Èm
p°ãÒ ÒÏ ¹¯ºË}È ÈãÒ© Ó˺²ºÒäº ÈãÒ ¹ºãË  ÒãÒ
ÓË°}ºã}º ¹ºãË® º Ó˺²ºÒäº ºäËÒ °ººmË°m
°¯º}ÒãÒ°¯º}ÒÒm©¯È }ºäÈÓ
ÈãÒ °¯º}Ò
ÒÏäËÓ
¯Èm}È

i¯‚º® °¹º°º­ ‚°ˆÈÓºm}Ò ¹Ë¯mÒÓºº }ã È Ü m©­¯Èˆ }ºäÈÓ‚
zã ËmºË ¹ºãË ÒÏ äËÓ ¯Èm}È p°ãÒ }ã °º°ˆÈmÓº® m}ã Èˈ
ÓË°}ºã }º ¹ºãË®  ˆº mÓÈÈãË Ó˺­²ºÒäº m©Ëã҈ ªˆÒ ¹ºã«
 ‚˯ÎÒmÈ«ÓÈÎȈº®}ãÈmÒ ‚&WUO ÈÏȈËäÓÈÎȈ ÓȹÈÓËãÒÒÓ
°ˆ¯‚äËӈºm}Óº¹}‚°ÒϺ­¯ÈÎËÓÒËä}ã È
      iã«ÓÈ Ëº¹¯Òä˯Èm}ÈË°ˆm˹˯mÒÓ©²}ã Ë®ÏÈÈÒä
¹ºã«~Èˈ}È ˆÈ­ãÒ©v‘ips‘ Òzº Ò°Ò¹ãÒÓ© ˆÈ­ãÒ
© ijv¡jjski㫈ȭãÒ©vp{kpl|v‘e ¹Ë¯mÒ
Ó©®}ã ­‚ˈ°º°ˆº«ˆ ÒÏm‚²¹ºãË®~Èˈ}È Òzº Ò°Ò¹
ãÒÓ©vãË‚ˈº­¯ÈˆÒˆ mÓÒäÈÓÒËÓȈºˆºÏÓÈËÓÒ«ªˆÒ²¹ºãË®
ÏË° ÓË«mã« ˆ°«‚ÓÒ}Èã Ó©äÒ ºÒÓÒˆºˆÎË°ˆ‚Ëӈ°Èˈª}
ÏÈäËÓ©¹ºäÓºÒäÒ°Ò¹ãÒÓÈääÓºÒË°ˆ‚Ëӈ©°È ˆª}ÏÈäËÓ
¹º ºÓº® Ò ˆº® ÎË Ò°Ò¹ãÒÓË  ºªˆºä‚ ¹Ë¯Ë ˆËä }È} ÏÈȈ
°º°ˆÈmÓº®}ã ‚}ÈÎËä‚}ÈκºÒÏÓҲ㫰mº®°ˆmÈjÓË}°Ò
¯ºmÈÓӺ˹ºãË ÏÓÈËÓÒËiÈ iº¹‚°}È ˆ°«°ºm¹ÈËÓÒ« 
           vº²¯ÈÓ҈ ¹¯ºË}ˆˆÈ­ãÒ©
      ººˆºmãËÓÓ©® ¹¯ºË}ˆ ˆÈ­ãÒ© °ãË‚ˈ °º²¯ÈÓ҈  ¹º
°}ºã }‚ÓÈ˺º°ÓºmË­‚ˈ°ˆ¯ºÒˆ °«m°«ˆÈ­ãÒÈi㫪ˆº®Ë
ãÒ°ãË‚ˈmº°¹ºã ϺmȈ °«}ºäÈÓº®vº²¯ÈÓ҈ äËÓ nÈ®ãp°
ã҈ȭãÒÈ°º²¯Èӫˈ°«¹Ë¯m©®¯ÈÏ$FFHVV m©mº҈ÓȪ}¯ÈÓÒÈ
㺺mºËº}Óºvº²¯ÈÓËÓÒË{mË҈ËÒä« ˆÈ­ãÒ© ãÒÓº®ÓË­ºãËË
 °Òämºãºm  ÒãÒ mº°¹ºã ς®ˆË° ÒäËÓËä ¹¯ËãÈÈËä©ä ¹¯º
¯Èä亮
      |ˆ¯ËÈ}ˆÒ¯ºmȈ ¹¯ºË}ˆˆÈ­ãÒ©
      ¯ºË}ˆ ˆÈ­ãÒ© äºÎÓº äºÒÁÒÒ¯ºmȈ  m È°ˆÓº°ˆÒ º
­Èm㫈 ‚È㫈 ¹ºã«ÒãÒÒÏäËÓ«ˆ Ò²¹È¯Èäˈ¯©¯Òªˆºäm°Ë
Ò°¹¯ÈmãËÓÒ«m¹¯ºË}ˆ°ãË‚ˈmÓË°ˆÒºÓÈÈãÈÏȹºãÓËÓÒ«­ÈÏ©
ÈÓÓ©² ¹º°}ºã }‚ ¹º¹©ˆ}È ÒÏäËÓ҈ ¹È¯Èäˈ¯© ¹ºãË® Ïȹºã
ÓËÓÓº® ­ÈÏ© ÈÓÓ©² äºÎˈ ¹ºmãË  ÏÈ °º­º® ¹ºˆË¯ ÒãÒ Ò°}È
ÎËÓÒËÈÓÓ©²
       iã«m°ˆÈm}ÒÓºmºº¹ºã«ÓȺ‚°ˆÈÓºm҈ }‚¯°º¯ÓÈ°ˆ¯º}‚
¹¯ºË}ˆÈ¹Ë¯Ë }ºˆº¯º®ºãÎÓÈ­©ˆ mmËËÓÈÓºmÈ«°ˆ¯º}ÈÒÓÈ
ÎȈ °ººˆmˈ°ˆm‚ ‚ }Óº¹}‚ ÓÈ ¹ÈÓËãÒ ÒÓ°ˆ¯‚äËӈºm ÒãÒ m©
ÏmȈ }ºäÈÓ‚vˆ¯º}Ò Òãҁºã˹º°ˆÈÓºmº} ÒÏäËÓ {°ˆÈm}È
      p°ãÒ ÒÏ ¹¯ºË}ˆÈ ˆÈ­ãÒ© Ó˺­²ºÒäº ‚Èã҈ ¹ºãË  ÒãÒ
ÓË°}ºã }º ¹ºãË®  ˆº Ó˺­²ºÒäº ºˆäˈ҈ °ººˆmˈ°ˆm‚ ‚
°ˆ¯º}‚ ÒãÒ°ˆ¯º}Ò Òm©­¯Èˆ }ºäÈÓ‚Èã҈ °ˆ¯º}Ò ÒÏäËÓ
¯Èm}È