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

UptoLike


ÓºËã«m©º¯È°¹º°ºÈ¹º°¯ºËÓÒ«Ïȹ¯º°ÈcȰ°äº¯Òä¹¯ÒäË
¯© °ºÏÈÓÒ« ÓÈÒºãËË Ȱº Ò°¹ºãÏË䩲 ÓÈ ¹¯È}Ò}Ë Ò¹ºm
Ïȹ¯º°ºm
¯º°©ËÏȹ¯º°©
¯º°º®Ïȹ¯º° Ü ªºÏȹ¯º°ËÏ}¯Ò˯ÒËmºº¯È¹¯ºÒÏmº
«Ò® m©º¯} ÒÏ º¹¯ËËãËÓÓ©² ¹ºãË® Ó˰}ºã² ÈãÒ ÒãÒ
¯Ò²Ïȹ¯º°ºmvºÏÈÒäÏȹ¯º°ã«ºº¯ÈÁÈäÒãÒ®ÒÁ¯ºm
¯¹¹ ÓÈÏmÈÓÒ® Ò°Ò¹ãÒÓ Ò ºËÓº} ÒÏ ÈãÒ ÈÏ© ÈÓÓ©²
vp{kpl|veË°mËËÓÒ®º°¹ËmÈË亰Òm°Ë²°ËÓºm
{ º}ÓË
sºm©® Ïȹ¯º°
m©˯Ëä lȰ˯
¯º°º® Ïȹ¯º°
 m
¹º«mÒmËä°«ÒÈ㺺mºäº}ÓË
vºÏÈÓÒË¹¯º°©²Ïȹ¯º°ºm
m©Ë
¯Ëä ¹Ëä ¹Ë¯ËÓº°È ÒÏ º}ÓÈ
iº°¹Ó©Ë ¹ºã«
m ºº
{©¯ÈÓÓ©Ë
¹ºã«
Ó˺²ºÒä©Ëã«Ïȹ¯º°È¹ºã«ÒÏÈãÒ©vips ¹º
ã«nÈäÒãÒ« Ò¯¹¹ÈÒÏÈãÒ©ijv¡jjsk Ü ¹ºãËÏmÈ
ÓÒË ÒÒÏÈãÒ©vp{kpl|ve Ü ¹ºãË|ËÓ}È{©º¯ÓÎ
Óº®ÈãÒ©º°˰mã«Ë°«mº}ÓË
ÈãÒ©Ïȹ¯º°©
¹Ë¯ËÓº°Ü
° ¹ºäº }Óº¹º} ¹Ë¯ËÓº°È ¯È°¹ºãºÎËÓÓ©² äËÎ º}ÓÈäÒ
iº°¹Ó©Ë¹ºã«
Ò
{©¯ÈÓÓ©Ë¹ºã«
º°ãËÓÈÎÈÒ«}Óº¹}Ò
iÈãËË
¹º«mã«Ë°«ÓºmºËº}Óº¹ºÏmºã«ËËÏÈÈ m˰mË¯ËÏãÈÈ
¹ºÒ°}È¹º¯ºÓ©®ÒãÒÒººm©®ºËº¯ºÓ©®ºËm}ã
ÈË }Èκº ¹ºã« }Èκ® ÏȹҰÒ Òººm©® ¹ºÏmºã«Ë
m©m˰Ò¯ËÏãÈ©º¯Èº}ÒÒ°ãºm©²¹ºãË®°ääÏÓÈËÓÒ®
äÒÓÒäÈãÓ©Ë äÈ}°ÒäÈãÓ©Ë °¯ËÓÒË ÏÓÈËÓÒ« ¹ºãË® È È}ÎË
Ò°ãºÏȹҰˮº°ãËÓÈÎÈÒ«}Óº¹}Ò
iÈãËË
Ó˺²ºÒäºÏÈÈ
Òä«Ïȹ¯º°ÒãÒº°ÈmÒ ¹¯ËãºÎËÓÓºË$FFHVVÒ¹ºãÓÒ ÏÈ
¹¯º° ÓÈÎÈm }Óº¹}
ººmº
 cËÏãÈ ¹ºãÓËÓÒ« Ïȹ¯º°È ã«
