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

UptoLike


{mË°ÒÒº¯ËÈ}Ò¯ºmÈ ÏȹҰÒÈãÒ©
jÈ}¹¯ºË} ÈãÒ© ººm ˹˯ äºÎÓºÏȹºãÓÒ È
ãÒ}ºÓ}¯ËÓ©äÒÈÓÓ©äÒÒ¹ºä˯ËÓ˺²ºÒ亰ÒmÓº°Ò m
ÓËË ÒÏäËÓËÓÒ« « mmºÈ ÏȹҰˮ m ÈãÒ Ó˺²ºÒäº Ë
ãÒ ËËÒä«mº}ÓËÈÏ©ÈÓÓ©²ÒÓÈÎÈ º¹}
|}¯©
p°ãÒ
m ÈÓÓ©® äºäËÓ º}¯©º ºº zºÓ°¯}º¯È ÈãÒ °ãËË
°ÈÓºmÒ ¯ËÎÒä ÈãÒ© m©ÏmÈm }ºäÈÓ
cËÎÒä ÈãÒ©
ÒÏ
äËÓ
ÒãÒËã}ÓmÓÈ}Óº¹}Ë
¹Ë¯mÈ«°ãËmÈ}Óº¹}È¹È
ÓËãÒÒÓ°¯äËÓºm
vm«ÏÈ ÈãÒ©
$FFHVV ¹ºÏmºã«Ë °ºÏÈmÈ ¯Ëã«ÒºÓÓ©Ë ÈÏ© ÈÓÓ©² º
ËãÓ©Ë ÈãÒ© }ºº¯©² äº © °m«ÏÈÓ© äËÎ °ºº®
vm«Ï äËÎÈãÒÈäÒº¹¯ËËã«ËÒ¹ºÓºËÓÒ«äËÎÒ²¹º
ã«äÒ } ¹¯ÈmÒãº °m«Ï© ËmºË ¹ºãË ºÓº® ÈãÒ© °
°ººmË°mÒä Ëä ¹ºãËä¯º® ÈãÒ© }ºº¯ºË ÓÈÏ©
¹ºãËä mÓËÓ˺ È vm«ÏÈÓÓ©Ë ¹ºã« äº ÒäË ¯ÈÏÓ©Ë
ÒäËÓÈ ºÓÈ}º  ÓÒ² ºãÎÓ© © ºÒÓÈ}ºm©Ë Ò¹© ÈÓÓ©² Ò
ºÒÓÈ}ºm©ËÏÓÈËÓÒ«°mº®°m¯ÒÓÈãÒÒÒ °m«ÏÒäËÎÈãÒ
ÈäÒ$FFHVV ËÈmºäÈÒË°}Òm©Ò¯È °m«ÏÈÓÓ©ËÈÓÓ©ËÒÏ
ÈãÒ mÏȹ¯º°È²ºËȲÒÁº¯äȲ
{ÓÈËä¹¯Òä˯ËÓ˺²ºÒäº°ÈÓºmÒ °m«ÏÒäËÎÈ
ãÒÈäÒvips Òvp{kpl|ve ÙºÒÓäÓºÒäµÒ
ijv¡jjskÒvp{kpl|veÙºÒÓäÓºÒäµ«
ªººmäËÓ
v˯mҰ
°ãËËm©¯È }ºäÈÓ
v²ËäÈÈÓÓ©²
ÒãÒ
ÓÈÎÈ °ººmË°m }Óº¹} ÓÈ ¹ÈÓËãÒ ÒÓ°¯äËÓºm sÈ
ª}¯ÈÓË¹º«mÒ°«º}Óº
v²ËäÈÈÓÓ©²
m}ºº¯ºääºÎÓºÏÈÈ Ò
¹¯º°äº¯Ë °m«ÏÒäËÎÈãÒÈäÒÈÏ©ÈÓÓ©²
º©ºÈmÒ ÈãÒ©ÒãÒÏȹ¯º°©mº}Óº
v²ËäÈÈÓÓ©²

