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

UptoLike


vºÏÈÓÒËÁº¯ä
nº¯ä© ¹¯Ë°Èmã«°ºº®ºÓ©®°¹º°º¯Èº©°ÈϺ®
ÈÓÓ©²°ºÏÈÒ®º¹¯ËËãËÓÓ©®}ºäÁº¯¹¯ÒmmºËÒÒÏäËÓË
ÓÒÒÈÓÓ©²ã«¯ÈÏãÒÓ©²}È˺¯Ò®¹ºãϺmÈËãË®
p°ãÒ¹¯Ë¹ºãÈÈË°«ºmmºÒä©ËÈÓÓ©ËÒÏäËÓ«
°«¯Ëºã«¯Èº©°ÓÒäÒÒ°¹ºãÏ®ËÈãÒcËÎÒäÈ
ãÒ©¯Ë}ºäËÓË°«Ò°¹ºãϺmÈ ÒºÈÈÓ˺²ºÒäº¹º
ãÒ ÓÈÒºãËË ¹ºãÓ©® ºϺ¯ ÈÓÓ©² sº ˰ãÒ ÈÓÓ©Ë 
ÒÏäËÓ«°« Ȱº ¹ºäËÈ®Ë Ò² m Áº¯ä ¹º°}ºã} m ¯ËÎÒäË
Áº¯ä© äºÎÓº °}ºÓËÓ¯Ò¯ºmÈ mÓÒäÈÓÒË ÓÈ ÈÓÓ©² ºÓº°«
Ò²°« } º¹¯ËËãËÓÓº® ÏȹҰÒ Óȹ¯Òä˯ ÓÈ ÒÓÁº¯äÈÒÒ }È
°ÈË®°«}ºÓ}¯ËÓºº°ËÓÈ
È« Áº¯äÈ °¯ºÒ°« ÓÈ º°ÓºmË ÈãÒ© ÒãÒ Ïȹ¯º°È
jäËÓÈ ¹ºãË® ¹Ë¯ËÓº°«°« m Áº¯ä ÒÏ °¹ËÒÁÒ}ÈÒÒ ÈãÒ©
ÒãÒÏȹ¯º°ÈÈ¯È°¹ºãºÎËÓÒË¹ºãË®ÏÈÈË°«¯ÈϯÈºÒ}ºäÁº¯
ä©¯Ò¯ÈϯÈº}ËäÈ}ËÈÁº¯ä©°ãËËº¹¯ËËãÒ ¹º°ã˺mÈ
ËãÓº° ¯È°¹ºãºÎËÓÒ«¹ºãË®ºËÒÓÒ ãºÒ˰}ÒmÏÈÒ亰m«
ÏÈÓÓ©Ë¹ºã«m¯¹¹©ÏÈÈ ÓÈÏmÈÓÒËÁº¯ä©ÈÈ}ÎËmm˰Òm
ÓËËªãËäËÓ©¹¯ÈmãËÓÒ««}Èκ®ÈÏ©ÈÓÓ©²}¹¯ÈmÒãº
¯ÈϯÈÈ©mÈË°« Ó˰}ºã}º Áº¯ä ¹¯ËÓÈÏÓÈËÓÓ©² ã« ¯ÈÏãÒ
Ó©²}È˺¯Ò®¹ºãϺmÈËãË®
nº¯ääºÎÓº°ºÏÈ ¯ÈÏÓ©äÒ°¹º°ºÈäÒÒ°¹ºãÏ«kmº
Áº¯ä ° ¹ºäº °˯È Áº¯ä ° ¹ºäº zºÓ°¯}º¯È
Áº¯ä zÈÎ Áº¯ä äºÎÓº ºº¯ÈÏÒ ÓÈ ª}¯ÈÓË m ºÓºä ÒÏ
¯Ë²¯ËÎÒäºmm¯ËÎÒäËÁº¯ä© ¯ÈºÒ®¯ËÎÒäm¯ËÎÒäËÓ
°¯}º¯È Òm¯ËÎÒäËÈãÒ©˯Ë}ãËÓÒËäËÎªÒäÒ¯Ë
ÎÒäÈäÒº°˰mã«Ë°«ãÒº°¹ºäº}ºäÈÓ äËÓ
ãÒº
°¹ºäº }Óº¹}Ò
ÓÈ¹ÈÓËãÒÒÓ°¯äËÓºm¹Ë¯mÈ«}Óº¹}È
°ãËmÈº}¯©mÈË®°¹Ò°º}°ÓÈÏmÈÓÒ«äÒ¯ËÎÒäºm
kmºÁº¯ä©
kmºÁº¯äÈ ÈmºäÈÒ˰}Ò °ºÏÈË ÓÈ º°ÓºmË m©¯ÈÓÓº®
ÈãÒ©ÒãÒÏȹ¯º°ÈÁº¯äºÓººÒÏ°ãËÒ²Ò¹ºmm°ºã
ËãËÓºÓ ÈãÒÓ¯Ò°ºÏÈÓÒÒÁº¯ä©kmºÁº¯äÈ m
°ºãË ã«}Èκ®ÏȹҰÒºmºÒ°«ºËãÓÈ«°¯ÈÓÒÈÁº¯ä©
È}º®Ò¹Áº¯ä©ãËm°Ëº¹º²ºÒã«ÏȹҰˮ°ºãÒä
                     vºÏÈÓÒËÁº¯ä

     nº¯ä© ¹¯Ë°ˆÈmã« ˆ°º­º®‚º­Ó©®°¹º°º­¯È­ºˆ©°­ÈϺ®
