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

UptoLike


¯¹¹©
Ò
¯ÒäËÈÓÒË ¯¹¹©
wº ºÏÓÈÈË º m ºËË 
m©mºÒ°«°ººmË°mÒË¯ÈÏËã©«°mº®°mÈ
¯¹¹Ò¯ºm}È
m©˯Ëä º¹ºãÓºäÏÓÈËÓÒ °mº®°mÈ
¯¹¹Ò¯ºm}È
Ò
jÓ˯mÈã
m©Ò¯È°«}©ãºº¹Ò°ÈÓº¹¯Ò¯ÈºË°°˯ºäºËºm
vmº®°mº
sË¯Èϯ©mÈ
ºË°¹ËÒmÈËÓ˯Èϯ©mÓºË¹¯Ë°ÈmãËÓÒË
ÈÓÓ©² ÓÈ °¯ÈÓÒË p°ãÒ ã« ÈÓÓºº °mº®°mÈ m©¯È ÏÓÈË
ÓÒËv¹Ë¯m©äÒÈÓÓ©äÒºÏȺãºmº}¯¹¹©ÓËº°ÈÓË°«mÓ
Ë°¯ÈÓÒ©ËÏÈÓÓ©²~ÓÈËÓÒË«¯¹¹È ºÏÓÈÈËºÈÓ
Ó©Ë ¯¹¹© ÓÈÒÓÈ°« ° Óºmº® °¯ÈÓÒ© Ë°ãÒ ºÓÒ ÓË ¹ºäË
È°« ÓÈ Ë} °¯ÈÓÒ « ÓÈã«Óº°Ò ºËÈ ˯Ëä
ÏÓÈËÓÒË « ¯¹¹È kÓÈãºÒÓº ÏÈÈÒä mº¯º® ¯ºmËÓ ¯¹
¹Ò¯ºm}Ò¹º¹ºã nÈäÒãÒ««°º¯Ò¯ºm}ÒËÈãÓ©²ÏÓÈËÓÒ®
ºËÈ¹ºÓÈÏmÈÓÒ«äÒ°Ò¹ãÒÓm©˯Ëä°ººmË°mËË¹ºãË
ÓºÓËËäÏÈÈmÈ m©mº ÏȺãºm}ºmÒ¹¯ÒäËÈÓÒ®¯¹¹º
°ãË ÏÈ}¯©Ò« º}ÓÈ
vº¯Ò¯ºm}È Ò ¯¹¹Ò¯ºm}È
ÓÈ äÈ}ËË ºËÈ
¹º«mã«°«¯ÈÏËã©
ºãºmº}¯¹¹©¯¹¹È

ºãºmº}¯¹¹©
nÈäÒãÒ«

¯ÒäËÈÓÒ« ¯¹¹© ¯¹¹È
Ò
¯ÒäËÈÓÒ« ¯¹¹©
nÈäÒãÒ«
ºäËÈ«}ÈÏÈËã ä©ÒÓÈ¯ÈÓÒ©¯ÈÏËãºm}È
ÏÈËã ¹¯ÒäË mÓȹ¯ÈmãËÓÓº®°¯Ëã}ÒmËãÒÒä¯ÈÏä˯©
¯ÈÏËãºm
˯ËÈÒä¹ºãË¯¹¹È ÒÏ
v¹Ò°}È¹ºãË®
mºãÈ°
ºãº
} ¯¹¹© ¯¹¹È
{ }ÈÏÈÓÓº® ºãÈ°Ò ¹º«mã«°« ¹º¹Ò°
¯¹¹ÈÒ¹ºãË¯¹¹ÈÈãÒämºËºÒËm¹º¹Ò°ÒÈ}Òäº
¯ÈϺä m ÏȺãºm}Ë Ë m©mºÒ°« ÒÁ¯ ËÓº® ¯¹¹©È}
ÎË}Ò¹¯Ò¯ÈºËm°¯ËË06 :RUG äºÎÓº°ÈÓºmÒ ¯ÒÁ
Ò¯ÈÏä˯Ò䩲¹ºãË®ÒÓȹҰˮ°¹ºäº äËÓ
¯
äÈ
äºÎÓº°ÈÓºmÒ ¯ÈÏä˯©Ò¯ºmÓ« ¹ºã«{
ºãºmº}
¯¹¹©nÈäÒãÒ«
¹Ë¯ËÈÒä¹ºã«nÈäÒãÒ« Òjä«º¹Ò° ¹ºã«
nÈäÒãÒ« ÏÈäËÓÒäÓÈ¹º¹Ò° vËÓÈ¹º¹Ò° ¹ºã«jä« È
ãÒä{ºãÈ° ÈÓÓ©²¹Ë¯ËÈÒä¹ºã«sÈÏmÈÓÒË Ò|ËÓ}ÈsÈ
ÏmÈÓÒ« ªÒ² ¹ºãË® m©¯ËÎËä Ò ¹ºäË°Òä m ºãÈ°Ò
ºãºmº}
¯¹¹© nÈäÒãÒ«
ÓÈ °ººmË°mÒäÒ ¹ºã«äÒ ¹Ë¯ËÈ°}ÒmÈ
¹ºã«ÒÏȺãºm}ÒÒÏºÓºº¯ÈÏËãÈäÈ}ËÈºËÈm¯º®ÓËã
Ï«