Ó˺²ºÒäº m©¯È }ºäÈÓ
iºÈmÒ ÈãÒ
m äËÓ
vm«ÏÒ
ÒãÒÓÈÎÈ }Óº¹}
iºÈmÒ ÈãÒ
ÓÈ¹ÈÓËãÒÒÓ°¯äËÓºm{
¯ËÏãÈË¹º«mã«Ë°«ÒÈ㺺mºËº}Óº
iºÈmãËÓÒËÈãÒ©
Ë°ãÒ
ÈãÒ©ÈÏ©ÈÓÓ©²°m«Ï©mÈ°«m¹Ë¯m©Ëºªººº¹º«mã«
Ë°«°¯ÈÏÎË¹º°ãËm©º¯È}ºäÈÓ©
v²ËäÈÈÓÓ©²
ÓÈm}ãÈ}Ë
ÈãÒ©
}ºº¯ºººº¯ÈÎÈË°«°¹Ò°º}ÈãÒ ÈÏ©ÈÓÓ©²{©
үȫ¹ºãËÎÈÒË°m«ÏÒÈãÒ©ÒÓÈÎÒäÈ«}ÈΩ®¯ÈÏ}Óº¹}
iºÈmÒ
¹Ë¯ËÓº°ÒäÒ²mº}Óº
v²ËäÈÈÓÓ©²
º°ãËªºººº
iºÈmãËÓÒË ÈãÒ©
ÓȺ ÏÈ}¯© ~ÈËä °ãËË ¹Ë¯ËäË°Ò °
¹ºäº ä©Ò¹ºãË°m«ÏÒºÓº®ÈãÒ©}¹ºã °m«ÏÒ¯º®
ÈãÒ©{ÓÈËä¹¯Òä˯Ë¹¯Ò°m«Ï©mÈÓÒÒÈãÒ vips
      {mË°ˆÒÒºˆ¯ËÈ}ˆÒ¯ºmȈ ÏȹҰ҈ȭãÒ©
      jˆÈ} ¹¯ºË}ˆ ˆÈ­ãÒ© ºˆºm ‘˹˯ äºÎÓº ÏȹºãÓ҈ ˆÈ­
ãÒ‚}ºÓ}¯ËˆÓ©äÒÈÓÓ©äÒÒ¹ºä˯ËÓ˺­²ºÒ亰ˆÒmÓº°Òˆ m
ÓËË ÒÏäËÓËÓÒ« iã« mmºÈ ÏȹҰˮ m ˆÈ­ãÒ‚ Ó˺­²ºÒäº m©Ë
ã҈ ËËÒä«mº}ÓË­ÈÏ©ÈÓÓ©²ÒÓÈÎȈ }Óº¹}‚|ˆ}¯©ˆ p°ãÒ
m ÈÓÓ©® äºäËӈ ºˆ}¯©ˆº º}Óº zºÓ°ˆ¯‚}ˆº¯È ˆÈ­ãÒ °ãË‚ˈ
‚°ˆÈÓºm҈ ¯ËÎÒä ˆÈ­ãÒ© m©ÏmÈm }ºäÈÓ‚ cËÎÒä ˆÈ­ãÒ© ÒÏ
äËÓ {Ò ÒãҝËã}ӂmÓÈ}Óº¹}Ë {Ò ¹Ë¯mÈ«°ãËmÈ}Óº¹}È ¹È
ÓËãÒÒÓ°ˆ¯‚äËӈºm
      vm«ÏȈ ˆÈ­ãÒ©
      $FFHVV ¹ºÏmºã«Ëˆ °ºÏÈmȈ ¯Ëã«ÒºÓÓ©Ë ­ÈÏ© ÈÓÓ©² ºˆ
