I-Excel 2003 Yokufundisa I-Database

01 ka 09

Uhlolojikelele lweDatha ye-Excel 2003

Ngezinye izikhathi, sidinga ukugcina ithrekhi yolwazi kanye nendawo enhle kulokhu kufayela le-Excel database. Kungakhathaliseki ukuthi uluhlu lomuntu siqu lwezinombolo zocingo, uhlu loxhumana nabo lwamalungu enhlangano noma ithimba, noma iqoqo lezinhlamvu zemali, amakhadi noma izincwadi, ifayela le-Excel yedatha yenza kube lula ukungena, ukugcina nokuthola ulwazi oluqondile.

I-Excel ikhiphe amathuluzi ukukusiza ukuthi ulandele idatha futhi uthole ulwazi oluqondile uma ulufuna. Futhi, namakhulu ayo amakholomu nezinkulungwane zemigqa, ispredishithi se-Excel lingabamba idatha enkulu kakhulu.

Futhi bheka isifundo esilandelayo: Excel 2007/2010/2013 Isinyathelo ngesinyathelo Database Database .

02 ka 09

Amatafula weDatha

Ifomethi eyisisekelo yokugcina idatha ku-database ye-Excel yithebula. Etafuleni, idatha ingeniswe emigqeni. Umugqa ngamunye uyaziwa njengerekhodi .

Uma sekusethwe itafula, amathuluzi wedatha we-Excel angasetshenziswa ukucinga, ukuhlunga, nokuhlunga amarekhodi ku-database ukuthola ulwazi oluthile.

Nakuba kunezindlela eziningi ongasebenzisa lawa mathuluzi wedatha ku-Excel, indlela elula yokwenza kanjalo ukudala ukuthi yini eyaziwa njengoluhlu oluvela kudatha etafuleni.

Ukuze ulandele lokhu kufundisa:

• faka idatha njengoba iboniswa esithombeni ngenhla.

Ithiphu - Ukufaka ngokushesha i-ID yomfundi:

1. Thayipha i-ID ezimbili zokuqala - ST348-245 no-ST348-246 kumaseli A5 no-A6 ngokulandelana.
2. Qinisekisa ama-ID amabili ukuze ukhethe.
3. Chofoza kwiphatha lokugcwalisa bese ulihudula phansi esitokisini A13.
4. Zonke ezinye ze-ID yomfundi kufanele zingeniswe kumaseli A6 kuya ku-A13 ngendlela efanele.

03 ka 09

Ukufaka idatha ngokuchanekile

Uma ufaka idatha, kubalulekile ukuqinisekisa ukuthi ifakiwe kahle. Okunye ngaphandle komugqa wesi-2 phakathi kwesihloko sespredishithi nezinhlobonhlobo zekholomu, ungashiyi noma yimiphi imigqa engenalutho uma ufaka idatha yakho. Futhi, qiniseka ukuthi awushiyi noma yimaphi amangqamuzana angenalutho.

Amaphutha wedatha, abangelwa ukungena kwedatha okungalungile, angumthombo wezinkinga eziningi ezihlobene nokuphathwa kwedatha. Uma idatha ingeniswe kahle ekuqaleni, uhlelo luvame ukukubuyisela imiphumela oyifunayo.

04 ka 09

Imigqa yiRekhodi

Njengoba kukhonjisiwe, imigqa yedatha, ku-database iyaziwa njengamarekhodi. Uma ufaka amarekhodi ugcine lezi ziqondiso engqondweni:

• Shiya imigqa engenalutho etafuleni edalwe, ngisho naphakathi kwezihloko nomugqa wokuqala wedatha.
• Idokhumenti ingaqukatha idatha mayelana nento eyodwa kuphela.
• Idokhumenti kumele iqukethe NOMA yonke idatha ku-database mayelana nento. Ayikwazi ukwaziswa ngento emgqeni ongaphezu kweyodwa.
  

05 ka 09

Amakholomu ayizinsimu

Ngenkathi imigqa egciniwe ye-Excel ibhekiswa njengamarekhodi, amakholomu ayaziwa njengamasimu. Ikholomu ngayinye idinga isihloko ukuze sibone idatha equkethe. Lezi zihloko zibizwa ngokuthi ngamasimu.

• Amagama asezindaweni asetshenziselwa ukuqinisekisa ukuthi idatha yerekhodi ngalinye ingenwe ngokulandelana okufanayo.
• Qinisekisa ukuthi yonke idatha ekholomu ingenwe isebenzisa ifomethi efanayo. Uma uqala ukungena izinombolo njengezidijithi (ezinjenge-10 noma 20) zigcinwe. Ungaguquki ingxenye yendlela futhi uqale ukungena izinombolo njengamazwi (afana neshumi noma amabili). Yiba njalo.
• Shiya amakholomu angenalutho etafuleni.

06 ka 09

Ukudala Uhlu

Uma idatha ifakiwe etafuleni, ingaguqulelwa ohlwini . Ukwenza kanjalo:

