Uyenza njani idatabase yoFikelelo egcina iindlela okanye izincamatheliso

Ngaba ukhe wazibuza ukuba ungawahlela njani amaxwebhu, imifanekiso, okanye iifayile ezidityaniswe ngokuthe ngqo kwisiseko sedatha ngaphandle kokuphazamiseka kwekhowudi yokubhala? Microsoft Access Yenye yezona zinamandla kwaye zilula iinketho zokugcina kunye nokulawula uncamathiselo okanye iindlela zamaxwebhu, ekuvumela ukuba ubeke embindini wolwazi lonke ngokufanelekileyo.

Kweli nqaku ndikuchazela ngendlela ecacileyo nengokwemvelo Uyenza njani i-database kwi-Fikelelo egcina iindlela okanye izinamathiselo, iingenelo zayo, awona manyathelo abalulekileyo, kunye neenkcukacha zobuchwephesha omele uzazi ukuze uqinisekise ukuba ulawulo lwakho loxwebhu lomelele, luyakhawuleza, kwaye kulula ukulugcina. Zilungiselele ukufumana yonke into oyifunayo ukuyazi, ukusuka kwezona ngcamango zisisiseko ukuya kwiimpawu eziphambili, ukudibanisa ezona ndlela zibalaseleyo kunye neengcebiso ezisebenzayo.

Yintoni isiseko sedatha ekuFikelelekeni kwaye sisetyenziselwa ntoni?

Omnye isiseko sedatha kuFikelelo Yinkqubo eququzelelayo, ihlele, kwaye ikhusele ulwazi oluninzi olwahlukeneyo: ukusuka kubathengi okanye idatha yemveliso ukuya kumaxwebhu e-elektroniki, ii-invoyisi, okanye iifoto. Ukufikelela Akugcini nje ukuvumela ukuba wenze iitafile kunye nokugcina idatha, kodwa inikezela ngezixhobo ezibonakalayo zemibuzo, iingxelo, kunye neefom, okwenza kube lula ukungena, ukukhangela, kunye nokuhlalutya ulwazi.

Eyona nto inika umdla kukuba ufikelelo ludibanisa imisebenzi ethile ncamathela iifayile ngqo kwiirekhodi. Oku kuluncedo ngakumbi ukuba usebenza ngamaxwebhu edijithali (ii-invoyisi, iikhontrakthi, imifanekiso, njl.), okanye ukuba ufuna nje ukugcina uluhlu olucwangcisiweyo lweendawo zefayile kwidiski, usebenzisa iindlela.

NgoFikelelo unako:

• Yila kwaye ulungise iitafile ngayo nayiphi na imfuno (i-inventory, abathengi, imbali ye-invoyisi, njl.).
• Qhoboshela ifayile enye okanye ngaphezulu kwirekhodi nganye ngokulula.
• Ukudibanisa iifayile usebenzisa iindlela ukugcina idatabase ilula kwaye ikhawuleza.
• Jonga, ulungise kwaye ulawule amaxwebhu okanye imifanekiso evela kwiifom kunye nemibuzo.

Imihlaba yokuncamathela kunye neendlela: Yeyiphi inketho endimele ndiyikhethe?

Ukufikelela kukuvumela ukuba ugcine iifayile usebenzisa uhlobo lwazo lwendawo Iziqhoboshelo, okanye gcina ngqo i indlela yefayile (indawo yayo kwindlela), enokwenziwa kusetyenziswa umhlaba wokubhaliweyo. Loluphi ukhetho olulungele wena?

Ukuba ufuna gcina ifayile kwisiseko sedatha (umzekelo, i-invoyisi PDF okanye umfanekiso), umhlaba wokuncamathela ugqibelele: igcina yonke into esembindini kwaye ikuvumela ukuba ufikelele iifayile ngaphandle kokuxhomekeka kulawulo loqobo. Ukongeza, ukufikelela inokucinezela iifayile kuxhomekeke kwifomathi yabo, inceda ukugcina indawo.

