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

UptoLike


¹¯Òä˯ ¹ºãÒ ÈÓÓ©Ë º °ËÓȲ m°Ë² ¯¹¹}¯ºäËk|
äºÎÓº°¹ºäºÏȹ¯º°È
6(/(&7
)520Klm^_gl
:+(5(127=jmiiZ :H
p°ãÒm°ãºmÒ«²¹ºÒ°}ÈÒ°¹ºãÏ°«È©ºÒ°¹ºãÏË°«
Èä˯Ò}ÈÓ°}Ò®Áº¯äÈÈ©¹Ë¯m©äÏȹҰ©mÈË°«Óºä˯ä˰«È
sȹ¯Òä˯ÓÈ®Ò°ËÓºm¯ºÒmÒ²°«¯ÈÓËËº}«¯« 
äºÎÓº°¹ºäº°ãË˺Ïȹ¯º°È
6(/(&7NZfbeby
)520Klm^_gl
:+(5(>>ZlZ jh`^_gby@
¯Ò¹¯º°äº¯ËªººÏȹ¯º°ÈmzºÓ°¯}º¯Ë ÈÈm°ãºmÒ
«²¹ºÒ°}È¹ºÏ©mÈË°«m¯°°äÁº¯äÈË

{ °ãºmÒ«² ¹ºÒ°}È äºÎÓº Ò°¹ºãϺmÈ ¹¯ËÒ}È©
,1
%(7:((1«$1'/,.(
Ò
,6 18//
¯ËÒ}È
,1
¹¯ºm˯«Ë°ºm
¹ÈÈËãÒÏÓÈËÓÒËm©¯ÈÎËÓÒ«°ºÓÒäÒÏªãËäËÓºm}ÈÏÈÓÓºº
°¹Ò°}È sȹ¯Òä˯ ã« ¹ºãËÓÒ« °mËËÓÒ® º °ËÓȲ m²
¯¹¹äºÎÓºÒ°¹ºãϺmÈ Ïȹ¯º°
6(/(&7
)520Klm^_gl
:+(5(=jmiiZ ,1:W:H
{¹º°ãËÓËä ¹¯Òä˯ËäºÎÓº¹¯ÒäËÓÒ °ãºmÒË¹ºÒ°
:+(5(=jmiiZ :W25=jmiiZ :H
¯Ò°ãºÎÓ©²°
ãºmÒ«² ¹¯ÒäËÓËÓÒË ¹¯ËÒ}ÈÈ
,1
º}ÈÏ©mÈË°« ºãËË ¹¯º°©äÒ
ÓÈã«Ó©ä
¯ËÒ}È
%(7:((1«$1'
º¹¯ËËã«Ë ¹¯ÒÓÈãËÎÓº° ÏÓÈË
ÓÒ«m©¯ÈÎËÓÒ«}ÈÏÈÓÓºäÒȹÈϺÓ¯ËÒ}È«mã«Ë°«m}ã
ÈÒä Ë¹¯ºm˯«Ë}ÈÏÈÓÓ©Ë¯ÈÓÒÓ©ËÏÓÈËÓÒ«¯ËÒ
ȰºÒ°¹ºãÏã«¹¯ºm˯}Ò¹º¹ÈÈËãÒÏÓÈËÓÒË¹ºã«m
}ÈÏÈÓÓ©®ÒȹÈϺÓÒ°ËãsºäºÎÓº¹¯ÒäËÓ« ªº¹¯ËÒ}ÈÒ
ã«¯Èº©°º°¯º}ºm©äÒÈÓÓ©äÒsȹ¯Òä˯È m°Ë °mË
ËÓÒ« º °ËÓȲ ÁÈäÒãÒÒ }ºº¯©² ÓÈÒÓÈ°« ° k ¹º z
m}ãÒËãÓºäºÎÓºº¹Ë¯Èº¯ºä
¹¯Òä˯ ¹ºã‚҈ ÈÓÓ©Ë º °ˆ‚ËӈȲ m°Ë² ¯‚¹¹ }¯ºäË k|
äºÎÓº°¹ºäº Ïȹ¯º°È
6(/(&7
 )520Klm^_gl
 :+(5(127=jmiiZ :H 
    p°ãÒm‚°ãºmÒ«²¹ºÒ°}ÈÒ°¹ºã ς ˆ°«Ȉ©ˆºÒ°¹ºã ςˈ°«
Èä˯Ò}ÈÓ°}Ò®Áº¯äȈȈ©¹Ë¯m©äÏȹҰ©mÈˈ°«Óºä˯ä˰«È
sȹ¯Òä˯ÓÈ®ˆÒ°ˆ‚Ëӈºm¯ºÒm Ò²°«¯ÈÓË˺}ˆ«­¯« 
äºÎÓº°¹ºäº °ãË‚ ËºÏȹ¯º°È
6(/(&7NZfbeby
 )520Klm^_gl
 :+(5(>>ZlZ jh`^_gby@
     ¯Ò¹¯º°äºˆ¯ËªˆººÏȹ¯º°ÈmzºÓ°ˆ¯‚}ˆº¯Ë ȈÈm‚°ãºmÒ
«²¹ºÒ°}ȹº}ÈÏ©mÈˈ°«m¯‚°°}ºäÁº¯äȈË
     { ‚°ãºmÒ«² ¹ºÒ°}È äºÎÓº Ò°¹ºã ϺmȈ ¹¯ËÒ}Ȉ© ,1
