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

UptoLike


>,1<g_rgyy;ZaZ>Zgguo!@
>:+(5(mkeh\by ihbkdZ!@
>*5283%<klhe[_p!@
>+$9,1*mkeh\by ihbkdZ!@
>25'(5%<kibkhd klhe[ph\!@
¯Ò º¹Ò°ÈÓÒÒ °ÒÓÈ}°Ò°È ¹¯ÒÓ«© °ãËÒË ººÏÓÈË
ÓÒ« {äË°º °ãºm m ãºm©² °}º}Ȳ Ó˺²ºÒäº }ÈÏÈ ÒäËÓÈ
¯ËÈãÓ©²ÈãÒ°ºãºmÒ¹äËÓ©}ÈÏÈÓÓ©Ëm¹¯«
䩲°}º}ȲÓË«mã«°«º«ÏÈËãÓ©äÒp°ãÒ}ÈÏÈÓºÓË°}ºã
}ºȯäËÓºm¯ÈÏËãËÓÓ©²°Òämºãºä_ºäºÎÓºÒ°¹ºãϺmÈ
ºã}ººÒÓȯäËÓ¯Ó©Ë°}º}ÒººÏÓÈÈ°¹Ò°º}ªãË
äËÓºmÏȹҰÈÓÓ©²˯ËÏÏȹ«
cÈ°°äº¯Òä }¯È}º ȯäËÓ© ÒÓ°¯}ÒÒ
6(/(&7
 º°ãË
Ëmºº°ãºmÈ
6(/(&7
¹¯ÒmºÒ°«°¹Ò°º}ÏÓÈËÓÒ®}ÈκËÒÏ
}ºº¯©² º¹¯ËËã«Ë °ºãË ¯ËÏãÒ¯˺ ÓÈº¯È ÈÓÓ©²
} ¹¯ÈmÒãº ªº ÒäËÓÈ °ºãºm ÈãÒ ¹Ë¯ËÒ°ãËÓÓ©² ¹º°ãË
°ãºmÈ
)520
¹¯ÒËä °ºã© m©mº«°« m }ÈÏÈÓÓºä ¹º¯«
jÓºÈ Ü ªº ÏÓÈËÓÒ« Ò°ãËÓÓ©Ë ÓË}ºº¯©äÒ ÁÓ}Ò«äÒ
Óȹ¯Òä˯°¯ËÓËËÏÓÈËÓÒËvÒämºã}ÈÏ©mÈËÓÈm}ãËÓÒË
m¯ËÏãÒ¯Ò®ÓÈº¯m°Ë²°ºãºmm°Ë²ÈãÒ¹Ë¯ËÒ°ãËÓ
Ó©²¹º°ãË°ãºmÈ
)520
p°ãÒm¯ËÏãÒ¯Ò®ÓÈº¯«°«
ÏÓÈËÓÒ«°ºãºmÒäËÒ²ºÒÓÈ}ºm©ËÒäËÓÈmÒ°¹ºãÏË䩲
mÏȹ¯º°ËÈãÒȲº°ãËË¹¯ÒäËÓ« °º°ÈmÓºËÒä«
lZ[eb
pZ!agZq_gb_!
zºÓ°¯}Ò«
lZ[ebpZ!
ºÏÓÈÈË m}ãË
ÓÒË m ¯ËÏãÈ m°Ë² °ºãºm ºÓº® ÒÏ ÈãÒ zºÓ°¯}Ò«
$6 ik_\^hgbf!
ºÏÓÈÈËº
ik_\^hgbf!
°ÈÓËÏȺãºm}ºä
°ºãÈm¯ËÏãÒ¯ËäÓÈº¯ËÈÓÓ©²
¯ËÒ}È °ãºmÒË
',67,1&7
Ò°}ãÈË ÏȹҰÒ }ºº¯©Ë
°ºË¯ÎÈ¹ºmº¯«ÒË°«ÏÓÈËÓÒ«mm©¯ÈÓÓ©²¹ºã«²¯ËÒ}È
',67,1&752:
Ò°}ãÈË ¹ºmº¯«ÒË°« ÏȹҰÒ ¹ºãËÓÓ©Ë m
¯ËÏãÈË°ºËÒÓËÓÒ«ÈãÒ¯ËÒ}È
',67,1&752:
mãÒ«ËÓÈ
¯ËÏãÈ ºã}º m ºä °ãÈË Ë°ãÒ m Ïȹ¯º° m}ã ËÓ© ÓË Ë
¹ºã« ÒÏÈÓÈãÒÏÒ¯Ë䩲ÈãÒ¯ËÒ}È
',67,1&752:
ÒÓº¯Ò
¯Ë°«Ë°ãÒÏȹ¯º°°ºË¯ÎÒºã}ººÓÈãÒÒãÒË¹ºã«
m°Ë² ÈãÒ ¯ËÒ}È
$//
¯ÈϯËÈË m}ãËÓÒË m ¯ËÏãÈ
ºÒÓÈ}ºm©²°¯º}ºäºãÈÓÒ Ë°ãÒÓËÓÒºÓºº¹¯ËÒ}È
ÈË®°mË
$//

