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

UptoLike


)520Klm^_gl ,11(5-2,1
>bkpbiebgZ ,11(5-2,1Mki_\Z_fhklv
21>bkpbiebgZ>Dh^ ^bkpbiebgu@
Mki_\Z_fhklv>Dh^ ^bkpbiebgu@21Klm^_glAZq_ldZ
Mki_\Z_fhklvAZq_ldZ
|¹Ë¯ÈÒÒ
/()7 -2,1
ÒãÒ
5,*+7 -2,1
°ä ÓÒÎË äº
© mãºÎËÓ© m º¹Ë¯ÈÒ
,11(5 -2,1
 Óº º¹Ë¯ÈÒ«
,11(5
-2,1
ÓËäºÎË© ºÎËÓÈm
/()7-2,1
ÒãÒ
5,*+7-2,1
cËÎË Ò°¹ºãÏË°« mÓËÓËË ºËÒÓËÓÒË ÈãÒ |¹Ë¯ÈÒ«
/()7 -2,1
°ºÏÈË ãËmºË mÓËÓËË ºËÒÓËÓÒË ¹¯Ò }ºº¯ºä Ë
ÏȹҰÒÒÏÈãÒ©°º«Ë®mãËmº®È°Òº¹Ë¯ÈÒÒm}ã È°«
m¯ËÏãÒ¯Ò®ÓÈº¯~ȹҰÒÈãÒ©¯È°¹ºãºÎËÓÓº®°¹¯È
mÈ º º¹Ë¯ÈÒÒ ºËÒÓ«°« ° ÏȹҰ«äÒ ÒÏ ¯È°¹ºãºÎËÓÓº®
°ãËmÈÈãÒ©ºã}º¹¯ÒÓÈãÒÒÒ°ºm¹ÈÈÒ²ÏÓÈËÓÒ®m¹º
㫲 °m«ÏÒ p°ãÒ ã« ÏȹҰÒ ¯È°¹ºãºÎËÓÓº® °ãËmÈ ÓË °ºm¹È
ÈË® º Ë® °º¹º°Èmã«Ë°« °¯º}È ÏÓÈËÓÒ®
1XOO
° ¹¯Èmº®
°º¯ºÓ© kÓÈãºÒÓº m©¹ºãÓ«Ë°« º¹Ë¯ÈÒ« ¹¯Èmºº mÓËÓ˺
ºËÒÓËÓÒ« vÒÓÈ}°Ò° º¹Ë¯ÈÒ® mÓËÓ˺ ºËÒÓËÓÒ« °ºm¹È
ÈË ° °ÒÓÈ}°Ò°ºäº¹Ë¯ÈÒÒ mÓ¯ËÓÓ˺ ºËÒÓËÓÒ« °ãËË
ºã}ºÏÈäËÓÒ Ëm©Ë°ãºmÈº¹Ë¯ÈÒ®
{ºÏäºÎÓº È}ÎË °È亰ºËÒÓËÓÒË °È人ËÒÓËÓÒË  Ë °º
ËÒÓËÓÒËm²¹Ò®ºÓº®ÈãÒ©iº¹°ÒäÒäËË°«ÈãÒÈ
cp|ik{kpe m}ãÈÈ« °¯ËÒ ¹¯ºÒ² ¹ºã« ÈËãÓ©®
Óºä˯nÈäÒãÒ«~ÈmËÒ®}ÈÁ˯º®{¹º°ãËÓËä¹ºãË}ÈÏ©
mÈË°« ÈËãÓ©® Óºä˯ ÏÈmË˺ }ÈÁ˯º®  ÏÈÒ²
}ÈÏÈÓ
18//
 ÈãÒÈ °ºË¯ÎÒ ÈÓÓ©Ë m°Ë² ¹¯Ë¹ºÈmÈËãË®
