Indlela Yakha I-Database ku-Excel

Landelela oxhumana nabo, amaqoqo, kanye neminye imininingwane nge-Excel database

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-Microsoft Excel ikhiphe amathuluzi ukukusiza ukugcina ithrekhi yedatha nokuthola ulwazi oluqondile uma ulufuna. Futhi, namakhulu ayo amakholomu nezinkulungwane zemigqa , ispredishithi se-Excel lingabamba idatha enkulu kakhulu.

Ukufaka idatha

Ifomethi eyisisekelo yokugcina idatha ku-database ye-Excel yithebula.

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

Ukulandela ngokuhambisana nalesi sifundo, faka idatha njengoba iboniswa esithombeni ngenhla.

Faka 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.

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.

Imigqa yiRekhodi

Umugqa ngamunye wedatha, ku-database uyaziwa njengerekhodi . Uma ufaka amarekhodi ugcine lezi ziqondiso engqondweni:

• Shiya imigqa engenalutho etafuleni edalwe. Lokhu kuhlanganisa ukungashiyi umugqa ongacacile phakathi kwezihloko zekholomu kanye 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.

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.
• Ungashiyi amakholomu angenalutho etafuleni.

Ukudala Ithebula

Uma idatha ifakiwe, ingashintshwa ibe itafula . Ukwenza kanjalo:

1. Qinisekisa amaseli A3 kuya ku-E13 kushidi lokusebenzela.
2. Chofoza kuthebhu yasekhaya .
3. Chofoza ku- Fomathi njengeThebula inketho kubhebhoni ukuvula imenyu yehla.
4. Khetha ukhetho oluhlaza okwesibhakabhaka lweThebula lwe-Table Style Medium 9 ukuvula ibhokisi lokubhala njengefomethi .
5. Ngenkathi ibhokisi lengxoxo livuliwe, amaseli A3 kuya ku-E13 ekhasini lokusebenzela kufanele azungezwe izintuthwane ezihambayo.
6. Uma izintuthwane ezihambayo zizungezile uhla olufanele lwamaseli, chofoza u- Ok kwibhokisi lengxoxo yeThebula njengeThebula .
7. Uma izintuthwane ezihambayo zingangqingili uhla olufanele lwamaseli, gcizelela ibanga elifanele ekhasini lokusebenzela bese uchofoza u- Ok ebhokisini lethebula lethebula .
8. Ithebula kufanele libe nemicibisholo ehlehlayo engeza eceleni kwegama ngalinye lensimu futhi imigqa yetafula kufanele ifomathiwe ngokushintsha ukukhanya nokukhanya okwesibhakabhaka.

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 lokugcina legama.
2. Chofoza u- Uhlobo lwe-A kuya ku-Z ukuze uhlele uhlu lwama-alphabetically.
3. Uma ihlelwe, uGraham J. kufanele abe irekhodi lokuqala etafuleni naseWilson. R kufanele kube ngowokugcina.

Ukuhlunga idatha

1. Chofoza umcibisholo wehla phansi eduze kwegama leNhlelo yohlelo .
2. Chofoza ibhokisi lokuhlola eduze neNketho Yonke Yonke ukuze usule wonke amabhokisi okuhlola.
3. Chofoza ebhokisini lokuhlola eduze neBhizinisi ukukhetha ukwengeza uphawu lokuhlola ebhokisini.
4. Chofoza OK .
5. Abafundi ababili kuphela - uG. Thompson noFm Smith kumele babonakale ngoba yibo kuphela ababhalisile ohlelweni lwebhizinisi.
6. Ukuze ubonise wonke amarekhodi, chofoza umcibisholo wehla phansi eduze kwegama lohlelo lweNhlelo.
7. Chofoza kusihlungi esicacile kusuka ku-"Uhlelo" inketho.

Ukwandisa i-Database

Ukwengeza amarekhodi engeziwe ku-database yakho:

• Beka inkinobho yakho yegundane phezu kwephashazi encane engxenyeni engezansi kwesokudla kwetafula.
• I-pointer yegundane izoshintsha ibe umcibisholo ophethwe kabili.
• Uma lokhu kwenzeka, chofoza bese ubamba inkinobho yesokudla yegundane bese uhudula umdwebo phansi ukuze ungeze umugqa ongenalutho phansi kwedatha.
• Engeza idatha elandelayo kulolu hlu olusha:
  Cell - Idatha
  I-A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Isayensi

Ukuqedela ukufometha kwedatha