1. Gqamisa amaseli A3 kuya ku-E13 kushidi lokusebenzela.
2. Chofoza kuDatha> Uhlu> Yakha uhlu kusuka kwimenyu ukuvula ibhokisi lengxoxo Yokwakha Yohlu .
3. Ngenkathi ibhokisi lengxoxo livuliwe, amaseli A3 kuya ku-E13 ekhasini lokusebenzela kufanele azungezwe izintuthwane ezihambayo.
4. Uma izintuthwane ezihambayo zungeze uhla olufanele lwamaseli, chofoza u-Ok ebhokisini lengxoxo Yakha Uhlu .
5. Uma izintuthwane ezihambayo zingangqingili uhla olufanele lwamaseli, gcizelela ibanga elifanele ekhasini lokusebenzela bese uchofoza u-Ok ebhokisini lengxoxo Yakha Uhlu .
6. Ithebula kufanele lizungezwe umngcele omnyama futhi liyehla phansi imicibisholo eyongezwe eceleni kwegama ngalinye lesigcawu.

07 ka 09

Ukusebenzisa amathuluzi we-Database

Uma usudale i-database, ungasebenzisa amathuluzi atholakala ngaphansi kwemicibisholo ehlayo eceleni kwegama ngalinye leskambu ukuhlunga noma ukuhlunga idatha yakho.

Ukuhlela idatha

1. Chofoza kumcibisholo wokudonsa eduze kwegama legama legama lokugcina .
2. Chofoza ku- Uhlu Oluhlehlisayo Oluhlehlisayo ukuze uhlele uhlu lwe-alfabhethi kusuka ku-A kuya ku-Z.
3. Uma ihlelwe, uGraham J. kufanele abe irekhodi lokuqala etafuleni futhi uWilson R. kufanele abe ngowokugcina.

Ukuhlunga idatha

1. Chofoza kumcibisholo wokudonsa phansi eduze kwegama lensimu yohlelo .
2. Chofoza kwiBhizinisi ukukhetha ukuhlunga noma yikuphi abafundi, hhayi ohlelweni lwebhizinisi.
3. Chofoza OK.
4. Abafundi ababili kuphela - uG. Thompson noFm Smith kumele babonakale ngoba yibo kuphela ababhalisile ohlelweni lwebhizinisi.
5. Ukuze ubonise wonke amarekhodi, chofoza umcibisholo wokudonsela phansi eduze kwegama lomkhakha weNhlelo .
6. Chofoza kukho konke okukhethwa kukho.
   

08 ka 09

Ukwandisa i-Database

Ukwengeza amarekhodi engeziwe ku-database yakho:

• Umugqa ongenalutho oqukethe i-asterisk (amangqamuzana A14 kuya ku-E14) ungeziwe ngaphansi kwedatha uma kudalwa.
• Idatha eyengeziwe ingezwa kwi-database usebenzisa lo mgca ongacacile.
• Engeza idatha elandelayo:
  
  Cell - Idatha
  I-A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Isayensi

09 ka 09

Ukuqedela ukufometha kwedatha

Qaphela : Lesi sinyathelo sithinta ukusebenzisa izithonjana eziseBharthri yamathuluzi okufometha , evame ukutholakala phezulu kwesikrini se-Excel 2003. Uma ingekho, funda indlela yokuthola amabhasi we-Excel ukukusiza ukuthi uyithole.

1. Gqamisa amaseli A1 kuya ku-E1 kushidi lokusebenzela.
2. Chofoza kusithonjana se- Merge and Center ku- Barrefri yokufometha ukuze ubeke isihloko.
3. Ngamaseli A1 kuya ku-E1 okwamanje ekhethiwe, chofoza uphawu lwe- Fill Color ku- Barrend Toolbar (kubonakala sengathi upende uyakwazi) ukuvula uhlu lokudonsela phansi kombala.
4. Khetha uhlaza olwandle kusuka kuhlu ukuze ushintshe umbala wangemuva wamaseli A1 - E1 obumnyama.
5. Chofoza ku-Isithonjana soMbala wefonti kuBha yamathuluzi okufometha (kuyincwadi enkulu "A") ukuvula uhlu lwezintambo ezenziwe phansi.
6. Khetha Okumhlophe ohlwini ukuze ushintshe umbala wombhalo emafenjini A1 - E1 abe mhlophe.
7. Gqamisa amaseli A2 - E2 kushidi lokusebenzela.
8. Chofoza ku-Isithonjana sombala wokugcwalisa ku- Barrefri yokufometha ukuze uvule uhlu lokudonsela phansi kombala ongemuva.
9. Khetha ukukhanya okukhanyayo kusuka ohlwini ukuze ushintshe umbala wangemuva wamaseli A2 - E2 kuya obala ohlaza.
10. Gqamisa amaseli A3 - E14 ekhasini lokusebenzela.
11. Khetha Ifomethi> I-AutoFormat kusuka kumamenyu ukuvula ibhokisi lokuxoxa le- AutoFormat .
12. Khetha Uhlu 2 ukusuka kuhlu lokukhethwa kukho ukufometha amaseli A3 - E14.
13. Gqamisa amaseli A3 - E14 ekhasini lokusebenzela.
14. Chofoza ku-optionicon ye-Center kwi-Barbar yokufometha ukuze uhlele ukuqondanisa umbhalo kumaseli A3 kuya ku-E14.
15. Kuleli phuzu, uma ulandele zonke izinyathelo zalesi sifundo ngendlela efanele, ispredishithi sakho kufanele sifane nespredishithi efanekisiwe kuNyathelo 1 yalesi sifundo.