I-Microsoft Access inezingxenye ezintathu ezinkulu: amatafula, imibuzo kanye namafomu
Noma yimuphi inkampani ephazamiseke yimininingwane eminingi edinga ukulandelwa noma ngesistimu esebenzisa ukufaka iphepha, imibhalo yombhalo noma ispredishithi ukugcina ithrekhi yolwazi olubucayi kungaluthola ekwenzeni ushintsho ohlelweni lokuphathwa kwedatha. Uhlelo lwe-database olufana ne-Microsoft Access 2010 lungaba yilokho inkampani idinga khona.
Iyini Idatha?
Ngezinga eliyisisekelo kunazo zonke, i-database iyinhlangano yokuqoqwa kwedatha ehleliwe. Uhlelo lwezokuphathwa kwedatha (i-DBMS) njenge-Microsoft Access inikeza ngamathuluzi esofthiwe okudingayo ukuhlela leyo datha ngendlela eguquguqukayo. Ihlanganisa izindawo zokwengeza, ukuguqula nokususa idatha kusuka ku-database, ubuze imibuzo mayelana nedatha egcinwe ku-database bese uveza imibiko efingqa okuqukethwe okukhethiwe.
I-Microsoft Access 2010 Izingxenye
I-Microsoft Access 2010 inikeza abasebenzisi isixazululo esilula nesifanelekayo se-DBMS. Abasebenzisi abasebenzisa imikhiqizo ye-Microsoft bayakwazisa ukubuka okujwayelekile kwe-Windows nokuzizwa nokuhlanganiswa okuqinile nezinye imikhiqizo yomndeni wakwa-Microsoft Office.
Izingxenye ezintathu eziyinhloko zoFinyelelo lapho abasebenzisi abaningi basebenzi behlangana nabo kukhona amatafula, imibuzo, namafomu. Uma uqala nje ngo-Ukufinyelela futhi ungenalo database yokufinyelela ku-sicela, funda ngokudala i-Database Access ka-2010 kusuka ku-Scratch.
Amathebula Ayisakhiwo Sezakhiwo
Amathebula yizona zakhiwo ezibalulekile zedatha yolwazi. Uma ujwayele amaspredishithi, uzothola amatafula e-database afanayo. Ithebula le-database elijwayelekile lingase liqukethe ulwazi lomsebenzi, kufaka phakathi izici ezinjengegama, usuku lokuzalwa nesihloko. Kungase ihlelwe kanje:
- I-ID yomsebenzi
- Isibongo
- Igama
- Isihloko
- Ukubonga
- Usuku lokuzalwa
Hlola ukwakhiwa kwetafula futhi uzothola ukuthi ikholomu ngayinye yetafula ihambelana nesici esithile somsebenzi-noma umphumela wemigomo yedatha. Umugqa ngamunye uhambelana nesisebenzi esisodwa futhi uqukethe ulwazi lwakhe. Yilokho okukhona kulokho. Uma kusiza, cabanga ngetafula ngalinye njengehlu lwesipredishithi lokwaziswa.
Imibuzo Ukuthola Ulwazi
Idatha egciniwe kuphela egcina ulwazi ngeke ibe usizo; udinga izindlela zokuthola ulwazi kanye. Uma ufuna ukukhumbula imininingwane egcinwe etafuleni, i-Microsoft Access ikuvumela ukuvula ithebula bese upheqa kumarekhodi akhona ngaphakathi kwalo. Noma kunjalo, amandla angempela e-database asemandleni ayo ukuphendula imibuzo eyinkimbinkimbi. Imibuzo yokufinyelela ihlinzeka ikhono lokuhlanganisa idatha kusuka kumatafula amaningi nokubeka izimo ezithile idatha ebuyisiwe.
Cabanga ukuthi inhlangano yakho idinga indlela elula yokwakha uhlu lwazo imikhiqizo okwamanje edayisa ngaphezu kwentengo yabo ejwayelekile. Uma uvele uthola ithebula lwazi lomkhiqizo, ukufeza lo msebenzi kungadinga inani elikhulu lokuhlunga idatha bese wenza izibalo ngesandla. Noma kunjalo, amandla ombuzo ikuvumela ukuba ucele ukuthi Ukufinyelela kubuyele kuphela lawo marekhodi ahlangabezana nesimo esingenhla sesilinganiso semali. Ukwengeza, ungafundisa i-database ukuthi ubhale uhlu lwamanani kanye neyunithi yento.
Ukuze uthole ulwazi oluningi ngamandla wemininingwane yedatha ku-Ukufinyelela, funda Ukudala Umbuzo Olula ku-Microsoft Access 2010.
Amafomu Faka Ulwazi
Kuze kube manje, ufunde mayelana nemibono ngemuva kokuhlelwa kolwazi ku-database futhi uthola ulwazi oluvela ku-database. Usadinga izindlela zokubeka ulwazi ematafuleni kuqala. I-Microsoft Access inikeza izindlela ezimbili eziyinhloko zokufeza lo mgomo. Indlela yokuqala ukuletha ithebula efasiteleni ngokuchofoza kabili kuso. Bese, engeza ulwazi phansi kwetafula, njengoba nje ungangezela ulwazi kuspredishithi.
Ukufinyelela nakho kunikeza isikhombimsebenzisi esibonakalayo somsebenzisi. I-interface ivumela abasebenzisi ukungenisa ulwazi kwifomu elidwebayo futhi babe nolwazi oludlulele ku-database. Le ndlela ayesabisa kakhulu umsebenzisi we- data entry kodwa idinga umsebenzi omncane engxenyeni yomlawuli wedatha . Ukuze uthole olunye ulwazi, funda Ukudala Amafomu Ekufinyeleleni kuka-2010
I-Microsoft Access Reports
Imibiko inikeza ikhono lokukhiqiza izifinyezo ezihlelwe kahle zedatha equkethwe kuthebula elilodwa noma ngaphezulu nemibuzo. Ngokusebenzisa izinkomba nezinqamuleli zokunciphisa, abasebenzisi be-database abanolwazi bangakha imibiko ngendaba yamaminithi.
Ake sithi ufuna ukukhiqiza ikhathalogi ukwabelana ngolwazi lomkhiqizo namakhasimende anamanje nalabo abazoba khona. Lolu hlobo lwolwazi lungasuswa kusukela ku-database ngokusebenzisa ukuhlakanipha kwemibono. Noma kunjalo, ulwazi lunikezwe ngendlela ye-tabular-hhayi ngqo impahla ekhangayo kakhulu yokuthengisa. Imibiko ivumela ukufakwa kwegrafu, ukufometha okukhangayo, nokuzikhethela. Ukuze uthole olunye ulwazi, bheka Ukudala Imibiko Ekufinyeleleni ngo-2010.