1025  gakveTili 25

  Tema 10

 

  monacemebis importi da eqsporti 

   

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

damatebiTi

literatura

pedagogis konsultacia

5

√ pasuxebi testebze

2

√ pasuxebi savarjiSoebze

4? savarjiSoebi

3

? kiTxvebi da testebi

1 

importi, eqsporti da monacemebis dakavSireba

ODBC daniSnuleba Access-i SegviZlia gamoviyenoT rogorc damoukidebeli daxuruli sistema,

magram Access-s SeuZlia imuSaos agreTve sxvadasxva programuli sistemebis mier Seqmnil monacemTa bazebTan, TviTon Access-is monacemTa bazebTan, teqsturi redaq-torebis failebTan, eleqtronul cxrilebTan da nebismier sistemasTan, romelic iyenebs ODBC standarts _ dBase, Rbase, Pradox, Microsoft Fox Pro, SQL monacemTa bazebi, Excel, Word, Pover Point. mas SeuZlia monacemebis gacvla – importireba, eqsportireba da kavSiriT sargebloba. Tu Access-Si „Rrmad CaixedavT“, dainaxavT, rom nebismieri moTxovna iyenebs enas, romelsac moTxovnis struqturirebuli ena – SQL (Structured Query Language) ewodeba. SQL-is konstruqciebi SeiZleba dainaxoT, Tu gaxsniT moT-xovnas da instrumentul panelidan gamoiZaxebT brZanebas Home\Views\View\SQL. SQL oficialuri standartia relaciuri bazebisTvis. Tumca firmebi, romlebic pro-gramul produqtebs qmnian, iyeneben Tavisi produqciis specialuri funqciebisTvis am enis sxvadasxva dialeqts. amitom sxvadasxva monacemTa bazebis marTvis sistemebis-Tvis Seiqmna urTierT-gansxvavebuli sintaqsi. aman ganapiroba SQL-is erTiani standartis (CLI - Common Language Interface) Seqmna. Microsoft-ma am standartis formalizeba moaxdina da gamoacxada, rom yvela programuli produqti da maT So-ris is, romelic muSaobs Microsoft Windows-is garemoSi SQL-bazebisTvis, gamoiyenebs CLI standarts. am formalizebul interfeiss daerqva Open Data Base Connectivity (ODBC – monacemTa bazasTan Ria urTierTqmedeba). amis Semdeg monacemTa bazebis mwarmoe-blebma Tavisi programuli sistemebis (monacemTa bazebis marTvis sistemebisTvis) SeqmnaSi aiRes valdebuleba, gaeTvaliswinebinaT maTi muSaoba ODBC standartTan. TviTon Microsoft-ma Access-is SemqmnelebTan erTad SeimuSava ODBC programa-administratori da ODBC draiveri Microsoft SQL Server-isTvis. Microsoft-ma mbms-is Semqmnel sxva firmebTan erTad imuSava maTi ODBC draiverebis Seqmnaze.

monacemebis importireba monacemTa bazebidan

monacemebis importireba SesaZlebelia ara marto Access-is monacemTa bazebidan, aramed im bazebidanac, romlebic Seqmnilia dBaze, Rbase, Paradox, FoxPro marTvis sistemebis mier, nebismieri SQL-bazidan, vinaidan isini ODBC standarts eqvem-debarebian. qvemoT garCeulia monacemebis gacvla Access-is bazebs Soris, Access-isa da Excel-is bazebs Soris. sxva marTvis sistemebis bazebTan muSaoba igive teqnologi-iT sruldeba. instrumentul panelze importirebis da eqsportirebis moqmedebebia Tavmoyrili CanarTSi External Data. aq SesaZlebelia airCioT yvelaze popularuli formatebiT monacemebis gadatana Access-Si. Tu Tqven ver xedavT TqvenTvis saWiro formats, imoqmedeT TagviT Rilakze More da CamoSaleT damatebiTi formatebis sia:

Access-Si Seqmnili monacemTa bazis nebismieri obieqtis (cxrilebis,

moTxovnebis, formebis, angariSebis, makrosebis da modulebis) importireba SesaZlebelia Access-is mier Seqmnil sxva bazaSi. bazis obieqtebis importireba Se-saZlebelia kopirebis brZanebebiT: Cut/Copy/Paste. magram, rodesac mravali obieqtia gadasatani erTi bazidan meoreSi, maSin es meTodi ar gamodgeba da unda visargebloT importirebis specialuri brZanebiT.

Access-is erTi bazidan meoreSi monacemebis importirebisTvis SeasruleT Semdegi moqmedebebi: 1. gaxseniT monacemTa baza, romelSic obieqtebis importireba gnebavT. 2. airCieT brZaneba Get External Data/Import/Access. Access-i gaxsnis ostatis fanjaras,

sadac unda moZebnoT da miuTiToT monacemTa baza, saidanac gnebavT obieqtebis gadmotana:

SeitaneT failis saxeli, romlis importirebas apirebT. Tu ar gaxsovT misi sexeli da misamarTi, isargebleT RilakiT Browse. fanjaraSi Open File moZebneT faili, imoqmedeT TagviT masze orjer. fanjaraSi Get External Data ori gadamrTvelia: failis da danarCeni obieqtebis importireba bazaSi da obieqtebis importireba kavSiriT. CarTeT pirveli gadamrTveli da daxureT fanjara.

 

3. gaixsneba fanjara Import Objects. am fanjaraSi moniSneT obieqtebi, romlis importirebas apirebT. aq SegiZliaT moniSnoT nebismieri obieqti nebismieri raodenobiT. Rilaki Select All dagexmarebaT moniSnoT erTianad TiToeuli saxis obieqtebi. Rilaki Options gTavazobT damatebiT parametrebs: importirebisas SegiZliaT gadmoitanoT obieqtis struqtura, struqtura da monacemebi, bazis logikuri struqtura (Relationships), Seqmnili bazisTvis meniu da panelebi, moTxovnebi cxrilebadD an moTxovnebad.

4. gadmotanil obieqtebs unarCundeba dasaxelebebi, magram, Tu bazaSi, sadac gadmo-gaqvT obieqti, ukve arsebobs igive dasaxelebis obieqti, Access-i mas igive dasaxelebas miscems, oRond dasaxelebis bolos nomers mianiWebs.

5. bolo fanjaraSi ostati gekiTxebaT _ gnebavT, Tu ara SeinaxoT importirebis bijebi. Tu momavalSic mogixdebaT importirebis gameoreba, CarTeT gadamrTveli Save import steps (SeinaxeT importirebis procesis bijebi) da daxureT fanjara. Tu importirebis procesSi programa aRmoaCens Secdomebs, is Seqmnis igive dasaxe-lebis cxrils, romelic aqvs miznobriv cxrils, da cxrilis dasaxelebas miuer-Tebs nasils ImportErrors. am cxrilSi naxavT im Canawerebs, romlebic problema-turia impirtisaTvis.

monacemebis importireba eleqtronuli cxrilidan

eleqtronuli cxrili rom SeitanoT Access-is monacemTa bazaSi, SeasruleT Semdegi moqmedebebi.

gaxseniT Access-Si monacemTa baza, romelSic eleqtronuli cxrilidan unda gadmoitanoT monacemebi. gamoiZaxeT brZaneba Get External Data/ Import/Excel. ostatis pirvel fanjaraSi unda miuTiToT im failis saxeli da misi misamarTi, romelic SemogaqvT bazaSi. SegiZliaT gamoiyenoT Rilaki Browse:

CarTeT pirveli gadamrTveli, romliTac uTiTebT, rom asrulebT Excel-is

cxrilis importirebas Access-is bazaSi. meore gadamrTvels iyenebT im SemTxvevaSi, Tu cxrils, romelic monacemTa bazaSi arsebobs, Canawerebs amatebT. mesame gadamrTveli emsaxureba cxrilis kavSiriT impirtirebas. daxureT fanjara da gadadiT ostatis meore fanjaraze.

