02-09-2014_16-40-43 / 2013 Пакеты прикладных программ

0KHO OIIHCaHIDI CBOHCTB HBIDleTCH OCHOBOH 06'beKTHO-OpHeHTH- poBaHHOro rrporpaMMHpoBaHIDI B cpe;::i;e Access. Ha pHc. 10.5 rrpe;::i;- craBJieHa <PopMa, OTKpbIBaIOUlaHCH rrpH HCl)l(aTHH KHOIIKH [ Co3;::i;aHHe l>a3 ;::i;aHHhrx]. Ha 3TOH <PopMe TaIOKe rroKaJaHhI ;::i;pyrne rrp11Mepb1 o<PopMJieHIDI KHOIIOK.

B pe3yJihTaTe BhIIIOJIHeHIDI rrepeq11cJieHHbIX ;::i;e:H:crn11H: .ll:JlH 3a;::i;aH11 o:H: KHOIIKH 6y;::i;eT C03)l;aH MaKpoc, T. e. rrpH HCl)l(aTHH 3TOH KHOIIKH 6y;::i;eT BbIIIOJIHHTbCH COOTBeTCTBYJOUlaH KOMatt;::i;a (mm KOMatt;::i;bI) MaK-

poca.

Co3;::i;aHHe KHorroK, BbIIIOJIHHIOlllHX KaKHe-JI1160 ;::i;e:H:crnID1:

=> pa3pa60TaTb KHOJIOqttyio <PopMY;

=> pa3pa6oTaTb )l;JIH K(l)l()l;OH KHOIIKH MaKpoc, HCIIOJib3YH )l;JIH 3TOfO

KOHC'fPYKTOPMaKpOCOB, H rrpHCBOHTb K(l)l()l;OMY MaKpocy HMH;

=> OTKpbITb <POPMY B pe:xrn:Me KOHC'fPYKTOpaH )l;JIH KIDK,UOH KHOIIKH

B COOTBeTCTBYJOUleM OKHe CBOHCTB BbI6paTb HMH MaKPOCa.

Ha pHC. 10.6 IIOKa3aH rrpHMep <PopMbl BBO)l;a HH<PopMal.l;HH B Ta6m1u;y B,ll; c KHOIIKaMH yrrpaBJieHIDI, a Ha PHC. 10.7 - MaKPOC, COCTO-

HlllHH H3 IIOCJie)l;OBaTeJibHOCTH MaKPOKOMatt;::i;, BbIIIOJIHHeMbIX rrpH Ha- )l(aTHH KHOIIKH BblBO)l;a Ha rre1IaTb co;::i;epxaHIDI Maprnpynm:H: KaPTbI TeXHOJIOfHqeCKoro rrpou;ecca 113roToBJ1eHID1 H3;::i;eJIID1 - [fJeqaTb MK].

10.2. AeT0MaT1113a4111H pa60Tb1 c ,qaHHblMM np111 noMOlJ.\M

nporpaMMHblX MO,qy11el:1

IlpH pa3pa60TKe IIOJib30BaTeJibCKOro HHTep<Pe:H:ca B CHCTeMe Access B03MO)l{H0 rrpHMeHeHHe He TOJibKO MaKpOCOB, HO H rrporpaMM, Ham1caHHblX Ha H3hIKe Visual Basic. Ilp11MeHenue MaKpocoB 11eJiecoo6pa3HO MH aBTOMaTH3aUHH rrpou;eccoB yrrpaBJieHIDI o6'beKTaMH6a3bI ;::i;aHHbIX. B 3TOM cJiyqae rrpH pa3pa6oTKe KHorroqHbIX <PopM MaKpoc CBH3bIBa10T c 3JieMeHTOM yrrpaBJieHIDI - KHOITKOH.

IlpH pa3pa60TKe <PopM ITOJib30BaTeJibCKOfO UHTep<Pe:H:ca MOryT BC'l'peqaTbCH3a;::i;aqu, MH KOTOpbIX HeT COOTBeTCTBYJOUlUX MaKpOKOMatt;::i;. Heo6xo;::i;HMO HCITOJib30BaTb B03MO)l{HOCTH H3bIKa Visual Basic, npHHIIHIIHaJibHOe OTJIH'rneKOTOporo OT H3bIKa rrporpaMMHpOBaHIDI Basic COCTOHT B TOM, qTO OH pa3pa60TaH B COOTBeTCTBHU c rrpttHIIHIIaMU COBpeMeHHOfO o6'beKTHO-OpHeHTHpoBaHHOrorrporpaMMHpOBaHIDI.

Ha p11c. 10.8 rroKa3aHa <PopMa .ll:JlH cocTaBJieHIDI KJiacc11<P11KaTopa H3roTaBJIHBaeMbIX H3)l;eJIHH, rrpe;::i;Ha3HaqeHHOfO MH 6bICTporo ITOHCKa o603ttaqeHIDI c6opoqtto:H: e;::i;HHHIIbI (HoMepa c6opoqttoro qepTexa).

)],aHHbIH KJiacc11<P11KaTop rrpe;::i;cTaBJIHeT co6otl: qeTblpexypoBHeByio 11epap~eCKyio CHCTeMy, COCTOHUlYIO H3 qeTblpex Ta6JIHII ( CITHCKOB),

