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

UptoLike


ÒmºÏm¯ÈÈÒ®Ë¹ºã«Ó˺²ºÒä©Ëã«¹º°¯ºËÓÒ«ºËÈ
vÓÈÈãÈ°ÈÓºmÒä¹È¯ÈäË¯©°¯ÈÓÒ©m©¯Èm¹Ó}äË
Ó
nÈ®ã_ȯÈäË¯© °¯ÈÓÒ©
 sÈ m}ãÈ}Ë
|Ë©
º}ÓÈ
rÈÏÈ
ÈÓÓ©²
m©˯Ëä }Óº¹}
vºÏÈ
Ò m ¹º«mÒmËä°« º}ÓË
sºm©®
ºË
m©˯Ëä ¯ËÎÒä zºÓ°¯}º¯ m Ë°mË Ò°ºÓÒ}È ÈÓ
Ó©²Ü Ïȹ¯º°°¹ËmÈË亰sÈÎäËä}Óº¹}
2.
¹º°ãË˺º
}¯ºË°« º}Óº ºËÈ m ¯ËÎÒäË zºÓ°¯}º¯È ¯Ò°  °ºË¯
ÎÈËË ¹°º® äÈ}Ë ºËÈ Ò È}ÒË °¯Ë°mÈ ¯ÈϯÈº}Ò }
¹ÈÓËã ªãËäËÓºm°¹Ò°º}¹ºãË®º}Óº°mº®°m Ò¹ÈÓËãÒÒÓ°¯äËÓ
ºmp°ãÒÓÎÓ©Ë°¯Ë°mÈ¯ÈϯÈº}Òº°°mºÒ²äºÎÓº
m}ãÒ ° ¹ºäº ¹Ó}È äËÓ
ÒãÒ °ººmË°mË®
}Óº¹}Ò ¹ÈÓËãÒ ÒÓ°¯äËÓºm zºÓ°¯}º¯È ºËºm { äÈ}ËË
ºËÈÒÏäËÓÒäÒ¯ÒÓºËÈº°ä¹ºäË°Òm}¯°º¯ä©Ò
ÓÈ¹¯Èm ¯ÈÓÒäÈ}ËÈÒ¹Ë¯ËÈ°}ÒmÈ«¯ÈÓÒ¹¯ÒÓÈÎÈ
º®ãËmº®}Óº¹}Ëä©ÒcÈÏä˯©Ò¯È°¹ºãºÎËÓÒËªãËäËÓºmÓÈ
äÈ}ËË }ºÓ¯ºãÒ¯Ë°« ° ¹ºäº
ãÒÓËË}
Ò
°Ë}Ò
 }ºº¯©Ë