importireba Sesruldeba, Tu Tqven sworad gansazRvravT diapazonebs, gverdebs, rac niSnavs, rom Excel-is cxrili momzadebulia importirebisTvis. cxrilis pirvel striqonSi SegiZliaT SeitanoT fiqtiuri striqoni, romliTac Access-i gansazRvravs monacemebis tips da formats. rogorc wesi, Excel-is cxrilSi velebis dasaxelebis striqoni arsebobs da, Tu Tqven miuTiTebT programa-ostats aseTi striqonis arsebobas, igi Sesabamisad daarqmevs Access-Si Seqmnili cxrilis velebs. programa-ostatSi saTiTaoT yvela velze mieTiTeba velis saxeli, monacemebis tipi, indeqsi. amas ostati Excel-is cxrilis pirveli striqonis analizis Sedegad gamoitans, magram, Tu Tqven cvlilebis Setana gnebavT, miuTiTeT Access. zogierTi veli Tqveni miTiTebiT SegiZliaT ar CarToT importSi. qvemoT moyvanilia Excel-is gverdis fragmenti:

ostatis meore fanjaraSi amoarCieT Excel-is wignis gverdi (Show Worksheets) an

ujredebis diapazoni (Show Named Ranges). Tu winaswar ara gaqvT diapazonisTvis miniWebuli saxeli, gamodiT importirebidan, daarqviT cxrilis diapazons saxeli da ganmeorebiT gamoiZaxeT importirebis programa-ostati:

ostatis mesame fanjaraSi miuTiTeT, rom eleqtronuli cxrilis pirvel

striqonSi mocemuli velebis dasaxelebebi (First Row Contains Column Header) unda gamoyenebul iqnes Access-is cxrilis velebis saxelebad:

Rilakis Next daWeris Semdeg ostatis Semdeg fanjaraSi vamatebT Access-Si

arsebul cxrils importirebis monacemebs, risTvisac uTiTebT axali cxrilis saxels (In a New Table) an uTiTebT arsebuli cxrilis saxels (In an Existing Table) gverdiT fanjaraSi. gadadiT Semdeg fanjaraze RilakiT Next:

Tu cxrili axalia da iqmneba Access-Si, am fanjaraSi gansazRvreT velebi –

maTi dasaxeleba (Field Name), indeqsirebis Tviseba (Indexed). indeqsirebas Tu uTiTebT, CamoSaleT gverdze arsebuli fanjris samkuTxedi da aarCieT mniSvneloba _ ganmeorebebi ar daiSveba (No Dublicates) an ganmeorebebi daiSveba (Yes Dublicates). monacemebis tipi mieTiTeba eleqtronuli cxrilis pirveli ramdenime striqonis ana-lizis Sedegad. Tu Tqven mis mier velisTvis gansazRvrul tips ar eTanxmebiT, SegiZliaT SecvaloT. xSirad importirebis velebidan gnebavT gamoricxoT eleqt-ronul cxrilSi arsebuli romelime veli, maSin CarTeT gadamrTveli (Do Not Import Field, Skip):

Semdeg fanjaraSi SegiZliaT gansazRvroT pirveladi gasaRebi. aq Semdegi

pirobebia SemoTavazebuli: daadginos gasaRebi Access-ma (Let Access add primary key), daadginoT gasaRebi Tqven (Choose my own primary key) da darCes cxrili gasaRebis gareSe (No primary key). Tu gasaRebi problemas giqmniT, nu SeqmniT gasaRebs importirebis dros, Tqven SegeZlebaT mogvianebiT, eqsportirebul obieqtSi daniSnoT gasaRebi:

ostatis bolo fanjaraSi SegiZliaT axali cxrilis saxeli SeitanoT. Tu

Access-Si arsebobs ukve am cxrilis saxeli, Access-i SegekiTxebaT, gnebavT datovoT igive saxeli, Tu SecvliT mas.

importirebis SesrulebisTvis daaWireT Rilaks Finish. Access-i Setyobinebis

fanjaras gaxsnis. Tu importirebam kargad Caiara, Access-i Excel-is cxrilis saxels Secvlis Access-Si Seqmnili axali cxrilis saxeliT. Tu monacemebs amatebT Access-

 