Ëä°Èä©äÏȺãºmº}ÈãÒ©Ë¹ºmº¯«°«mÏȺãºm}Ë
ÈÓÓ©² }Èκº °ËÓÈ cÈÏäË°Òä ªãËäËÓ
ÒÓÒ«
ÒÏ ¹ÈÓËãÒ
ªãËäËÓºm º©¹¯ºmË°Ò º¯ÒϺÓÈãÓ©ËãÒÓÒÒãÈÒË
ºËÈlºÎÓº¹¯ºmË°ÒÒm˯Ò}ÈãÓ©ËãÒÓÒÒÒËº
ÓËãÏ« ¹¯ºmË°Ò m˯Ò}ÈãÓ ãÒÓÒ ¹¯º²º« ˯ËÏ mÈ Ò
ºãËË¯ÈÏËãºm äÈ}ËÈºËÈ¯ºmºÒ º¯ÒϺÓÈãÓ©ËÒ¯
Ò}ÈãÓ©Ë ãÒÓÒÒ ¯Ë}ºäËÓË°« ˯ÎÒ« ÓÈÎÈº® ÈmÒ
¯‚¹¹© Ò ¯ÒäËÈÓÒË ¯‚¹¹© wˆº ºÏÓÈÈˈ ˆº m ºˆˈË ­‚‚ˆ
m©mº҈ °«°ººˆmˈ°ˆm‚ Ò˯ÈÏËã©iã«°mº®°ˆmÈ €¯‚¹¹Ò¯ºm}È
m©­Ë¯Ëä º¹ºãÓºä‚ÏÓÈËÓÒ        °mº®°ˆmÈ€¯‚¹¹Ò¯ºm}È Òjӈ˯mÈã
m©­Ò¯È ˆ°«}È}­©ãºº¹Ò°ÈÓº¹¯Ò¯È­ºˆË°lÈ°ˆË¯ºäºˆˈºm 
vmº®°ˆmºs˯Èϯ©mȈ º­Ë°¹ËÒmÈˈÓ˯Èϯ©mӺ˹¯Ë°ˆÈmãËÓÒË
ÈÓÓ©² ÓÈ °ˆ¯ÈÓÒË p°ãÒ ã« ÈÓÓºº °mº®°ˆmÈ m©­¯Èˆ ÏÓÈË
ÓÒËv¹Ë¯m©äÒÈÓÓ©äÒˆºÏȺãºmº}¯‚¹¹©Ó˺°ˆÈÓˈ°«m}ºÓ
Ë°ˆ¯ÈÓÒ©­ËÏÈÓÓ©²~ÓÈËÓÒË{°«¯‚¹¹È ºÏÓÈÈˈˆºÈÓ
Ó©Ë ¯‚¹¹© ÓÈÒÓÈ ˆ°« ° Óºmº® °ˆ¯ÈÓÒ© Ë°ãÒ ºÓÒ ÓË ¹ºäË
È ˆ°« ÓÈ ˆË}‚‚ °ˆ¯ÈÓÒ‚ iã« ÓÈã«Óº°ˆÒ ºˆˈÈ m©­Ë¯Ëä
ÏÓÈËÓÒË {°« ¯‚¹¹È kÓÈãºÒÓº ÏÈÈÒä mˆº¯º® ‚¯ºmËÓ ¯‚¹
¹Ò¯ºm}Ò ¹º ¹ºã nÈäÒãÒ«iã«°º¯ˆÒ¯ºm}ÒˈÈã Ó©²ÏÓÈËÓÒ®
ºˆˈÈ ¹º ÓÈÏmÈÓÒ«ä Ò°Ò¹ãÒÓ m©­Ë¯Ëä °ººˆmˈ°ˆm‚ ËË ¹ºãË
ÓºÓË­‚ËäÏÈÈmȈ m©mº ÏȺãºm}ºmÒ¹¯ÒäËÈÓÒ®¯‚¹¹º
°ãË ÏÈ}¯©ˆÒ« º}ÓÈ vº¯ˆÒ¯ºm}È Ò ¯‚¹¹Ò¯ºm}È ÓÈ äÈ}ˈË ºˆˈÈ
¹º«mã« ˆ°«¯ÈÏËã©~Ⱥãºmº}¯‚¹¹© €¯‚¹¹È ~Ⱥãºmº}¯‚¹¹©
 nÈäÒãÒ«  ¯ÒäËÈÓÒ« ¯‚¹¹© €¯‚¹¹È Ò ¯ÒäËÈÓÒ« ¯‚¹¹©
 nÈäÒãÒ«  ºä˝ȫ ‚}ÈÏȈËã ä© Ò ÓȯÈÓÒ©¯ÈÏËãºm ‚}È
