rTuli formebis Seqmna

Tema 7
720
gakveTili
20
formebi: rTuli
formebis Seqmna

?
1
kiTxvebi da testebi
√
2
pasuxebi testebze
damatebiTi
literatura
5
pedagogis konsultacia
?
savarjiSoebi
3
√
4
pasuxebi svarjiSoebze
rTuli formis SemuSaveba
formis Seqmna ramdenime cxrilis bazaze
winamdebare masalaSi gavecaniT, Tu rogor SevqmnaT forma erTi cxrilis bazaze.
xSirad ki saWiroa iseTi formis Seqmna, romelic moicavs farTo monacemebs da Tanac
ramdenime urTierTdakavSirebuli cxrilidan. mravalcxriliani moTxovnebis Seqmnisas
gamoiyeneba cxrilebi, romelTa Soris aris kavSiri „erTi-bevrTan“. rogorc viciT,
Access-i gvaZlevs saSualebas SevitanoT nebismieri monacemi cxrilSi, romelic
kavSirSi „bevris“ mxarezea da is monacemebi, dakavSirebuli cxrilidan mxareze „erTi“,
romlebic ar miekuTvneba gasaRebriv monacemebs. amitom moTxovnaSi SegiZliaT SeitanoT
cvlilebebi im velebSi, romlebic aRebulia cxrilidan „bevris“ mxridan da
mniSvnelovani nawili im velebisa, romlebic aRebulia cxrilebidan „erTis“ mxridan.
aseT moTxovnebze dayrdnobiT Seqmnil formebs eZaxian formebs „bevri-erTTan“. SevqmnaT
moTxovna qrywigniavtoriangariSisTvis monacemTa bazaSi Biblioteka.mdb. cxrilidan tblwigniavtori
gadaitaneT yvela veli, cxrilidan tblwigni, t blavtori, t blgamomcemloba - yvela, veli-gasaRebis garda:
SeqmeniT am moTxovnis safuZvelze forma an SeqmeniT forma im cxrilebis
safuZvelze, romlebis gamoyenebiT Seqmnilia moTxovna. SegiZliaT isargebloT
programa-ostatiT.
axla SevqmnaT am formis safuZvelze martivi forma (Single Form). amisaTvis
monacemTa bazis sawyis fanjaraSi gadadiT formebis Seqmnis CanarTSi Create da
nawilSi Forms CamoSaleT Rilaki More Forms da airCieT brZaneba Form Wizard. programaostatis pirvel fanjaraSi SearCieT sabazo cxrilebi an maTi gamoyenebiT Seqmnili moTxovna. Cven ukve SevqmeniT moTxovna, amitom miuTiTeT es moTxovna da gadaitaneT
moTxovnis velebi marjvniv Semdeg fanjrebSi SeurCieT formas maketi Columnar da
stili Standard. daarqviT mas saxeli frmwigniavtoriangariSisTvis da daaWireT Rilaks Finish.
Sedegad unda miiRoT martivi (Single Form) forma:
Tu Tqvens moTxovnaSi gadaitanT
cxrilebidan yvela vels da ise SeqmniT
moTxovnas an isargeblebT cxrilebiT,
romlebidanac gadagaqvT yvela veli
ostatis im fanjaraSi, romelSic ganisazRvreba velebis Semadgenloba formisTvis, maSin ostati SemogTavazebT
fanjaras, sadac mogTxovT miuTiToT,
rogor gindaT warmoadginos monacemebi,
magaliTad, daalagoT Canawerebi avtorebiT (by av tori) Tu wignebiT (by w igni). Tu
miuTiTebT by wigniavtori, ostati gamoitans martiv formas (Single F orm), iseTives, rogoric Seiqmna moTxovnis safuZvelze. Tu airCevT Canawerebis dalagebas avtorebiT (by avtori), maSin miiRebT TiToeuli
avtorisTvis Canawers avtoris Sesaxeb da im wignebis CamonaTvals, romelic am avtoris
mier aris Seqmnili:
am
fanjaraSi
ori
gadamrTvelia:
Forms w ith s ubform(s) da Linked f orms. CarTeT
jer pirveli gadamrTveli. momdevno fanjrebSi SearCieT formis maketi, stili da
bolos mieciT saxeli miRebul or (an met)
formas. daaWireT Rilaks Finish.
ostatis mier iqmneba ori forma Avtori
da Wigniavtori S ubform, romlis dasaxelebebi
cal-calke iwereba bazis formebis CanarTSi mocemul siaSi. TviTon forma Avtori
ostats gamoaqvs ekranze. formis Avtori
gaxsnis dros ixsneba orive forma _ Avtori
da Wigniavtori Subform. Tu formaSi ar mogwonT velebis da maTi dasaxelebebis ganlageba,
SeasworeT isini konstruqtoris reJimSi. Tu romelime veli moiTxovs veli-siis Seqmnas,
SeqmeniT igi (magaliTad, velisTvis kod-avtori, veli-siis Seqmnas odnav mogvianebiT
gavarCevT). Tu erTi da igive veli orjer moxvda formaSi, gaxseniT misi Tvisebebis
fanjara da striqonSi Visible mouTiTeT No. gadadiT formis reJimSi da SeecadeT SeitanoT an SecvaloT Canawerebi. siebis gamoyenebisas daakvirdiT, Tu CanawerSi siis axali
mniSvneloba gaxda Sesatani, mniSvneloba siasac unda daematos. magram Canaweridan
Canawerze gadasvlis Semdegac axali mniSvneloba siaSi ar gamoCndeba iqamde, sanam ar
daxuravT fanjaras an gadaerTvebiT konstruqtoris reJimSi da dabrundebiT isev
formis reJimSi. Tu avtoris kods SecvliT, dainaxavT im avtoris wignebs, romlis
kodic miuTiTeT CanawerSi. daakvirdiT, Canawerebis Sevsebis dros zogi veli avtomaturad ivseba (kod-avtori, w igni-kodi, qa laqi), vinaidan formaSi avtomaturad ivseba dakavSirebuli monacemi mxaridan „erTi“, Tu Tqven cvliT gareSe gasaRebs mxareze „bevri“.
qvemoT moyvanilia forma Avtori, romelic or formas Seicavs: Avtori da Wigniavtori Subform:
daxureT forma da gaxseniT cxrilebi tblavtori, tblwigni, tblwigniavtori, t blgamomcemloba.
dainaxavT, rom am cxrilebSi axali Canawerebia Setanili, is Canawerebi, romlebic Tqven
formiT SeitaneT.
Tu ostatis monacemebis ganlagebis SerCevis fanjaraSi meore gadamrTvels (Linked
forms) CarTavT, maSin gansxvavebul formas miiRebT. am SemTxvevaSi iRebT erT formas
(avtori1), romelSic moTavsebulia brZanebis Rilaki im formis saxeliT, romelic formis
CanawerTan dakavSirebul Canawerebs Seicavs.
forma avtori1 Seicavs monacemebs avtorze da Rilaks, romliTac iZaxebs dakavSirebul formas _ wigniavtori1. SegaxsenebT, rom am or formas Soris arsebobs kavSiri
„erTi-bevrTan“, rac niSnavs, rom erT avtors bevri wigni aqvs dawerili. Tu formaSi
avtori1 isargeblebT brZanebis RilakiT wigniavtori1, gaixsneba forma igive dasaxelebiT.
qvemoT warmodgenilia gaxsnili orive forma.
daqvemdebarebuli formis Seqmna da misi Canergva mTavar formaSi
monacemebis Setana ramdenime dakavSirebul cxrilSi SesaZlebelia agreTve rTuli
formiT, romelSic warmodgenilia mTavari da daqvemdebarebuli nawili. ganvixiloT
Semdegi magaliTi. biblioTekaSi mravali avtoris bevri wignia. am or obieqts Soris
rTuli kavSiria – „bevri-bevrTan, amitom iqmneba maT Soris damakavSirebeli cxrili
tblwigniavtori. konkretul avtors ramdenime wigni aqvs dawerili, e. i. Canawers cxrilidan
tblavtori unda Seesabamebodes ramdenime Canaweri dakavSirebuli cxrilTan tblwigniavtori.
vinaidan am cxrilSi marto ori monacemia (veli) kod_avtori da kod_wigni da saWiroa
vicodeT wignis monacemebic, amitom jer SevqmnaT moTxovna, romelSic cxrilidan
tblwigniavtori da tblwigni gadmovitanT yvela monacems, garda kod_wigni cxrilidan tblwigni:
miaqcieT yuradReba, rom cxrili tblwigniavtori kavSirSi mxarezea „bevrTan“, maSin,
rodesac tblwigni _ mxareze “erTTan”. amitom SegviZlia axali Canawerebis Setana „bevris“
mxares, Tu gasaRebrivi (cxrilSi tblwigniavtori orive veli aris gasaRebrivi) Canawerebi
ar gameordeba.
axla SeqmeniT forma am moTxovnis safuZvelze ostatis gareSe. gaxseniT forma
konstruqtoris reJimSi, miuTiTeT safuZvlad moTxovna qryDaqvemdebarebuliwigniavtoriwigni.
konteqstur meniudan CarTeT brZaneba FormHeader/Footer. winaswar gamorTeT velebis
dasaxelebebis gadatana, amisTvis formis reJimSi daaWireT Rilaks Text Bo x da mis
TvisebaSi Auto Lable miuTiTeT No. gamorTeT agreTve ostatis Rilaki. monacemebis nawilSi gadaitaneT moTxovnis velebi. dasaxelebebis nawilSi (Header) SeqmeniT dasaxelebebi
RilakiT Lable. nawilSi Footer SeitaneT Tavisufali veli RilakiT Text B ox, raTa
daTvaloT avtoris wignebis raodenoba da maTi fasi. gamosaTvleli velebis TvisebaSi
Control S ource pirveli maTganisTvis SeitaneT =Count([dasaxeleba]), meorisTvis _
=Sum([fasi]). SeqmeniT maT gaswvriv marcxniv dasaxelebebis veli saxeliT „sul“. daaformateT forma: gaasworeT velebi swor xazze, mieciT swori zomebi da daSoreba,
SeurCieT Srifti da a.S. TvisebebSi striqonSi Default View miuTiTeT Continuous Form
(lenturi forma) an Datasheet ( cxriluri). ra Tqma unda sveturi aq ar gamodgeba.
miuTiTeT, gnebavT Tu ara navigaciis Rilakebi – Navigation Buttons (daqvemdebarebul
formaSi sakmarisia ekranis vertikaluri moZraobis Rilakebi). SeinaxeT forma saxeliT
frmDaqvemdebarebuliwigniavtoriwigni da daaTvaliereT igi formis daTvalierebis reJimSi.
forma frmDaqvemdebarebuliwigniavtoriwigni konstruqtoris reJimSi:
igive forma daTvalierebis reJimSi
mivubrundeT mTavari formis Seqmnas. SeqmeniT moTxovna cxrilis tblavtori
safuZvelze. gadaitaneT moTxovnaSi yvela veli cxrilidan, miuTiTeT daxarisxeba
avtoris kodis mixedviT. SeinaxeT moTxovna saxelis qveS qryMTavariwigniavtori:
am moTxovnis safuZvelze SevqmnaT igive dasaxelebis forma. SegiZliaT SeqmnaT es
forma konstruqtoris reJimSi ise, rogorc SevqmeniT wina forma, an isargebloT programa-ostatiT. amiT mTavari formis Seqmna damTavrebulia. axla saWiroa davakavSiroT
es ori forma, raTa SevqmnaT rTuli forma. amisaTvis gavxsnaT mTavari forma konstruqtoris reJimSi, gamovrToT ostatis marTvis Rilaki. gavaaqtiuroT marTvis Rilaki
Subform/Subreport. movxazoT formis maketSi adgili, sadac Semdeg CavsvamT daqvemdebarebul formas (Subform). gaxseniT formis Tvisebebi da TvisebaSi Source Object CasviT
frmDaqvemdebarebuliwigniavtori. Tvisebebis velebSi Link Child Fields (daqvemdebarebuli velebi)
da Link Master Fields (mTavari velebi) unda miuTiToT damakavSirebeli veli (Tu Access-ma
ukve ar miuTiTa monacemTa bazis kavSirebidan gamomdinare) or formas Soris. Cven
SemTxvevaSi es velia – kod_avtori. Tu aseTi velebi ramdenimea, velebi mieTiTeba TanmimdevrobiT da maT Soris ixmareba wertil-mZime. SeasworeT formaSi velebis ganlageba.
SegiZliaT ixmaroT gamyofi xazebi, Sriftis tipi da feri. moxseniT, Tu jer ar mogixsniaT, zedmeti elementebi, magaliTad, navigaciis Rilakebi, da saboloo saxis micemis
Semdeg gadadiT formis daTvalierebis reJimSi. SeamowmeT jer vizualurad, ramdenad
misaRebia forma, Semdeg gadadiT cariel Canawerze da SeitaneT axali Canaweri. Sedegebi unda miiRoT Semdeg cxrilebSi: tblavtori, t blwigni, t blwiogniavtori, t blgamomcemloba. Tu
axali avtoris wigni CarTeT bazaSi, avrotebis sias miemateba misi monacemebi. cxrilSi
tblwigni Caiwereba wignis maxasiaTeblebi, gaizrdeba gamomcemlobebis da Temebis sia,
vinaidan isini warmoadgenen velebs, romlebidanac virCevT monacemebs. rTuli, Sedgenili forma SegiZliaT SeqmnaT programa-ostatiT. wina masalaSi moyvanilia ostatis
mier Sedgenili formis Seqmnis magaliTi. ostati, rogorc vnaxeT, qmnis mTavar formas
velebis svetSi CamoTvliT da daqvemdebarebul formisTvis irCevs lentur an cxrilur
formas Tqveni miTiTebiT, magram, ra Tqma unda, ostatis mier Seqmnil formaSi saWiro
xdeba Sesworebebis Setana. Tu Seqmnili forma kargad muSaobs, SeinaxeT da daxureT
igi.
rTuli forma frmMtavariwigniavtori konstruqtoris reJimSi qveformis Tvisebebis fanjriT:
rTuli forma frmMtavariwigniavtori daTvalierebis reJimSi qveformis Tvisebebis fanjriT:
CanarTebi rTul formebSi
arsebobs kidev erTi gza rTuli kavSirebiT informaciis warmodgenis da
redaqtirebis. rodesac informacia mxareze „bevri“ didia, gamogadgebaT CanarTebis (Tab
Control) erToblioba. am tipis formis Seqmna sakmarisad iolia. magaliTad aviRoT
monacemTa baza Magistratura(0203weli12kursi1semestri).mdb. SevqmnaT konstruqtoris reJimSi
forma frmStudentebis_sia. movniSnoT instrumentul panelze Tool Box marTvis elementi
_ CanarTi, SemovxazoT svetobrivad ganlagebuli velebis qvemoT marTkuTxedi. Access-i
Seqmnis marTvis elements ori CaSenebuli gverdiT. Tu meti CaSenebuli gverdebi gWirdebaT, sanam fokusi (kursori) CanarTebis areSia, gamoiZaxeT brZaneba Insert Page, A ccess-i
daamatebs kidev erT gverds. gverdebs SegiZliaT saxeli daarqvaT:
igive forma CanarTebiT daTvalierebis reJimSi:
daaWireT Tagvis marcxena RilakiT gverdis saxels da fanjaraSi Properties
striqonSi Caption SeitaneT misi dasaxeleba. Cven magaliTisTvis unda SeitanoT pirveli
gverdidan mexuTemde: samagistro Tema, profesiuli praqtika, pedpraqtika, studentis
piradi monacemebi. amis Semdeg gaxseniT pirveli gverdi, moniSneT marTvis elementi
Subform/Subreport
panelze Controls da gverdis dasaxelebis qveS moxazeT TagviT
marTkuTxedi. Tvisebebis siaSi Tvisebis Source O bject striqonSi SeitaneT im formis
(SegiZliaT cxrilis an moTxovnis) dasaxeleba, romelic unda moaTavsoT marTkuTxedSi.
ase CasviT xuTive gverdze formebi. kargia, Tu winaswar moamzadebT formebs
cxrilebidan an moTxovnebidan, raTa gamoricxoT zedmeti monacemebi, Tu aseTi aris
cxrilSi. damakavSirebel vels uTiTebT, Tu es Access-ma TviTon ar gaakeTa. qveformis
TvisebebSi Link Master Field da Link Child Fields uTiTebT studentis CaTvlis wignakis nomris
vels _ Catvlis_ wignakis_ nomeri. Tu gverdebis Tanmimdevroba gnebavT SecvaloT, gamoyaviT
romelime gverdi da konteqsturi meniudan airCieT brZaneba Page Order. igive dasaxelebis
fanjris ekranze gamosvlis Semdeg, sadac mocemulia gverdebis sia, moniSneT gadasatani
gverdi da gadaitaneT an zemoT, an qvemoT. Semdeg gverdebze ganTavsebuli formebi
daaformateT. gadadiT formis daTvalierebis reJimSi da SeafaseT, Tu ramdenad misaRebia Tqven mier Seqmnili rTuli forma. formis Senaxvis Semdeg Tqven naxavT, rom Accessma cal-calke Seinaxa yvela is forma, romelic CasviT CanarT gverdebSi. maT saxels
miuwers sityvas Subform. rodesac Tqven mTavar formaSi cvlilebebi SegaqvT, Access
gamoaqvs dialoguri fanjara, sadac gekiTxebaT, Seitanos Tu ara cvlilebebi
qveformebSic. SeamowmeT Tqvens mier Seqmnili forma: jer SeitaneT mTavar nawilSi
studentis CaTvlis wignakis nomeri da Semdeg ki - CanaerT gverdebze ganlagebul
formebSi. daxureT forma da sabazo cxrilebi daaTvaliereT _ iq Tqven mier Setanili
Canawerebi unda aisaxos.
forma, romelic warmodgenilia qvemoT naxatze marto dasaTvaliereblad
gamodgeba, vinaidan Seqmnilia moTxovnis safuZvelze, sadac sruldeba velebis
dajgufeba da gamoTvla:
formebis dakavSireba brZanebis RilakebiT
Access-is yvelaze saintereso Tvisebaa makrosebis da VBA procedurebis amoqmedeba
formaSi romelime moqmedebis pasuxad. magaliTad, Tu aTvalierebT monacemTa bazaSi
Biblioteka.mdb avtorebis sias, iqve SeZlebT naxoT misi wignebic. amisTvis SegiZliaT
gamoiyenoT brZanebis Rilakebi. gaxseniT forma frmavtoriRiakebiT konstruqtoris reJimSi
da dasaxelebis nawilSi SeitaneT marTvis elementi Button CarTuli ostatis RilakiT.
ostatis pirvel fanjaraSi marcxniv airCieT da moniSneT moqmedebebis kategoriebis
CamonaTvalSi Form O perations (moqmedebebi formebze), marjvniv ki – Open F orm ( formis
gaxsna):
vinaidan brZanebis Rilakma unda gaxsnas dakavSirebuli forma „wigni“, ostatis
momdevno fanjaraSi airCieT es forma, gadadiT mesame fanjaraSi. aq CarTeT
gadamrTveli Open T he F orm A nd F ind Specific D ata T o D isplay (SerCeuli CanawerebisTvis
formis gaxsna). es gadamrTveli Semdeg fanjaraSi gamoitans ori formis velebis sias
da mogTxovT airCioT maTi saerTo, damakavSirebeli veli:
moniSneT orive mxares veli kod_avtori da daaWireT maT Soris aRniSnul niSans <->.
daxureT fanjara. momdevno fanjrebSi miuTiTeT Rilakis dasaxeleba „wignebi“ da
daaWireT Rilaks Finish.
gadaerTeT formis daTvalierebis reJimSi, rom dainaxoT Sedegi. forma avtorebis
Canawerebis sias gaCvenebT. am siidan Tu romelime avtoris wignebi gnebavT, daaWireT
Rilaks „wignebi“, gaixsneba forma, sadac moyvanilia am avtoris mier Seqmnili wignebi.
forma frmavtoriRilakiT, romelic xsnis RilakiT „wignebi“ formas “wigni”:
Tu isev konstruqtoris reJimSi gadaxvalT da gamoiZaxebT Rilakis _ „wignebi“
Tvisebebs, naxavT, rom TvisebaSi On Click miTiTebulia moqmedebis damuSavebis
procedura:
daaWireT marjvniv am striqonis bolos sam wertils. gaixsneba procedura VBA,
romelic programa-ostatis mier aris Seqmnil:

sakontrolo kiTxvebi da testebi
1.
2.
3.
4.
5.
6.
7.
ra gzebiT SeiZleba rTuli formebis Seqmna?
ras niSnavs da rogor unda Seiqmnas forma daqvemdebarebuli formiT?
ras warmoadgens formis CanarTi da rogor SevqmnaT forma CanarTiT?
rogor SevqmnaT forma marTvis RilakiT?
SeuZlia Tu ara ostats Seqmnas forma ori erTmaneTTan daukavSirebeli
cxrilisagan?
1. ara
2. ki
SieZleba, rom forma Seicavdes ramdenime daqvemdebarebul formas?
1. ara
2. ki
formis Seqmnis romel variants ar gTavazobT ostati, Tu miTiTebuli aqvs
isargeblos erTi mTavari da erTi daqvemdebarebuli cxrilis velebiT?
1. Form with subform
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
2. Linked form
3. Single Form
daqvemdebarebuli formis romeli Canaweri Cans rTul formaSi?
1. daqvemdebarebuli formis is Canawerebi, romlebic kavSirSia mTavari nawilis
CanawerTan
2. daqvemdebarebuli formis is Canawerebi, romlebic ar aris kavSirSi mTavari
nawilis CanawerTan
ras uTiTebs ostati formis wyarod, Tu is Seicavs velebs ramdenime urTierTdakavSirebuli cxrilidan?
1. SQL instruqcias
2. VBA moduls
3. makrosis dasaxelebas
mravalcxrilian formaSi rogor gamoviZaxo sabazo moTxovna konstruqtoris
reJimSi?
1. moTxovnebis amSeneblis RilakiT
2. formis TvisebaSi Record Source marjvniv samkuTxa isriT
romeli reJimi qmnis formas ramdenime cxrilis gamoyenebiT?
1. Splite Form
2. Multiple Item
3. Form
marTvis romeli elementi qmnis formaSi gamomTvlel vels?
1. Text Box
2. Attachment
SeiZleba Tu ara SevcvaloT Rilakis saxe, ostatis muSaobis dasrulebis Semdeg?
1. ki
2.ara
rogor gamoviZaxo amSenebeli gamosaxulebis SetanisTvis velSi?
1. velis konteqstur meniudan airCieT brZaneba Build Event\Expression Builder
2. velis konteqstur meniudan airCieT brZaneba Properties\Control Source
3. orive brZanebiT pasuxebis siidan
formis romel nawilSi Tavsdeba veli, romelic iTvlis saSedego monacemebs
daqvemdebarebul angariSisTvis?
1. daqvemdebarebuli formis SeniSvnis nawilSi
2. formis SeniSvnis nawilSi
SeiZleba Tu ara gamoviyenoT sxva gamomTvleli velis saxeli saSedego
monacemebis gamoTvlisas Sum funqciis argumentebSi?
1. ara
2. ki
rogor gamovsaxo mTavar formaSi saSedego monacemebi, gamoTvlili
daqvemdebarebul formaSi?
1. axali gamomTvleli velis SeqmniT mTavar formaSi, romelSic SeitanT
miTiTebas velze, romelSic gamoTvlilia Sedegi
2. axali gamomTvleli velis SeqmniT mTavar formaSi, romelSic SeitanT
gamosaxulebas gamomTvleliT
ra SeiZleba miviCnioT formisTvis monacemebis wyarod?
1. cxrili
2. moTxovna
19.
20.
21.
22.
23.
24.
25.
3. SQL- instruqcia
4. samive pasuxebis siidan
sad inaxeba SQL-instruqcia, romelic gamoiyeneba formis Canawerebis wyarod?
1. formaSi
2. sabazo cxrilebSi
marTvis romel elementSia ganTavsebuli daqvemdebarebuli forma?
1. Subform/Subreport
2. Combo Box
romel TvisebebSi mieTiTeba mTavarisa da daqvemdebarebuli formebis
damakavSirebeli velebi?
1. Ldaqvemdebarebuli velebi _ Link Child Fields da ZiriTadi velebi _ Link Master
Fields
2. TvisebebSi Source Object
rogor unda moviqceT, Tu ar muSaobs kavSiri mTavarsa da daqvemdebarebul
formebs Soris?
1. SevamowmoT mTavarisa da daqvemdebarebuli formebis damakavSirebeli
velebi TvisebebSi Link Child Fields da Link Master Fields
2. SevamowmoT Sesabamisi kavSirebi cxrilebs Soris Database Tools\ Relationships
velebs, romlebic akavSirebs mTavarsa da daqvemdebarebul formebs, identuri
saxeli unda hqondes?
1. ki
2. ara
SeiZleba Tu ara kavSiri mTavarsa da daqvemdebarebul formebs Soris ramdenime
veliT dadgindes?
1. ara
2. ki
SeiZleba Tu ara navigatoris panelidan cxrilis gadaTreviT formaSi, SevqmnaT
daqvemdebarebuli forma?
1. ki
2. ara