ÓÈ˺ ¹¯Òä˯È m °ãÈË m©º¯È ¹º¯ºÓºº ºËÈ m ˰mË
¯ËÏãÈÈ¹ºÒ°}È¹¯Ë°ÈmãËÓÓÈ¯Ò°
sÈ¹¯È}Ò}ËÈÓÓ©Ë¹ºãËÓÓ©Ëm¯ËÏãÈËm©¹ºãÓËÓÒ«
Ïȹ¯º°È ºmºãÓº Ȱº ¹¯Ò²ºÒ°« ¹¯Ë°Èmã« m º°º¯Ò¯º
mÈÓÓºäË{©¹ºãÓÒ °º¯Ò¯ºm}mº}ÓËÏȹ¯º°ÈäºÎÓº°¹º
äº }ºäÈÓ©
vº¯Ò¯ºm}È
ÒÏ äËÓ
~ȹҰÒ
 È È}ÎË }Óº¹º}
vº¯Ò¯ºm}È ¹º ϯȰÈÓÒ
Ò
vº¯Ò¯ºm}È ¹º ©mÈÓÒ
¹ÈÓËãÒ
ÒÓ°¯äËÓºm
~ȹ¯º°m¯ËÎÒäËÈãÒ©
«ªºº°ãËËmÓÈÈ
ãËºäËÒ °ºãË ÈãÒ©¹º}ºº¯ºäº°º¯Ò¯ºmÈÓ©
ÏȹҰÒÈ¹ººäÏÈÈ °¹º°º°º¯Ò¯ºm}Ò
ÓºËã«m©­º¯È°¹º°º­È¹º°ˆ¯ºËÓÒ«Ïȹ¯º°ÈcȰ°äºˆ¯Ò乯ÒäË
¯© °ºÏÈÓÒ«  ÓÈÒ­ºãËË Ȱˆº Ò°¹ºã ςË䩲 ÓÈ ¹¯È}ˆÒ}Ë ˆÒ¹ºm
Ïȹ¯º°ºm


                    ¯º°ˆ©ËÏȹ¯º°©

      ¯º°ˆº®Ïȹ¯º° Ü ªˆºÏȹ¯º°­ËÏ}¯ÒˆË¯ÒËmºˆ­º¯È¹¯ºÒÏmº