m}ãÈ°«m¹Ó}ËäËÓ
{©˯ËäÓÈ
ÈÓËãÒªãËäËÓºm
ªãËäËÓ
¹Ò°
¯ÈÏäË°Òä
°mººÓ©®ªãËäËÓ
¹Ò°
m¯ÈÏËãËm˯²Ó˺}ºãºÓÒãÈ ºË
ÈÒmmËËämªãËäËÓÏȺãºmº}ºËÈ
ËãÒm ¯Èä} äºÎÓº °ÈÓºmÒ Ó˺²ºÒä©® ¯ÒÁ
sȹ¯Òä˯ °ÈÓºmÒä ¯ÒÁ $ULDO ¯ÈÏä˯ºä  ¹Ó}ºm ¹ºã
ÎÒ¯Ó©® { ¹Ó}Ë äËÓ
nº¯äÈ_cÈÏä˯_º ¯ÈÏä˯ ÈÓÓ©²
ÓÈ
°¯ºÒä¯ÈÏä˯¯Èä}Òm°ººmË°mÒÒ°¯ÈÏä˯ºäÏȺãºm}Èº
ãºmº}äºÎÓº¹Ë¯ËäË°Ò mÓÎÓºËäË°ºm˯²Ó˺}ºãºÓÒãÈ
j°¹ºãÏ« }Óº¹}
_¯ËmȯÒËãÓ©® ¹¯º°äº¯
¹ÈÓËãÒ ÒÓ°
¯äËÓºm äºÎÓº¹º°äº¯Ë}Ëã«Ë ºË¹¯Ò¹Ë
ÈÒ
|¹¯ËËãÒä°ãºmÒ«¯¹¹Ò¯ºm}ÒÒ°º¯Ò¯ºm}ÒÈÓÓ©²mº
ËË«ªººÓÈÎäËä}Óº¹}
vº¯Ò¯ºm}ÈÒ¯¹¹Ò¯ºm}È
¹ÈÓËãÒ
ÒÓ°¯äËÓºmlºÎÓºËã}Ó ¹¯Èmº®}Óº¹}º®ä©Òmãºä
äË°Ë ºËÈ Ò ÒÏ ¹º«mÒm˺°« }ºÓË}°Óºº äËÓ m©¯È
¹Ó}
vº¯Ò¯ºm}ÈÒ¯¹¹Ò¯ºm}È
º«mã«Ë°«º}Óº
vº¯Ò¯ºm}ÈÒ
¯¹¹Ò¯ºm}È
¯Ò°ÈÒämºËËm²¯ºmÓËm ¯¹¹Ò
¯ºm}ÈÓÓ©²°ÓÈÈãÈ¹ºËÓ©ä¯¹¹ÈäÏÈËä¹ºÁÈäÒãÒ«ä
°ËÓºm
ÒmºÏm¯ÈÈ Ò®m°Ë¹ºã«Ó˺­²ºÒä©Ë㫹º°ˆ¯ºËÓÒ«ºˆˈÈ
      vÓÈÈãÈ‚°ˆÈÓºmÒä¹È¯Èäˈ¯©°ˆ¯ÈÓÒ©m©­¯Èm¹‚Ó}ˆäË
Ó nÈ®ã_È¯Èäˈ¯© °ˆ¯ÈÓÒ© sÈ m}ãÈ}Ë |ˆˈ© º}ÓÈ rÈÏÈ
ÈÓÓ©² m©­Ë¯Ëä }Óº¹}‚ vºÏȈ Ò m ¹º«mÒm Ëä°« º}ÓË sºm©®
ºˆˈ m©­Ë¯Ëä ¯ËÎÒä zºÓ°ˆ¯‚}ˆº¯ m }ÈË°ˆmË Ò°ˆºÓÒ}È ÈÓ
Ó©²Ü Ïȹ¯º°°¹ËmÈË亰ˆ sÈÎäËä}Óº¹}‚2.¹º°ãË˺ºˆ
}¯ºËˆ°« º}Óº ºˆˈÈ m ¯ËÎÒäË zºÓ°ˆ¯‚}ˆº¯È ¯Ò°   °º˯
ÎȝËË ¹‚°ˆº® äÈ}ˈ ºˆˈÈ Ò ˆÈ}ÒË °¯Ë°ˆmÈ ¯Èϯȭºˆ}Ò }È}
¹ÈÓËã ªãËäËӈºm°¹Ò°º}¹ºãË®º}Óº°mº®°ˆm Ò¹ÈÓËãÒÒÓ°ˆ¯‚äËÓ
ˆºmp°ãÒӂÎÓ©Ë°¯Ë°ˆmȯÈϯȭºˆ}Òºˆ°‚ˆ°ˆm‚ ˆˆºÒ²äºÎÓº
m}ã ҈ ° ¹ºäº  ¹‚Ó}ˆÈ äËÓ {Ò ÒãÒ °ººˆmˈ°ˆm‚ Ë®
}Óº¹}Ò ¹ÈÓËãÒ ÒÓ°ˆ¯‚äËӈºm zºÓ°ˆ¯‚}ˆº¯È ºˆˈºm { äÈ}ˈË
ºˆˈÈÒÏäËÓÒä Ò¯ÒӂºˆˈȺ°ä¹ºäË°ˆÒm}‚¯°º¯ä© Ò
ÓÈ ¹¯Èm‚ ¯ÈÓÒ‚ äÈ}ˈÈ Ò ¹Ë¯ËˆÈ°}ÒmÈ«  ¯ÈÓÒ‚ ¹¯Ò ÓÈÎÈ
ˆº®ãËmº®}Óº¹}Ëä© ÒcÈÏä˯©Ò¯È°¹ºãºÎËÓÒ˪ãËäËӈºmÓÈ
äÈ}ˈË }ºÓˆ¯ºãÒ¯‚ˈ°« ° ¹ºäº  ãÒÓËË} Ò °Ëˆ}Ò }ºˆº¯©Ë
m}ã È ˆ°«m¹‚Ó}ˆËäËÓ {Ò
      {©­Ë¯ËäÓȁÈÓËãÒªãËäËӈºm ªãËäËӈsȹҰ  ¯ÈÏäË°ˆÒä
°mº­ºÓ©®ªãËäËӈsȹҰ m¯ÈÏËãËm˯²Ó˺}ºãºÓˆÒˆ‚ãÈ ºˆË
ˆÈÒmmËËämªãËäËӈÏȺãºmº}ºˆˈÈ
      {©ËãÒm ¯Èä}‚ äºÎÓº ‚°ˆÈÓºm҈ Ó˺­²ºÒä©® ¯ÒÁˆ