ÈÓÓ©²°ºÏÈ Ò®º¹¯ËËãËÓÓ©®}ºäÁº¯ˆ¹¯ÒmmºËÒÒÏäËÓË
ÓÒÒÈÓÓ©²ã«¯ÈÏãÒÓ©²}Ȉ˺¯Ò®¹ºã ϺmȈËãË®
     p°ãÒ¹¯Ë¹ºãÈÈˈ°«ˆºmmºÒä©ËÈÓÓ©Ë­‚‚ˆÒÏäËÓ«ˆ 
°«¯Ë}ºˆºã«¯È­ºˆ©°ÓÒäÒÒ°¹ºã ς®ˆËˆÈ­ãÒ‚cËÎÒäˆÈ­
ãÒ©¯Ë}ºäËÓ‚ˈ°«Ò°¹ºã ϺmȈ ÒˆºÈ}ºÈÓ˺­²ºÒ亹º
ã‚҈ ÓÈÒ­ºãËË ¹ºãÓ©® º­Ïº¯ ÈÓÓ©² sº ˰ãÒ ÈÓÓ©Ë ­‚‚ˆ
ÒÏäËÓ«ˆ °« Ȱˆº ¹ºä˝ȮˆË Ò² m Áº¯ä‚ ¹º°}ºã }‚ m ¯ËÎÒäË
Áº¯ä© äºÎÓº °}ºÓËӈ¯Ò¯ºmȈ mÓÒäÈÓÒË ÓÈ ÈÓÓ©² ºˆÓº°«
Ò²°« } º¹¯ËËãËÓÓº® ÏȹҰÒ Óȹ¯Òä˯ ÓÈ ÒÓÁº¯äÈÒÒ }È
°È Ë®°«}ºÓ}¯ËˆÓºº°ˆ‚ËӈÈ
      ­È« Áº¯äÈ °ˆ¯ºÒˆ°« ÓÈ º°ÓºmË ˆÈ­ãÒ© ÒãÒ Ïȹ¯º°È
jäËÓÈ ¹ºãË® ¹Ë¯ËÓº°«ˆ°« m Áº¯ä‚ ÒÏ °¹ËÒÁÒ}ÈÒÒ ˆÈ­ãÒ©
ÒãÒÏȹ¯º°ÈȯȰ¹ºãºÎËÓÒ˹ºãË®ÏÈÈˈ°«¯ÈϯȭºˆÒ}ºäÁº¯
䩁¯Ò¯Èϯȭºˆ}ËäÈ}ˈÈÁº¯ä©°ãË‚ˈº¹¯ËËã҈ ¹º°ã˺mÈ
ˆËã Óº°ˆ ¯È°¹ºãºÎËÓÒ«¹ºãË®º­žËÒÓ҈ ãºÒ˰}ÒmÏÈÒ亰m«
ÏÈÓө˹ºã«m¯‚¹¹©ÏÈȈ ÓÈÏmÈÓÒËÁº¯ä©ÈˆÈ}ÎËmm˰ˆÒm
ÓË˪ãËäËӈ©‚¹¯ÈmãËÓÒ«iã«}Èκ®­ÈÏ©ÈÓÓ©²}È}¹¯ÈmÒãº
¯ÈϯȭȈ©mÈˈ°« Ó˰}ºã }º Áº¯ä ¹¯ËÓÈÏÓÈËÓÓ©² ã« ¯ÈÏãÒ
Ó©²}Ȉ˺¯Ò®¹ºã ϺmȈËãË®
     nº¯ä‚äºÎÓº°ºÏȈ ¯ÈÏÓ©äÒ°¹º°º­ÈäÒÒ°¹ºã ς«kmˆº
Áº¯ä‚ ° ¹ºäº  lȰˆË¯È Áº¯ä ° ¹ºäº  zºÓ°ˆ¯‚}ˆº¯È
Áº¯ä zÈ΂ Áº¯ä‚ äºÎÓº ºˆº­¯ÈÏ҈ ÓÈ ª}¯ÈÓË m ºÓºä ÒÏ
ˆ¯Ë²¯ËÎÒäºmm¯ËÎÒäËÁº¯ä© ¯È­ºÒ®¯ËÎÒä m¯ËÎÒäËzºÓ
°ˆ¯‚}ˆº¯È Òm¯ËÎÒäˈȭãÒ©Ë¯Ë}ã ËÓÒËäË΂ªˆÒäÒ¯Ë
ÎÒäÈäÒº°‚Ë°ˆmã«Ëˆ°«ãÒ­º°¹ºäº }ºäÈÓ äËÓ {ÒãÒ­º
°¹ºäº }Óº¹}Ò{Ò ÓȹÈÓËãÒÒÓ°ˆ¯‚äËӈºm ¹Ë¯mÈ«}Óº¹}È
°ãËmÈ ºˆ}¯©mÈ Ë®°¹Ò°º}°ÓÈÏmÈÓÒ«äÒ¯ËÎÒäºm


                        kmˆºÁº¯ä©

      kmˆºÁº¯äÈ ÈmˆºäȈÒ˰}Ò °ºÏÈˈ ÓÈ º°ÓºmË m©­¯ÈÓÓº®
ˆÈ­ãÒ©ÒãÒÏȹ¯º°ÈÁº¯ä‚ºÓººÒϰãË‚ Ò²ˆÒ¹ºmm°ˆºã
­Ë ãËӈºӂ  ˆÈ­ãÒӂ  ¯Ò °ºÏÈÓÒÒ Áº¯ä© kmˆºÁº¯äÈ m
°ˆºã­Ë ã«}Èκ®ÏȹҰÒºˆmº҈°«ºˆËã ÓÈ«°ˆ¯ÈÓÒÈÁº¯ä©
‘È}º® ˆÒ¹ Áº¯ä© ã‚ Ë m°Ëº ¹º²º҈ã«ÏȹҰˮ°­ºã Òä