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

UptoLike


vºÏÈÒä ° ¹ºäº lÈ°Ë¯È ¹Ë¯Ë}¯Ë°Ó©® Ïȹ¯º° ºº
¯ÈÎÈÒ®mmÒËÈãÒ©¯ËÏãÈ©°ÈÒ°ËÓÈäÒª}ÏÈäË
Óºm¹º}Èκ®Ò°Ò¹ãÒÓËv¯º}ÒÈ}º®ÈãÒ©ºãÎÓ©¹¯Ë
°Èmã« ÁÈäÒãÒÒ°ËÓºm °ºã© Ü ©Ò°Ò¹ãÒÓm©
¯ÈÓ©mäË°ºÓÈÏmÈÓÒ®Ò°Ò¹ãÒÓã«ºãËË}ºä¹È}Óºº¹¯Ë
°ÈmãËÓÒ«ÈãÒ©z¯ºäËººmmÒËºËãÓºº°ºãÈÈ
ãÒ© ¹º}ÈÎËä °¯ËÓÒ® Èãã }Èκº °ËÓÈ ¹º ¯ËÏãÈÈä
°ÈÒª}ÏÈäËÓºm
º°}ºã}mÓÈËä°ãÈË¹Ë¯Ë}¯Ë°Ó©®Ïȹ¯º°ºãÎËÓm©
Ò ¹ºã« ÒÏ ¯ÈÏÓ©² ÈãÒ ÈÏ© ÈÓÓ©² º ¹¯ËmȯÒËãÓº
°ºÏÈÒä Ïȹ¯º° m}ã ÈÒ® ªÒ ¹ºã« Ò ÓÈ ˺º°ÓºmË Ëä
°¯ºÒ ¹Ë¯Ë}¯Ë°Ó©®vºÏÈÓÒËªººm°¹ºäºÈËãÓººÏȹ¯º°È
¹¯ºmºÒ°« ÈÓÈãºÒÓº °ºÏÈÓÒ ¹¯º°ºº Ïȹ¯º°È ÒÏ ¯È°°äº
¯ËÓÓºº¯ÈÓËË¹¯Òä˯È¹ºã}ºmäË°º¹ºã«sÈÏmÈÓÒË ÒÏ
ÈãÒ©ijv¡jjsk ÓȺm©¯È ¹ºãË Ò°Ò¹ãÒÓ©
¯Ò°¹Òä ˹˯ } °ºÏÈÓÒ °º°mËÓÓº ¹Ë¯Ë}¯Ë°Óºº
Ïȹ¯º°È « ªºº m ÒÈ㺺mºä º}ÓË
sºm©® Ïȹ¯º°
m©˯Ëä
ÏÓÈËÓÒË
˯Ë}¯Ë°Ó©®Ïȹ¯º°
ÒÓÈÎäËä}Óº¹}
2.
{¹Ë¯mºä
ÒÈ㺺mºäº}ÓË
vºÏÈÓÒË¹Ë¯Ë}¯Ë°Ó©²ÈãÒ
m©˯Ëäºã}º
º °ºÏÈÓÓ©® m°¹ºäºÈËãÓ©® Ïȹ¯º° ÓÈ º°ÓºmË }ºº¯ºº
lÈ°˯ °ºÏÈ° ¹Ë¯Ë}¯Ë°Ó©® Ïȹ¯º° Ò ÓÈÎäËä }Óº¹}
iÈãËË