«Ò® m©­º¯}‚ ÒÏ º¹¯ËËãËÓÓ©² ¹ºãË® Ó˰}ºã }Ò² ˆÈ­ãÒ ÒãÒ
¯‚Ò² Ïȹ¯º°ºm vºÏÈÒä Ïȹ¯º° ã« ºˆ­º¯È ÁÈäÒãÒ® ÒÁ¯ºm
¯‚¹¹ ÓÈÏmÈÓÒ® Ò°Ò¹ãÒÓ Ò ºËÓº} ÒÏ ˆÈ­ãÒ ­ÈÏ© ÈÓÓ©²
vp{kpl|v‘eˆË°mËËÓÒ®º­‚°¹ËmÈË亰ˆÒm°Ë²°ˆ‚Ëӈºm
      { º}ÓË sºm©® Ïȹ¯º° m©­Ë¯Ëä lȰˆË¯ ¯º°ˆº® Ïȹ¯º° m
¹º«mÒm Ëä°« ÒÈ㺺mºä º}ÓËvºÏÈÓÒ˹¯º°ˆ©²Ïȹ¯º°ºm m©­Ë
¯Ëä ¹‚ˆËä ¹Ë¯ËÓº°È ÒÏ º}ÓÈ iº°ˆ‚¹Ó©Ë ¹ºã« m º}Óº {©­¯ÈÓÓ©Ë
¹ºã« Ó˺­²ºÒä©Ëã«Ïȹ¯º°È¹ºã«ÒψȭãÒ©v‘ips‘ ¹º
ã«nÈäÒãÒ« Ò€¯‚¹¹ÈÒψȭãÒ©ijv¡jjsk Ü ¹ºãËsÈÏmÈ
ÓÒË Ò ÒψȭãÒ©vp{kpl|v‘e Ü ¹ºãË|ËÓ}È{©­º¯ӂÎ
Óº®ˆÈ­ãÒ©º°‚Ë°ˆmã«Ëˆ°«mº}ÓˑȭãÒ©Ïȹ¯º°©¹Ë¯ËÓº°Ü
° ¹ºäº  }Óº¹º} ¹Ë¯ËÓº°È ¯È°¹ºãºÎËÓÓ©² äË΂ º}ÓÈäÒ
iº°ˆ‚¹Ó©Ë¹ºã« Ò{©­¯ÈÓө˹ºã«º°ãËÓÈÎȈҫ}Óº¹}ÒiÈãËË
¹º«mã«Ëˆ°«ÓºmºËº}Óº¹ºÏmºã« ËËÏÈȈ m}È˰ˆm˯Ëς㠈ȈÈ
¹ºÒ°}È ¹º¯º­Ó©® ÒãÒ ҈ººm©® ºˆˈ º¯º­Ó©®ºˆˈm}ã 
Èˈ m©mº }Èκº ¹ºã« }Èκ® ÏȹҰÒ ҈ººm©®  ¹ºÏmºã«Ëˆ
m©m˰ˆÒ ¯Ëς㠈Ȉ© º­¯È­ºˆ}ÒÒ°ãºm©² ¹ºãË® °‚ää‚ ÏÓÈËÓÒ®
äÒÓÒäÈã Ó©Ë äÈ}°ÒäÈã Ó©Ë °¯ËÓÒË ÏÓÈËÓÒ« ¹ºãË® È ˆÈ}ÎË
Ұ㺠ÏȹҰˮ º°ãË ÓÈÎȈҫ }Óº¹}Ò iÈãËË Ó˺­²ºÒäº ÏÈȈ
Òä«Ïȹ¯º°‚ ÒãÒº°ˆÈm҈ ¹¯ËãºÎËÓÓºË$FFHVV Òm©¹ºãÓ҈ ÏÈ
¹¯º° ÓÈÎÈm }Óº¹}‚ €ºˆºmº cËς㠈Ȉ m©¹ºãÓËÓÒ« Ïȹ¯º°È ã«
ÓÈ Ëº ¹¯Òä˯È m °ã‚ÈË m©­º¯È ¹º¯º­Óºº ºˆˈÈ m }È˰ˆmË
¯Ëς㠈ȈȹºÒ°}È ¹¯Ë°ˆÈmãËÓÓȯҰ
      sÈ ¹¯È}ˆÒ}Ë ÈÓÓ©Ë ¹ºã‚ËÓÓ©Ë m ¯Ëς㠈ȈË m©¹ºãÓËÓÒ«
Ïȹ¯º°È ºmºã Óº Ȱˆº ¹¯Ò²º҈°« ¹¯Ë°ˆÈm㫈 m ºˆ°º¯ˆÒ¯º
mÈÓÓºämÒË{©¹ºãÓ҈ °º¯ˆÒ¯ºm}‚mº}ÓËÏȹ¯º°ÈäºÎÓº°¹º
亝  }ºäÈÓ© vº¯ˆÒ¯ºm}È ÒÏ äËÓ ~ȹҰÒ È ˆÈ}ÎË }Óº¹º}
vº¯ˆÒ¯ºm}È ¹º mºÏ¯È°ˆÈÓÒ Ò vº¯ˆÒ¯ºm}È ¹º ‚­©mÈÓÒ ¹ÈÓËãÒ
ÒÓ°ˆ¯‚äËӈºm~ȹ¯º°m¯ËÎÒäˈȭãÒ©i㫪ˆºº°ãË‚ˈmÓÈÈ
ãË ºˆäˈ҈ °ˆºã­Ë ˆÈ­ãÒ© ¹º }ºˆº¯ºä‚ ­‚‚ˆ ºˆ°º¯ˆÒ¯ºmÈÓ©
ÏȹҰÒȹºˆºäÏÈȈ °¹º°º­°º¯ˆÒ¯ºm}Ò