Ifomu le-Excel Data Entry

Imiyalo yesinyathelo ngesinyathelo sokufaka idatha

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 njengoba kudingeka

Mayelana Ukwengeza Icon Form Form Icon ku-Quick Access Toolbar

Ifomu lokufaka idatha lingenye yamathuluzi wedatha akhiwe ngaphakathi kwe-Excel. Ukuze uyisebenzise konke okudingeka ukwenze ukunikeza izihloko zekholomu okufanele zisetshenziswe ku-database yakho, chofoza ku-Ifomu yeFomu, futhi i-Excel izokwenza konke okunye.

Ukuze wenze izinto zibe nzima nakakhulu, noma kunjalo, kusukela ku-Excel 2007, i-Microsoft ikhethe ukungayifaki isithonjana seFomu ebhobheni.

Isinyathelo sokuqala sokusebenzisa ifomu lokungena kwedatha ukufaka isithonjana seFomu kwi-Quick Access Toolbar ukuze sikwazi ukuyisebenzisa.

Lena ukusebenza kwesikhathi esisodwa. Uma usuleziwe, isithonjana seFomu sihlala sitholakala kwi-Quick Access Toolbar.

Ukuthola Inkinobho Yefomu Yokufaka Data

Ibha yamathuluzi okufinyelela okusheshayo isetshenziselwa ukugcina izinqamuleli ezibonakalayo ezisetshenziswa njalo ku-Excel. Kulapho futhi ongangeza khona izinqamuleli ezicikisweni ze-Excel ezingatholakali kwi-Ribbon.

Enye yalezi zici ifomu lokufaka idatha.

Ifomu yedatha kuyindlela elula futhi elula yokwengeza idatha etafuleni le-Excel database.

Ngesizathu esithile, uMicrosoft ukhethe ukungayifaki ifomu kwelinye lamathebhu ebhande eliqala nge-Excel 2007.

Ngezansi izinyathelo ezizokubonisa ukuthi ungeza kanjani isithonjana seFomu kwi-Quick Access Toolbar.

Engeza ifomu lesedatha kwi-Quick Access Toolbar

1. Chofoza phansi phansi komcibisholo ekupheleni kwe-Quick Access Toolbar ukuvula imenyu yehla.
2. Khetha Imiyalo Engaphezulu ohlwini ukuze uvule ngokwezifiso ibhokisi lengxoxo ye -Quick Access Toolbar.
3. Chofoza phansi phansi komcibisholo ekupheleni kweMilayezo yokukhetha kusuka emgqeni ukuze uvule imenyu yehla.
4. Khetha Yonke Imiyalo ohlwini ukuze ubone yonke imiyalo etholakalayo ku-Excel 2007 ngakwesokunxele.
5. Pheqa ngalolu hlu lwama-alfabhethi ukuthola umyalo weFom.
6. Chofoza inkinobho yokufaka phakathi kwamaphoyinti omyalo wokufaka umyalo weFomu kwi-Quick Access Toolbar.
7. Chofoza OK .

Inkinobho yefomu kufanele manje ingezwe kwi-Quick Access Toolbar.

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

Ukuvula ifomu lokufaka idatha

Ukuvula ifomu lokufaka idatha

1. Chofoza ku-cell A2 ukuze wenze iseli esebenzayo .
2. Chofoza isithonjana sefomu esongezwe ku-Quick Access Toolbar ekhasini 2.
3. Ukuchofoza isithonjana sefomu kuzokhipha 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.

Ukwengeza Amarekhodi Emininingwane Ngefomu

Ukwengeza Amarekhodi Emininingwane ngeFomu

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 nenombolo ye-ID yomfundi (kuphela izinombolo ngemuva kwedashi ehlukile) sebenzisa ikhophi bese unamathisele ukusheshisa nokulula ukungena kwedatha.

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

Ukwengeza Amarekhodi Emininingwane Ngefomu (con't)

Ukwengeza amarekhodi asele ku-database yokufundisa, sebenzisa ifomu ukungena kulo lonke idatha etholakala esithombeni lapha kuma-cell A4 kuya ku-E11.

Ukusebenzisa ama-Data Data Data

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.

Ukufuna Amarekhodi Ukusebenzisa Igama Elilodwa Lensimu

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

Ukufuna Amarekhodi Ukusebenzisa Igama Elilodwa Lensimu

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 nesikhathi sesithathu futhi amarekhodi kaJ. Graham noWilliam Henderson kufanele avele omunye emva kokunye njengoba ebhalisiwe ohlelweni lobuGcisa.

Isinyathelo esilandelayo salesi sifundo sibandakanya isibonelo sokufuna amarekhodi afana nemigomo eminingi.

Ukufuna Amarekhodi Ukusebenzisa Amagama Ezindaweni Eziningi

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 inkambu yobudala bese uthayipha u-18.
3. Chofoza kuhlelo lwe - Program 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 lobuGcisa.
6. Chofoza inkinobho ethi Thola Okulandelayo okwesithathu futhi irekhodi likaJ. Graham kufanele lisabonakala ngoba awekho amanye amarekhodi afana nawo kokubili okulinganiselwe.

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