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

UptoLike


¹ºã«ÈãËÓÓº®ÒÏÏȹ¯º°ÈÈãÒ©¹ºäËËÓÓ©ËmãÈÓ}Ïȹ¯º
°È
º°¯Ë°mºä }¯Ò˯ÒËmºº¯È¹ºãϺmÈËã }ÈÏ©mÈË}È
ËÏȹҰÒÓÎÓºm©Ò¯È mÈãÒȲÒºº¯ÈÎÈ m¯ËÏãÈ
Ȳ ¹ºÒ°}È z¯Ò˯ÒÒ ºº¯È }ÈÏ©mÈ°« ã« ºÓºº ÒãÒ ÓË
°}ºã²¹ºãË®
nº¯äÒ¯Ëä©® m ÓÈËä ¹¯Òä˯Ë Ïȹ¯º° ºãÎËÓ ºÒ¯È
ÈÓÓ©Ë º °ËÓȲ ¯¹¹© k| ¹ºãÒmÒ² ¹º Ò°Ò¹ãÒÓË
ÙnÒÏÒ}ȵºËÓ}ÒÙµÒãÒÙµºªºäã«¹Ë¯ËÒ°ãËÓÓ©²ÓÒÎË
¹ºãË® °ÈÓºmÒä m °¯º}Ë
°ãºmÒË ºº¯È
ãÈÓ}È Ïȹ¯º°È È}ÒË
}¯Ò˯ÒÒºº¯È
¯¹¹È k|
sÈÏmÈÓÒË nÒÏÒ}È
|ËÓ}È 2U
vÓÈÈãÈmmËËä}¯Ò˯Үã«¹ºã«¯¹¹È Ü k|º°ãË
mmºÈ ÓÈÎäËä }ãÈmÒ
(QWHU
 m°ãË°Ë ˺ $FFHVV ¹¯ºm˯Ò
¹¯ÒÓÈãËÎÓº° ªºº ÏÓÈËÓÒ« ÏÈÈÓÓºä °¹Ò°} k|
kwkwÒÈmºäÈÒË°}ÒÏÈ}ãÒ˺m}Èm©~È
Ëä¹Ë¯Ë®Ëäm«Ë®}ÓÈ¹Ë¯Ë°ËËÓÒÒ°¯º}Ò
°ãºmÒËºº¯È
Ò
°ºãÈsÈÏmÈÓÒË ÒmmËËäÏÓÈËÓÒËnÒÏÒ}Èm}Èm©²ÒãÒ
ËÏ}Èm©Ë}sÈ}ºÓËÏÈÈÒä}¯Ò˯Үã«¹ºã«|ËÓ}È2U
$FFHVV ÈmºäÈÒË°}Ò¹¯ºm˯Ò°ÒÓÈ}°Ò°ªººm©¯ÈÎËÓÒ«Ò
m°ãÈË˺ÓȯËÓÒ«È°°ººËÓÒËººÒ}Ë
¯Òm©¹ºãÓËÓÒÒÏȹ¯º°ÈÏȹҰÒäº© º°º¯Ò¯ºmÈÓ©
¹ºÈãÁÈmÒm¹º¯«}ËmºÏ¯È°ÈÓÒ«ÒãÒ©mÈÓÒ«ã«Ò°ãºm©²
¹ºãË®ÎÓººÓºm¯ËäËÓÓº¹¯ºÒÏmºÒ °º¯Ò¯ºm}¹º°ºË¯
ÎÒäºä ÓË°}ºã² ¹ºãË® º Ë°«Ò « m©¹ºãÓËÓÒ« °º¯Ò
¯ºm}Ò °ãËË ¹Ë¯Ë®Ò m °ºãË ãÈÓ}È Ïȹ¯º°È °ºË¯ÎÈÒ®
Òä« ¹ºã« ¹º }ºº¯ºä Ó˺²ºÒäº ¹¯ºÒÏmË°Ò °º¯Ò¯ºm} Ò
}ÈÏÈ °¹º°º °º¯Ò¯ºm}Ò m °¯º}Ë
vº¯Ò¯ºm}È
 ¯Ò m©¹ºãÓË