Ngakolunye uhlangothi, ukuba awufuni ukuba i-database ikhule kakhulu, okanye ukhetha ukunqanda okuphindwe kabini ngokugcina kuphela indawo yefayile, yongeza ngokulula indawo yokubhaliweyo kwaye ugcine umendo apho (umzekelo, 'C:\invoyisi\2024\invoice124.pdf'). Ngale ndlela, unokuvula uxwebhu kwifolda yalo yoqobo, kwaye idatabase ihlala incinci kakhulu.

Yeyiphi eyona ntsilelo ingundoqo yenkqubo nganye? Ukugcina izincamatheliso ezininzi kakhulu kunokwenza isiseko sedatha sibe sikhulu kakhulu kwaye sicothe, ngelixa iindlela zokudibanisa zifuna ukuba iifayile zingasuswa kwiifolda zazo, kungenjalo ikhonkco liya kulahleka. Ke ngoko, kuxhomekeke kwiimfuno zakho, unokudibanisa zombini iindlela okanye ukhethe eyona ikufaneleyo.

Izinto ezilungileyo zokusebenzisa iindawo ezincamatheleyo kuFikelelo

Uhlobo lwentsimi Iziqhoboshelo Igqithise iindlela zakudala ezifana ne-OLE (i-Object Linking and Embedding), ezazingasebenzi kakuhle kwaye zathatha indawo eninzi. Iinzuzo zayo eziphambili ziquka:

• Kulula ukongeza iifayile ngokwemveli, ngaphandle kokwenza inkqubo nantoni na.
• Ukuhambelana neefomathi ezininzi: imifanekiso (JPG, PNG, GIF, BMP), Amaxwebhu e-Ofisi, iifayile ze-zip, phakathi kwabanye.
• Akukho software eyongezelelweyo efunekayo ukujonga uninzi lwezincamatheliso, ngokungafaniyo ne-OLE endala.
• Ulawulo olulula: Ngokucofa kabini unokongeza, ucime okanye uhlele iifayile eziqhagamshelwe kwirekhodi nganye.

Unako kwakhona ncamathela iifayile ezininzi kwirekhodi enye (umzekelo, amaxwebhu ahlukeneyo asuka kumxhasi omnye), walawule kwiifomu, kwaye uwagcine okanye uwathumele ngaphandle njengoko kufuneka. Ubukhulu besayizi kwi-attachment nganye yi-256 MB, kwaye i-database iyonke inokufikelela kwi-2 GB.

Uyenza njani isiseko sedatha ekuFikelelekeni ngeendlela okanye iifayile eziqhotyoshelweyo?

Inkqubo yokudala ilula kakhulu kwaye inokulungiswa nokuba ufuna ukugcina iifayile ngaphakathi kwesiseko sedatha okanye ufuna nje ukugcina iindlela. Nanga amanyathelo ngokubanzi:

1. Yenza i-database entsha okanye uvule esele ikho

Vula Microsoft Access kwaye ukhethe "Idatha yeDesktop eNtsha." Yinike igama elinentsingiselo kwaye ugcine ifayile ye.accdb kwisiqulathi seefayili ozikhethayo. Ukuba sele unayo i-database eyenziwe, yivule ngokulula kwimenyu ethi "Ifayile> Vula".

2. Yenza okanye ulungise itafile

Unokwenza oku kwithebhu ethi "Yenza > Itheyibhile" okanye ukhethe esele ikhona. Iitheyibhile ziya kuba ngundoqo wedatha yakho: umzekelo, "Abathengi," "Iinvoyisi," okanye "Amaxwebhu."

3. Yongeza indawo yokuncamathela

Ukugcina iifayile ngokuthe ngqo, udinga indawo ekhethekileyo. Yenza ngolu hlobo:

• Vula itafile kwiJongo yeDatha kwaye ufumane indawo ethi "Yongeza indawo entsha". Yinike igama (umzekelo, "I-Attachment") kwaye ukhethe "I-Attachment" njengohlobo lwedatha.
• Ukuba usebenza kuMbono woYilo, yongeza indawo entsha, yinike igama, kwaye ukhethe i-Attachment njengohlobo.