º©}ÈÏÈÒäËÓÈ}È}Ò²¹ºãË®Ò°¹ºãϺmÈ°«mË
°mË ÏȺãºm}ºm °¯º} ¹Ë¯Ë}¯Ë°Óº® ÈãÒ© ÒÏ ¹¯ËãºÎËÓÓ©²
¹ºãË®
iº°¹Ó©Ë¹ºã«
°ãË˺ºÈlÈ°Ë¯È m©˯Ëä¹ºã«
nÈäÒãÒ« Ò¯¹¹È Ò¹Ë¯ËÓË°ËäÒ²m°¹Ò°º}
{©¯ÈÓÓ©Ë¹ºã«
°
¹ºäº }Óº¹}Ò¹Ë¯ËÓº°È
!
sÈÎÈm}Óº¹}
iÈãËË
¹Ë¯Ë®Ëäm°ãËËËº}ÓºlÈ°˯È
{ªºäº}ÓËÓÎÓºm©¯È ¹ºãËÏÓÈËÓÒ«}ºº¯ººÁÒ
¯Ò¯ºmÈ mÏȺãºm}Ȳ°ºãºm¹Ë¯Ë}¯Ë°Óº®ÈãÒ©{ÓÈËä
¹¯Òä˯ËªºË¹ºãË Ò°Ò¹ãÒÓ©
{°ãËËäº}ÓËlÈ°Ë¯È }ÈÎËäÏÓÈËÓÒ«}È}ºº¹ºã«
ÓȲºÒ°«m«Ë®}Ȳ¹Ë¯Ë}¯Ë°Óº®ÈãÒ©mÓÈËä°ã
ÈË Ü ¹ºã«|ËÓ}È Ò m©˯Ëäº¹Ë¯ÈÒ ã« º¯Èº}ÒªÒ²
ÏÓÈËÓÒ®Ü v¯ËÓËË m©Ò°ãËÓÒË°¯ËÓ˺ÏÓÈËÓÒ«z¯ºäËºº
°ÈÓºmÒä º¹Ò iÈ m ºãÈ°Ò
Ò°ãÒ ÒººmºË ÏÓÈËÓÒË
ã«}Èκ®°¯º}Ò"
{¯ËÏãÈËm¹Ë¯Ë}¯Ë°Ó ÈãÒË
ºÈmãËÓ°ºãË °ºÏÓÈËÓÒËä°¯ËÓ˺ÈããÈ}Èκº°ËÓÈ
       vºÏÈÒä ° ¹ºäº  lÈ°ˆË¯È ¹Ë¯Ë}¯Ë°ˆÓ©® Ïȹ¯º° ºˆº
­¯ÈÎÈ Ò®mmÒˈȭãÒ©¯Ëς㠈Ȉ©°ÈÒ°ˆ‚ËӈÈäÒª}ÏÈäË
Óºm¹º}Èκ®Ò°Ò¹ãÒÓËvˆ¯º}ÒˆÈ}º®ˆÈ­ãÒ©ºãÎÓ©¹¯Ë
°ˆÈm㫈 ÁÈäÒãÒÒ °ˆ‚Ëӈºm °ˆºã­© Ü }º© Ò°Ò¹ãÒÓ m©
­¯ÈÓ©mäË°ˆºÓÈÏmÈÓÒ®Ò°Ò¹ãÒÓã«­ºãËË}ºä¹È}ˆÓºº¹¯Ë
°ˆÈmãËÓÒ«ˆÈ­ãÒ© z¯ºäˈººmmÒ˺ˆËã Óºº°ˆºã­ÈˆÈ­
ãÒ© ¹º}ÈÎËä °¯ËÓÒ® ­Èãã }Èκº °ˆ‚ËӈÈ ¹º ¯Ëς㠈ȈÈä
°ÈÒª}ÏÈäËÓºm
       º°}ºã }‚mÓÈ Ëä°ã‚È˹˯Ë}¯Ë°ˆÓ©®Ïȹ¯º°ºãÎËÓm©
mº҈ ¹ºã« ÒÏ ¯ÈÏÓ©² ˆÈ­ãÒ ­ÈÏ© ÈÓÓ©² ˆº ¹¯Ëmȯ҈Ëã Óº
°ºÏÈÒä Ïȹ¯º° m}ã È Ò® ªˆÒ ¹ºã« Ò ÓÈ Ëº º°ÓºmË ­‚Ëä
°ˆ¯ºÒˆ ¹Ë¯Ë}¯Ë°ˆÓ©®vºÏÈÓÒ˪ˆººm°¹ºäºȈËã ÓººÏȹ¯º°È
¹¯ºmº҈°« ÈÓÈãºÒÓº °ºÏÈÓÒ ¹¯º°ˆºº Ïȹ¯º°È ÒÏ ¯È°°äºˆ
¯ËÓÓºº¯ÈÓË˹¯Òä˯È ¹ ˆºã }ºmäË°ˆº¹ºã«sÈÏmÈÓÒË ÒÏ
ˆÈ­ãÒ©ijv¡jjsk ÓȺm©­¯Èˆ ¹ºãËzº Ò°Ò¹ãÒÓ©
       ¯Ò°ˆ‚¹Òä ˆË¹Ë¯ } °ºÏÈÓÒ        °º­°ˆmËÓÓº ¹Ë¯Ë}¯Ë°ˆÓºº
