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

UptoLike


ÒÓ°¯äËÓºm ÒãÒäËÓ
 ÈÈ}ÎË°¹ºäº }Óº¹}Ò
|
}¯©
m}ãÈ}Ò
~ȹ¯º°© |}ÓÈÈÏ©ÈÓÓ©²
|¯ÈÒË mÓÒäÈÓÒË º ¹Ë¯Ë}ãÈ«° äËÎ ¯ËÎÒäÈäÒ
zºÓ°¯}º¯64/ äºÎÓº ¹º°äº¯Ë } ã«Ò ÓÈ 64/ ÏÈ
¹¯º°°Áº¯äÒ¯ºmÈÓÓ©®zºÓ°¯}º¯ºäÒÓȺº¯ºmÒ Ïȹ¯º°È
º¹¯ËËã«Ë°« m ¹Ó}Ë äËÓ
~ȹ¯º°
 ËÓÒË °º°Èmã«Ë
¹¯Èmã«Ò® Ïȹ¯º° ÓÈ °ºÏÈÓÒË ÈãÒ© }ºº¯©® ºÓº°Ò°« }
È}ÓÈÏ©mÈËä©ä°¹ËÒÁÒ˰}ÒäÏȹ¯º°Èä64/ Ò°ºÏÈË°«ºã}º
°¯Ë°mÈäÒ 64/ sË}ºº¯ºË ÓËº°mº °º°ºÒ m ºä º Ó
°¯}º¯ Áº¯äÈãÓººÈmã«ËmÏȹ¯º°ÓÈ64/ ãÒÓÒË°}º

sÈm}ãÈ}Ë
~ȹ¯º°
º}ÓÈ
rÈÏÈ
ÈÓÓ©²
Ïȹ¯º°©ÓÈ°ºÏÈÓÒËÒ
ÒÏäËÓËÓÒË ÈãÒ ººÏÓÈÈ°« °¹ËÒÈãÓ©äÒ ÏÓÈäÒ ºãÒ
ÈÒäÒ°«ºÏÓÈmÏȹ¯º°ºmÓÈm©º¯}
¹¯Èmã«Ò®Ïȹ¯º°ÓÈ°ºÏÈÓÒËÈãÒ©
jÓ°¯}Ò« °ºÏÈÓÒ« Óºmº® ÈãÒ© ÓÈÏ©mÈË°« m $FFHVV
¹¯Èmã«Òä Ïȹ¯º°ºä ÒÒäËËÁº¯äÈ
&5($7(7$%/(lZ[ebpZ!ihe_!lbi!>jZaf_j!@
>12718//@>h]jZgbq_gby gZ ihe_!@
>ihe_!lbi!>jZaf_j!@
>12718//@>h]jZgbq_gby gZ ihe_!@>@@
>&21675$,17h]jZgbq_gby gZ lZ[ebpm!>@@
~˰ ÒÈãËË¹¯Òº¹Ò°ÈÓÒÒ°ÒÓÈ}°Ò°È¹¯ÒÓ«©°ãËÒË
ººÏÓÈËÓÒ«{ä˰º°ãºmmãºm©²°}º}ȲÓ˺²ºÒäº}ÈÏÈ
ÒäËÓÈ¯ËÈãÓ©²ÈãÒ°ºãºmÒ ¹ äËÓ©}ÈÏÈÓÓ©Ëm
¹¯«ä©² °}º}Ȳ ÓË «mã«°« º«ÏÈËãÓ©äÒ p°ãÒ }ÈÏÈÓº ÓË
°}ºã}ºȯäËÓºm¯ÈÏËãËÓÓ©²°Òämºãºä_ºäºÎÓºÒ°¹ºã
ϺmÈ ºã}ººÒÓȯäËÓ¯Ó©Ë°}º}ÒººÏÓÈÈ°¹Ò
°º}ªãËäËÓºmÏȹҰÈÓÓ©²˯ËÏÏȹ«
{ÒÓ°¯}ÒÒ
&5($7( 7$%/(
¹¯ÒÓ«©°ãËÒËººÏÓÈ
ËÓÒ«
lZ[ebpZ
! Ü ªº Òä« °ºÏÈmÈË亮 ÈãÒ©
ihe_
!
ihe_
!Ü ÒäËÓÈ¹ºãË®°ºÏÈmÈË䩲mÓºmº®ÈãÒËÈãÒÈ
ºãÎÓÈ°ºË¯ÎÈ ²º«©ºÓº¹ºãË
lbi
!Ü Ò¹ÈÓÓ©²¹ºã«
ÈË m°Ëº Ò°¹ºãÏ°« °ãËÒË Ò¹© ÈÓÓ©²
7(;7Q±
Ë}°ºm©®Ò¹ãÒÓº®
Q
°Òämºãºm
,17(*(5 ±
ãÒÓÓºËËãºË

5($/
±
Ò°ãºmº® ° ¹ãÈmÈË® º® ãÒÓº®  È®È

)/2$7
Ü
ÒÓ°ˆ¯‚äËӈºm ÒãÒ äËÓ {Ò  È ˆÈ}ÎË ° ¹ºäº  }Óº¹}Ò |ˆ
}¯©ˆ m}ãÈ}Ò~ȹ¯º°© |}ÓÈ­ÈÏ©ÈÓÓ©²
     |­¯ÈˆÒˆË mÓÒäÈÓÒË ˆº ¹Ë¯Ë}ã È«° äË΂ ¯ËÎÒäÈäÒ
