02-09-2014_16-40-43 / 2013 Пакеты прикладных программ
.pdf5.2. "1MnopT, np11tcoeA11tHeH11te 11'1 3KcnopT A3HHblX
O;::i;H11M 113 ;::i;ocTOl1HCTB CYE,U Access 51BJHieTC51 B03MO)!(HOCTb pa6oTbI c ;::i;aHHbIMl1, pa3pa6oTaHHbIMl1 c rrp11MeHeH11eM ;::i;pyrMX rrpo-
rpaMMHbIX rrpo;::i;yicroB, T. e. 11MrropT mm 3KcrropT ;::i;aHHbIX.
Access B3a11Mo;::i;eikTByeT c ;::i;aHHbIMl1, pa3pa6oTaHHbIMl1 ;::i;pyr11M11 rrpMJIO)!(eHM51Ml1 Windows (TeKCTOBbIMl1, rpaq>:w1ecKMMl1, 3JieKTPOH-
HbIMl1 Ta6JIMI.J;aM11), a TaK)!(e c 6a3aMl1 ;::i;aHHbIX, pa3pa60TaHHbIMl1 c 11CIIOJib30BaHl1eM crreu.11aJibHbIX 513bIKOB rrporpaMM11pOBaHM51 dBASE, Paradox, Btrive, SQL.
Bee ;::i;eH:cTBM51 c 11mpopMau.neH: B CYE,U Access - qTeH11e, BCTaBKa, y;::i;aneH11e ;::i;aHHbIX 11 ;::i;pyr11e BbITIOJIIDIIOTC51 c IIOMOll.lbIO KOMaH;::i;,
HarrncaHHhIX Ha CTPYKTYPl1POBaHHOM 513hIKe 3arrpocoB - SQL, KO-
TOPhIH ,ll;OJI)!(eH 6bITb yTBep)l{)leH Me)!()J;yHapO,ll;HOH opraHH3al.l,HeH CTaH- ;::i;apTOB ISO B KaqecTBe oqm:u,HaJihHOro CTaH;::i;apTa peJI5IU.110HHhIX 6a3 ;::i;aHHbIX.
Mo;::i;mpHKaU.HH 513b1Ka SQL rrpHMeIDIIOTC51 B CTPYKTYPe rrpaKTHqecKM Bcex peJI5IU.110HHhIX. CYE,U. B CTPYKTYPe CYE,U Access co;::i;ep- )!(HTC51 ;::i;paH:Bep Open Database Connectivity (ODBC - OTKPhIThIH ,ll;OCTYII K ;::i;aHHbIM), o6ecrreqnBaIOll.lHH B3aHMO,ll;eHCTBHe c ;::i;pyrHMH 6aJaMl1 ;::i;aHHbIX.
HMIIOP'fa npacoe,ll,lllleHHe ,11;3.llllblX. I1p11 co3;::i;aHHH Ta6JIHU. B Access 06ecrreq11BaeTC5I B03MO)!(HOCTb 11MIIOpTa ;::i;aHHbIX 113 <t>aH:JioB c pa3JIJfqHbIMl1 <t>opMaTaMl1, pa3pa60TaHHbIMl1 c IIOMOll.lbIO ;::i;pyr11x rrporpaMMHbIX rrpOAYK'fOB,rrocpe;::i;CTBOM KOII11pOBaHl151.
I1p11coe;::i;11HeH11e ;::i;aHHbIX - 3TO B03M0)!(H0CTb o6pameHM51 113 o;::i;- HOH 6a3bl ;::i;aHHbIX K UH$OpMau.1111, UMeIOmetl:c51 B ;::i;pyrux 6a3aX ;::i;aHHblX (Ta6JIHU.aM), KOTOpbie MOryr HaXO,ll;UTbC51 KaK B TOM )Ke KOMIIbIOTepe, TaK " B ;::i;pyr11x KOMIIblOTepax, o6be,ll;UHeHHbIX ceTbIO.
11MrropT ;::i;aHHbIX rrpe;::i;rroqT11TeJieH B cJie;::i;yrom11x cmyau,M51x:
•Heo6xOJJ;l1Mbie ;::i;aHHbie HaXOMTCH B <t>aH:Jie He60JibllIOfO pa3Mepa (K6aHTbI);
•He06XO,ll;l1Mbie ;::i;aHHhie HaXOMTC51 B <t>aH:Jie, co;::i;ep)!(aH11e KOToporo IIOJib30BaTeJieM MeIDieTC51 JJ;OCTaToqHo pe;::i;Ko;
•rrp11 3aMeHe Bepc11u Access <t>aH:JlhI rrpe)!(Hero <t>opMaTa B HOBOH Bepc11u 11CIIOJib30BaTbCH He MOryr.
I1p11coe;::i;uHeHue ;::i;aHHbIX rrpe;::i;rroqTuTeJibHO B cJie;::i;yromwx c11zya- U.M5IX:
•TPe6yeMbIH <t>aH:JI no pa3Mepy 6oJihllie MaKCl1MaJihHO B03MO)!(HOro pa3Mepa EL( B Access (1 f6atl:T);
•;::i;aHHbie <t>anJia qacTO MeH5IIOTC51 IIOJib30BaTeJieM;
•;::i;aHHbie <t>aH:Jia 11CIIOJib3YJOTC51 rrp11 pa6oTe B pe)!(HMe KOJIJieKTl1BHOf0 ;::i;ocryrra.
TeXHoJior1151 11MrropTa <t>aH:JioB:
~OTKPbITh 6aJy ;::i;aHHhIX, B KOTopyro 6y;::i;eT 11MrropT11poBaTbC5I <t>aH:JI;
~aKT11B113upoBaTh MeHIO </Jaii.n 11 KOMaH;::i;y HMnopm;
70
:::::} B IIOHBMBIIIeMCH )J;Ma.JIOfOBOM OKHe lfMnopm BbI6paTb M3 rrpeMO- )l(eHHOfO crrwcKa ¢>opMaT MMrropTMpyeMoro <t>aitrra. TipM 3TOM Access OTKpoeT .IJ:Ma.JIOroBoe OKHO
:::::} B OKHe Bbt6op <jJaUA06 BbI6paTh MMIIOPTMpyeMblM <t>aitrr.
B rrpo:uecce MMIIOpTa rrpOMCXO.IJ:MT rrpeo6pa30BaHMe TMIIOB IIOJie:H 11 MrropTMpyeMhIX ;::i:aHHhIX B ¢>opMaThI ;::i:aHHhIX Access.
AHa.JiorWIHO rrpoM3BO.IJ:MTCH MMrropT ;::i:aHHhIX M M3 ;::i:pymx B,Z:t pa3pa6oTaHHhIX B cpe;::i:e Access.
HarrpMMep, rrpM MMIIOPTMPOBaHMM TeKCTOBhIX ¢>aitrroB B rn6JIM:UhI Access MX Heo6xo;::i:MMO COOTBeTCTBYIOIUMM o6pa30M CTpYKTYPMPOBaTh: JIH6o TeKCT o<t>opMMTb B BM)J;e Ta6JIM:U, JIM6o MCIIOJib30BaTh B TeKCTe pa3;::i:emrren11, OTJIWiaIOIUlle Haqa.Jio 11 KOHe:u a63a:ua. TaKHMll pa3;::i:e- J111TeID1M11 MOryT CJIY)l(HTb 3alliITaH, rrpo6eJI, Ta6yJIHI(llH.
TeXHoJiorHH 11p11coe;::i:11HeHHH rn6n11:u:
:::::} OTKpbITb 6a3y ;::i:aHHhIX, B KOTOpyro 6y;::i:eT HMIIOpm:poBaTbCH <l>aitrr;
:::::} aKTIIBll3HpOBaTb MeHIO </JaWi II KOMaH,.!JY IlpucoeiJUHUmb ma611u-tzy;
:::::} B IIOHBHBIIIeMCH )J;llaJIOfOBOM OKHe IlpucoeiJuHeHue ma611u14 Bbl6-
paTb 113 11peMOXeHHOfO CIIllCKa <t>opMaT HMIIOpm:pyeMoro <t>aitrra, Access OTKpoeT ;::i:11a.Jioroeoe OKHO Bbt6op 603bl iJaHHbDC;
:::::} B oKHe Bbt6op 6a3bl iJaHHbDC Bh16paTh llMH B,lI;, Access
.IJ:MaJIOfOBOe OKHO CO CIIllCKOM Ta6Jill:U Bhl6paHHOM B,lJ;;
:::::} BbI6paTb HYXHYID Ta6n11:uy II aKTllBll311pOBaTb KOMaH.IJ:Y
OUHUmb.
3KcnopT .n;annhlx. TexHonorMH 3Kcrroprn rn6mr:u M3 o.n;Ho:H B,lI; B ;::i:pynre rrpaKTWieCKH aHanomqHa MMrropry.
5.3. ny6m1Ka4MJ1 AaHHblX B ceTJIX Internet "'Intranet
CoBpeMeHHhie KOMIIhlOTepHbie TeXHoJionrn, 11p11MeHHeMb1e B rrpoH3BO)J;CTBe M 6113Hece, OpMeHTHPYIOTCH Ha IIIHPOKHe B03M0)!(HOCTM npMMeHeHHH JIOKa.JibHbIX M fJI06a.JibHbIX BblqlfCJIMTeJihHbIX ceTeM - Intranet H Internet, T. e. rrepe;::i:aqy MJIM rronyqeHHe rpa¢>wqecKo:i1: M TeKcToBo:H HH¢>opMa:UHH (qepTe)l(eM .n;eTa.Jie:H, y3JloB, TeXHOJIOrWiecKo:H JJ:OKYMeHTa:UMM, ;:i:aHHbIX 0 <l>MHaHCOBOM ;::i:eHTeJibHOCTM <l>HpMbl 11 ;::i:p.) y;::i:a.JieHHhIMM rroJib30BaTeJIHMH. CYB,lI; Microsoft Access 2000 npe;:i:ocTaBJIHeT IIOJih30BaTeJI10 Bce Heo6xo;::i:HMhie cpe;:i:cTBa MH BhInoJIHeHHH 3TMX orrepau;w:H.
,lljrn 11H¢>opMa:UHOHHoro o6MeHa qepe3 Internet B CYB,lI; Access 2000 npe;:i:ycMOTpeHO C03,[(aHMe TaK Ha3bIBaeMblX CTpaHM:U )J;OCTYIIa K ;::i:aHHbIM (Data Access Pages), rrpe;::i:cTaBJIHIOIIIHX co6otl crre:u;Ha.JihHhie ¢>opMhI, c KOTOPhIMM MO)l(HO pa6oTaTh B Web-6poy3epax, HaIIpMMep Internet Explorer. no CYTM CTpaHH:Ua ,[(OCTYIIa K ;::i:aHHblM - 3TO WebCTpaHH:Ua, pa3pa6oTaHHaH B BM)J;e <t>opMbl, 1103BOJIHlOII(eH BBO,[(MTh, npocMaTpHBaTh H .uenaTh BhI6opKH MH<t>opMa:UHH B 6a3e .uaHHhIX. CrpaHM:UhI .UOCTYIIa K .uaHHhIM, B OTJIWIHe OT <t>opM xpaIBITCH B BR)le OT-
71
,lleJibHblX <t>aIDIOB BHe <t>aIDia 6a.3bl .uaHHbIX H MOI)'Trry6JIHKOBaTbCH Ha Web-cepeepax.
<l>aKTHqecKH CTPaHHUhI .llOCTYIIa K .uaHHbIM no3BOJIHIOT coJ.uasaTh H xpaHHTb HH<t>opMaUHIO B <t>opMaTe HTML.
0.UHHM H3 ,llOCTif)l(eHHH COBpeMeHHbIX HH<t>opMaUHOHHbIX TeXHOJIOfHH HBJIHeTCH 803MOXHOCTb COBMeCTHOH pa60Tbl cneuHaJIHCTOB B JIOKaJlbHblX (B npe.uenax npe.n:npIDITIDI) KOMnbKYrepHbIX CeTHX Intranet.
B 3TOM c;zyqae Access 2000 no3BOJIHeT opraHH3oBaTb 3<l><l>eKTHBH}'IO pa6ory c 6a.3aMH .uaHHhIX no apXHTeKT}'PeKJIHeHT-cepeep, T.e. co- 3.llaTb cneu11anbHbIH <t>aIDI npoeKTa c pac11111peHHhlM ADP, B KOTO-
poM xpaHHTc.si: o6'beKTblHHTep<t>eika noJib30BaTeJIH - |
<t>opMhl, o~e |
Thl, MaKpOChl, MOJlYJIH. Bee o6'beKThl6a.3hl .uaHHhlX - |
Ta6JIHUhl, JaII- |
pocbl pa.3pa6aTblBaIOTC.SI Ha .SI3h1Ke SQL H xpaHHTC.SI B BH.z:t:e <t>aIDios SQL-Server, a KJIHeHTCKaH qacTu pa.3pa6aTumaeTC.si: B cpe.ue Access 2000. B 3TOM cnyqae o6ecrreq}{BalQTC.si: ueHTPaJIH30BaHHoe coJ.z:t:aHHe 6aJ .uattHLIX H 3<l><t>eKTHBHhlii )lOCTYII K 3THM )laHHhIM pa3.JIH11HhIMH IlOJib30BaTeJIHMH. TaKHe 6a3hl .llaHHhlX HHor.ua Ha3hIBaIOT KoprropaTHBHhIMH.
5.4. "1HTenneKTYanbHblM aHanM3 AaHHblX
B HaCTO.SIIUee BpeM.SI rro;zyqaeT pa.3BHTHe HOBoe HarrpaBJieHHe KOMIlbIOTepHbIX HH<t>opMaUHOHHbIX TeXHOJIOfHH - HHTeJIJieKryaJibHbIH aHaJIH3 .uaHHblX (MA.l1:), OCHOBHOe Ha3HaqeHHe KOTOporo - IlOBbIIIIeHHe 3<l><l>eKTHBHOCTH npHHHMaeMbIX peIIIeHHH.
C11cTeMbI MM peaJIH3YIOT HOBbIH HHTeJIJieKTYaJihHbIH no.uxo.u K npHMeHeHHIO CYB)],, a HMeHHO noucK u 8blH8AeHue JaKoHoMepHocmeii B pa3JIHqHbIX c<t>epax .ueHTeJibHOCTH. TaK, eme npH wcnoJih30BaHHH CYB)], «Pe6yc» (dBase-III) pa3pa6aTbIBaJIHCb 6a3bI .uaHHbIX MH yqeTa H IIOCJie,llYJOIUero aHaJIH3a rrpHqHH OTKa30B H3,lleJIHH B rrpouecce rrpoH3BO.llCTBa H 3KcnJiyaTaUHH. B HacToHmee epeMH c pa3BHTHeM CYB)], 3TO HanpaeneHHe pa3pa6oTKH B)l, CTaJIO HCIIOJih30BaTbCH rrpH aHaJIH3e 6H3Hec-rrpoueccoe B caMhIX OTBeTCTBeHHhIX c<t>epax .ueHTeJibHOCTH - MapKeTHHre, rrpOH380,llCTBe, o6CJIY)l(HBaHHH.
Pa3BHTHe MA.l1: o6ycnoBJieHo cJieJlYIOIUHMH TeXH11qecKHMH H co- UHaJibH0-3KOHOMHqecKHMH <t>aKTopaMH:
•IlOHBJieHHeM OTHOCHTeJibHO .ueIIIeBblX H )lOCTaToqHo o6beMHbIX YCTPOHCTB xpaHeHHH HH<t>opMaUHH (.uo 100 f6aff:T), C03)laHHeM KOMIlbIOTepOB c rrapaJIJieJibHOH apXHTeKT}'POHH pa3BHTHeM ceTeBblX TexHOJIOrHH;
•cTatt.z:t:apTHJauweH: cpe.ucrn CYB)]. Ha ocHoBe SQL-Janpocos;
•o60CTPeHHeM KOHKYPeHTHOH 6opb6bl 3a c<t>epbl BJIHHHHH Ha IIOTPe6HTeJieH IIPO.UYKUHH H ycnyr;
•rrepexO,llOM OT MaCCOBOro o6CJiyxHBaHHH IIOTPe6HTeJieH K HH.z:t:H-
BHJzyaJibHOMY.
Pa3JI}{qaJOT cne.uyiomHe 3TaIIbI npouecca MM:
72
=> BhI6op .uaHHhIX;
=> TpaHcq>0pMa1urn .uaHHhIX;
=> aHaJIHJ HmpopMaUHH.
KaK rrpaBHJIO, ,U.JUI pernemrn KOHKpeTHOM Ja,naqH Tpe6yeTCR He BCR 11H<l>opMaUHR, co.uepxamaRcR B 6,[J:, T.e. HJ HMeIOIIlHXCR Ta6JIHU Tpe6yeTCR BbI6paTb JaIIHCH c orrpe.ueneHHOM HOMeHKJiaTYPOM IIOJie:H.
TeXHonorHR Bb16opa .uaHHhIX ,U.JUI 11A,U:
=> COJ,UaHHe Ta6JIHUbl (AHOJZU3 OOHHblX) c Tpe6yeMOM CTpYKTYPOM ( COCTaBOM IIOJie:H HJ HMeIOIIlHXCR Ta6JIHU 6,[J:);
=> COJ,UaHHe JanpocOB Ha Bbl6op Tpe6yeMOM HH<l>opMaUHH HJ Ta6JIHU H ee .uo6aBJieHHe B ra6nnuy AHOJZU3 iJaHHblX.
Ilocne COJ,UaHHR Ta6JIHUhl ,U.JUI aHa.JIHJa .U3HHhIX HHOr.ua rrpOBO.D;HTCR ynopR,D;oqHBaHHe HH<l>opMaUHH (TpaHc<t>opMaUHR) - y,n;aJieHHe
.uy6JIHPYJOIIlHX JaITHce:ii, npHBe.n;eHHe .n;aHHblX B IlOllilX K e.n;HHOMY <PopMazy H ,n;p.
,llmI Henocpe,n;cTBeHHoro aHaJIHJa HH<l>opMauHH c ueJlbIO no.rryqeHHR onpe,n;eJieHHhlX JaKOHOMepHocTeit rrpHMeIDIIOTCR HJBeCTHble MeTO.D;bl MaTeMaTJNeCKOit CTilTHCTHKH. IlpH 3TOM npouecc aHaJIHJa HH- <PopMauHH CBO.D;HTCR K .D;BYM OCHOBHhIM rrpoue,n;ypaM: npoeepKe m- noTeJ H IlOHCKY JaKOHOMepHOCTe:H.
,llmI rrpoBepKH mnoTeJhl npe,n;cTaBJIRIOT HH<l>opMaUHIO, co,n;ep:xcaIUYIOCR B Ta6nuue AHOJZU3 iJaHHblX, B BH.D;e OT11eTa (Ta6JIHUhl, rpa<l>H- Ka, .uuarpaMMbI), npwreM peJyJibTaTbl 3T0f0 o~eTa MOryT IIO,UBepraTbCR CTaTHCTH'IeCKOMYaHaJIHJY c npHMeHeHHeM paJJmqHbIX MaTeMaTWieCKHX MeTO.UOB.
110HCK JaKOHOMepHOCTe:H CBO.UHTCR K CJie.UYIOIIlHM onepaum1M: nporHOJHOMY MO,UeJIHpoBaHHIO; aHaJIHJY CBRJe:H; cerMeHTaUHl-1 6,[J:;
11)].eHTH<l>HKaUHH OTKJIOHeHHM.
Uenh nporHOJHoro Mo.uenHpoBaHHR JaKJI10qaeTcR B coJ,UattHH 0606- w.eHHOM MO,UeJIH IIOBe,UeHHR aHaJIHJHpyeMOM CHCTeMbl .uaHHbIX Ha OCHOBe IIOCTpOeHHR H aHaJIHJa MaTeMaTHqecKHX Mo.uene:H.
3aBHCHMOCTH (CBRJH) Me)K)zy OT,UeJibHblMH JaIIHCRMH 6,[J: orrpe.ueJIRIOTCR KJiaCCH'IeCKHMHMeTO,UaMH KoppeAAUHOHHOro H perpeCCHOHHOfO aHaJIHJa.
U:eJibIO cerMeHTaUHH 6,[J: - paJ6HeHHR JaIIHCe:H Ha rpynIIhl c ueJlhlO cyxeHHR o6naCTeM aHaJIHJa .uaHHblX - RBJIReTCR COJ,UaHHe o~e
TOB c rpynnHpOBKOM .uaHHbIX.
U:eJibIO H,D;eHTH<l>HKaUHH OTKJIOHeHHM RBJIReTCR BbUIBJieHHe JaIIHce:H, He BXO,URIIlHX B ycTaHOBJieHHbie rpynIIhl, H rrpoBe,UeHHe MaTeMaTHqeCKOM o6pa60TKH .uaHHblX, T. e. ycTaHOBJieHHe, RBJIRIOTCR JIH 3TH OTKJIOHeHHR «llIYMOM» HJIH xe OHH rrpe,UCTaBJIRIOT co6o:H JaKOHOMepHhIM rrpouecc.
KoHTponbHble eonpocb1
1. KaKHe xapaKTepHCTHKH CYE.Il Access C.LleJiarrH ee O.LIHOJ:t H3 caMhIX nonyAApHhIX nporpaMMHhIX CHCTeM?
73
2.qTO TaKOe HMUOpT, 3KCUOpT H npncoe.n;HHeHHe .n;aHHhIX?
3.qeM OTJmqaeTCH HMUOPT .n;aHHhIX OT npncoe.n;HHeHHH .n;aHHhIX?
4.B KaKHX CJIY'IaHX11eJiecoo6pa3HO npHMeHeHHe HMUOpTa H B KaKHX - npHCOe,ll;HHeHHe .n;aHHhIX?
5.qTO TaKOe HHTeJIJieK'ryaJihHhIHaHaJIH3 .n;aHHhIX?
6.B KaKHX c<t>epax .n;eHTeJihHOCTH npHMeHHIOT l1A,[l?
7.KaKOBhl OCHOBHhie 3Tanhl npo11ecca l1A,[l?
8.c KaKOH 11eJihIO npOBO,ll;HTCH aHaJIH3 HH<t>opMaIIHH?
9. .[Lim qero nplIMeHHIOT TeXHOJIOrHIO TpaHc<t>opMaIIHH .n;aHHhIX?
10.J.fa KaKttX onepa1111il: COCTOHT 3a,11;aqa IlOHCKa 3aKOHOMepHOCTeil:?
11.qeM o6ycJIOBJieHO UOHBJieHHe 11A,ll,?
rnaea 6
TEXHOJ10rl.1.SI PA3PA60TKl.1 TA6111.1U 6A3 .QAHHblX
6.1. Pa3pa6oTKa <1>M3M"leCKOM MOAenM AaHHblX
IlpelK,lle qeM BKJIIOqHTh KOMIIhIOTep H JarrycTHTh Access, Heo6xo,n;HMO ycTaHOBHTh o6H3aTeJibHbie xapaKTepHCTHKH o6'beKTOBB.[l - cPHJHqeCKYIO MO,D;eJib ,D;aHHbIX, T.e. HOMeHKJiaTypy rrpH3HaKOB OIIHcaHHH 06'beKTa(cocTaB H qHCJIO IIOJieU:) H xapaKTepHCTHKH KIDK-
JlOfO IIOJIH Ta6mn.J;hl, a pe3yJihTaThI O<popMHTb B Ta6JIHqHOM BH,D;e (pHC. 6.1).
|
XapaicrepHCTHKH norreil: B.D: |
|
|
IlpH3HaKH ofu.eicra B.D: |
THn |
lJHCJIO |
ToqHOCTb |
|
HMH IlOJUI |
CHMBOJIOB |
|
|
.llllHHhIX |
|
|
P11c. 6.1. BH.ll: rn61rnu:h1 )LJUI orrncamui: xapaKTep11cTHK noneii: 6a3hI .n;aHHhIX
3aTeM MO)l(HO rrpHCTYITHTh K C03,llaHHIO Ta6JIHUhI B cpe,lle Access. Bo Bcex HMeIOW:HXCH BepcHHX 3TOM CHCTeMbI IlOCJie,n;oBaTeJibHOCTb ,n;e:H- CTBHM rrpaKTflqeCKH o,n;HHaKoBa. CymecTByeT JIHIIIh tteKOTOpaH pa3HHua B o<t>opMJieHHH JlHaJIOroBbIX OKOH. PaccMOTpHM rrpHMepbI co3;::i;a- HHH Ta6JIHU c HCITOJih30BattHeM Bepcww Microsoft Access 2000.
6.2. C03AaHMe Ta6n1>1'-'b1c noMOU4blO KOHCTpyKTopa Ta6nM""
,[lJIH C03)J;aHHH Ta6JIHUbl Heo6XO)J;HMO BbIIlOJIHHTb CJie;::i;yiomwe ,n;e:H-
CTBHH:
::::} BKJIJOqHTh KOMIThIOTep H 3arpy3HTu rrporpaMMHoe o6ecrreqeHHe - Windows H Access;
::::} B IIOHBHBIIIeMCH ,D;HaJIOfOBOM OKHe JlBaJK,D;bl meJIKHYTb KHOIIKOH MhIIIIH 110 MeHIO <l>all.n H Bb16paTh KOMaHJlY C03aamb;
::::} B ,n;wanoroBoM oKHe Co3aaHue (pnc. 6.2) aKTHBH3HpoBaTh rrepeKJIJOqaTeJib Ba3hI ,n;aHHhIX H menKHyTh MhIIIIhIO no KHOIIKe [OK];
::::} B )J;HaJIOfOBOM OKHe </>aUJl H060U 6a3bl aaHHblX (pHC. 6.3) rrp11CBOHTb HMH <t>a:Hny, yKa3aB rrpH 3TOM HMH )J;HpeKTOPHH (nanKH), r;::i;e 6y;::i;eT xpaHHThCH B,[l, H meJIKHYTh MhIIIIhIO no KHOnKe
oamb;
•B HMeHH IIOJUI He .D:OJDKHO 6bITb 3HaKOB rrpeIIHHamui:, CK060K, BOCKJIHIIaTeJihHbIX 3HaKoB;
•He .n;onycKaeTC51 IIOBTOpeHHe HMeH B Ta6JIHI1e.
Tex.ttoJiorIDI JaHeceHHH .n;aHHhIX B CTpOKH HH$opMaIIHOHHhIX 6JioKOB KOHCTp}'KTOpaTa6JIHII aHaJIOfH'!HaTeXHOJIOfHH pa60Tbl c Ta6JIH11aMH B TeKCTOBOM pe.n;aKTope Word. IlpH'!eMJarroJIHeHHe HH$opMaIIHOHHhIX 6JIOKOB CJie.nyeT rrpOH3BO.D:HTb IIOCJie.n;osaTeJibHO .D:llil KIDK,Ll;O- ro IIOJUI B CJie.nyromeM IIOPH.n;Ke:
~BBeCTH HM51 IIOJIH;
~Bb16paTb THII .n;aHHbIX;
~BBeCTH B CTpOicy 6JIOKa OnucaHue KOMMeHTapHH, IIOHCHHIOIIIHH
xapaKTep BBO.D:HMbIX 3Ha1:1eHHH B H':leH:icy.LJ:aHHOfO IIOJIH (B .LJ:aJibHeHIIIeM rrpH 3aIIOJIHeHHH Ta6JIHllhl 3TOT KOMMeHTapHH BbIBO,llHTC51 B CTpOKY 110.D:CKaJKH B HIDKHeH 1:1aCTH 3KpaHa);
~33,ll;aTb CBOHCTBa IIOJIH;
~IIOBTOpHTb YKaJaHHbie .n;eHCTBHH .D:llil acex OCTaJibHblX IIOJieH Ta6-
JIH11hl.
B KOHcrpyicrope Ta6.mm Microsoft Acee~ ahl6op THIIa .llaHHhIX MOJK-
HO ocyw;eCTBHTb 1:1epe3 CIIHCOK. IIpHBe.n;eM THIIbl .n;aHHhIX, BXO.ll;HID;HX B 3TOT CIIHCOK.
TeJCcmoBblU. IIoJie ,uaHHhIX 3TOro THrra MoxeT co.nepxaTh .no 255 mo6bIX CHMBOJIOB, B TOM 1:1HCJie H IIH$phl. B TaKoe IIOJie .n;aHHbIX MOryT TaKXe BBO.LJ:HTbC51 O.LJ:HH IIH$phl, eCJIH c HHMH He rrpe.nrroJiaraeTC51 npOH3BO.D:HTb Bbl1:1HCJieHHH.
MeMo. IloJie .n;aHHhIX 3Toro THrra, HaJhIBaeMoe rroJieM TeKCTOBhIX IIPHMe1:1aHHH, rrpe.n;Ha3Ha1:1eHO )J,Jl51 co.n;ep)l(aHH51 TeKCTOBOH HH$OpMallHH )J,JIHHOH 6oJiee 255 CHMBOJIOB; B Access 2000 - .no 65 535 CHMBOJIOB. 3TOT THII .n;aHHbIX OTJIH'!aeTC51OT TeKCTOBOfO TeM, 'ITOrrpe.n;cTaBJIHeT co6oH: He caMH .n;aHHhie, a CCbIJIKH Ha COOTBeTCTBYIOlllHe 6JIOKH
.n;aHHbIX, xpaHH111nec51 OT.D:eJibHO, 'ITO 3Ha1:1HTeJihHO YCKOpHeT o6pa60TKY Ta6JIHII. Ilpn 3TOM rroJIH .n;aHHhIX Tttna MeMo He MOfYT 6hITh KJllO'IeBbIMHHJIH HH.n;eKCHbIMH.
lfUCJl060U. )laHHbie 3TOfO THna npeJJ;Ha3Ha1:1aIOTC51 )J,Jl51 xapaKTepHCTHKH 06'beKTOB6a3bl JJ;aHHbIX, KOTOpbie MOryT yqaCTBOBaTb B MaTeMaTH'IeCKHXpac1:1ernx.
J(ama/6peMR. )laHHhie TaKoro THna rrpe.nHaJHa1:1etthI MH YKaJaHHH JJ;aTbl HJIH speMeHH, xapaKTepH3YJOIIIHX KOHKpeTHYJO JailHCb Ta6JIHllhl, HanpHMep JJ;aTbl rroczyIIJieHH51 TOBapa Ha CKJiaJJ; HJIH BpeMeHH Ha1:1aJia H OKOH1:1aHHH pa6oThI rroJihJOBaTeJIH B ceTH Internet. B rroJie JJ;aHHbIX 3TOfO THIIa MO)l(HO BBOL(HTb JJ;aTbl c 100 no 9999 fOL(bl.
J(eHeJICHblU. )laHHbie 3T0f0 THIIa aHaJIOfH'!Hbl.n;aHHbIM 1:1HCJIOBOfO THIIa H OTJIH1:1aIOTC51 OT HHX TOJibKO xapaKTepHCTHKaMH BBO.D:HMbIX 1:1HceJI. To1:1HOCTh 1:1HCJia .naHHhIX TaKoro THIIa He rrpeBhIIIIaeT 1:1eTb1pex 3HaKOB IIOCJie 3a1I51TOH, a 11emu1 qacTb MOXeT co.nepxaTb L(O 15 .necHTH':IHhIXpaJpMOB. B KOHIIe 1:1ncJia MO)l(eT 6h1Th rrpocrnBJieHo 060JHa1:1eHHe BaJIIOTbl.
78
C11em11wc. IloJie co.uep:>KHT YHl1KaJihHhIH (He noBTOpH10m11iicH) HOMep Jan11c11 rn6JI11u;b1 B)l,. 3HaqeHHH 3Toro noAA He o6HOBAAIOTCH. Ta6JIHI.J;a Access 2000 MO:>KeT co.uepxaTb 2 MJIP.U Jan11ceti.
JlozuiteCICUU. IlapaMeTpbl IlOJIH .uaHHbIX 3TOro Tl1Ila MOryr npl1Hl1MaTb TOJlbKO .usa JHaqeHHH, l1HTepnpeT11poBaHHhie KaK )l,a/HeT, licTHHa/Jlo:>Kb, BKJI10qeHo/Bb1KJI10qeHo. IloAA .uaHHhIX JIOIWiecKoro T11na He MOryr 6bITb KJIIOqeBbIMl1, HO MOryr 6bITb 11H,UeKCHbIMl1.
OLE (OLE-o6'heKT).B H'leHKHnoJIH .uaHHhIX 3Toro THna BBOMTCH cchIJIKH Ha npHJio:>KeHHH, pa3pa60TaHHhie UM Windows. 3TO Moryr 6hITh TeKCTOBbie, rpa.pnqecKHe 11 MYJihTl1Me.UHHHhie .PatiJibI. 06neM xpaHHMbIX .uaHHblX TaKoro THna B Hqeif:Kax IlOJIH orpaHHqeH TOJibKO
.U11CKOBblM npOCTPaHCTBOM KOMilbIOTepa.
I'unepCCblJllCO (Hyperlink). IlOJBOJIHeT BCTaBAATb B IlOJie a.upec, c IIOMOil.t;bIO KOTOporo MO:>KHO CCblJiaTbCH Ha JII06oif: 4>atiJI HJIH q,parMeHT n106oro .PatiJia, HaxoMmerocH B TOM xe KOMilbIOrepe, r.ue Haxo.uHTCH Ta6nHu;a B)l,, HJIH B JII060M KOMilbIOrepe JIOKaJibHOH ceTH HJIH B ceTH Internet.
fHrrepCCbIJIKa COCTOHT HJ TPeX qacTeif:: a.upeca, YKaJblBaIOil.t;ero rryrh K .paif:Jiy, .uonoJIHHTeJibHOro a.upeca, YKaJbIBaIOw;ero nonoxeHHe .pparMeHTa BHyrpH .PatiJia HJIH CTPaHHI.J;bl TeKCTa, H OT06paxaeMoro TeKcTa. KIDK,.uaH qacTh mnepccbIJIKH MO:>KeT co.uepxaTh .uo 2048
Cl1MBOJIOB.
Macmep noiJcm01-t0601C. IloJBOJIHeT coJ.uasaTh 4>11Kc11posaHHb1e cn11c-
KH 3HaqeHl1H, KOTOPhie MOryT rrpHHl1MaTh .uaHHhie, JaHOCl1Mhie B j{qeif-
KH IlOJIH.
IlocJie ycTaHOBJieHl1H 11MeHl1 11 T11na .uaHHhIX Kypcop IIOMern;aIOT B coOTBeTCTBYJOmyIO CTPOKY 6JioKa OnucaHue H co3.ua10T KOMMeHTap11ti, Il03BOJIHIOIU11H IlOJibJOBaTeJIIO npaBHJibHO BBO.UHTh 11H.PopMau;1110 rrp11 JanoJIHeH1111 Ta6JI11u;b1.
PeKOMeH,D,yeTCH o6HJaTeJihHO BBO.U11Th KOMMeHTapHH, oco6eHHO B Tex CJI)"laHX, Kor.ua B o6oJHaqeHl111 11MeHl1 HJll1 IlO.Uill1CH IlOJIH co.uep- )1(11TCH He,UOCTaToqHo l1H4>0pMau;1111 MH npaBHJihHOro BBO.Ua .uaHHbIX. Hanp11Mep, np11 sso.ue xapaKTep11cT11K TeXHoJior11qecKoro 06opy.uoBaH11H B noJie Dmax (CM. p11c. 4.3) IlOJihJOBaTeJih ,UOJl)l(eH JHaTb, qTo MaKCl1MaJibHbIH .u11aMeTP JaroTOBKH, KOTOpaH MO:>KeT 6hITh o6pa6oTaHa Ha CTaHKe .uaHHOH MO,UeJil1, YKaJaH B MHJIJil1MeTpax, T. e. B 3TOM cJiyqae B CTPOKe 6JioKa OnucaHue MO:>KHO c.ueJiaTb cJie,UYJOIUHH KOMMeHTap11ti: MOICCUMaJlbHblU iJuaMemp 3a20m061CU 6 MM.
IlocJie BBO.Ua KOMMeHTapHH He06XO.Ul1MO nepetiTH K 6JIOKY
cm6a noflJl B paJ.lleJie 06w,ue H Ja,IJ,aTh noJIIO TPe6yeML1e csoticTBa. B KOHCTPYKTOpe Ta6JIHI.J; Ka)l(,UOMY IlOJIIO B JaB11CHMOCTl1 OT Tl1Ila .uaHHblX aBTOMaT11qeCKl1 (no yMoJiqaH11IO) Ja.uaeTCH onpe.ueJieHHbIH Ha6op CBOHCTB. KoHCTPYHPYH Ta6JIHI.J;y, 3TH CBOHCTBa HJMeHHIOT B COOTBeTCTBl111 c KOHKpeTHbIMl1 TPe6osaHHHMl1 K .uaHHbIM.
Ha pHc. 6.5 noKaJaH .pparMeHT CTPYKTYPhI Ta6JI11u;b1, coJ.uaHHOH B pe)l(l1Me KOHCTPYKTOpa, c on11catt11eM CBOHCTB O.UHOro 113 IlOJieH.
79