Gcina utshintsho. Khumbula ukuba Nje ukuba uhlobo lwesiqhoboshelo lunikezelwe, awukwazi ukusitshintsha kamva. (nangona ungayicima indawo ukuba wenze impazamo).

Ukugcina iindlela zefayile

Yongeza ngokulula indawo ethi "Umbhalo oMfutshane" okanye "Umbhalo omde" kwaye ugcine idilesi epheleleyo yefayile okanye ifolda apho. Ngale ndlela, unokuvula amaxwebhu kwindawo yawo yokwenyani ngokucofa kabini okanye usebenzisa iqhosha lesiko.

Uncamathela njani iifayile kwiirekhodi zokuFikelela

Nje ukuba ulungiselele indawo yokuncamathela, ukongeza amaxwebhu kulula kakhulu:

1. Vula itafile kwimboniselo yeDatasheet.
2. Cofa kabini iseli ehambelana nomhlaba wokuncamathela.
3. Ifestile ebizwa ngokuba yi "Attachments" iya kuvula. Cofa "Yongeza."
4. Fumana ifayile kwikhompyuter yakho (ungakhetha iifayile ezininzi ngaxeshanye) kwaye ucofe "Vula."
5. Ekugqibeleni, cofa "Yamkela" ukongeza amaxwebhu kwirejista.

Ungaphinda le nkqubo ukongeza iifayile kwirekhodi enye, uzicime, okanye uzihlele kwifestile enye. Xa iifayile zincanyathiselwe, Ufikelelo luya kubonisa i icon encinci ye-paperclip kwiseli ukubonisa ukuba kukho amaxwebhu anxulumeneyo.

Lawula kwaye ujonge izinamathiselo kwiifom

Enye yezinto eziluncedo zoFikelelo kukuba unokwandisa ukusebenza kweetafile zakho iifom zesiko. Oku kwenza ulawulo lwefayile lube lula kakhulu.

Ukubonisa kunye nokuphatha izincamatheliso kwifom:

• Hlela ifom kwi-"Design View".
• Ukusuka kwithebhu ethi "Yilwayo", sebenzisa "Yongeza iindawo ezikhoyo" kwaye utsale indawo yokuncamathela kwifom.
• Beka ulawulo apho ukhetha kwaye ulungelelanise iimpawu ukuba ziyimfuneko.

Ukusuka kwifom, unako ukuvula, ukongeza, okanye ukucima izinamathiselo ngendlela ebonakalayo kunye nenembile. Ukuba irekhodi iqulethe imifanekiso emininzi okanye amaxwebhu, unokuhamba ngokulula phakathi kwabo usebenzisa iintolo kulawulo.

Gcina, hlela, kwaye ucime izinamathiselo

Ukufikelela kukuvumela ukuba uguqule ngokulula okanye ukhuphe iifayile ezigciniweyo:

• Gcina iifayile kwenye indawo: Vula ifestile yokuncamathisela, khetha ifayile, kwaye ukhethe "Gcina Njenge." Khetha isiqulathi seefayili apho uzakukhuphela khona.
• Hlela iifayile: Cofa kabini kuxwebhu oluncanyathiselweyo kwaye, ukuba unenkqubo ehambelanayo efakiweyo (igama, Excel, njalo njalo), unokuyihlela ngesiqhelo. Xa ugcina utshintsho lwakho kwaye ubuyela kuFikelelo, uya kubuzwa ukuba uyafuna na ukugcina inguqulelo elungisiweyo.
• Cima iziqhoboshelo: Kwifestile yokuncamathisela, khetha uxwebhu kwaye ucofe "Susa."

Khumbula ukuba Access igcina okwexeshana iifayile ezihleliweyo kwisiqulathi seefayili sexeshana Windows de ugqibe ekubeni uzigcine kuvimba weenkcukacha.

Izinto ezilungileyo zokulawula izinamathiselo ezivela kwiifom kunye neengxelo

Ngokudibanisa imimandla yokuncamathela kwiifom kunye neengxelo, unako:

• Jonga imifanekiso ngokuthe ngqo ngelixa ubrawuza iirekhodi.
• Ukufikelela kwaye ulawule amaxwebhu ukusuka kwiqela elinye, ngaphandle kokukhangela kubo ngesandla.
• Yongeza okanye ususe iifayile ngokulula ngaphandle kokuvula itafile ephambili.

Nceda uqaphele oko Iingxelo zivumela kuphela ukujonga okanye ukugcina izinamathiselo, kodwa ungazihleleli, njengoko zifundwa kuphela.

Iifomati zefayile ezixhaswayo kunye nemida

Ukufikelela kunokusingatha iifomati eziqhelekileyo ezisetyenziswa kwimisebenzi yemihla ngemihla:

• Imifanekiso: BMP, JPEG (JPG, JPE), GIF, PNG, TIFF, ICON, wmf, EMF, phakathi kwabanye.
• Amaphepha: ILizwi, i-Excel, i-PowerPoint, iifayile ze-ZIP, iifayile ezibhaliweyo (.txt), i-XML.

Nangona kunjalo, kukho iifomati ezithile Iibhloko zokungena ngezizathu zokhuseleko (umzekelo, eziphunyeziweyo, izikripti, okanye Fikelela iifayile kwiinguqulelo ezindala). Phambi kokuzama ukuncamathisela iifayile, jonga kwakhona uluhlu olusemthethweni lweefomathi ezivaliweyo kuxwebhu loncedo lokuFikelela ukunqanda iimpazamo ezingeyomfuneko.

Ndizicinezela njani izincamatheliso kuFikelelo?

Ufikelelo lucinezela iziqhoboshelo ngokuzenzekelayo ngaphandle kokuba sele zicinezelwe ngendlela yazo yendalo. Umzekelo, Imifanekiso yeJPEG, iifayile ze-GIF okanye ze-zip aziyi kuphinda zinyanzeliswe, ngelixa i-BMP, i-TIFF okanye amaxwebhu angaxinzelelwanga aya kuba, enceda ukwandisa indawo ehlala kwisiseko sedatha.

Le nkqubo yoxinzelelo ikuvumela ukuba uphathe imiqulu emikhulu yamaxwebhu ngaphandle kokukhula okugqithisileyo kwedatha, nangona kucetyiswa ukuba ungadluli umda omkhulu we-2 GB.

Ukusebenza ngeendlela: ukudibanisa iifayile zangaphandle

Kwiimeko ezininzi, okona kusebenzayo ukudibanisa iifayile kwisiseko sedatha kunokuba unamathele kwindawo apho zigcinwe khona. Ukwenza oku:

• Yenza indawo yokubhaliweyo apho uya kugcina umendo opheleleyo (umzekelo, D:\Documents\Invoice_A123.pdf).
• Yongeza amakhonkco ngesandla okanye usebenzisa ifom oko kubandakanya indawo yendlela.
• Kwiifom, unokongeza iqhosha nge-macro ukuvula ifayile usebenzisa umyalelo othi "Ikhonkco kwi-Hyperlink".

Eyona nto iluncedo kukuba i-database ayinyuki ngobukhulu, nangona uya kuphulukana nereferensi ukuba ifayile isusiwe okanye icinyiwe kwindawo yayo yoqobo. Le ndlela ikhethwa kubasebenzisi abalawula umthamo omkhulu wamaxwebhu kwaye abafuni ukugqithisela uFikelelo.

Inqaku elidibeneyo:

Ungazicombulula njani iingxaki zeOfisi xa uvula iifayile ezinkulu: Gqibezela kunye nesikhokelo esihlaziyiweyo

UIsake

Umbhali onomdla malunga nehlabathi le-bytes kunye netekhnoloji ngokubanzi. Ndiyakuthanda ukwabelana ngolwazi lwam ngokubhala, kwaye yile nto ndiza kuyenza kule bhlog, ndikubonise zonke izinto ezinomdla malunga nezixhobo, isoftware, ihardware, iindlela zetekhnoloji, kunye nokunye. Injongo yam kukukunceda uhambe kwihlabathi ledijithali ngendlela elula neyonwabisayo.