ÓÒÒ Ëã}È ÓÈ ªº® °¯º}Ë ¹º«mã«Ë°« ¹ºãË °¹Ò°}È ° ¹Ë¯ËÓËä
°¹º°ººm°º¯Ò¯ºm}Ò¯ÒÏÈ}¯©ÒÒº}ÓÈzºÓ°¯}º¯È Ïȹ¯º°ºm
$FFHVV ¹Ë¯ËäËÈË¹ºã«°ÏȹºãÓËÓÓº®«Ë®®
vº¯Ò¯ºm}È
mãË
m È° ãÈÓ}ÈÏȹ¯º°È
{ ÏÈm˯ËÓÒË º°º¯Ò¯Ëä ÁÈäÒãÒÒ °ËÓºm m ÈãÁÈmÒ
Óºä ¹º¯« « ªºº ¹Ë¯Ë®Ëä m °ºãË °ºË¯ÎÈÒ® ¹ºãË
nÈäÒãÒ« ¹ºãÓÒä Ëãº} m °¯º}Ë
vº¯Ò¯ºm}È
Ò m ¹º«mÒm
Ëä°«°¹Ò°}Ëm©˯Ëä°¹º°º°º¯Ò¯ºm}Ò¹ºmºÏ¯È°ÈÓÒ Ë°ãÒ
¹ºã«‚ÈãËÓÓº®ÒÏÏȹ¯º°ÈˆÈ­ãÒ©¹ºä˝ËÓÓ©Ëm­ãÈÓ}Ïȹ¯º
°È
      º°¯Ë°ˆmºä }¯ÒˆË¯ÒËm ºˆ­º¯È ¹ºã ϺmȈË㠂}ÈÏ©mÈˈ }È
}ÒËÏȹҰÒӂÎÓºm©­Ò¯Èˆ mˆÈ­ãÒȲÒºˆº­¯ÈÎȈ m¯Ëς㠈È
ˆÈ² ¹ºÒ°}È z¯ÒˆË¯ÒÒ ºˆ­º¯È ‚}ÈÏ©mÈ ˆ°« ã« ºÓºº ÒãÒ ÓË
°}ºã }Ò²¹ºãË®
      nº¯äÒ¯‚Ëä©® m ÓÈ Ëä ¹¯Òä˯Ë Ïȹ¯º° ºãÎËÓ ºˆ­Ò¯Èˆ
ÈÓÓ©Ë º °ˆ‚ËӈȲ ¯‚¹¹© k| ¹ºã‚Òm Ò² ¹º Ò°Ò¹ãÒÓË
ÙnÒÏÒ}ȵºËÓ}ÒÙµÒãÒÙµºªˆºä‚㫹˯ËÒ°ãËÓÓ©²ÓÒÎË
¹ºãË® ‚°ˆÈÓºmÒä m °ˆ¯º}Ë °ãºmÒË ºˆ­º¯È ­ãÈÓ}È Ïȹ¯º°È ˆÈ}ÒË
}¯ÒˆË¯ÒÒºˆ­º¯È
     €¯‚¹¹È k|
     sÈÏmÈÓÒË nÒÏÒ}È
     |ËÓ}È 2U 
      vÓÈÈãÈ mmËËä }¯ÒˆË¯Ò® ã« ¹ºã« €¯‚¹¹È Ü k| º°ãË