is cxrilSi da Secdomebs aRmoaCenT, maSin SegiZliaT SecdomebiT daasruloT importireba an dabrundeT ostatis wina fanjrebSi da SeecadeT SeasworoT Secdomebis mizezebi. xSirad mogiwevT Excel-Si dabruneba da Sesworebebis Setana wignis nawilebSi.

Tu importireba SecdomebiT Sesrulda, Access-i gamoitans monacemebis

gardaqmnis Secdomebs. magaliTad, Tu velis tipi arasworad aris miTiTebuli, Access-i migiTiTebT im Canawerebze, romlebSic mis mier Catarebuli analizis Sedegad Secdomaa aRmoCenili. am Secdomebis gasworeba SegiZliaT Seqmnil cxrilSi, rogorc konstruqtoris reJimSi, aseve uSualod cxrilis reJimSi monacemebis SesworebiT.

failebis dakavSireba

Access-Si iseve, rogorc nabismier Microsoft Office-is programebs Soris, SesaZlebelia monacemTa bazebis obieqtebis dakavSireba. SesaZlebelia Access-Si Seqm-nili sxvadasxva bazebis dakavSirebac. dakavSirebuli failebi SeiZleba ganTavsebul iqnes rogorc erT kompiuterze, aseve sxvadasxva kompiuterze qselis pirobebSi. monacemTa bazis dakavSirebul failebTan SesaZlebelia imuSaoT rogorc bazis sakuTar failebTan: SegiZliaT waikiTxoT misi Canawerebi, SeitanoT axali da waSaloT arsebuli Canawerebi1, gamoiyenoT isini formebSi, angariSebSi, moTxovnebSi.

imisTvis, rom Access-is monacemTa bazas daukavSiroT cxrili Access-is meore bazidan, SeasruleT Semdegi moqmedebebi: 1. gaxseniT monacemTa baza. 2. airCieT brZaneba Get Exterlal Data/Import/Access. ostatis pirvel fanjaraSi CarTeT

gadamrTveli Link to the data source by creating a linked table (SeqmeniT faili dakavSirebuli gareSe wyarosTan).

3. moZebneT is monacemTa baza, romlis obieqtic gWirdebaT. 4. Access-i gaxsnis fanjaras Link Table, sadac CamoTvlilia miTiTebuli monacemTa

bazis cxrilebi. moniSneT cxrili an cxrilebi da daaWireT Rilaks Ok:

 

5. Tu dakavSirebis operacia dadebiTad Catarda, bazaSi cxrilebis siaSi gamoCndeba SerCeuli cxrili (im SemTxvevaSi, Tu Semotanili cxrilis dasaxeleba imeorebs bazaSi arsebulis, maSin is miiRebs igive saxels da saxelis bilos – nomers). monacemTa bazaSi dakavSirebuli cxrili cxrilebis siaSi Cndeba specialuri

piqtogramiT:

                                                            1 Excel-Si Seqmnil dakavSirebul failSi striqonebis waSla ar SeiZleba.

teqsturi da eleqtronuli cxrilebis dakavSireba

teqsturi da eleqtronuli cxrilebis dakavSireba am tipis failebis importirebis identuria. failebis dakavSirebisTvis monacemTa bazasTan Semdegi moqmedebebi unda CaataroT.

gaxseniT monacemTa baza, airCieT brZaneba Get External Data/import/Excel eqselis tipis failis dakavSirebisTvis an External Data/Import/TextFile _ teqsturi tipis failisTvis. Sedegad gamoiZaxeba ostati da ixsneba ostatis pirveli fanjara. am ostatis fanjrebi analogiuria wina masalaSi garCeuli importirebis ostatis fanjrebisa. monacemTa bazaSi cxrilebis nawilSi dakavSirebis moqmedebebis Catarebis Semdeg gaCndeba axali faili kavSiris niSniT da failis tipis amRni-Svneli piqtogramiT. zemoT moyvanil suraTze bolo oTxi striqoni dakavSirebul failebs warmoadgenen. maTi tipebia: r\pilveli maTganisa _ Access-is, Semdegi ori _ eqselis, meoTxe – teqsturi tipis.

