02-09-2014_16-40-43 / 2013 Пакеты прикладных программ
.pdf
rnasa 10
ABTOMATM3ALU'I~ PA60Tbl C 06bEKTAMM 6A3 ,QAHHblX
10.1. ABTOM3TM33~1oUI pa60Tbl c ,QaHHblMM
npM nOMOU4M MaKpOCOB
l\1aKpoc npencTaBJUleT co6o:H: HeKoTopyro nocnenoBaTenhHOCTh MaKpoKoMa~, T. e. MHCTpYKJJ:MH l\1icrosoft Access, np11MeID1eMhIX ~ aBTOMaTM3all;MM BhIIIOnHeHIDI qacTO IlOBTOpHIOlllMXCH ne:H:CTBMH.
l\1aKpOKOM~hI B Access no cPYHKUMOHanhHOMY Ha3HaqeHMIO MO)l(- HO pa3nenMTh Ha cnenyrom11e Knaccb1:
•OTKPhlTMe 11 3aKphITMe Ta6n11u;, 3anpocoB, cJ?opM, o~eToB;
•neqaTh naHHhIX;
•BhmonHeHMe 3anpoca;
•npoBepKa MCTMHHOCTM ycnOBMH M ynpaBneHIDI BhIITOnHeHMeM
MaKPOKOM~;
•ycTaHOBKa 3HaqeHMH;
•IlOMCK naHHhIX;
•IlOCTpOeHMe IlORh30BaTenhCKOro MeHIO M BhIIIOnHeHMe KOMa~ MeHro;
•ynpaBneHMe BhIBonoM MHcPOPMall;MM Ha 3KpaH;
•coo6meHMe IlOnh30BaTen10 0 BhIIIOnIDieMhIX ne:H:CTBIDIX;
•nepeMMeHoBaHMe, KOilMpOBaHMe, ynaneHMe, MMilOpT M 3KCilOPT o6'beKToB;
•3anycK npyrnx npMnO)l(eHMH Windows.
B Ta6n. 10.1 nepeq11cneHh1 MaKpoKoMa~hI nnH c03naHMH MaKpocoB.
|
Ta6nttua 10.1 |
Ilepe'ICHhMaKpOKOMaH,ZJ, MJI C03)1.aHHJI ynpaBJIBIOIQHX MaKpOCOB |
|
MaKpoK0MaH.L1a |
Ha3Haqemre |
OmKpbtmue u 3aKpbtmue ma6Auu,, 3anpoco6, rjJopM, omitemoB |
|
3aKpbtmb |
3aKphrnaeT aKTHBHOe (3a,!J.aHHOe) OKHO |
OmKpbtmb r/JopMJ! |
OTKphrnaeT IPOPMY B pe)KHMe Ta6JIHUhI, KOHCTpYI<Topa |
|
HJIH it>opMhl |
OmKpbtmbMoi)yJlb |
OTKphrnaeT MO)l,YJih B pe)KHMe KOHCTp}'KTOpa |
0mKpbtmb3anpoc |
OTKpbmaeT 3arrpoc B pe)!(HMe Ta6JIHUhI HJIH KOHCTp}'KTOpa |
OmKpbtmbOmitem OTKphrnaeT o~eT B pe)KHMe rrpocMoTpa
OmKpbtmb Ta6Auu,y OTKpbrnaeT Ta6JIHuY B pe)KHMe Ta6JIHUhl HJIH KOHCTPYKTOPa
123
|
llpoiJ011J1CeHue ma611. 10.1 |
MaicpoKOM!IH)la |
Hll3Haqe1nte |
|
lle'tamb iJaHHblX |
0mKpblmbt1JopMy |
0rKpbIBaeT <l><>PMY B pe)KJ{Me npe.naapwreJihHOfO |
|
npocM01pa |
Om1CpblmbOm'tem |
OrKpbIBaeT O'NeTB pe)KJ{Me npe.naapH"reJihHOfO |
|
IlpocMOTpa |
Om1CpblmbTa611uu,y |
0rKpbIBaeT ni6JIHIJY B pe)KJ{Me npe.naapHTeJlhHOfO |
|
npocM01pa |
BblBecmuBt1JopMame |
XLS - .nrui: Excel, RTF - .nrui: Word |
lle'tamb |
BbIBOJJ:HT HHlf>opMal(HIO Ha ne11aTb |
|
BblnOAHeHUe 3anpoca |
Om1Cpblmb3anpoc |
3anycKaeT 3anpoc H BhlBO.ll;HT Bhl6pa.HHhle 3aIIHCH |
|
B pe:>KHMe ni6.Jnmhl |
llpoBeplCa ucmuHHocmu YCJI06UU u ynpa6/leHUJI BblnOAHeHUe.M MOICpolCOMQHD 0mMeHumbCo6blmue
KoMaHiJaMemo
Bb1XoiJ |
3aKphIBaeT BCe OKHa Access H BbIIlOJiffjfeT BhlXO.ll; H3 |
|
Hero |
3anyc1CllpozpaMMbl |
BhIIlOJiffjleT npoue.nypy Access Basic |
3anyc1CMa1Cpoca |
3anycKaeT .npyro:H MaKpOC |
OcmaHOBUmbBce |
OcTaHaBJrnaaeT pa601)'acex MaKpOCOB, BKJIJO'I~ |
MaKpocbl |
TeK}'IUHH |
OcmaHOBUmbMa1Cpoc |
OcnittaBJIHBaeT pa601y TeK}'l.UeroMaKpOCa |
|
YcmaHOBICa 3Ha'teHuu |
06HOB/leHue |
Mo:lKeT 6bITh Hcnonh3oBaHa JJ:Jiji o6ttoBJieHIUI |
|
.naHHbIX B aICTHBHOM ofu.eKTe (B pe:lKHMe <t>opMbI HJIH |
|
ni6JIHUhI) |
KoMaHOblKtlaBuamypbl |
3anoMHttaeT B 6y<l>epe o6Metta nocne.noaareJihHOCTh |
|
ffa)KJ{MaeMbIX KJiaBHW |
3aiJamb3HaiteHue |
06ttoBJrneT HJIH H3MeffjleT 3Ha'leHHjlmo6oro |
|
3JleMeHni ynpaBJieHIUI |
|
lloucK iJaHHblX |
llpuMeHumb<l>wibmp |
OrpaHH'IHBaeTBbIBOJJ:HMYIO uulf>opMauHio a OT'leTaX |
|
HJIH lf>opMax |
124
10.1
Ha3HaqaeT (OTMeHHeT) cHcreMHble coo6rn;eHID1 HJIH rrpe;:i;yrrpe~eHIDI, He ocTaHaBJIHBaH BhlBO)I Ha 3KPaH coo6meHHH: o6 oIIIH6KaX
TioKa3blBaeT BCe JaIIHCH Ta6mmhl, HIBOPHPYH
yCTaHoBJieHHhle paHee <l>HJih'Iphl
Bb1BO;:i;HT (y6HpaeT) JII06yio H3 CTil.H,!l;aPTffhIX HJIH IIOJib30BaTeJibCKHX rraHeJieH HHC'IpYMeHTOB
0 BhIIIOJIHHeMbIX )leHCTBIDlX
125
0KOH'tQHUe ma6A. JO. I
MaKJJOKOMaH.Ua |
HaJttaqettHe |
Coo6w,eHue noAb3oeameJ110 o 6blnOAHHeMbtx iJeucmeu.HX
CumaA |
BhmaeT 3B)'Koooil:c1-trHaJI |
Coo6w,eHue |
BhIBO)J,HT npe)J,ynpe)!()J,aiorn:ee HJIH |
|
nmpopMau,HOHHoe coo6rn:eHHe |
|
Pa6oma c o6oeKmaMu |
Konupoeamb06oeKm |
KonnpyeT mo6oil: o6'beKTreK}'l.Ueil:6a3hI )J,aHHhIX |
|
(c HOBhIM HJIH CTaphIM HMeHeM) B )J,pyryro 6a3y |
|
)J,aHHhIX Access |
YiJaAumb06oeKm |
Y)J,a.JUieTo6neKT (Ta61mu,y, 3anpoc, <t>opMY, OT'leT, |
|
Ma.KpOC, MO)J,YJih) |
BbleecmuB<l>opMame |
BhIBO.U.HT o6'beKTB <l>opMaTaX npHJioxeHHil: Windows |
IlepeuMenoeamb |
MeHSieT HWI o6neI<Ta B reK}'l.Ueil:E,[( |
Omnpaeumb06oeKm |
BhIBO.U.HT co.u.epxaHHe o6'beI<TaB <t>ail:JI H nepe)J,aeT |
|
ero B ::meKTpOJIHYIO IlO'ITY,T. e. 3a,L1.aHHOMY a)J,peCaTY |
Ilpeo6pa3oeambEa3y |
3KCilOpTHpyeT HJIH HMUOpTHpyeT o6'beKThIH3 |
J(aHHblX |
.u.pymx E,[( (dBASE, Paradox, FoxPro) |
Ilpeo6pa3oeamb TeKcm |
TipH 3Kcnopre HJIH HMUOpre ,LJ.aHHhIX nepe)J,aeT HH- |
|
<t>opMau,mo B reKCTOBhie <t>ail:JihI HJIH npeo6pa30BhI- |
|
BaeT ,LJ.aHHhie H3 TeKCTOBhIX <t>ail:JIOB |
Ilpeo6pa3oeamb 3AeKm- TipH 3Kcnopre HJIH HMUOpre ,LJ.aHHhIX nepe)J,aeT HH- pOHlf)llO Ta6AUU,Y <t>opMau,mo B 3JieKTpOHHhie Ta6JIHUhI HJIH npeo6pa-
30BhIBaeT HH<:l>opMau,mo 3JieKTpOHHhIX ra6JIHI.J, B <t>opMaT Ta6JIHI.J,
IlpM pa3pa60TKe <t>opM IIOJib30BaTeJibCKOfO MHTep<t>eii:ca, B KOTOpbIX BbIIIOJIHeHMe MaKpoca CB513aHO c HIDKaTMeM KHOIIKM, MO)l(HO MCIIOJib30BaTb .JJ:Ba crroco6a:
•C03.JJ:aTb MaKpoc M CB513aTb ero c COOTBeTCTBYJOIUeH KHOIIKOH <t>opMbI;
•C03.JJ:aTh KHOIIK)'Ha <t>opMe M rrpM orrncaHMM ee CBOHCTB pa3pa6oTaTb COOTBeTCTBYJOIUMH MaKpoc.
B mo6oM cJiyqae Heo6xo.nttMo rrpe.n:BapttTeJibHO C03.JJ:aTb KHorroqHYJO <t>opM)'.Ha pMC. 10.1 M51 rrpMMepa IIOKa3aHa KHOrroqHa51 <t>opMa CMCTeMbl aBTOMaTl'.13MpOBaHHOro rrpoeKTMPOBaHM51 TeXHOJioruqecKMX rrpou;eccoB, rrpM Ha)l(aTMM Ha mo6yio KHOIIK)'KOTOpo:H .JJ:OJI)l(Ha OTKpbIBaTbC51 coorneTCTBYJOIUa51 .nuanoroBM <t>opMa. PaccMOTPMM Ha .naHHOM rrpMMepe IIOCJie.JJ:OBaTeJibHOCTb .neHCTBMH C03.JJ:aHM51 yrrpaBJI5IIOIUMX MaKpOCOB. 11.TaK, rrpM HIDKaTMM KHOIIKM [C03.JJ:aHMe Ea3 .naHHbIX]
126
