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

UptoLike


Ò¹¹ºã«m©Ò¯ÈË°«ÒÏm©¹ÈÈ˺°¹Ò°}È}ºº¯©®¹º«m
ã«Ë°«¹¯ÒËã}Ëä©¹º}Óº¹}Ëm°ºãË
Ò¹ÈÓÓ©²
¯Ò
ÏÈÈÓÒÒ°mº®°m¹ºãË®¯ÈϯÈºÒ}ÈãÒ ºmºãÓºÈ°º¹¯Ò
²ºÒ°« ¹ºãϺmÈ°« °˯ºä ¹º°ÈÓºmº} Ò º°¯ºÒËãËä
m©¯ÈÎËÓÒ® È} ã« ºË°¹ËËÓÒ« m©º¯È ÏÓÈËÓÒ« ¹ºã« ¯¹¹È
ÈãÒ©vipsÒÏ°¹Ò°}ÈÏÓÈËÓÒ®Ó˺²ºÒäº°ËãÈ °ãË
ËË
x
m©¯È m}ãÈ}
º°ÈÓºm
mÓÒÎÓË®È°Òº}ÓÈm°¯º}Ë
Ò¹ ªãËäËÓÈ ¹¯ÈmãËÓÒ«
m©¯È ÒÏ m©¹ÈÈ˺ °¹Ò°}È
¹º«mã«Ë°« ¹¯Ò mº®Óºä Ëã}Ë ä© m °¯º}Ë ÏÓÈË
ÓÒËv¹Ò°º}
x
m°¯º}Ë
Ò¹Ò°ºÓÒ}È°¯º}
m©¯È ÒÏm©¹ÈÈ˺°¹Ò
°}ÈÏÓÈËÓÒËv¹Ò°º}ÏÓÈËÓÒ®
x
m°¯º}Ë
j°ºÓÒ}°¯º}
ÏÈÈ °¹Ò°º}ÏÓÈËÓÒ®Ùk|µ
ÙkwµÙkwµ
kÓÈãºÒÓº °ãËË¹º°¹Ò Òã«ºË°¹ËËÓÒ«m©º¯ÈÏÓÈË
ÓÒ«¹ºã«ºã ÈãÒ©vipsÒÏ°¹Ò°}ÈÏÓÈËÓÒ®ÙlµÙyµ
º©ºË°¹ËÒ ¹¯ºm˯}mmºÒ䩲ÏÓÈËÓÒ®¹ºã«|ËÓ
ÈãÒ© vp{kpl|ve ÓÈ ¹¯ÒÓÈãËÎÓº° ÏÈÈÓÓºä
ÒȹÈϺÓ >@ Ó˺²ºÒäº ÏÈÈ Ó˺²ºÒäºË m©¯ÈÎËÓÒË m
Ë°mËÏÓÈËÓÒ«°mº®°mÈ
°ãºmÒËÓÈÏÓÈËÓÒË
ªºº¹ºã««
ªººÓÎÓºm©ÏmÈ º°¯ºÒËã m©¯ÈÎËÓÒ®Ëã}Ómä©m
¹ºãË ÏÈÈÓÒ« ÏÓÈËÓÒ« °mº®°mÈ È ÏÈËä ËË ¯ÈÏ Ü ¹º ¹º«mÒm
Ë®°« }Óº¹}Ë « ÓÈ˺ °ãÈ« ªº äºÎË © Óȹ¯Òä˯
m©¯ÈÎËÓÒË%HWZHHQ$QG
¯Ò ÏÈÈÓÒÒ °mº®°m ¹ºã« iÈÈ ¯ºÎËÓÒ« ÈãÒ©
vips°ÈÓºmÒäÏÓÈËÓÒË¹ºäºãÈÓÒ
«m°Ë²¹ºãË®ÈãÒ ÈÏ©ÈÓÓ©²sj{pcvjpºäË
¹ºã«ËãËÁºÓ°ÈÓºäã« °mº®°mÈ
|«ÏÈËãÓºË¹ºãË
ÏÓÈË
ÓÒËwººÏÓÈÈËºÈ}ÒË¹ºã«º«ÏÈËãÓººãÎÓ©°ºË¯
ÎÈ ÈÓÓ©Ë
 °ÈÓºmÒ ÒÓË}°©
«¹ºãË®nÈäÒãÒ« ÈãÒ©vipssÈÏmÈÓÒË Ò¯Ë¹º
ÈmÈËã ÈãÒ©ijv¡jjsk mË°mË ÏÓÈËÓÒ® °mº®°mÈ
Ë}°Ò¯ºmÈÓÓºË¹ºãË
ÏÈÈÒä iº¹°}È°«°ºm¹ÈËÓÒ«
 °ÈÓºmÒ ¹Ë¯mÒÓ©®
«ªººÓ˺²ºÒäºm©¯È ¹ºãË«mã«ËË°« ºäÒ
ÓÈÎÈ }Óº¹} ° ÒϺ¯ÈÎËÓÒËä È ÓÈ ¹ÈÓËãÒ ÒÓ°¯äËÓºm
     ‘Ò¹¹ºã«m©­Ò¯Èˈ°«ÒÏm©¹ÈÈ Ëº°¹Ò°}È}ºˆº¯©®¹º«m