dakavSirebuli cxrilis bazidan waSla SeasruleT brZanebiT: Home/Records/Delete an pirdapir Del klaviSiT obieqtis moniSvnis Semdeg. Tu dakavSirebuli cxrilebis adgili icvleba, maTi kavSirSi miTiTebuli adgilis gana-xleba SesaZlebelia dispetCeris mier. rodesac aseTi informaciis ganaxleba gnebavT, gaxseniT baza, romelic Seicavs dakavSirebul failebs, airCieT brZaneba DatabaseTools/ DatabaseTools/Link Table Manager. igive dasaxelebis fanjaraSi gamoCndeba im cxrilebis sia, romlebic warmoadgenen dakavSirebulebs. moniSneT cxrili (cxrilebi), romlis adgilmdebareoba gainteresebT, SeitaneT gadamrTvelSi marcxniv Tolia da daaWireT Rilaks Ok. dakavSirebuli failebis adgilis SemowmebisTvis SegiZliaT CarToT gadamrTveli Always Prompt For New Location – yovelTvis gamoices Setyobineba adgilis Secvlis Sesaxeb.

monacemebis eqsportireba

Access‐is erTi bazidan meoreSi SesaZlebelia agreTve nebismieri obieqtis an obieqtis nawilis eqsportireba. aseve SesaZlebelia monacemebis eqsportireba Access-is bazebidan sxva monacemTa bazis marTvis sistemebis bazebSi, eleqtronul

cxrilebSi an teqstur redaqtorebSi. Access-is obieqtebis eqsporti SegiZliaT awarmooT agreTve SQL serverze da HTML dokumentebSi.

Access-is bazebs Soris monacemebis eqsportireba mniSvnelovnad hgavs importirebis operacias. gaxseniT monacemTa baza. moniSneT saeqsporto obieqti,

magaliTad monacemTa bazidan Testireba.mdb cxrili Sedegi da gamoiZaxeT brZaneba Get External Data/Export. airCieT Rilaki, romliTac miuTiTebT Access, romeli tipis failSi gnabavT eqsportireba. muSaobas daiwyebs programa-ostati da gaixsneba pirveli fanjara:

 

fanjaraSi miTiTebulia romel fails qmniT eqsportirebiT. SegiZliaT

isargebloT RilakiT Browse. aqve SegiZliaT miuTiToT failis formati, Tu samkuTxa isars CamoSliT. formatebis siaSi Setanilia Zveli da axali formatebi

EExcel-is versiebis Sesabamisad. Tu gvebavT SeinarCunoT miznobriv failSi monacemTa bazaSi saeqsporto failis struqtura da gamoyenebuli formatireba, CarTeT

pirveli gadamrTveli. Sedegad miRebul failis daTvalierebisTvis CarTeT meore

gadamrTveli. mesame gadamrTveli mkrTalad Cans, vinaidan emsaxureba obieqtis

moniSnuli nawilis eqsports, magaliTad cxrilis ramdenime Canawers, an angariSis

marto saSedego nawils. daxureT fanjara. Access-i DSeasrulebs eqsportirebas da SegekiTxebaT Seinaxos, Tu ara eqsportirebis procesis msvleloba.

eqsportisa da importis procesis gamoyeneba ganmeorebiT

SeiZleba dagWirdeT eqsportis da importis operaciebis regularulad

ganmeoreba. Tu Tqven importirebis an eqsportirebis ostatis SekiTxvas _ gnebavT Tu ara procesis Senaxva, TanxmobiT pasuxobdiT, Tqven SeZlebT gaimeoroT es procesebi.

amisaTvis instrumentul panelze importis da eqsportis brZanebebis nawilSi aris

Rilaki Saved Imports (Senaxuli importirebis procesebi) da Saved Exports (Senaxuli eqsportirebis procesebi). maTi gaaqtiurebiT iRebT fanjaras, sadac SeZlebT: gaimeoroT procesi an waSaloT Senaxuli procesi:

sakontrolo kiTxvebi da testebi

1. monacemebis gacvlis ra SesaZleblobebi aqvs Access? 2. ra udevs safuZvlad marTvis sistemebs da sxva programul sistemebs ganaxorcielos monacemTa gacvla?