CBH3aHHbIX OTHOllleHHeM O)l;HH - KO MHOfHM:

•B rrepBOH Ta6JIHu;e xpaHHTCH HaHMeHoBaHIDI THIIOB H3)l;eJIHtl:;

•BO BTOpou Ta6JIHIIe xpaHHTCH HaHMeHOBaHIDI BH;::i;OB H3)l;eJIHH )l;JIH

K(l)l()l;Oro THrra;

131

LIACTb Ill

TA6fl"14HblE nPOUECCOPbl

rnaea 11

OCHOBHblE CBE,QEHMfl 0 TA6nM"IHblX nPOl..l,ECCOPAX

11.1. noHHTMH, onpeAeneHMH, npMH~Mn AeMCTBMH

Ta6JIH11Hble npou:eccop1>1 (1rnor.na HX Ha3bIBaJOT 3JieicrpoHHble Ta6JIHU:b1) npe,n;cTaBIDIIOT co6oii u:eJioe HanpaBJieHHe npHKJia.n;HLIX nporpaMMHLIX CHCTeM, npe,n;Ha3HaqeHHbIX ,n;mI aBTOMaTH3aU:HH pacqeTHOaHaJDITINeCIGIX Ja,n;aq. lliHpOKoe npHMeHeHHe HaIIIJIH TaKHe nporpaMMHLie cHcTeMLI, KaK SuperCalk, Lotus 1-2-3, Quatro Pro, Excel for Windows. 06JiaCTL rrpHMetteHIDI Ta6JIH11HhIX npou:eccopoa qpe3Bbl'IaiiHO rn:upoKa: OT pac11eTa 3apa60THOM IIJiaTbI .n:o HCilOJib30BaHIDI B HayqHbIX HCCJie.n;oBaHmlX.

IlpHHU:Hil pa60TbI Ta6JI:uqttoro rrpoueccopa OCHOBaH Ha HCilOJib30BaHHH MeTO.IJ:OB anre6pa:uqecKoro npe.n;cTaBJieHHH MaTeMaTHlleCKHX

.n;eMCTBHM H crroco6oa KOMilblOTepHOM o6pa60TKH HH<t>opMaU:HH. PaccMOTpHM npocrnu npHMep. IlycTb Tpe6yeTcH pacc11HTaTh cyMMY

Tpex rrepeMeHHhIX aeJIH'IHH,T. e. D ==A+ B + C. 3.n:ech 3Ha11ettHe nepeMettttou D 6y.n;eT MeHHThCH npH H3MeHeHHH xoTH 61>1 o.n;ttou rrepeMeHHOM H3 rrpaaou 11acT:u BLipIDKeHIDI.

CocTaBHM anropHTM 3Toro BhillHCJIHTeJibHoro rrpouecca. IlycTb HMeeTCH Ta6JIHU:a, COCTOH1UaH H3 CTOJI6U:OB H CTPOK. CTpOKH B 3TOM Ta6JIHU:e npoHyMepoBaHbl, HallHHaH OT e.n;HHHU:bl, a CTOJI6U:bl o603HalleHbl 6YKBaMH JiaTHHCKoro an<t>aBHTa OT A .n:o Z. (AttanorH11H1>1e rn6JIHU:hI paccMaTpHBaJIHCh rrpH H3yqeHHH cnoco6oa pacqern B rn6nttu:ax pe.n;aKTopa Word.)

B 3TOM cnyqae npou:ecc ai,1qHcJiettm1 MO)!(}{O npe.n;crnBHTh B BH.n;e CJie.n;yI01UHX .n;eMCTBHM:

==> noMeCTHTh 3Ha11eHHe rrepaou rrepeMettttoii A B Hqet!:KY Al; ==> rroMeCTHTh 3Ha11ettHe BTopou nepeMeHHOM BB H11et!:KY Bl; ==> IIOMeCTHTb 3HalleHHe TpeTbeM nepeMeHHOM c B HlleMKY c 1; ==> peJyJihTaT pac11ern rroMeCTHTh B H11et!:KY D 1 == Al + B 1+ C 1.

yfa .n;aHHOfO rrpHMepa BH.n;HO, llTO B 3JieKTpOHHblX Ta6JIHU:aX Bee MaTeMaTHlleCKHe .n;eMCTBIDI BblIIOJIHHIOTCH Hao Jl'teUKaMU, T. e. rrpH H3MeHeHHH 3HalleHIDI rrepeMeHHOM, HaXO.n;HIUeMCH, HaIIpHMep, B HlleM-

134

R<teiilw - qacTb Ta6JIHUhI, <t>opMHpyeMrui: Ha rrepeceqeHHH cTon6ua

co CTpOKOH. 5{qe:HKa Kax,n:oro JIHCTa HMeeT lfMjl, COCTORIIIee HJ 6}'KBbl

H UH$phl. D}'KBOHo60JHaqeH CTOJI6eu, a UH$po:H - CTpOKa.