zºÓ°ˆ¯‚}ˆº¯64/ äºÎÓº ¹º°äºˆ¯Ëˆ  }È} m©ã«҈ ÓÈ 64/ ÏÈ
¹¯º°°Áº¯äÒ¯ºmÈÓÓ©®zºÓ°ˆ¯‚}ˆº¯ºäÒÓȺ­º¯ºˆ mÒ Ïȹ¯º°È
º¹¯ËËã«Ëˆ°« m ¹‚Ó}ˆË äËÓ    ~ȹ¯º°  j°}ã ËÓÒË °º°ˆÈmã«Ëˆ
‚¹¯Èmã« Ò® Ïȹ¯º° ÓÈ °ºÏÈÓÒË ˆÈ­ãÒ© }ºˆº¯©® ºˆÓº°Òˆ°« }
ˆÈ}ÓÈÏ©mÈËä©ä°¹ËÒÁÒ˰}ÒäÏȹ¯º°Èä 64/ Ò°ºÏÈˈ°«ˆºã }º
°¯Ë°ˆmÈäÒ 64/ sË}ºˆº¯ºË Ó˂º­°ˆmº °º°ˆºÒˆ m ˆºä ˆº zºÓ
°ˆ¯‚}ˆº¯ Áº¯äÈã Óºº­Èmã«ËˆmÏȹ¯º°ÓÈ64/ ãÒ ÓÒ˰}º­
}Ò
     sÈ m}ãÈ}Ë ~ȹ¯º° º}ÓÈ rÈÏÈ ÈÓÓ©² Ïȹ¯º°© ÓÈ °ºÏÈÓÒË Ò
ÒÏäËÓËÓÒË ˆÈ­ãÒ º­ºÏÓÈÈ ˆ°« °¹ËÒÈã Ó©äÒ ÏÓÈ}ÈäÒ ºˆãÒ
È ÒäÒ°«ºˆÏÓÈ}ºmÏȹ¯º°ºmÓÈm©­º¯}‚

         ¹¯Èmã« Ò®Ïȹ¯º°ÓȰºÏÈÓÒˈȭãÒ©

     jÓ°ˆ¯‚}Ò« °ºÏÈÓÒ« Óºmº® ˆÈ­ãÒ© ÓÈÏ©mÈˈ°« m $FFHVV
‚¹¯Èmã« Òä Ïȹ¯º°ºä ÒÒäËˈÁº¯äȈ
&5($7(7$%/(lZ[ebpZ! ihe_!lbi!> jZaf_j! @
>12718//@>h]jZgbq_gby gZ ihe_!@
>ihe_!lbi!> jZaf_j! @
>12718//@>h]jZgbq_gby gZ ihe_!@>@@
>&21675$,17h]jZgbq_gby gZ lZ[ebpm!>@@ 
     ~˰ ÒÈãË˹¯Òº¹Ò°ÈÓÒÒ°ÒӈÈ}°Ò°È¹¯ÒÓ«ˆ©°ãË‚ ÒË
º­ºÏÓÈËÓÒ«{ä˰ˆº°ãºmm‚ãºm©²°}º­}ȲÓ˺­²ºÒ亂}ÈÏȈ
ÒäËÓȯËÈã Ó©²ˆÈ­ãÒ°ˆºã­ºmÒˆ ¹ k¯‚äËӈ©‚}ÈÏÈÓÓ©Ëm
¹¯«ä©² °}º­}Ȳ ÓË «mã« ˆ°« º­«ÏȈËã Ó©äÒ p°ãÒ ‚}ÈÏÈÓº ÓË
°}ºã }ºȯ‚äËӈºm¯ÈÏËãËÓÓ©²°Òämºãºä _ ˆºäºÎÓºÒ°¹ºã 
ϺmȈ ˆºã }ººÒÓȯ‚äËӈnÒ‚¯Ó©Ë°}º­}Òº­ºÏÓÈÈ ˆ°¹Ò
°º}ªãËäËӈºmÏȹҰÈÓÓ©²˯ËÏÏȹ«ˆ‚ 
     { ÒÓ°ˆ¯‚}ÒÒ &5($7( 7$%/( ¹¯ÒÓ«ˆ©°ãË‚ Ò˺­ºÏÓÈ
ËÓÒ« lZ[ebpZ! Ü ªˆº Òä« °ºÏÈmÈË亮 ˆÈ­ãÒ© ihe_!
ihe_! Ü ÒäËÓÈ ¹ºãË® °ºÏÈmÈË䩲 m Óºmº® ˆÈ­ãÒË ˆÈ­ãÒÈ
ºãÎÓȰº˯ÎȈ ²ºˆ«­©ºÓº¹ºãË lbi!Ü ˆÒ¹ÈÓÓ©²¹ºã«
  ȝË m°Ëº Ò°¹ºã ς ˆ°« °ãË‚ ÒË ˆÒ¹© ÈÓÓ©² 7(;7 Q ±
ˆË}°ˆºm©® ˆÒ¹ ãÒÓº® Q °Òämºãºm ,17(*(5 ± ãÒÓÓºË ËãºË
5($/ ± Ò°ãºmº® ° ¹ãÈmÈ Ë® ˆº}º® ãÒÓº®  ­È®ˆÈ )/2$7 Ü