3. rogor sruldeba monacemebis eqsporti da importi Access-is bazebs Soris? 4. rogor sruldeba monacemebis eqsporti da importi Access-is bazebis monacemebsa da Excel-is cxrilebs Soris?

5. ras niSnavs da rogor sruldeba monacemebis dakavSireba bazebs Soris da bazebsa da eleqtronul cxrilebs Soris?

6. cxrilis importireba SeiZleba saWiro gaxdes, Tu: 1. cxrili mcire zomisaa da xSirad ar sWirdeba modificireba 2. monacemebiT ar sargeblobs sxva momxmarebeli 3. cvliT Zvel amocanas axliT da ar gindaT datovoT igive formati 4. gindaT moigoT dro mza aslis gamoyenebiT 5. oTxive swori pasuxia

miuTiTeT, romelia swori pasuxi.

7. failTan kavSiriT importireba bazaSi SeiZleba Sesruldes im SemTxvevaSi, Tu: 1. faili sakmarisad didia 2. monacemebi xSirad icvleba 3. monacemTa bazis ganlageba gnebavT qselur serverze 4. samive SemTxvevaSi pasuxebi siidan marTebulia

miuTiTeT, romelia swori pasuxi.

8. SeiZleba Tu ara SevucvaloT saxeli da sxva Tvisebebi importirebul cxrils?

1. ki 2. ara

9. SeiZleba Tu ara SevucvaloT saxeli da sxva Tvisebebi importirebul cxrils kavSiriT? 1. ki 2. ara

10. SeiZleba Tu ara failis importireba brZanebiT: Copy/ Paste? 1. ki 2. ara

11. inaxeba Tu ara eqsportirebuli failis asli Access-Si?

1. ki 2. ara

12. monacemTa bazaSi monacemebis importireba dakavSirebulia Semdeg problemebTan: 1. importirebis cxrilis SesabamisobaSi moyvana monacemTa bazis mkacr

wesebTan 2. informaciis damuSaveba, romlis warmodgena monacemTa bazaSi ar emTxveva

mis warmodgenas saimporto dokumentSi 3. Access-Si ar arsebobs programa-ostatebi, romliTac iolad SemoitanT

monacemebs Access-Si miuTiTeT mcdari problema siidan

13. monacemis damatebis tipis (Attachment) importirebis Sedegad bazaSi miviRebT: 1. fails 2. damatebebis raodenobas

14. Access-is erTi monacemTa bazidan meoreSi cxrilis importirebis dros SesaZlebelia importireba:

1. cxrilis struqturis 2. cxrilis struqturisa da monacemebis 3. cxrilSi damatebiTi monacemebis 4. samive pasuxi marTebulia

15. romeli proceduraa sistemurad metad ioli: 1. Access-dan monacemebis gatana sxva programul sistemaSi, magaliTad Excel-

Si an Word_Si 2. monacemebis Semotana Access-Si, magaliTad Excel-idan an Word-idan

16. Eeqselidan importirebis cxrili unda akmayofilebdes Semdeg pirobebs:

1. cxrilis velebis dasaxeleba Excel-is furcelze da Access-Si misaReb cxrilSi unda emTxveodes

2. sabazo Excel-is cxrilSi da Access-Si misaReb cxrilSi svetebis raodenoba erTia

3. sabazo Excel-is cxrilSi ar unda iyos mniSvnelobebi, romlebic formulebiT gamoiangariSeba

4. samive pirobis Sesruleba marTebulia

17. Access-is romeli obieqtis eqsportireba ar Sesruldeba: 1. moTxovnis 2. cxrilis 3. angariSis 4. formis

savarjiSoebi

1. SeqmeniT axali monacemTa baza da SeecadeT bazidan Magistratura(0203weli12kur si1semes tri).mdb gadaitanoT romelime cxrili meTodiT Copy/Paste.

2. SeiZleba Tu ara SegxvdeT Semdegi problemebi eleqtronuli cxrilis Canawerebis damatebisas Access-is cxrilSi?