B CBRJH c TeM, qTo Ta6JIHUa COCTOHT HJ 256 CTOJI6UOB, a 6yKB

B JiaTHHCKOM an<t>amne BCero 26, HaqHHrul c 27 CTOJI6ua, HCIIOJihJyeTCR ,ri;Bo:HHoe o6oJHaqeHHe, T.e. AA, AB, AC H T.,ri;.

B gqe:HKIDC Ta6JIHUbl MOryT paJMeIIIaTbCR KaK TeKCTOBble ( CHMBOJibHble), TaK H ql{CJIOBbie ,ri;aHHbie B BH,ll;e qHcJia HJIH <l>OPMYJibl. IlpH 3TOM <l>OPMYJibI rrpe,ri;CTaBJIRIOT co6o:H OTHOIIIeHIDI Ha)]; gqe:HKaMH, HarrpHMep (=Al+ B2) HJIH =(Al+ B2)/31. B gqe:HKe rrepe,ri; <l>OPMYJIOH o6RJaTeJibHO ,ll;OJDKeH CTORTb JHaK paBeHCTBa (=), B rrpoTHBHOM cnyqae BBe,lleHHrui: <l>oPMYJia 6y.lleT pacIIOJHaBaTbCR rrporpa.MMoA KaK 06~­

HhIA TeKCT.

11.2. TexHonorMH Bbl'IMcneHMMe cpe,qe Excel for Windows

B rrpe,llhI,llJ1IIUIX rnaBaX JlOCTaTO'IHOIIOJlP06Ho paccMaTpHBa.Jiach rexHOJIOI'IDIpa6oTbl c rrpHJio:>KeHIDIMH Word H Access H MHorne KOMaH-

.llhl MeHIO, IIOKaJaHHble Ha pHC. 11.1, II03TOMY OCBOeHHe TeXHOJIOrHH B~CJieHHA B CHCTeMe Excel HaqHeM c KOHKPeTHoro rrpHMepa.

IlycTb Tpe6yeTCR paccqHTaTb CMery JaTpaT, CBRJaHHblX c BblIIOJIHeHHeM ,llOroBopa Ha OKaJaHHe ycnyr, HarrpHMep Ha pa3pa60TKY 6aJhl ,lJ;aHHblX .llJIR KaKOH-JIH60 opraHHJaUHH.

IlpH pacqeTe CMeTbl JaTpaT 06111rui: CTOHMOCTb ,llOroBopa MO)l(eT onpe,lleJIRThCR JaKaJqHKOM. McrroJIHHTeJI& )Ke, HJMeHRR cocTaBJIR10-

11111e JaTpaT'MO)l(eT o6ecneqHTb MaKCHMaJihHYIO rrpH6hIJib.

Ha pHc. 11.2 noKaJaHo oKHo Excel c cocTaBJieHHo:H Ta6n11ue:H pacqern CMeTbl JaTpaT. 11J pHCyHKa BH,ll;HO, qTO HCXO,ll;Hble ,ri;aHHhie .llJIR

BhlIIOJIHeHIDI pacqern H ero peJyJI&TaT&I JaHeceHhI B gqe:HKH cTon6ua H, 11cxo,ri;H&1e ,ri;aHH&Ie ,ll;J1R pacqern ueH&I )];OroBopa - cTpoKH A3 ... A12,

peJyJI&TaT&I pacqern ueH&I ,ri;oroBopa H Bcex cocTaBJIRIOIIIHX ee JaTpaT -

CTpOKH Al 5 ... A23. MaHHnyJrnpyR 11cxo,ri;m1MH ,ri;aHHhIMH ( CTpOKH A3 ...

Al2), aBTOMaT11qecKH nonyqaIOT Bee cocTaBJIRIOIIIHe ueHhI ,ri;oroBopa.

Ha 3TOM )Ke npHMepe paccMOTpHM TeXHonorHqeCKHe npHeM&I pa-

6oThI c Ta6JIHUaMH Excel:

•	BBO,ll; H pe,ri;aKTHpOBaHHe TeKcTa;
•	BBO,ll; B gqeii:KH OT)];eJibHblX ,[(aHHblX ,ll;J1R BblIIOJIHeHHR pacqern;
•	BBO,ll; B gqe:HKH <l>OPMYJI .llJIR BblIIOJIHeHIDI pacqeTa.

TeXHonorIDI BBO)];a TeKcTa B gqeii:KH Excel H pe)];aKTHpoBaHIDI npaKTHqecKH He OTJIHqaeTCR OT aHaJIOrHqHblX orrepau11:H B TeKCTOBblX pe- ,[(aKTOpax. 06paTHM BHHMaHHe TOJibKO Ha HeKOTOpbie oco6eHHOCTH.

~ BBO,ll;a ,ri;aHHblX Heo6XO,llHMO JIH6o aKTHBHJHpoBaTb COOTBeTCTBYIOIIIYIO gqeii:KY, ;rn6o rrepeMeCTHTh B Hee KYPCOp. 3aTeM paMKa jJqeii:KH Bhl,ll;eJIReTCR )l(HpHblMH JIHHIDIMH, IIOCJie qero B Hee MO)l(HO BBO,ll;HTb ,ri;aHHbie (,ri;o 255 CHMBOJIOB TeKCTa HJIH <l>OPMYJI).

136

<l>opMaT BpeM.R. c.riy:xan ,UJUI oTo6pIDKemrn BpeMeH11.

<l>opMaT Ilpou,eHmHblU rrp11MeID1eTCH ,UJUI BBO,D.a rum BbIBO,D.a q11ceJI, 3a,LJ,aHHbIX B Bl1,ll,e rrpou:eHTOB c yr<a3aH11eM 3HaKa % 11 orrpe,D.eJieHHbIM q11cJIOM 3HaKOB ITOCJie 3aITHTOH.

<l>opMaT ,lJpo6HblU rrp11MeHHeTCH ,UJUI BbIBO,D.a pe3yJihTaTOB pacqern B ,D.p06HOM Bl1,ll,e.

<l>opMaT 3KcnoHeHU,Ua.JlbHblU, KaK rrpaBI1JIO, rrp11MeID1eTCH ,UJUI BbIBO,D.a pe3yJihTaTOB pacqern B 3KCITOHeHU:11aJibHOM Bl1,ll,e.

<l>opMaT TeKcmoBbtu rrp11MeHHeTCH ,D.JIH BBO,D.a 11 BhIBO,D.a ,D.aHHhIX B TeKCTOBOM Bl1,ll,e. Ilp11 3TOM c q11cJiaM11, BBe,D.eHHbIM:U B 3TOM <t>opMaTe, H:UKaKMe ,D.eHCTBMH He rrpOl13BO)J.HTCH.

<l>opMaT }Jono1mumeJ1bHblU rrpe,D.Ha3HaqeH ,UJUI BBO,D.a ,D.aHHhIX T:urra rroqToBoro :uH,D.eKca 11JIM HOMepa TeJie<t>oHa.

Ilo KOMaH,D.e Bee rjJopMambl IIOJib30BaTeJib MmKeT BHeCT:U B ~eHKY

,D.aHHhie mo6oro T:urra.

q T06hI 3a,D.aTb <t>opMaT ,D.aHHbIX, BBO)J.:UMblX :u.rr:u OT06pa:xcaeMbIX B ~ei1:Kax Ta6JIMU:hI, He06XO)J.:UMO BbIIIOJIHMTb CJie.IJYIO:w;:ue ,D.eHCTBMH:

:::} ycTaHOBMTb rcypcop B COOTBeTCTByro:w;yIO ~eii:KY;

:::} Bb16paTb B CTPOKe MeHIO KOMaH,D.y <PopMam, a B IIOHB:UBIIIeMCH )J.:UaJIOroBOM OKHe - KOMaH,D.y JlrteUKU (p:uc. 11.3);

:::} B CJie.IJYIO:w;eM IIOHB:UBIIIeMCH OKHe (p:uc. 11.4) BbI6paTb Heo6xo- )J.:UMbIH <t>opMaT ~eHKM (,D.aHHbIX).

______l:t___,,,6_,,_I·...._.-_____./_

Bpy6.nflX	3 000,00p
		35,80%
		O,OOp
	10	OClJ,OOp
		O,OOp
	30	OClJ,OOp
		15,00%
		25,00%

i

					I
					I
					I
					II
					I
	flMcTl~~~s;:-::-:-::-:-~-:--------- ------.w. •				J•I
					11r
~· ~~j_~·". "Q~Ji•LRJl.&·ii(~6,·E~.g·ji.[ ...					. ....
rQitBO	'	; !r- .		rr=;u;-r·r:-r
•nll* .J ~ 8 ~ i\ll IJ QY"'6M<rt0~:..j		'W:Tblv.Mi... ·t)MCM	. liS!MicrooaftL	/~--

PHC. 11.3. ,LI;muIOroBoe OKHO KOMaH,llbl <PopMam

138