pasuxebi testebze
5.
1; 6. 2; 7.3; 8. 1; 9. 1; 10. 1; 11. 3; 12. 1; 13. 1; 14. 3; 15. 1; 16.1; 17. 1; 16. 4; 19. 1; 20. 1; 21.
1; 22. 1; 23. 2; 24. 2; 25. 1.

savarjiSoebi
1.
gaxseniT monacemTa baza Biblioteka.mdb. gadadiT formebze. daaTvaliereT aq
arsebuli formebi. gaxseniT forma Avtori, imoZraveT CanawerebSi _ jer mTavari
formis Canawerze gadadiT da daaTvaliereT misi daqvemdebarebuli Canawerebi,
Semdeg gadadiT mTavari formis meore Canawerze da axla amis daqvemdebarebuli
Canawerebi daaTvaliereT. gamoiyeneT formaSi gadaadgilebis Rilakebi.
2. monacemTa bazaSi Biblioteka.mdb SeqmeniT forma frmWigniAvtori ori cxrilis safuZvelze tblwigni da tblwigniavtori. SeitaneT monacemebi am formiT. gadadiT cxrilebis
CanarTSi, gaxseniT cxrilebi tblAvtori da tblWigni. ra Sedegi miiReT?
3. monacemTa bazaSi Biblioteka.mdb gaxseniT rTuli forma frmMTavariwigniavtori, SeitaneT axali Canawerebi mTavar da daqvemdebarebul formaSi. daxureT forma.
gaxseniT cxrilebi tblavtori, tblwigni, tblwigniavtori. rogori Sedegi miiReT?
4. monacemTa bazaSi Biblioteka.mdb, formaSi frmMTavariwigniavtori SeitaneT dasaxeleba
avtoris wignebi, Semdeg daaTvaliereT da gamobeWdeT.
5. daqvemdebarebuli formis gamobeWdvis dros
SeiZleba warmoiqmnas Semdegi
problemebi:
- daqvemdebarebuli forma Tumca konstruqtoris reJimSi Cans, magram
daTvalierebis reJimSi ar Cans, an formaSi Cans carieli Canaweri;
- beWdvis
dros ar ibeWdeba
mTavari formis CanawerTan daqvemdebarebuli
formidan yvela masTan dakavSirebuli Canaweri, an, Tu aseTi Canawerebi ar
arsebobs, daqvemdebarebul
formaSi gamoitaneba carieli
Canaweri. axseniT,
ratom SeiZleba hqondes adgili aseT problemebs da rogor gadavwyvitoT isini.
6. monacemTa bazaSi Biblioteka.mdb SeqmeniT forma frmavtoriRilakebiT RilakiT, romelic
daakavSirebs cxrils tblavtori cxrilTan tblgamomcemloba.
7. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT: mTavar formaSi specialobebs da daqvemdebarebulSi _
studentebs. isargebleT formis Seqmnis dros meTodiT „mTavari-daqvemdebarebuli“ (Form with subform(s)).
8. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT: mTavar formaSi specialobebs da daqvemdebarebulSi _
studentebs. daqvemdebarebuli forma gamoitaneT RilakiT (Linked form(s)).
9. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT specialobebs da studentebs. isargebleT formis Seqmnis
dros meTodiT „erTiani forma” (Single Form).
10. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT: mTavar formaSi studentebs
da daqvemdebarebulSi _
sagamocdo Sefasebebs. formis Seqmnis dros isargebleT meTodiT „mTavaridaqvemdebarebuli“ (Form with subform(s)).
11. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT: mTavar formaSi studentebs
da daqvemdebarebulSi _
sagamocdo Sefasebebs. daqvemdebarebuli forma gamoitaneT RilakiT (Linked
form(s)).
12. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb SeqmeniT rTuli forma,
romelSic warmoadgenT studentebs
da sagamocdo Sefasebebs. formis Seqmnis
dros isargebleT meTodiT „erTiani forma“ (Single Form).