- velebis dasaxeleba eleqtronul cxrilSi ar emTxveva Access-is cxrils (Tu Tqven miuTiTeT, rom pirveli striqoni velebis dasaxelebebs Seicavs, isini unda emTxveodnen);

- monacemebi, romelsac amatebT, gansxvavebuli tipisaa Sesabamisi velisTvis dasamatebel cxrilSi, magaliTad, cxrilis tipi cifrulia da masSi Tavsdeba teqsturi monacemi. aseve zoma am ori velisa SeiZleba gansxvavdebodes.

dasamatebeli velis monacemis zoma met adgils moiTxovs, vidre, romelsac amatebT;

- dasamatebel velSi aris ganmeorebadi Canawerebi da es veli mimReb cxrilSi gasaRebad aris gamocxadebuli. axseniT, rogor moviqceT TiToeuli am problemis gadasaWrelad.

3. gaitaneT eqsportis brZanebiT monacemTa bazidan Testireba.mdb cxrili Instraction. isargebleT failis tipiT Text Files.

4. gaitaneT eqsportis brZanebiT monacemTa bazidan Testireba.mdb cxrili jgufi_specialoba. isargebleT Excel-is failis tipiT, CaurTeT gadamrTveli Exsport File with formatting and Layout. rodis ar uTiTebT am pirobas?

5. monacemTa bazaSi Magistratura(0203weli12kursi1semestri).mdb cxrilebSi kavSiriT aris cxrili StudSpecialobebze. SeucvaleT adgili cxrils da SeitaneT sxva folderSi. gamoiZaxeT igi monacemTa bazidan. am cxrilis gamoZaxebis dros Access SegatyobinebT, rom cxrils ver poulobs. romeli brZanebiT isargeblebT imisaTvi , rom SeucvaloT cxrils misamarTi, raTa Access-ma moZebnos igi? s

pasuxebi testebze

6. 5; 7. 4; 8. 1; 9. 2; 10. 1; 11. 1; 12. 3; 13. 2; 14. 4; 15. 1; 16. 4; 17. 4.

pasuxebi savarjiSoebze

1. SevqmnaT monacemTa baza Magaliti.mdb. gavxsnaT orive baza Testireba.mdb da Magaliti.mdb ekranze vertikalurad erTi meores gverdze. CamoSaleT navigaciis panelze obieqtebis sia monacemTa bazaSi Testireba.mdb. airCieT cxrili sakiTxi, isargrbleT konteqsturi meniuTi da gaaaqtiureT brZaneba Copy. gadadiT monacemTa bazaSi Magaliti.mdb. imoqmedeT TagviT navigaciis panelze da konteqsturi menius gamoZaxebis Semdeg airCieT brZaneba Paste. ekranze patara fanjara gamoCndeba, romelic migiTiTebT cxrilis saxels da SegekiTxebaT cxrilis ra nawilis Casma gnebavT: cxrilis struqturis, cxrilis struqturis da monacemebis, an gnebavT daamatoT Canawerebi cxrilSi, Tu aseTi dasaxelebis cxrili ukve arsebobs bazaSi. CarTeT meore gadamrTveli da daxureT fanjara. axali cxrili obieqtebis siaSi gamoCndeba.

2. pirvel SemTxvevaSi SeamowmeT velebis dasaxelebebi, tipebi da zomebi. Semdeg ki xelmeored SeecadeT monacemebis importirebas; mesame SemTxvevaSi jer Access-is cxrils gasaRebi unda moxsnaT da ise gaimeoroT importireba. Setanili monacemebisTvis redaqtirebis Semdeg ki daadgineT velisTvis gasaRebi. rogorc wesi, Tu monacemebis Setana SecdomebiT midis, dagWirdebaT dabruneba saomporto cxril-Si da monacemebis Sesworeba.

3. gaxseniT baza Testireba.mdb, moniSneT cxrili Instraction, gamoiZaxeT brZaneba External Data/Export/TextFile. ostatis pirvel fanjaraSi CarTeT pirveli ori gadamrTveli: SeinarCunos failis formatirebis pirobebi saSedego cxrilSi da gaxsnas ekranze miRebuli Sedegi eqsportirebis procesis damTavrebis Semdeg. daxureT fanjara. eqsportirebul failSi SeiZleba dagWirdeT fontis Secvla. faili iqmneba Windows-is programiT Notped.

