Yenye yeenkqubo ezingaziwayo kwi-ofisi ye-Microsoft 365, nangona iqukiwe ukususela kwinguqulo ye-1992, sisixhobo esiluncedo kakhulu. Kule post sichaza Yintoni iMicrosoft Access kwaye yenzelwe ntoni?.
Inguqulelo yamva nje ye Ukufikelela kwiMicrosoft, yile nto siza kuthetha ngayo apha, yakhululwa ngo-Oktobha 5, 2021 ukuba isetyenziswe Windows 10 kunye ne-Windows 11. Oku kuthatha phakathi kwe-44 MB kunye ne-60 MB kwi-hard drive, kuxhomekeke kwiinketho zokufakela ezikhethiweyo.
Yintoni iMicrosoft Access?
UMicrosoft nguye Inkqubo yolawulo lwedatha iqukwe kwiMicrosoft Office suite yezicelo (ngoku eyiMicrosoft 365). Sisixhobo esijolise ekuncedeni abasebenzisi ukudala nokulawula i-database ngenjongo yokugcina, ukulungelelanisa kunye nokuhlalutya ulwazi.
Isizathu sokuba esi sicelo sisetyenziswe kancinci kungenxa yokungazi ukuba luncedo kwaso kokwenyani. Abasebenzisi abaninzi bakholelwa ngempazamo ukuba nantoni na eyenziwe ngoFikelelo inokwenziwa ngoFikelelo. I-Excel.
Nangona kuyinyani ukuba zombini iinkqubo zinamanqaku afanayo, i-Excel ifaneleke ngakumbi ukuphatha idatha yamanani kunye nokwenza izibalo kuloo datha. Ukufikelela, ngokwenxalenye yayo, yongeza iqondo elikhulu lobungcali kwaye ibandakanya imisebenzi ethile yokulawula iindidi ezahlukeneyo zedatha. Ukongeza, ikuvumela ukuba uthintele idatha abasebenzisi abangena kuyo kwintsimi nganye, kunye nokudibanisa idatha ehambelanayo kwiitafile ezininzi.
Iidatabase ezigcinwe ngoFikelelo lweMicrosoft zibonisa i ulwandiso lwefayile ".accdb". Nangona oku kuyeyona nto ixhaphakileyo kwaye ikwayeyona yangoku, kusenokwenzeka ukufumana ezinye izandiso (".mdbe" o ".mde"), ezihambelana neenguqulelo ngaphambi kuka-2007. Ngamanye amaxesha, ukuvula olu hlobo lwezandiso, umsebenzisi kufuneka aqale asebenzise isixhobo sokuguqula ukuguqulela kwi «.accdb».
Izinto esinokuzenza ngoFikelelo
Unokusebenzisa njani Ufikelelo ukulawula isiseko sedatha? Ngezantsi, sichaza eminye yemisebenzi eqhelekileyo esinokuyenza ngesi sixhobo.
Yenza isiseko sedatha
Kwisikrini sasekhaya sokuFikelela, cofa "Ifayile" kwaye kwikholamu yokukhetha ngasekhohlo, khetha "Entsha." Phakathi kweenketho ezahlukeneyo eziboniswe kwisikrini, kufuneka sikhethe enye enesihloko esithi "IDatha yeDesktop engenanto".
Le database esanda kwakhiwa inokunikwa igama njengenyathelo lokuqala lokufikelela kwitemplate entsha kwaye uqale ukuyisebenzisa.
Yenza itafile
Ukongeza itafile yedatha kwisiseko sedatha esiyidalileyo, kuyimfuneko ukuya kwiribhoni yesixhobo kwaye ucofe kwithebhu "Itheyibhile". Iinkalo ezininzi njengoko sifuna zinokongezwa kule theyibhile intsha. Ukwenza oku kufuneka ucofe ekunene kwaye ukhethe ukhetho "Cofa ukongeza".
Icandelo lebhokisi ye-combo lisetyenziselwa ukudwelisa iindidi ezahlukeneyo zedatha ezinokwabelwa kumhlaba (kwi-Fikelelo kunyanzelekile ukuba unike udidi lwedatha kumhlaba ngamnye).
Yongeza idatha kwitafile
Kukho iindlela ezininzi zokongeza idatha kwitafile yokuFikelela: usebenzisa ifom, ukuyingenisa kwifayile yangaphandle, usebenzisa i-SQL, okanye ukufaka idatha ngokuthe ngqo (oko kukuthi, ngesandla). Eyona ndlela iqhelekileyo yi ngenisa ngeefayile ".csv"Nantsi indlela ekwenziwa ngayo:
- Kwiribhoni yesixhobo, cofa apha "Idatha yangaphandle".
- Emva koko sicofa "Ifayile yombhalo."
- Okulandelayo sikhetha ifayile yemvelaphi kunye netafile yendawo.
- Ngaphambi kokuqhubeka nokungeniswa, sinokuphonononga zonke iinkcukacha zefayile (ukusetyenziswa kwamaxesha okanye iikoma njenge-delimiters, kufuneka zishiye iindawo ezithile.
- Ekugqibeleni, sicinezele iqhosha "Gqiba" ukuqhuba ungeniso.
Ukusuka apha, zininzi iintshukumo esinokuzenza kwisicelo ngeetafile ezahlukeneyo esizazisileyo. Ngokomzekelo, kunokwenzeka yenza ubudlelwane phakathi kweetafile ukubuza idata kwiitafile ezahlukeneyo. Unokwenza kwakhona i itafile yokujonga, equlethe idatha echazwe yenye itafile, okanye udale imibuzo enzima kwiitafile ezininzi ezineentlobo ezahlukeneyo zedatha.
Ezinye izenzo ezinokwenzeka zi yenza i-backups, yenza i-database ephunyeziweyo (abasebenzisi bangaphandle abangenako ukuyiguqula) yenza ii-macros ukwenza imisebenzi enzima okanye thumela ngaphandle idatha ukugqwesa, phakathi kwezinye izinto ezininzi ezinokwenzeka.
Ukwenza zonke ezi ntshukumo, uFikelelo lweMicrosoft lubandakanya isixhobo esiluncedo umncedisi leyo ngokungathandabuzekiyo iluncedo olukhulu kwabo basebenzisa esi sicelo okokuqala.
Isiphelo
UFikelelo lweMicrosoft lukhetho olucetyiswayo kumashishini amancinci naphakathi ayifunayo isixhobo solawulo lwedatha esilula nesilula ukusisebenzisa. Ilungele imisebenzi efana ne-gulawulo lwempahla okanye ukubeka iliso kweprojekthi. Kuzo zonke ezi meko, kuyafaneleka ukufunda indlela yokuyisebenzisa.
Umhleli okhethekileyo kwitekhnoloji nakwimiba ye-intanethi eneminyaka engaphezu kweshumi yamava kumajelo osasazo edijithali. Ndisebenze njengomhleli kunye nomdali womxholo we-e-commerce, unxibelelwano, ukuthengisa kwi-intanethi kunye neenkampani zentengiso. Ndibhale kwakhona kwiiwebhusayithi zezoqoqosho, ezemali kunye namanye amacandelo. Umsebenzi wam ukwangumnqweno wam. Ngoku, ngamanqaku am kwi Tecnobits, Ndizama ukuhlola zonke iindaba kunye namathuba amatsha ukuba ihlabathi lobuchwepheshe lisinika yonke imihla ukuphucula ubomi bethu.