Ïȹ¯º°È iã« ªˆºº m ÒÈ㺺mºä º}ÓË  sºm©® Ïȹ¯º° m©­Ë¯Ëä
ÏÓÈËÓÒˁ˯Ë}¯Ë°ˆÓ©®Ïȹ¯º° ÒÓÈÎäËä}Óº¹}‚2.{¹Ë¯mºä
ÒÈ㺺mºäº}ÓËvºÏÈÓÒ˹˯Ë}¯Ë°ˆÓ©²ˆÈ­ãÒ m©­Ë¯Ë䈺ã }º
ˆº °ºÏÈÓÓ©® m°¹ºäºȈËã Ó©® Ïȹ¯º° ÓÈ º°ÓºmË }ºˆº¯ºº
lÈ°ˆË¯ °ºÏÈ°ˆ ¹Ë¯Ë}¯Ë°ˆÓ©® Ïȹ¯º° Ò ÓÈÎäËä }Óº¹}‚ iÈãËË
  ˆº­©‚}ÈÏȈ ÒäËÓÈ}È}Ò²¹ºãË®­‚‚ˆÒ°¹ºã ϺmȈ °«m}ÈË
°ˆmË ÏȺãºm}ºm °ˆ¯º} ¹Ë¯Ë}¯Ë°ˆÓº® ˆÈ­ãÒ© ÒÏ ¹¯ËãºÎËÓÓ©²
¹ºãË®iº°ˆ‚¹Ó©Ë¹ºã« °ãË‚ Ëºº}ÓÈlÈ°ˆË¯È m©­Ë¯Ë乺ã«
nÈäÒãÒ« Ò€¯‚¹¹È ҹ˯ËÓË°ËäÒ²m°¹Ò°º}{©­¯ÈÓө˹ºã« °
¹ºäº }Óº¹}ҹ˯ËÓº°È!
       sÈÎÈm}Óº¹}‚iÈãË˹˯ˮËäm°ãË‚ Ë˺}ÓºlÈ°ˆË¯È
{ªˆºäº}ÓËӂÎÓºm©­¯Èˆ ¹ºãËÏÓÈËÓÒ«}ºˆº¯ºº­‚‚ˆÁÒ‚
¯Ò¯ºmȈ mÏȺãºm}Ȳ°ˆºã­ºm¹Ë¯Ë}¯Ë°ˆÓº®ˆÈ­ãÒ©{ÓÈ Ëä
¹¯Òä˯˪ˆº­‚ˈ¹ºãËzº Ò°Ò¹ãÒÓ©
       { °ãË‚ Ëä º}ÓË lÈ°ˆË¯È ‚}ÈÎËä ÏÓÈËÓÒ« }È}ºº ¹ºã«
­‚‚ˆÓȲº҈ °«m«Ë®}Ȳ¹Ë¯Ë}¯Ë°ˆÓº®ˆÈ­ãÒ© mÓÈ Ëä°ã‚
ÈË  Ü ¹ºã« |ËÓ}È  Ò m©­Ë¯Ëä º¹Ë¯ÈÒ ã« º­¯È­ºˆ}Ò ªˆÒ²
ÏÓÈËÓÒ®Ü v¯ËÓËË m©Ò°ãËÓÒË°¯ËÓ˺ÏÓÈËÓÒ« z¯ºäˈºº
‚°ˆÈÓºmÒä º¹Ò       iÈ m º­ãÈ°ˆÒ  {©Ò°ã҈ ҈ººmºË ÏÓÈËÓÒË
ã«}Èκ®°ˆ¯º}Ò"{¯Ëς㠈ȈËm¹Ë¯Ë}¯Ë°ˆÓ‚ ˆÈ­ãÒ‚­‚ˈ
º­ÈmãËÓ°ˆºã­Ë °ºÏÓÈËÓÒËä°¯ËÓ˺­ÈããÈ}Èκº°ˆ‚ËӈÈ