pasuxebi savarjiSoebze
2. gaxseniT monacemTa baza Biblioteka.mdb. jer SeqmeniT moTxovna qrywigniavtori, risTvisac
gadadiT CanarTSi Create. RilakiT Query D esign gamoiZaxeT moTxovnis Seqmnis fanjara,
Semdeg fanjaraSi Show T able miuTiTeT cxrilebi tblwigniavtori, t blavtori, romlidanac
gadaitanT moTxovnaSi velebs. cxrilidan tblavtori gadaitaneT gasaRebis garda yvela
veli. SeinaxeT moTxovna saxelis qveS qrywigniavtori. formis Sesaqmnelad moniSneT
moTxovna qrywigniavtori, gadadiT CanarTSi Create da gamoiZaxeT axali formis Seqmnis
brZaneba Form. miRebuli forma daaformateT da SeitaneT formiT monacemebi. Setanil
monacemebs ixilavT cxrilebSi tblwigniavtori, tblavtori.
3. formaSi frmMTavariwigviavtori Canawerebis Setanis Semdeg, im cxrilebSi, romlisaganac
Sedgenilia forma, axali Canawerebi Cndeba.
4. gaxseniT monacemTa baza Biblioteka.mdb. gamoitaneT navigaciis panelze formebis sia
F11/Forms. moniSneT forma frmMTavariwigviavtori, daaWireT Rilaks Home/View/Design View da
gadadiT konstruqtoris reJimSi. daaWireT Tagvis marjvena RilakiT striqons Detail da
konteqstur meniudan gamoiZaxeT brZaneba Form H eader/Footer (Tu formas jer ara aqvs es
struqturuli nawilebi). isargebleT marTvis elementiT Lable da nawilSi Form H eader
moxazeT marTkuTxedi. SeitaneT masSi formis saxeli da daaformateT.
5. daqvemdebarebul formaSi Canawerebi ar Cans maSin, rodesac aseTebi ar aris an
daqvemdebarebuli formis TvisebaSi Data Entry (monacemebis Setana) miTiTebulia mniSvneloba Yes (ki), ris Sedegad gamodis carieli Canaweri. Tu Tqven danamdvilebiT iciT,
rom daqvemdebarebuli Canawerebi arsebobs, maSin moiqeciT Semdegnairad: monacemTa
bazaSi amoarCieT daqvemdebarebuli forma da gadadiT konstruqtoris reJimSi,
gamoiZaxeT formis Tvisebebi _ Properties, striqonSi Data Entry miuTiTeT mniSvneloba No.
SeinaxeT forma da gaxseniT mTavari forma _ axla daqvemdebarebul formaSi Canawerebi
unda gamoCdes. Tu gnebavT, rom daqvemdebarebuli Canawerebis arsebobis dros beWdvaze
gaitanoT daqvemdebarebuli forma, moiqeciT Semdegnairad: gaxseniT daqvemdebarebuli
forma da konstruqtoris reJimSi, formis nawilisTvis Detail Tvisebebis striqonebSi Can
Grow (gafarToeba) da Can S hrink (SemWidroeba) miuTiTeT mniSvneloba Yes (ki). pirveli
maTgani uzrunvelyofs beWdvis dros daqvemdebarebuli formis yvela Canaweris
gamotanas, meore ki, Tu daqvemdebarebuli Canawerebi ar arsebobs, gamoitans marto
mTavar formas.
6. gaxseniT monacemTa baza Biblioteka.mdb. jer SeqmeniT moTxovna qryavtorigamomcemloba,
risTvisac gadadiT CanarTSi Create. RilakiT Query Design gamoiZaxeT moTxovnis Seqmnis
fanjara Show Table, miuTiTeT cxrilebi tblwigniavtori, tblavtori, tblwigni da tblgamomcemloba,
romlidanac gadaitanT moTxovnaSi velebs. cxrilidan tblwigniavtori gadaitaneT yvela
veli da danarCeni cxrilebidan _ yvela, gasaRebis garda. SeinaxeT moTxovna saxelis
qveS qryavtorigamomcemloba. formis Sesaqmnelad
gamoiZaxeT axali formis Seqmna
RilakiT More Forms/Form Wizard, ostatis pirvel fanjaraSi miuTiTeT wyarod qryavtorigamomcemloba, meore fanjaraSi gadaitaneT yvela veli. Semdeg fanjaraSi miuTiTeT,
rogor gnebavT gamoitanoT velebi. mouniSneT by tblavtor da CaurTeT gadamrTveli Linked
forms. gadadiT Semdeg fanjaraSi da miuTiTeT formis maketis xedi _ Standart. mieciT saxeli mTavar da daqvemdebarebul formas. daaWireT Rilaks Finish. gaxseniT Seqmnili
forma konstruqtoris reJimSi da daaformateT: SeasworeT dasaxelebebi, damaleT
velebi, romlebic ar gWirdebaT, SeucvaleT Srifti. gaxseniT formis daTvalierebis
reJimSi. formas aseTi saxe unda hqondes:
axla daaWireT Rilaks _ gamomcemloba, gaixsneba daqvemdebarebuli forma:
7. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblSpecialoba_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
tblStudentebis_sia da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi miuTiTeT,
Tu rogor gindaT monacemebis ganlageba: zemoT by tblSpecialoba_sia, Tu qvemoT by tblStudentebis_sia, radgan am or obieqts Soris kavSiri aris „erTi-bevrTan“ da Cven vqmniT
rTul formas mTavari da daqvemdebarebuli nawiliT:
ostatis mesame fanjaraSi CaurTeT Tolia gadamrTvelSi Form w ith s ubform(s). gadadiT
Semdeg fanjrebze da daeTanxmeT ostats SemoTavazebebze. bolos mieciT saxeli
miRebul formas. daaTvaliereT miRebuli Sedegi, gadadiT konstruqtoris reJimSi da
daaformateT miRebuli forma. Sedegi ase unda gamoiyurebodes:
8. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblSpecialoba_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
tblStudentebis_sia da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi miuTiTeT,
Tu rogor gnebavT monacemebis ganlageba: zemoT by t blSpecialoba_sia Tu qvemoT by t blStudentebis_sia, radgan am or obieqts Soris kavSiri aris „erTi-bevrTan“ da Cven vqmniT
rTul formas mTavari da daqvemdebarebuli nawiliT. mivuTiToT pirveli _
by
tblStudentebis_sia. CaurTeT Tolia gadamrTvelSi Linked f orms. gadadiT Semdeg fanjrebze
da
daeTanxmeT
ostats
SemoTavazebebze.
bolos
mieciT
saxeli
mTavar
da
daqvemdebarebul formebs. daaTvaliereT miRebuli Sedegi:
es forma dakavSirebulia daqvemdebarebul formasTan, romelsac gamoitanT
ekranze, Tu daaWerT Rilaks „studentebi specialobebze“.
9. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblSpecialoba_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
tblStudentebi_sia da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi miuTiTeT, Tu
rogor gindaT am velebis ganlageba: Tu ostatis me-3 fanjaraSi moniSnavT by t blStudentebi_sia da ara by tblSpecialoba_sia, maSin miiRebT erTian formas (Single Form):
SeasruleT moqmedebebi ostatis momdevno fanjrebSi. Sedegad aseTi forma unda
miiRoT:
10. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblStudentebis_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
sagamocdo Sefasebebi
da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi
miuTiTeT, Tu rogor gindaT monacemebis ganlageba: zemoT cxrilis tblStudentebis_sia
velebi Tu qvemoT cxrilis sagamocdo S efasebebi, radgan am or obieqts Soris kavSiri
aris „erTi-bevrTan“ da qmniT rTul formas mTavari da daqvemdebarebuli nawiliT,
miuTiToT pirveli - by tblStudentebis_sia:
CaurTeT Tolia Form w iht s ubform(s) gadamrTvelSi. gadadiT Semdeg fanjrebze da
daeTanxmeT ostats SemoTavazebebze. bolos mieciT saxeli mTavar da daqvemdebarebul
formebs. daaTvaliereT miRebuli Sedegi, gadadiT konstruqtoris reJimSi da
daaformateT miRebuli forma. Sedegi ase unda gamoiyurebodes:
11. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblStudentebis_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
sagamocdo Sefasebebi
da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi
miuTiTeT, Tu rogor gindaT monacemebis ganlageba: zemoT cxrilis tblStudentebis_sia
velebi Tu qvemoT cxrilis sagamocdo S efasebebi. radgan am or obieqts Soris kavSiri
aris „erTi-bevrTan“ da qmniT rTul formas mTavari da daqvemdebarebuli nawiliT,
miuTiTeT pirveli - by tblStudentebis_sia. CaurTeT Tolia Linked form(s) gadamrTveli.
gadadiT Semdeg fanjrebze da daeTanxmeT ostats SemoTavazebebze. bolos mieciT
saxeli mTavar da daqvemdebarebul formebs. daaTvaliereT miRebuli Sedegi, gadadiT
konstruqtoris reJimSi da daaformateT miRebuli forma. Sedegi naCvenebia qvemoT
naxatze:
es forma dakavSirebulia daqvemdebarebul formasTan,
ekranze, Tu daaWerT Rilaks „sagamocdo Sefasebebi“.
romelsac
gamoitanT
12. gaxseniT baza Magistratura(0203weli12kursi1semestri).mdb, gadadiT navigaciis panelSi
RilakiT F11, gadadiT formebis CanarTSi, gaaaqtiureT brZaneba More F orm//FormWizard.
miuTiTeT wyaro _ jer tblStudentebis_sia da gadaitaneT yvela veli, Semdeg miuTiTeT
sagamocdo Sefasebebi
da aqedanac gadaitaneT velebi. ostatis Semdeg fanjaraSi
miuTiTeT, Tu rogor gindaT monacemebis ganlageba: Tu ostatis me-3 fanjaraSi moniSnavT by s agamocdo S efasebebi da ara by tblStudentebi_sia, maSin miiRebT erTian formas
(Single Form):
gadadiT Semdeg fanjrebze da daeTanxmeT ostats SemoTavazebebze. bolos mieciT
saxeli mTavar da daqvemdebarebul formebs. daaTvaliereT miRebuli Sedegi, gadadiT
konstruqtoris reJimSi da daaformateT miRebuli forma. Sedegi naCvenebia qvemoT
naxatze:

damatebiTi literatura
1.
2.
3.
4.
5.
6.
7.
c. jafiaSvili. monacemTa bazebis daproeqteba da marTva. _ Tbilisi; Tbilisis
saxelmwifo universitetis gamomcemloba, 2008. gv. 273-290.
Mak-Donal,d M& Access 2007&Nedosta.]ee rukowodstwo& Per& s angl& ! M&% Izdatel,stwo&
“Russkaq Redakciq“ + SPb&% $BHW-_Peterburg$, 2007. str& 421_459&
Гончаров А. Ю. Access 2007. Самоучитель с примерами. Москва, «КУДИЦ-ПРЕСС», 2007, .гл. 5.
http://office.microsoft.com/ru-ru/training/CR101582831049.aspx (аудио курсы)
John Viescas , Jeff Conrad. Microsoft® Office Access 2007 Inside Out. Intermediate, Advanced.
US,ISBN 13 : 9780735623255, 2007.
Curtis D. Frye . Microsoft® Office Access 2007 Plain & Simple. Beginner.ISBN 13 : 9780735622920,
2007.
Steve Lambert, M. Dow Lambert III, Joan Preppernau. Microsoft® Office Access 2007. Step by Step.
Beginner, Intermediate. ISBN 13 : 9780735623033, 2007.
8.
9.
Michael R. Groh, Joseph C. Stockman, Gavin Powell, and Cary N. Prague. "Access 2007 Bible"ISBN-13: 9780-470-04673-9ббWiley Publishing, Inc., Indianapolis, pg.269-296.
http://office.microsoft.com/en-us/training/CR101582831.aspx (Audio kurses)

konsultaciisTvis isargebleT misamarTiT:
1. [email protected]
2. Tsu, ekonomikisa da biznesis fakulteti, oTaxi 612, tel. 303710