Ëã Ó©Ë ˆÈ­ãÒ© }ºˆº¯©² 亂ˆ ­©ˆ °m«ÏÈÓ© äË΂ °º­º®
vm«Ï äË΂ˆÈ­ãÒÈäÒº¹¯ËËã«ËˆˆÒ¹ºˆÓº ËÓÒ«äË΂Ҳ¹º
ã«äÒ zÈ} ¹¯ÈmÒ㺠°m«Ï©mÈ ˆ }ã ËmºË ¹ºãË ºÓº® ˆÈ­ãÒ© °
°ººˆmˈ°ˆm‚ Òä Ëä‚ ¹ºãËä ¯‚º® ˆÈ­ãÒ© }ºˆº¯ºË ÓÈÏ©mÈ ˆ
¹ºãËä mÓË Ó˺ }ã È vm«ÏÈÓÓ©Ë ¹ºã« 亂ˆ Òäˈ ¯ÈÏÓ©Ë
ÒäËÓÈ ºÓÈ}º ‚ ÓÒ² ºãÎÓ© ­©ˆ ºÒÓÈ}ºm©Ë ˆÒ¹© ÈÓÓ©² Ò
ºÒÓÈ}ºm©Ë ÏÓÈËÓÒ« °mº®°ˆm ¯Ò ÓÈãÒÒÒ °m«ÏÒ äË΂ ˆÈ­ãÒ
ÈäÒ$FFHVV ­‚ˈÈmˆºäȈÒË°}Òm©­Ò¯Èˆ °m«ÏÈÓÓ©ËÈÓÓ©ËÒÏ
ˆÈ­ãÒ mÏȹ¯º°È²ºˆˈȲÒÁº¯äȲ
      {ÓÈ Ë乯Òä˯ËÓ˺­²ºÒ亂°ˆÈÓºm҈ °m«ÏÒäË΂ˆÈ­
ãÒÈäÒv‘ips‘ Ґvp{kpl|v‘e ÙºÒÓ}ºäÓºÒäµ Ò
ijv¡jjskҐvp{kpl|v‘e ÙºÒÓ}ºäÓºÒäµ iã«
ªˆººmäËÓ v˯mÒ° °ãË‚ˈm©­¯Èˆ }ºäÈÓ‚v²ËäÈÈÓÓ©² ÒãÒ
ÓÈÎȈ °ººˆmˈ°ˆm‚ ‚ }Óº¹}‚ ÓÈ ¹ÈÓËãÒ ÒÓ°ˆ¯‚äËӈºm sÈ
ª}¯ÈÓË ¹º«m҈°« º}Óº v²ËäÈ ÈÓÓ©² m }ºˆº¯ºä äºÎÓº ÏÈȈ Ò
¹¯º°äºˆ¯Ëˆ °m«ÏÒäË΂ˆÈ­ãÒÈäÒ­ÈÏ©ÈÓÓ©²
        ˆº­©º­Èm҈ ˆÈ­ãÒ©ÒãÒÏȹ¯º°©mº}Óºv²ËäÈÈÓÓ©²
Ó˺­²ºÒäº m©­¯Èˆ }ºäÈÓ‚ iº­Èm҈ ˆÈ­ãÒ‚ m äËÓ vm«ÏÒ
ÒãÒÓÈÎȈ }Óº¹}‚iº­Èm҈ ˆÈ­ãÒ‚ ÓȹÈÓËãÒÒÓ°ˆ¯‚äËӈºm{
¯Ëς㠈Ȉ˹º«mã«Ëˆ°«ÒÈ㺺mºËº}Óºiº­ÈmãËÓÒˈȭãÒ© Ë°ãÒ
ˆÈ­ãÒ©­ÈÏ©ÈÓÓ©²°m«Ï©mÈ ˆ°«m¹Ë¯m©Ëˆºªˆºº}Óº¹º«mã«
ˈ°« °¯Èς Î˹º°ãËm©­º¯È}ºäÈÓ©v²ËäÈÈÓÓ©² ÓÈm}ãÈ}Ë
‘È­ãÒ© }ºˆº¯ºººˆº­¯ÈÎÈˈ°«°¹Ò°º}ˆÈ­ãÒ ­ÈÏ©ÈÓÓ©²{©
­Ò¯È«¹ºãËÎȝÒË°m«Ï҈ȭãÒ©ÒÓÈÎÒäÈ«}ÈΩ®¯ÈÏ}Óº¹}‚
iº­Èm҈ ¹Ë¯ËÓº°ÒäÒ²mº}Óºv²ËäÈÈÓÓ©²º°ã˪ˆººº}Óº
iº­ÈmãËÓÒË ˆÈ­ãÒ© ÓȺ ÏÈ}¯©ˆ  ~ȈËä °ãË‚ˈ ¹Ë¯ËäË°ˆÒˆ °
¹ºäº ä© Ò¹ºãË°m«ÏÒºÓº®ˆÈ­ãÒ©}¹ºã °m«ÏÒ¯‚º®
ˆÈ­ãÒ© { ÓÈ Ëä ¹¯Òä˯Ë ¹¯Ò °m«Ï©mÈÓÒÒ ˆÈ­ãÒ v‘ips‘