%(7:((1«$1' /,.( Ò ,6 18// ¯ËÒ}Ȉ,1 ¹¯ºm˯«Ëˆ °ºm
¹ÈÈˈãÒÏÓÈËÓÒËm©¯ÈÎËÓÒ«°ºÓÒäÒϪãËäËӈºm‚}ÈÏÈÓÓºº
°¹Ò°}È sȹ¯Òä˯ ã« ¹ºã‚ËÓÒ« °mËËÓÒ® º °ˆ‚ËӈȲ m‚²
¯‚¹¹äºÎÓºÒ°¹ºã ϺmȈ Ïȹ¯º°
6(/(&7
 )520Klm^_gl
 :+(5(=jmiiZ ,1      :W  :H     
       {¹º°ãËÓËä ¹¯Òä˯ËäºÎÓº¹¯ÒäËÓ҈ ‚°ãºmÒ˹ºÒ°
}È :+(5(=jmiiZ :W25=jmiiZ :H¯Ò°ãºÎÓ©²‚°
ãºmÒ«² ¹¯ÒäËÓËÓÒË ¹¯ËÒ}ȈÈ ,1 º}ÈÏ©mÈˈ°« ­ºãËË ¹¯º°ˆ©ä Ò
ÓÈã«Ó©ä
      ¯ËÒ}Ȉ %(7:((1«$1' º¹¯ËËã«Ëˆ ¹¯ÒÓÈãËÎÓº°ˆ ÏÓÈË
ÓÒ«m©¯ÈÎËÓÒ«‚}ÈÏÈÓÓºä‚ÒȹÈϺӂ¯ËÒ}Ȉ«mã«Ëˆ°«m}ã 
È Òä ˆ Ë ¹¯ºm˯«Ëˆ‚}ÈÏÈÓÓ©Ë ¯ÈÓÒÓ©ËÏÓÈËÓÒ«¯ËÒ
}ȈȰˆºÒ°¹ºã ς ˆã«¹¯ºm˯}Ò¹º¹ÈÈˈãÒÏÓÈËÓÒ˹ºã«m
‚}ÈÏÈÓÓ©®ÒȹÈϺÓÒ°ËãsºäºÎÓº¹¯ÒäËÓ«ˆ ªˆºˆ¹¯ËÒ}ȈÒ
ã« ¯È­ºˆ© °º °ˆ¯º}ºm©äÒ ÈÓÓ©äÒ sȹ¯Òä˯ m©Ȉ m°Ë °mË
ËÓÒ« º °ˆ‚ËӈȲ ÁÈäÒãÒÒ }ºˆº¯©² ÓÈÒÓÈ ˆ°« ° k  ¹º z 
m}ã ҈Ëã ÓºäºÎÓºº¹Ë¯Èˆº¯ºä