sȹ¯Òä˯ ‚°ˆÈÓºmÒä ¯ÒÁˆ $ULDO ¯ÈÏä˯ºä  ¹‚Ó}ˆºm ¹ºã‚
ÎÒ¯Ó©® { ¹‚Ó}ˆË äËÓ nº¯äȈ_cÈÏä˯_º ¯ÈÏä˯‚ ÈÓÓ©² ÓÈ
°ˆ¯ºÒä¯ÈÏä˯¯Èä}Òm°ººˆmˈ°ˆmÒÒ°¯ÈÏä˯ºäÏȺãºm}È~Ⱥ
ãºmº}äºÎÓº¹Ë¯ËäË°ˆÒˆ mӂÎÓºËäË°ˆºm˯²Ó˺}ºãºÓˆÒˆ‚ãÈ
j°¹ºã ς« }Óº¹}‚ {Ò_¯Ëmȯ҈Ëã Ó©® ¹¯º°äºˆ¯ ¹ÈÓËãÒ ÒÓ°ˆ
¯‚äËӈºm äºÎÓº¹º°äºˆ¯Ëˆ }È}­‚ˈm©ã«ˈ ºˆˈ¹¯Ò¹Ë
ȈÒ
      |¹¯ËËãÒä‚°ãºmÒ«¯‚¹¹Ò¯ºm}ÒÒ°º¯ˆÒ¯ºm}ÒÈÓÓ©²mºˆ
ˈËi㫪ˆººÓÈÎäËä}Óº¹}‚vº¯ˆÒ¯ºm}ÈÒ¯‚¹¹Ò¯ºm}È ¹ÈÓËãÒ
ÒÓ°ˆ¯‚äËӈºmlºÎÓºËã}ӂˆ ¹¯Èmº®}Óº¹}º®ä© Òmã ­ºä
äË°ˆË ºˆˈÈ Ò ÒÏ ¹º«mÒm ˺°« }ºÓˆË}°ˆÓºº äËÓ      m©­¯Èˆ
¹‚Ó}ˆvº¯ˆÒ¯ºm}È Ò ¯‚¹¹Ò¯ºm}È º«mã«Ëˆ°« º}Óº vº¯ˆÒ¯ºm}È Ò
¯‚¹¹Ò¯ºm}È ¯Ò° ~ÈÈÒämºˆˈËm‚²‚¯ºmÓËm‚ ¯‚¹¹Ò
¯ºm}‚ÈÓÓ©²°ÓÈÈãȹº‚˭ө䯂¹¹ÈäÏȈË乺ÁÈäÒãÒ«ä
°ˆ‚Ëӈºm