ã«Ëˆ°«¹¯ÒËã}Ëä©        ¹º}Óº¹}Ëm°ˆºã­Ë‘Ò¹ÈÓÓ©²¯Ò
ÏÈÈÓÒÒ°mº®°ˆm¹ºãË®¯ÈϯȭºˆÒ}‚ˆÈ­ãÒ ºmºã ӺȰˆº¹¯Ò
²º҈ °« ¹ºã ϺmȈ °« lÈ°ˆË¯ºä ¹º°ˆÈÓºmº} Ò º°ˆ¯ºÒˆËãËä
m©¯ÈÎËÓÒ® ‘È} ã« º­Ë°¹ËËÓÒ« m©­º¯È ÏÓÈËÓÒ« ¹ºã« €¯‚¹¹È
ˆÈ­ãÒ©v‘ips‘ÒÏ°¹Ò°}ÈÏÓÈËÓÒ®Ó˺­²ºÒ亰ËãȈ °ãË
‚ ËË
   x m©­¯Èˆ m}ãÈ}‚º°ˆÈÓºm}È mÓÒÎÓˮȰˆÒº}ÓÈm°ˆ¯º}Ë
     ‘Ò¹ ªãËäËӈÈ ‚¹¯ÈmãËÓÒ« m©­¯Èˆ ÒÏ m©¹ÈÈ Ëº °¹Ò°}È
      ¹º«mã«Ëˆ°« ¹¯Ò mº®Óºä Ëã}Ë ä©          m °ˆ¯º}Ë  ÏÓÈË
     ÓÒËv¹Ò°º}
   x m°ˆ¯º}Ë‘Ò¹Ò°ˆºÓÒ}È°ˆ¯º} m©­¯Èˆ ÒÏm©¹ÈÈ Ëº°¹Ò
     °}ÈÏÓÈËÓÒËv¹Ò°º}ÏÓÈËÓÒ®
   x m°ˆ¯º}Ëj°ˆºÓÒ}°ˆ¯º} ÏÈȈ °¹Ò°º}ÏÓÈËÓÒ®Ùk|µ
     ÙkwµÙkwµ
kÓÈãºÒÓº °ãË‚ˈ ¹º°ˆ‚¹Òˆ Ò ã« º­Ë°¹ËËÓÒ« m©­º¯È ÏÓÈË
ÓÒ«¹ºã«ºã ˆÈ­ãÒ©v‘ips‘ÒÏ°¹Ò°}ÈÏÓÈËÓÒ®ÙlµÙyµ
       ˆº­©º­Ë°¹Ë҈ ¹¯ºm˯}‚mmºÒ䩲ÏÓÈËÓÒ®¹ºã«|ËÓ
}È ˆÈ­ãÒ© vp{kpl|v‘e ÓÈ ¹¯ÒÓÈãËÎÓº°ˆ ÏÈÈÓÓºä‚
ÒȹÈϺӂ >@ Ó˺­²ºÒäº ÏÈȈ Ó˺­²ºÒäºË m©¯ÈÎËÓÒË m
}ÈË°ˆmËÏÓÈËÓÒ«°mº®°ˆmȐ°ãºmÒËÓÈÏÓÈËÓÒ˪ˆºº¹ºã«iã«
ªˆººӂÎÓºm©ÏmȈ º°ˆ¯ºÒˆËã m©¯ÈÎËÓÒ®Ëã}ӂmä©                 m
¹ºãË ÏÈÈÓÒ« ÏÓÈËÓÒ« °mº®°ˆmÈ È ÏȈËä ˝Ë ¯ÈÏ Ü ¹º ¹º«mÒm
  Ë®°« }Óº¹}Ë iã« ÓÈ Ëº °ã‚È« ªˆº äºÎˈ ­©ˆ  Óȹ¯Òä˯
m©¯ÈÎËÓÒË%HWZHHQ$QG
     ¯Ò ÏÈÈÓÒÒ °mº®°ˆm ¹ºã« iȈÈ ¯ºÎËÓÒ« ˆÈ­ãÒ©
v‘ips‘‚°ˆÈÓºmÒäÏÓÈËÓÒ˹º‚äºãÈÓÒ 
     iã«m°Ë²¹ºãË®ˆÈ­ãÒ ­ÈÏ©ÈÓÓ©²sj{pcvj‘p‘}¯ºäË
¹ºã« ‘ËãËÁºÓ ‚°ˆÈÓºmÒä ã« °mº®°ˆmÈ |­«ÏȈËã ÓºË ¹ºãË ÏÓÈË
ÓÒËiÈwˆººÏÓÈÈˈˆºˆÈ}Ò˹ºã«º­«ÏȈËã ÓººãÎÓ©°º˯
ÎȈ ÈÓÓ©Ë
         °ˆÈÓºm҈ ÒÓË}°©
     iã« ¹ºãË® nÈäÒãÒ« ˆÈ­ãÒ© v‘ips‘ sÈÏmÈÓÒË Ò ¯Ë¹º
ÈmȈË㠈ȭãÒ© ijv¡jjsk m }ÈË°ˆmË ÏÓÈËÓÒ® °mº®°ˆmÈ
jÓË}°Ò¯ºmÈÓӺ˹ºãË ÏÈÈÒäiÈ iº¹‚°}È ˆ°«°ºm¹ÈËÓÒ« 
         °ˆÈÓºm҈ ¹Ë¯mÒÓ©®}ã 
     i㫪ˆººÓ˺­²ºÒäºm©­¯Èˆ ¹ºãË«mã« ËË°«}ã ºäÒ
ÓÈÎȈ }Óº¹}‚ ° ÒϺ­¯ÈÎËÓÒËä }ã È ÓÈ ¹ÈÓËãÒ ÒÓ°ˆ¯‚äËӈºm