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

UptoLike


Ò¹ÈÓÓ©²
|¹Ò°ÈÓÒË
ºÒ˰}Ò®
{È}Ò²¹ºã«²°º²¯ÈÓ«°«ÏÓÈËÓÒ«iÈÒãÒ ¹ºã«
ªººÒ¹ÈÓËÒÓË}°Ò¯°«
ºãË
0(02
{0(02Ü ¹ºã«²²¯ÈÓ«°«Ë}°ºm©Ë ãÒºË}°ºm©ËÒ
Ò°ãºm©ËÈÓÓ©ËºËäºäÓËºãËË°Òämºãºm¹ºã«
ªººÒ¹ÈÓËÒÓË}°Ò¯°«
ºãËºË}È
2/(
{¹ºã«ÈÓÓººÒ¹È¹ºäËÈ°«ºË}©º¯ÈºÈÓÓ©Ë
2/( Ü °Ë¯m˯ºäÈ}ÒË¹ºã«ÓËÒÓË}°Ò¯°«ÒÒ²º
ËäÓËºãÎËÓ¹¯Ëm©È lÈ®
ҹ˯°°©ã}È
{¹ºã«²ªººÒ¹È²¯ÈÓ«°«ҹ˯°°©ã}Ò}ºº¯©Ë¹¯Ë
°Èmã«°ºº®¹ }ÁÈ®ãÓÈÎ˰}ºäÒ°}ËãÒºȯ˰
m°Ë«²jÓ˯ÓËÒãÒÒÓ¯ÈÓË
lȰ˯
¹º°ÈÓºmº}
vºÏÈË¹ºãË¹ºÏmºã«ËËm©¯È ÏÓÈËÓÒËÒÏ¯º®
ÈãÒ©ÒãÒÒÏ°¹Ò°}ÈÏÓÈËÓÒ®Ò°¹ºãÏ«¹ºãË°º°¹Ò
°}ºä
{©º¯ ¹ºãË® }Èκ® ÈãÒ© ÈÏ© ÈÓÓ©² ÓȺ ¹¯ºÒÏmº
Ò ° È}Òä¯È°Ëºä º©ºÓÒº°ÈºÓº¹ºãÓºº¹Ò°©mÈãÒ
°ººmË°mÒ® ºË} ¹¯ËäËÓº® ºãȰÒ k¯Ò© ¹ºãË®
Ó˺²ºÒäºm©Ò¯È m°ººmË°mÒÒ°Ò²mºÏäºÎÓ©äÒ¯ËÈãÓ©
äÒÏÓÈËÓÒ«äÒ
«ÓÈ˺¹¯Òä˯ÈÈÏ©ÈÓÓ©²sj{pcvjpº¹Ò°È
ÓÒË¹ºãË®ÈãÒ äºÎËã«Ë ¹¯Òä˯ӺÈ}}}ÈÏÈÓºm
ÈãÜ 
ÈãÒÈ
|¹Ò°ÈÓÒË¹ºãË®ÈãÒ©
vips
«¹ºã«
Ò¹ÈÓÓ©²
vmº®°mÈ¹ºã«
|¹Ò°ÈÓÒË
Ë}È
Ë}°ºm©®
iãÒÓÈÒÓË}°ËÏ¹ºmº
¯ËÓÒ®¹Ë¯mÒÓ©®
bÒÁ¯ÏÈËÓº®
}ÓÒÎ}Ò
¯¹¹È
Ë}°ºm©®
v¹Ò°º}Ùk|µÙkwµ
Ùkwµ
bÒÁ¯ËÓº®
¯¹¹©
nÈäÒãÒ«
Ë}°ºm©®
iãÒÓÈÒÓË}°°¹ºmº¯Ë
ÓÒ«äÒ
nÈäÒãÒ«°
ËÓÈ
jä«
Ë}°ºm©®
iãÒÓÈ
«°ËÓÈ
|˰mº
Ë}°ºm©®
iãÒÓÈ
|˰mº°
ËÓÈ
ºã
Ë}°ºm©®
v¹Ò°º}Ùlµµyµ
iÈÈ
¯ºÎËÓÒ«
iÈÈm¯Ëä«
z¯È}Ò®Áº¯äÈÈ©¹º
äºãÈÓÒ 
ËãËÁºÓ
Ë}°ºm©®
iãÒÓÈÓ˺«ÏÈËãÓºË
‘Ò¹ÈÓÓ©²      |¹Ò°ÈÓÒË
ºÒ˰}Ò®      {ˆÈ}Ò²¹ºã«²°º²¯ÈÓ« ˆ°«ÏÓÈËÓÒ«iÈÒãÒsˈ ¹ºã«
                ªˆººˆÒ¹ÈÓËÒÓË}°Ò¯‚ ˆ°«