1. Qinisekisa amaseli A1 kuya ku-E1 kushidi lokusebenzela.
2. Chofoza kuthebhu yasekhaya .
3. Chofoza ku- Ongakhetha kokuhlangana Nezikhungo zebhebhoni ukuze uqale isihloko.
4. Chofoza kumbala ogcwalisayo (ubukeka sengathi upende ungakwazi) ku-riboni ukuvula uhlu lokudonsela phansi kombala ogcwala.
5. Khetha i- Blue, i-Accent 1 ohlwini ukuze ushintshe umbala wesizinda emafenjini A1 - E1 ukuya emnyama okwesibhakabhaka.
6. Chofoza kusithonjana sombala wefonti kubha yamathuluzi wokufometha (kuyincwadi enkulu "A") ukuvula uhlu lwezintambo zombala wefonti.
7. Khetha Okumhlophe ohlwini ukuze ushintshe umbala wombhalo emafenjini A1 - E1 abe mhlophe.
8. Gqamisa amaseli A2 - E2 kushidi lokusebenzela.
9. Chofoza kumbala ogcwalisayo ku-riboni ukuvula uhlu lokudonsa umbala ogcwala.
10. Khetha i- Blue, i-Accent 1, i-Lighter engu-80 ohlwini oluthile ukuze ushintshe umbala wesizinda emafenjini A2 - E2 kuya kuluhlaza okwesibhakabhaka.
11. Gqamisa amaseli A4 - E14 kushidi lokusebenzela.
12. Chofoza ku- Okthoba inketho kubhebhoni ukuze uhambisane nombhalo kumaseli A14 kuya ku-E14.
13. Kuleli phuzu, uma ulandele zonke izinyathelo zalesi sifundo ngendlela efanele, ispredishithi sakho kufanele sifane nespredishithi efanekisiwe kuNyathelo 1 yalesi sifundo.

Imisebenzi yedatha

I-Syntax : Isibambiso (Database_arr, Field_str | inombolo, Criteria_arr)

Lapho umsebenzi D kungenye yezinto ezilandelayo:

• I-DAVERAGE
• I-DCOUNT
• DCOUNTA
• DGET
• I-DMAX
• DMIN
• DPRODUCT
• DSTDEV
• I-DSTDEVP
• I-DSUM
• I-DVAR
• I-DVARP

Thayipha : Idatha

Imisebenzi yedatha ye-Database isebenza ngokukhethekile uma amaSpredishithi e-Google asetshenziselwa ukugcina idatha ehlelekile, njenge-database. Umsebenzi ngamunye we-database, i- Dfunction , ihlanganisa umsebenzi ohambelana nendawo egciniwe yesigaba sefoni esithathwa njengetafula le-database. Imisebenzi yedatha yemvelo ithatha izingxabano ezintathu:

• I-Database_arr ibanga, ibhodi elihlanganisiwe noma i-array ekhiqizwa inkulumo ehleliwe ehlelwe ukuze umugqa ngamunye emva kweRow 1 irekhodi ledatha, futhi ikholomu ngayinye yinkambu yedatha. Umzila 1 uqukethe amalebula enkambu ngayinye.
• I-Field_str | inombolo ibonisa ukuthi iyiphi ikholomu (insimu) iqukethe amanani okumele abe nesilinganiso. Lokhu kungabonakaliswa njengegama lomkhakha (umbhalo wezinhlamvu) noma inombolo yekholomu, lapho ikholomu engakwesokunxele lizobe limelelwa njengo-1.
• I-Criteria_arr ibanga, i-array ehlanganisiwe noma i-array eyenziwe ngezwi elihle elihlelwe ukuthi umugqa wokuqala uqukethe igama lamasimu okuzosetshenziselwa umgomo (imigomo), futhi imigqa elandelayo iqukethe ukuhlolwa okunemibandela (s) .

Umugqa wokuqala ku-Criteria ucacisa amagama ensimu. Njalo enye umugqa ku-Criteria imelela isihlungi, okuyisethi yemingcele emikhakheni ehambelanayo. Imikhawulo ichazwa ngokusebenzisa i-Query-by-Example notation, futhi ingabandakanya inani lokufanisa noma u-opharetha wokuqhathanisa olandelwa inani lokufanisa. Izibonelo zemingcele yi: "Ushokolethi", "42", "> = 42", "<> 42". Iseli elingenalutho lisho umkhawulo emkhakheni ohambelana nawo.

Isihlungi sihambisana nomugqa wokugciniwe uma yonke imingcele yemifanekiso (imingcele emgqeni wesihlungi) ihlangene. Umugqa wolwazi (irekhodi) lugcwalisa Isihlonzi uma futhi kuphela uma okungenani ukuhlunga kufana nalo. Igama lefomu lingabonakala izikhathi ezingaphezu kwesisodwa ebangeni lokunquma ukuvumela imikhawulo eminingi esebenza ngesikhathi esisodwa (isibonelo, izinga lokushisa> = 65 nokushisa <= 82).

I-DGET yiyona kuphela imisebenzi yedatha engahlanganisi amanani. I-DGET ibuyisela inani lensimu echazwe kwingxabano yesibili (ngokufanayo ne-VLOOKUP) kuphela uma irekhodi elilodwa lihambisana neCriteria; uma kungenjalo, kubuyisa iphutha elibonisa ukungalingani noma ukufana okuningi