m}ãÈ« ÏÈmËÒ² }ÈÁ˯ÈäÒ ~ȹ¯º°m©mºÒ ÁÈäÒãÒÒ ¹¯Ë
¹ºÈmÈËãË®ÒÁÈäÒãÒÒÏÈmËÒ²°ººmË°mÒäÒ}ÈÁ˯È
äÒ
6(/(&7DhibyNZfbeby $6Ij_ih^Z\Zl_ev
DhibyNZfbeby $6>AZ\_^mxsbc dZn_^jhc@
)520 Ij_ih^Z\Zl_ev $6 Dhiby,11(5 -2,1 Ij_ih^Z\Zl_ev
$6 Dhiby21 DhibyAZ\_^mxsbc dZn_^jhc
DhibyLZ[_evguc ghf_j
{¹¯Òä˯Ëm¹¯ËãºÎËÓÒÒ
)520
Ò°¹ºãϺmÈÓ©¹°ËmºÓÒä©
ÈãÒ
Dhiby
Ò
Dhiby
È m ¹¯ËãºÎËÓÒÒ
6(/(&7
ÏÈÈÓ©Óº
ËÒäËÓÈ°ºãÈä{ºÏäºÎÓº°ºËÒÓËÓÒË¯ÈÏãÒÓ©²ÈãÒ Ò
¹Ò®ºÓº®ÈãÒ©
)520Klm^_gl ,11(5-2,1
     >bkpbiebgZ ,11(5-2,1Mki_\Z_fhklv
          21>bkpbiebgZ>Dh^ ^bkpbiebgu@
Mki_\Z_fhklv>Dh^ ^bkpbiebgu@ 21Klm^_glAZq_ldZ 
 Mki_\Z_fhklvAZq_ldZ
      |¹Ë¯ÈÒÒ /()7 -2,1 ÒãÒ 5,*+7 -2,1 °ä ÓÒÎË  亂ˆ
­©ˆ mãºÎËÓ© m º¹Ë¯ÈÒ         ,11(5 -2,1 Óº º¹Ë¯ÈÒ« ,11(5
-2,1 ÓËäºÎˈ­©ˆ mãºÎËÓÈm/()7-2,1 ÒãÒ5,*+7-2,1
      cËÎË Ò°¹ºã ςˈ°« mÓË ÓËË º­žËÒÓËÓÒË ˆÈ­ãÒ |¹Ë¯ÈÒ«
/()7 -2,1 °ºÏÈˈ ãËmºË mÓË ÓËË º­žËÒÓËÓÒË ¹¯Ò }ºˆº¯ºä m°Ë
ÏȹҰÒÒψȭãÒ©°ˆº«Ë®mãËmº®È°ˆÒº¹Ë¯ÈÒÒm}ã È ˆ°«
m¯Ëς㠈ү‚ Ò®ÓÈ­º¯~ȹҰ҈ȭãÒ©¯È°¹ºãºÎËÓÓº®°¹¯È
mÈ ºˆ º¹Ë¯ÈÒÒ º­žËÒÓ« ˆ°« ° ÏȹҰ«äÒ ÒÏ ¯È°¹ºãºÎËÓÓº®
°ãËmȈȭãÒ©ˆºã }º¹¯ÒÓÈãÒÒÒ°ºm¹ÈÈ Ò²ÏÓÈËÓÒ®m¹º
㫲 °m«ÏÒ  p°ãÒ ã« ÏȹҰÒ ¯È°¹ºãºÎËÓÓº® °ãËmÈ Óˈ °ºm¹È
È Ë® ˆº Ë® °º¹º°ˆÈmã«Ëˆ°« °ˆ¯º}È ÏÓÈËÓÒ® 1XOO ° ¹¯Èmº®
°ˆº¯ºÓ© kÓÈãºÒÓº m©¹ºãӫˈ°« º¹Ë¯ÈÒ« ¹¯Èmºº mÓË Ó˺
º­žËÒÓËÓÒ« vÒӈÈ}°Ò° º¹Ë¯ÈÒ® mÓË Ó˺ º­žËÒÓËÓÒ« °ºm¹È
Èˈ ° °ÒӈÈ}°Ò°ºä º¹Ë¯ÈÒÒ mӂˆ¯ËÓÓ˺ º­žËÒÓËÓÒ« °ãË‚ˈ
ˆºã }ºÏÈäËÓ҈ }ã Ëm©Ë°ãºmȺ¹Ë¯ÈÒ®
      {ºÏäºÎÓº ˆÈ}ÎË °È亰ºËÒÓËÓÒË °È人­žËÒÓËÓÒË  ˆ Ë °º
ËÒÓËÓÒËm‚²}º¹Ò®ºÓº®ˆÈ­ãÒ©iº¹‚°ˆÒäÒäËˈ°«ˆÈ­ãÒÈ
cp|ik{k‘pe m}ã È È« °¯ËÒ ¹¯ºÒ² ¹ºã« ‘È­Ëã Ó©®
Óºä˯ nÈäÒãÒ« ~ÈmË‚ Ò® }ÈÁ˯º® { ¹º°ãËÓËä ¹ºãË ‚}ÈÏ©
mÈˈ°« ˆÈ­Ëã Ó©® Óºä˯ ÏÈmË‚ Ëº }ÈÁ˯º® ‚ ÏÈmË‚ Ò²
‚}ÈÏÈÓ 18//  ‘È­ãÒÈ °º˯Î҈ ÈÓÓ©Ë m°Ë² ¹¯Ë¹ºÈmȈËãË®
m}ã È« ÏÈmË‚ Ò² }ÈÁ˯ÈäÒ ~ȹ¯º° m©mº҈ ÁÈäÒãÒÒ ¹¯Ë
¹ºÈmȈËãË®ÒÁÈäÒãÒÒÏÈmË‚ Ò²°ººˆmˈ°ˆm‚ ÒäÒ}ÈÁ˯È
äÒ
6(/(&7DhibyNZfbeby $6Ij_ih^Z\Zl_ev
       DhibyNZfbeby $6>AZ\_^mxsbc dZn_^jhc@
)520 Ij_ih^Z\Zl_ev $6 Dhiby,11(5 -2,1 Ij_ih^Z\Zl_ev
$6 Dhiby21 DhibyAZ\_^mxsbc dZn_^jhc 
DhibyLZ[_evguc ghf_j
      {¹¯Òä˯Ëm¹¯ËãºÎËÓÒÒ)520Ò°¹ºã ϺmÈÓ©¹°ËmºÓÒä©
ˆÈ­ãÒ Dhiby Ò Dhiby È m ¹¯ËãºÎËÓÒÒ 6(/(&7 ÏÈÈÓ© Óº
m©Ë ÒäËÓÈ °ˆºã­Èä {ºÏäºÎÓº °ºËÒÓËÓÒË ¯ÈÏãÒÓ©² ˆÈ­ãÒ Ò
}º¹Ò®ºÓº®ˆÈ­ãÒ©