ÏȈËã ¹¯Òäˈ mÒ m‚Óȹ¯ÈmãËÓÓº®°ˆ¯Ëã}Ò ‚mËãÒÒä¯ÈÏä˯©
¯ÈÏËãºm
      Ë¯ËˆÈÒä ¹ºãË €¯‚¹¹È ÒÏ v¹Ò°}È ¹ºãË® m º­ãÈ°ˆ ~Ⱥãº
mº} ¯‚¹¹© €¯‚¹¹È   { ‚}ÈÏÈÓÓº® º­ãÈ°ˆÒ ¹º«mã« ˆ°« ¹º¹Ò°
€¯‚¹¹ÈÒ¹ºãË€¯‚¹¹ÈÈãÒämºËˆºÒËm¹º¹Ò°Ò‘È}Ò亭
¯ÈϺä m ÏȺãºm}Ë ­‚ˈ m©mº҈ °« ÒÁ¯ ‚Ë­Óº® ¯‚¹¹© ‘È}
ÎË}È}Ò¹¯Ò¯È­ºˆËm°¯ËË06 :RUG äºÎÓº‚°ˆÈÓºm҈          ¯ÒÁˆ
Ò ¯ÈÏä˯ m©mºÒ䩲 ¹ºãË® Ò ÓȹҰˮ ° ¹ºäº  äËÓ nº¯
äȈ äºÎÓº ‚°ˆÈÓºm҈ ¯ÈÏä˯© Ò m©¯ºmÓ«ˆ ¹ºã« { ~Ⱥãºmº}
¯‚¹¹© nÈäÒãÒ« ¹Ë¯ËˆÈÒ乺ã«nÈäÒãÒ« Òj䫁º¹Ò° ¹ºã«
nÈäÒãÒ« ÏÈäËÓÒäÓȹº¹Ò° vˆ‚Ëӈȹº¹Ò° ¹ºã«jä« ‚È
ãÒä { º­ãÈ°ˆ ÈÓÓ©² ¹Ë¯ËˆÈÒä ¹ºã« sÈÏmÈÓÒË Ò|ËÓ}ÈsÈ
ÏmÈÓÒ« ªˆÒ² ¹ºãË® m©¯ËÎËä Ò ¹ºäË°ˆÒä m º­ãÈ°ˆÒ ~Ⱥãºmº}
¯‚¹¹© nÈäÒãÒ«  ÓÈ °ººˆmˈ°ˆm‚ ÒäÒ ¹ºã«äÒ ¹Ë¯ËˆÈ°}ÒmȈ
¹ºã«ÒÏȺãºm}ÒÒϺӺº¯ÈÏËãÈäÈ}ˈȺˆˈÈm¯‚º®ÓËã 
Ï« ‘Ëä°Èä©äÏȺãºmº}ˆÈ­ãÒ©­‚ˈ¹ºmˆº¯«ˆ °«mÏȺãºm}Ë
ÈÓÓ©² }Èκº °ˆ‚ËӈÈ cÈÏäË°ˆÒä ªãËäËӈ ÒÓÒ« ÒÏ ¹ÈÓËãÒ
ªãËäËӈºm ˆº­© ¹¯ºmË°ˆÒ º¯ÒϺӈÈã Ó©Ë ãÒÓÒÒ ‚ã‚ È ÒË
mÒ ºˆˈÈlºÎÓº¹¯ºmË°ˆÒÒm˯ˆÒ}Èã Ó©ËãÒÓÒҐˆÒˆËˆº
ÓËã Ï« ¹¯ºmË°ˆÒ m˯ˆÒ}Èã ӂ ãÒÓÒ  ¹¯º²º«‚ ˯ËÏ mÈ Ò
­ºãËË ¯ÈÏËãºm äÈ}ˈÈ ºˆˈÈ ¯ºmº҈ º¯ÒϺӈÈã Ó©Ë Ò m˯
ˆÒ}Èã Ó©Ë ãÒÓÒÒ ¯Ë}ºäËÓ‚ˈ°« ‚˯ÎÒmÈ« ÓÈÎȈº® }ãÈmÒ ‚