ºãË          {0(02Ü ¹ºã«²²¯ÈÓ«ˆ°«ˆË}°ˆºm©Ë ãÒ­ºˆË}°ˆºm©ËÒ
0(02            Ò°ãºm©ËÈÓө˺­žËäºäÓË­ºãË˰Òämºãºm ¹ºã«
                ªˆººˆÒ¹ÈÓËÒÓË}°Ò¯‚ ˆ°«
ºã˺­žË}ˆÈ    {¹ºã«ÈÓÓººˆÒ¹È¹ºäËÈ ˆ°«º­žË}ˆ©º­¯È­ºˆÈÓÓ©Ë
2/(             2/( Ü °Ë¯m˯ºä ˆÈ}Ò˹ºã«ÓËÒÓË}°Ò¯‚ ˆ°«ÒÒ²º­ž
                ËäÓ˺ãÎËÓ¹¯Ëm© Ȉ l­È®ˆ
€Ò¹Ë¯°°©ã}È     {¹ºã«²ªˆººˆÒ¹È²¯ÈÓ«ˆ°«ҹ˯°°©ã}Ò}ºˆº¯©Ë¹¯Ë
                °ˆÈmã« ˆ°º­º®¹‚ˆ }ÁÈ®ã‚ÓÈÎ˰ˆ}ºäÒ°}ËãÒ­ºÈ¯Ë°
                m°Ëˆ«²jӈ˯ÓˈÒãÒÒӈ¯ÈÓˈ
lȰˆË¯         vºÏÈˈ¹ºã˹ºÏmºã« ËËm©­¯Èˆ ÏÓÈËÓÒËÒϯ‚º®
¹º°ˆÈÓºmº}     ˆÈ­ãÒ©ÒãÒÒϰ¹Ò°}ÈÏÓÈËÓÒ®Ò°¹ºã ς«¹ºã˰º°¹Ò
                °}ºä

      {©­º¯ ¹ºãË® }Èκ® ˆÈ­ãÒ© ­ÈÏ© ÈÓÓ©² ÓȺ ¹¯ºÒÏmº
҈ ° ˆÈ}Òä ¯È°ˈºä ˆº­© ºÓÒ º°ˆÈˆºÓº ¹ºãÓº º¹Ò°©mÈãÒ
°ººˆmˈ°ˆm‚ Ò® º­žË}ˆ ¹¯ËäˈӺ® º­ãȰˆÒ kˆ¯Ò­‚ˆ© ¹ºãË®
Ó˺­²ºÒäºm©­Ò¯Èˆ m°ººˆmˈ°ˆmÒÒ°Ò²mºÏäºÎÓ©äÒ¯ËÈã Ó©
äÒÏÓÈËÓÒ«äÒ
      iã«ÓÈ Ëº¹¯Òä˯È ­ÈÏ©ÈÓÓ©²sj{pcvj‘p‘ º¹Ò°È
ÓÒË ¹ºãË® ˆÈ­ãÒ äºÎˈ m©ã«ˈ ¹¯Òä˯ӺˆÈ}}È}‚}ÈÏÈÓºm
ˆÈ­ãÜ 
                                                             ‘È­ãÒÈ

                    |¹Ò°ÈÓÒ˹ºãË®ˆÈ­ãÒ©v‘ips‘

j䫹ºã«      ‘Ò¹ÈÓÓ©²   vmº®°ˆmȹºã«                 |¹Ò°ÈÓÒË
~Èˈ}È       ‘Ë}°ˆºm©®    iãÒÓÈÒÓË}°­ËϹºmˆº    bÒÁ¯ÏÈˈӺ®
                           ¯ËÓÒ®¹Ë¯mÒÓ©®}ã          }ÓÒÎ}Ò
€¯‚¹¹È        ‘Ë}°ˆºm©®    v¹Ò°º}Ùk|µÙkwµ    bÒÁ¯‚Ë­Óº®
                           Ùkwµ                       ¯‚¹¹©
nÈäÒãÒ«       ‘Ë}°ˆºm©®    iãÒÓÈÒÓË}°°¹ºmˆº¯Ë   nÈäÒãÒ«°ˆ‚
                           ÓÒ«äÒ                         ËӈÈ
jä«           ‘Ë}°ˆºm©®    iãÒÓÈ                      jä«°ˆ‚ËӈÈ
|ˆ˰ˆmº      ‘Ë}°ˆºm©®    iãÒÓÈ                      |ˆ˰ˆmº°ˆ‚
                                                         ËӈÈ
ºã           ‘Ë}°ˆºm©®    v¹Ò°º}Ùlµµyµ
iȈÈ         iȈÈm¯Ëä«   z¯Èˆ}Ò®Áº¯äȈȈ©¹º
¯ºÎËÓÒ«                   ‚äºãÈÓÒ 
‘ËãËÁºÓ       ‘Ë}°ˆºm©®    iãÒÓÈÓ˺­«ÏȈËã ÓºË