I-Excel 2003 Ifomu lokufaka idatha

01 ngo-08

Ukusebenzisa ifomu lokufaka idatha kwi-Excel

Ukusebenzisa i-Excel eyakhiwe efomini lokungena kwedatha kuyindlela elula futhi elula yokufaka idatha kwi- database ye- Excel.

Ukusebenzisa ifomu kukuvumela ukuba:

• qala ithebula elisha le-database noma ukwengeza amarekhodi amasha kulowo okhona
• pheqa kumarekhodi wedatha eyodwa ngesikhathi
• sesha amarekhodi aqukethe ulwazi oluthile
• hlela noma ususe amarekhodi ngabanye uma kunesidingo

Bheka isifundo esihlobene: I- Excel 2010/2007 Ifomu lokufaka idatha .

02 ngo-08

Ukwengeza Amagama Ezindaweni Ze-Database

Njengoba kushiwo ngaphambili, konke okudingeka sikwenze ukuze sisebenzise ifomu lokungena kwedatha ku-Excel ukuhlinzeka ngezihloko zekholomu noma emasimini okufanele zisetshenziswe ku-database yethu.

Indlela elula yokwengeza amagama ensimu efomini ukuwafakela kumaseli kushidi lakho lokusebenzela . Ungafaka amagama angama-32 asefomu efomu.

Faka izihloko ezilandelayo kumaseli A1 kuya ku-E1:

I-StudentID
Isibongo
Okokuqala
Ubudala
Uhlelo

03 ngo-08

Ukuvula ifomu lokufaka idatha

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

1. Chofoza ku-cell A2 ukuze wenze iseli esebenzayo .
2. Chofoza kuDatha> Ifom kumamenyu.
3. Ukuvula ifomu kuzokhipha kuqala ibhokisi lomlayezo kusuka ku-Excel equkethe inombolo yezinketho ezihlobene nokwengeza izihloko kwifomu.
4. Njengoba sesifakile kakade kumagama asensimu esifuna ukuwasebenzisa njengezihloko konke okumele sikwenze ukuchofoza Kulungile ebhokisini lomyalezo.
5. Ifomu eliqukethe wonke amagama ensimu kufanele avele esibukweni.

04 ngo-08

Ukwengeza Amarekhodi Emininingwane Ngefomu

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

Uma izihloko zedatha zengezwe efomini yokwengeza amarekhodi ku-database kungumlando wokuthayipha idatha ngokulandelana okulungile emasimini efomu.

Amarekhodi Esibonelo

Engeza amarekhodi alandelayo ku-database ngokufaka idatha efomini yefomu eceleni kwezihloko ezifanele. Chofoza inkinobho entsha ngemva kokufaka irekhodi lokuqala ukuze usule amasimu erekhodi lesibili.

1. I-StudentID : SA267-567
   Igama lokugcina : uJones
   Okokuqala : B.
   Ubudala : 21
   Uhlelo : Izilimi
   
   I-StudentID : SA267-211
   Igama lokugcina : u-Williams
   Okokuqala : J.
   Ubudala : 19
   Uhlelo : Isayensi

Ithiphu: Uma ufaka idatha efana kakhulu njengezinombolo ze-ID yomfundi (kuphela izinombolo ngemuva kwedashi ehlukile), sebenzisa ikhophi bese unamathisele ukusheshisa nokulula ukungena kwedatha.

05 ka-08