¯ËÒ
723 Q
mºÏm¯ÈÈË
Q
¹Ë¯m©² ÏȹÒ
°Ë®¯ËÏãÒ¯˺ÓÈº¯È°Ëºä°º¯Ò¯ºm}Ò¯ËÏãÈÈ¹¯Ò
>,1Zgguo!@
>:+(5(mkeh\by ihbkdZ!@
>*5283%<klhe[_p!@
>+$9,1*mkeh\by ihbkdZ!@
>25'(5%<kibkhd klhe[ph\!@
      ¯Ò º¹Ò°ÈÓÒÒ °ÒӈÈ}°Ò°È ¹¯ÒÓ«ˆ© °ãË‚ ÒË º­ºÏÓÈË
ÓÒ« {äË°ˆº °ãºm m ‚ãºm©² °}º­}Ȳ Ó˺­²ºÒäº ‚}ÈÏȈ ÒäËÓÈ
¯ËÈã Ó©² ˆÈ­ãÒ °ˆºã­ºm Ò ˆ ¹ k¯‚äËӈ© ‚}ÈÏÈÓÓ©Ë m ¹¯«
䩲°}º­}ȲÓË«mã« ˆ°«º­«ÏȈËã Ó©äÒp°ãÒ‚}ÈÏÈÓºÓË°}ºã 
}ºȯ‚äËӈºm¯ÈÏËãËÓÓ©²°Òämºãºä _ ˆºäºÎÓºÒ°¹ºã ϺmȈ
ˆºã }ººÒÓȯ‚äËӈnÒ‚¯Ó©Ë°}º­}Òº­ºÏÓÈÈ ˆ°¹Ò°º}ªãË
äËӈºmÏȹҰÈÓÓ©²˯ËÏÏȹ«ˆ‚ 
      cÈ°°äºˆ¯Òä }¯Èˆ}º ȯ‚äËӈ© ÒÓ°ˆ¯‚}ÒÒ 6(/(&7 º°ãË
}ã Ëmºº°ãºmÈ6(/(&7 ¹¯Òmº҈°«°¹Ò°º}ÏÓÈËÓÒ®}ÈκËÒÏ
}ºˆº¯©² º¹¯ËËã«Ëˆ °ˆºã­Ë ¯Ëς㠈ү‚ Ëº ÓÈ­º¯È ÈÓÓ©²
zÈ} ¹¯ÈmÒ㺠ªˆº ÒäËÓÈ °ˆºã­ºm ˆÈ­ãÒ ¹Ë¯ËÒ°ãËÓÓ©² ¹º°ãË
°ãºmÈ )520 ¹¯ÒËä °ˆºã­© m©mº«ˆ°« m ‚}ÈÏÈÓÓºä ¹º¯«}Ë
jÓºÈ Ü ªˆº ÏÓÈËÓÒ« m©Ò°ãËÓÓ©Ë ÓË}ºˆº¯©äÒ Á‚Ó}Ò«äÒ
Óȹ¯Òä˯ °¯ËÓËË ÏÓÈËÓÒË vÒämºã ‚}ÈÏ©mÈˈÓÈm}ã ËÓÒË
m¯Ëς㠈ү‚ Ò®ÓÈ­º¯m°Ë²°ˆºã­ºmm°Ë²ˆÈ­ãҹ˯ËÒ°ãËÓ
Ó©²¹º°ãË°ãºmÈ)520p°ãÒm¯Ëς㠈ү‚ Ò®ÓÈ­º¯m©mº«ˆ°«
ÏÓÈËÓÒ«°ˆºã­ºmÒäË Ò²ºÒÓÈ}ºm©ËÒäËÓÈmÒ°¹ºã ςË䩲
mÏȹ¯º°ËˆÈ­ãÒȲˆº°ãË‚ˈ¹¯ÒäËÓ«ˆ °º°ˆÈmÓºËÒä« lZ[eb
pZ!agZq_gb_! zºÓ°ˆ¯‚}Ò« lZ[ebpZ! ºÏÓÈÈˈ m}ã Ë
ÓÒË m ¯Ëς㠈Ȉ m°Ë² °ˆºã­ºm ºÓº® ÒÏ ˆÈ­ãÒ zºÓ°ˆ¯‚}Ò«
$6 ik_\^hgbf!ºÏÓÈÈˈˆº ik_\^hgbf!°ˆÈÓˈÏȺãºm}ºä
°ˆºã­Èm¯Ëς㠈ү‚ ËäÓÈ­º¯ËÈÓÓ©²
      ¯ËÒ}Ȉ ‚°ãºmÒË  ',67,1&7 Ò°}ã Èˈ ÏȹҰÒ }ºˆº¯©Ë