4. gaxseniT baza Testireba.mdb, moniSneT cxrili StudSpecialobebze, gamoiZaxeT brZaneba Get External Data/Export/Excel. ostatis pirvel fanjaraSi miuTiTeT miznobriva failis Senaxvis adgili da misi tipi. CarTeT gadamrTveli formatirebis SenarCunebaze, daa-WireT Rilaks Ok. ostatis Semdeg fanjaraSi nu CarTavT eqsportirebis procesis Senaxvis gadamrTvels da daxureT fanjara. Tu gadamrTvels formatirebis SenarCu-nebaze ar CarTavT, Secdomebis SemTxvevaSi miiRebT Setyobinebas Secdomebze da Secdomebis fails. gaxseniT Secdomebis faili da SeadareT eqselSi eqsportirebuli faili Secdomebis fails.

5. gaxseniT monacemTa baza Magistratura(0203weli12kursi1semestri).mdb. gadadiT navigaciis panelze cxrilebze da SeecadeT gaxsnaT cxrili StudSpecialobebze. Tu cxrils misa-marTi Secvlili aqvs, Access-i SegatyobinebT, rom ver xsnis cxrils. amitom isar-

gebleT brZanebiT Linked Table Manager instrumentul panelis CanarTidan DataTools gaaqtiureT brZaneba DataTools/Linked Table Manager. ekranze fanjara gamoCndeba im cxrilebiT, romlebic dakavSirebul cxrilebs warmoadgenen. moniSneT cxrili StudSpecialobebze da daaWireT Rilaks Ok. ekranze gamosul fanjaraSi miuTiTeT cxrilis axali misamarTi. ostati SegatyobinebT, Tu rogor Caiara Sesworebam.

damatebiTi literatura

1. c. jafiaSvili. monacemTa bazebis daproeqteba da marTva. _ Tbilisi; Tbilisis saxelmwifo universitetis gamomcemloba, 2008. gv. 223-240.

2. MakDonal,d M& Access 2007&Nedosta.]ee rukowodstwo& Per& s angl& ! M&% Izdatel,stwo& “Russkaq Redakciq“ + SPb&% $BHW_Peterburg$, 2007. str& 647_667&

3. Гончаров А. Ю. Access 2007. Самоучитель с примерами. Москва, «КУДИЦ-ПРЕСС», 2007, .гл. 7. 4. http://office.microsoft.com/ru-ru/training/CR101582831049.aspx (аудио курсы) 5. John Viescas , Jeff Conrad. Microsoft® Office Access 2007 Inside Out. Intermediate,

Advanced. US,ISBN 13 : 9780735623255, 2007. 6. Curtis D. Frye . Microsoft® Office Access 2007 Plain & Simple. Beginner.ISBN 13 : 9780735622920,

2007. 7. Steve Lambert, M. Dow Lambert III, Joan Preppernau. Microsoft® Office Access 2007. Step by Step.

Beginner, Intermediate. ISBN 13 : 9780735623033, 2007. 8. Michael R. Groh, Joseph C. Stockman, Gavin Powell, and Cary N. Prague. "Access 2007 Bible"ISBN-

13: 978-0-470-04673-9ббWiley Publishing, Inc., Indianapolis, pg.525-580. 9. http://office.microsoft.com/en-us/training/CR101582831.aspx (Audio kurses)

     konsultaciisTvis isargebleT misamarTiT:

1. Tzira@rocketmail.com 2. Tsu, ekonomikisa da biznesis fakulteti, oTaxi 612, tel. 303710

     

http://office.microsoft.com/ru-ru/training/CR101582831049.aspxhttp://office.microsoft.com/en-us/training/CR101582831.aspx

importi, eqsporti da monacemebis dakavSirebaODBC daniSnulebamonacemebis importireba monacemTa bazebidanmonacemebis importireba eleqtronuli cxrilidanfailebis dakavSirebateqsturi da eleqtronuli cxrilebis dakavSireba monacemebis eqsportirebapasuxebi testebze