mmºÈ ÓÈÎäËä }ãÈmÒ ‚ (QWHU m°ãË°ˆmÒË Ëº  $FFHVV ¹¯ºm˯҈
¹¯ÒÓÈãËÎÓº°ˆ ªˆºº ÏÓÈËÓÒ« ÏÈÈÓÓºä‚ °¹Ò°}‚ k|
kw kw  Ò ÈmˆºäȈÒË°}Ò ÏÈ}ã ҈ ˺ m }Èm©}Ò ~È
ˆËä ¹Ë¯Ë®Ëä m «Ë®}‚ ÓÈ ¹Ë¯Ë°ËËÓÒÒ °ˆ¯º}Ò °ãºmÒË ºˆ­º¯È Ò
°ˆºã­ÈsÈÏmÈÓÒË ÒmmËËäÏÓÈËÓÒËnÒÏÒ}È m}Èm©}ȲÒãÒ
­ËÏ}Èm©Ë} sÈ}ºÓËÏÈÈÒä}¯ÒˆË¯Ò®ã«¹ºã«|ËÓ}È2U
$FFHVV ÈmˆºäȈÒË°}Ò¹¯ºm˯҈°ÒӈÈ}°Ò°ªˆººm©¯ÈÎËÓÒ«Ò
m°ã‚ÈË˺Óȯ‚ ËÓÒ«m©È°ˆ°ºº­ËÓÒ˺­º Ò­}Ë
      ¯Òm©¹ºãÓËÓÒÒÏȹ¯º°ÈÏȹҰÒ亂ˆ­©ˆ ºˆ°º¯ˆÒ¯ºmÈÓ©
¹ºÈãÁÈm҈‚m¹º¯«}ËmºÏ¯È°ˆÈÓÒ«ÒãÒ‚­©mÈÓÒ« ã«Ò°ãºm©²
¹ºãË® lºÎÓººÓºm¯ËäËÓÓº¹¯ºÒÏmº҈ °º¯ˆÒ¯ºm}‚¹º°º˯
ÎÒäºä‚ ÓË°}ºã }Ò² ¹ºãË® º Ë°«ˆÒ  iã« m©¹ºãÓËÓÒ« °º¯ˆÒ
¯ºm}Ò °ãË‚ˈ ¹Ë¯Ë®ˆÒ m °ˆºã­Ë ­ãÈÓ}È Ïȹ¯º°È °º˯ÎȝҮ
Òä« ¹ºã« ¹º }ºˆº¯ºä‚ Ó˺­²ºÒäº ¹¯ºÒÏmË°ˆÒ °º¯ˆÒ¯ºm}‚ Ò
‚}ÈÏȈ °¹º°º­ °º¯ˆÒ¯ºm}Ò m °ˆ¯º}Ë vº¯ˆÒ¯ºm}È ¯Ò m©¹ºãÓË
ÓÒÒ Ëã}È ÓÈ ªˆº® °ˆ¯º}Ë ¹º«mã«Ëˆ°« ¹ºãË °¹Ò°}È ° ¹Ë¯ËÓËä
°¹º°º­ºm°º¯ˆÒ¯ºm}ҁ¯ÒÏÈ}¯©ˆÒÒº}ÓÈzºÓ°ˆ¯‚}ˆº¯È Ïȹ¯º°ºm
$FFHVV ¹Ë¯Ëä˝Èˈ¹ºã«°ÏȹºãÓËÓÓº®«Ë®}º®vº¯ˆÒ¯ºm}È mãË
m‚ È°ˆ ­ãÈÓ}ÈÏȹ¯º°È
      { ÏÈm˯ ËÓÒË ºˆ°º¯ˆÒ¯‚Ëä ÁÈäÒãÒÒ °ˆ‚Ëӈºm m ÈãÁÈm҈
Óºä ¹º¯«}Ë iã« ªˆºº ¹Ë¯Ë®Ëä m °ˆºã­Ë °º˯ÎȝҮ ¹ºãË
nÈäÒãÒ«  m©¹ºãÓÒä Ëãº} m °ˆ¯º}Ë vº¯ˆÒ¯ºm}È Ò m ¹º«mÒm
  Ëä°«°¹Ò°}Ëm©­Ë¯Ëä°¹º°º­°º¯ˆÒ¯ºm}Ò¹ºmºÏ¯È°ˆÈÓÒ          Ë°ãÒ