Ukwengeza Amarekhodi Emininingwane Ngefom (Con't)

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

Ukwengeza amarekhodi asele ku-database yokufundisa, sebenzisa ifomu ukungena kulo lonke ulwazi olutholakala esithombeni ngenhla kumaseli A4 kuya ku-E11.

06 ka-08

Ukusebenzisa ama-Data Data Data

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

Inkinga enkulu nge-database igcina ubuqotho bemininingwane njengoba ifayela likhula ngobukhulu. Lokhu kudinga:

• ukulungisa amaphutha wedatha noma ukuvuselela amarekhodi ngabanye
• ukususa amarekhodi angasebenzi noma aphindaphindiwe

Ifomu lokufaka idatha liqukethe amathuluzi amaningana ngakwesokudla kwesandla okwenza kube lula ukuthola nokulungisa noma ukususa amarekhodi avela ku-database.

Lawa mathuluzi:

• I- Find Pre and Find izinkinobho ezilandelayo - lezi zivumela ukuba uqhube phambili uye emuva ngokusebenzisa irekhodi eyodwa ngesikhathi esisodwa.
• Inkinobho yokususa - lokhu kusetshenziselwa ukususa amarekhodi kusuka ku-database.
• Inkinobho yokubuyisela - Le nkinobho ingasetshenziswa ukulungisa izinguquko kwirekhodi elihlelwe. Ngezinye izikhathi, senza izinguquko ezingalungile kumarekhodi noma ngisho nokuhlela irekhodi elingalungile ngokuphelele. Uma kunjalo, inkinobho yokubuyisela ingasetshenziswa ukuhlehlisa lezo zinguquko.
• Qaphela: inkinobho yokubuyisela isebenza kuphela uma irekhodi likhona efomini. Uma nje uthola elinye irekhodi noma uvale ifomu, inkinobho yokubuyisela ayisebenzi.
• Inkinobho Yokunquma ikuvumela ukuba useshe imininingwane yamarekhodi ngokusekelwe ezimweni ezithile, njengegama, ubudala, noma uhlelo. Isibonelo sokusebenzisa inkinobho yokunqunywa kufakwe kwisinyathelo esilandelayo sokufundisa.

07 ngo-08

Ukufuna Amarekhodi Ukusebenzisa Igama Elilodwa Lensimu

Inkinobho Yokunquma ikuvumela ukuthi useshe imininingwane yedatha kumarekhodi usebenzisa igama elilodwa noma ngaphezulu yamasimu - njengegama, ubudala, noma uhlelo.

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

1. Chofoza inkinobho yokunqunywa efomini.
2. Ukuchofoza inkinobho yokunquma kuhlanza zonke izinsimu zefomu kepha akususi noma iyiphi idatha kusuka ku-database.
3. Chofoza ku-Field field bese uthayipha Ubuciko njengoba sifuna ukusesha bonke abafundi ababhalisile ohlelweni lobuGcade ekolishi.
4. Chofoza inkinobho ethi Thola Okulandelayo . Irekhodi lika H. Thompson kufanele livele efomini njengoba ebhaliswe ohlelweni lobuGcisa.
5. Chofoza inkinobho ethi Thola Okulandelayo okwesibili nesikwesithathu futhi amarekhodi kaJ. Graham noWilliam Henderson kufanele avele omunye emva kokunye njengoba ebhalisiwe ohlelweni lobuGugu.

Isinyathelo esilandelayo sokufundisa sifaka isibonelo sokufuna amarekhodi afana nemigomo eminingi.

08 ngo-08

Ukufuna Amarekhodi Ukusebenzisa Amagama Ezindaweni Eziningi

Inkinobho Yokunquma ikuvumela ukuthi useshe imininingwane yedatha kumarekhodi usebenzisa igama elilodwa noma ngaphezulu yamasimu - njengegama, ubudala, noma uhlelo.

Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.

Kulesi sibonelo, sizosesha bonke abafundi abaneminyaka engu-18 ubudala futhi ababhalise ohlelweni lwezobuciko ekolishi. Yilabo kuphela amarekhodi ahambisana nalokho kokubili okufanele aboniswe efomu.

1. Chofoza inkinobho yokunqunywa efomini.
2. Chofoza kwenkambu yobudala bese uthayipha u- 18 .
3. Chofoza kwi- Program field bese uthayipha Ubuciko .
4. Chofoza inkinobho ethi Thola Okulandelayo . Irekhodi lika H. Thompson kufanele livele efomini kusukela eneminyaka engu-18 ubudala futhi ibhalisiwe ohlelweni lobuGcisa.
5. Chofoza inkinobho ethi Thola Okulandelayo okwesibili futhi irekhodi likaJ. Graham kumele livele ngoba naye uneminyaka engu-18 ubudala futhi ubhalisile ohlelweni lobuChwepheshe.
6. Chofoza inkinobho ethi Thola Okulandelayo okwesikhashana futhi irekhodi likaJ. Graham kufanele lisabonakala ngoba awekho amanye amarekhodi afana nawo kokubili.

Irekhodi likaWilliam Henderson akumele liboniswe kulolu hlobo ngoba, nakuba ebhalisiwe ohlelweni lobuGcisa, uneminyaka engama-18 ubudala ngakho akafani nemibandela yokucinga.