°º˯ÎȈ¹ºmˆº¯« ÒË°«ÏÓÈËÓÒ«mm©­¯ÈÓÓ©²¹ºã«²¯ËÒ}Ȉ
',67,1&752: Ò°}ã Èˈ ¹ºmˆº¯« ÒË°« ÏȹҰÒ ¹ºã‚ËÓÓ©Ë m
¯Ëς㠈ȈË°ºËÒÓËÓÒ«ˆÈ­ãҁ¯ËÒ}Ȉ',67,1&752: mãҫˈÓÈ
¯Ëς㠈Ȉ ˆºã }º m ˆºä °ã‚ÈË Ë°ãÒ m Ïȹ¯º° m}ã ËÓ© ÓË m°Ë
¹ºã« ÒÏÈÓÈãÒÏÒ¯‚Ë䩲ˆÈ­ãҁ¯ËÒ}Ȉ',67,1&752: ÒÓº¯Ò
¯‚ˈ°« Ë°ãÒ Ïȹ¯º° °º˯Î҈ ˆºã }º ºӂ ˆÈ­ãÒ‚ ÒãÒ m°Ë ¹ºã«
m°Ë² ˆÈ­ãÒ ¯ËÒ}Ȉ $// ¯ÈÏ¯Ë Èˈ m}ã ËÓÒË m ¯Ëς㠈Ȉ
ºÒÓÈ}ºm©² °ˆ¯º} º ‚äºãÈÓÒ        Ë°ãÒ ÓˈÓÒºÓºº¹¯ËÒ}È
ˆÈ Ë®°ˆm‚ˈ$//¯ËÒ}Ȉ723 Q mºÏm¯ÈÈˈ Q¹Ë¯m©² ÏȹÒ
°Ë®¯Ëς㠈ү‚ ËºÓÈ­º¯È °‚ˈºä°º¯ˆÒ¯ºm}Ò¯Ëς㠈Ȉȹ¯Ò