Excel 2003 Tutorial Database

01 ye 09

Excel 2003 Database Overview

Pane dzimwe nguva, tinoda kuchengetedza ruzivo rwemashoko uye nzvimbo yakanaka kune iyi iri mune faira reDec database. Kunyangwe iri urongwa hwemhando dzefoni, nhamba yekutsvaga kune nhengo yesangano kana kuti timu, kana kuunganidza mari, makadhi, kana mabhuku, faira reAccel database rinounza nyore kupinda, kuchengeta, uye kuwana ruzivo rwakananga.

Excel yakazvivakira zvishandiso kuti zvikubatsire kuchengetedza deta uye kuwana ruzivo rwakananga kana uchida. Uyewo, pamwe nemazana emakoroni uye zviuru zvemasero, Excel spreadsheet inogona kubata yakawandisa deta.

Onawo zvidzidzo zvakafanana: Excel 2007/2010/2013 Nhanho Nhanho Database Tutorial .

02 of 09

Tables of Data

Izvo zvakakosha maitiro ekuchengetedza data mune imwe nhoroondo ye Excel ndiro tafura. Mune tafura, data inopinda mumitsara. Mutsara mumwe nomumwe unozivikanwa serekodhi .

Kana imwe tafura yakasikwa, zvishandiso zveDexcel zvinogona kushandiswa kutsvaga, kutarisa, uye firiji zvinyorwa mu database kuti uwane ruzivo rwakananga.

Kunyange zvazvo kune nzira dzakasiyana siyana dzaungashandisa idzi idzi dzekushandisa muExcel, nzira yakanakisisa yekuita izvi ndeyekusika izvo zvinozivikanwa sehurongwa kubva pane data iri patafura.

Kuti uite zvinotevera:

• pinda deta sezvinoratidzwa mumufananidzo wepamusoro.

Zano - Kupinda muIndaneti mudzidzi nokukurumidza:

1. Tora yekutanga maD ID - ST348-245 uye ST348-246 mumasero A5 neA6 maererano.
2. Simbisai maDI maviri kuti musarudze.
3. Dzvanya pazadziro rinogadziriswa uye uikurire pasi kuti isvike A13.
4. Zvose zveDhiyabhorosi ID zvinofanira kuiswa mumasero A6 kusvika kuA13 zvakarurama.

03 of 09

Kupinda Dhidziro Zvakarurama

Paunopinda munharaunda, zvinokosha kuti uone kuti yakapinda zvakanaka. Zvimwe pane mutsara 2 pakati pehesi yespredishiti uye chinyorwa chinyorwa, usasiya chero imwe mitsetse isina kuvhara paunopinda data yako. Uyewo, iva nechokwadi chokuti hausi kusiya masero asina chinhu.

Dhiyabhorosi kukanganisa, kunokonzerwa nekupinda kwakashata kwemashoko, ndiko kunokonzera matambudziko akawanda ane chokuita nekugadzirisa deta. Kana iyo data yakapinda zvakanaka pakutanga, purogiramu yacho inowanzokudzorera mhinduro dzaunoda.

04 of 09

Row Are Records

Sezvakataurwa, mitsara yedata, mune databata inozivikanwa sezvinyorwa. Apo paunopinda zvinyorwa, chengetedza mazano aya mupfungwa:

• Siya mitsetse isina kuvhara iri patafura iyo yakasikwa, kwete kunyange pakati pemisoro uye musara wokutanga wedata.
• Dare rinogona kunge rine data pamusoro peimwe chinhu chaiyo.
• Nhoroondo inofanirawo kuva neZVO data yose mu database pamusoro pechinhu ichocho. Ikoko hakugoni kuve neruzivo pamusoro pechinhu mumutsetse unopfuura mumwe.
  

05 of 09

Columns ndiwo Minda

Kunyange zvazvo mitsetse mune imwe nhoroondo ye Excel inotumidzwa sezvinyorwa, mazamu anozivikanwa seminda . Chikamu chimwe nechimwe chinoda musoro wekutora deta iri. Iyi misoro inonzi mazita emunda.

• Mazita emunda anoshandiswa kuve nechokwadi chokuti data yekodhi imwe neimwe inopinda muchikamu chakafanana.
• Iva nechokwadi chokuti data yose iri muhwendefa inopinda uchishandura mafomu akafanana. Kana iwe uchitanga kupinda nhamba sezviwero (zvakadai se10 kana 20) zvichengetedze. Usashandura chikamu nenzira uye uchitanga kupinda nhamba semashoko (akadai gumi kana makumi maviri). Iva akafanana.
• Siya pasina chinyorwa chinyorwa mutafura.

06 of 09

Kuumba Runyora

Kana imwe nyaya ichinge yatopindwa mutafura, inogona kutendeuka kuurongwa . Kuita izvi:

1. Simbisai masero A3 kusvika E13 mubasa rekushanda.
2. Dzvanya paData> Rongai> Shandisa Purogiramu kubva pane menyu kuti uzarure Dhinda Rakakurukurwa.
3. Nepo bhokisi rebhokisi rakazaruka, masero A3 kusvika E13 pane pepa rekushanda anofanira kunge akakomberedzwa nyerere dzinofamba.
4. Kana mhashu dzinofamba dzakakomberedza mararamiro akaenzana emasero, chengetedza Ok muGadzira Rukurano dialog box.
5. Kana mhasara dzinofamba dzisina kukomberedza mararamiro akaenzana emasero, tsanangurira mararamiro akakodzera mubheji rekushandura uye ipapo chekai Ok pane Denga Rakabhokisi reki dialog.
6. Tafura inofanira kuve yakakomberedzwa nemuganhu werima uye uise pasi miseve yakawedzerwa kune imwe neimwe yezita remunda.

07 of 09

Kushandisa Database Tools

Kana uchangobva kusika database, unogona kushandisa zvishandiso zviri pasi pemiseve inodonha pasi pezita roga roga remunharaunda kuti uronge kana kuchenesa data yako.

Kuronga Data

1. Dzvanya pamusana webhokisi rinotsika pasi pedyo neChita Name Last field field.
2. Dzvanya paChirongwa Kukwira kusarudza kusarudza dhesiyo kubva pane A kusvika Z.
3. Kamwe kanyatsorongwa, Graham J. anofanira kunge ari nhoroondo yekutanga patafura uye Wilson R. anofanira kuva wekupedzisira.

Kuchengeta Data

1. Dzvanya pamusorosoro unodonhedzwa uri pedyo neChirongwa chemaPurogiramu.
2. Dzvanya paBhizinesi sarudzo kusarudza kunze kwevadzidzi vose, kwete purogiramu yebhizimisi.
3. Dzvanya OK.
4. Vadzidzi vaviri chete - G. Thompson naFF Smith vanofanira kuonekwa sezvo ivo chete vari vaviri vakanyoreswa purogiramu yebhizimisi.
5. Kuti uratidze zvese zvinyorwa, tsvaga pahotera inodonha iri pedyo nePurogiramu yezita iri.
6. Dzvanya pane Zvose zvinosarudzwa.
   

08 of 09

Kuwedzeresa Database

Kuti uwedzere mamwe marekodhe ku database yako:

• Mutsara usina ruvara une asterisk (masero A14 kusvika E14) unowedzerwa kusvika pasi pe database apo yakasikwa.
• Zvimwe zvinyorwa zvinogona kuwedzerwa kune dhesiyo uchishandisa musara usina chinhu.
• Wedzera iyi inotevera:
  
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Sayenzi

09 of 09

Kuzadza Dhesefomu yeDatabase

Cherechedza : Danho iri rinosanganisira kushandisa zvidhori zviri paIttingting toolbar , iyo inowanikwa panzvimbo yeExcel 2003. Kana iyo isipo, verenga kuti ungawana sei Excel toolbars kuti ikubatsire kuiwana.

1. Simbisai masero A1 kusvika E1 mubasa rekushanda.
2. Dzvanya paMusanganisi neCentral icon paBuritsa Toolbar kuti ugadzire musoro.
3. Nemasero A1 kusvika kuE1 achiri kusarudzwa, chengetera Fill Color icon pane Formatting Toolbar (inoratidzika sepende inogona) kuzarura rondedzero rezasi yevaravara.
4. Sarudza Gungwa Dzvuku kubva pakurongwa kuti uchinje ruvara rwemukati wemasero A1 - E1 kusvika kune rima rakasvibirira.
5. Dzvanya paIndaneti Mufananidzo weChirangaridzo paBuritsa Toolbar (iyo tsamba yakakura "A") kuti uzarure maruva epavara pasi.
6. Sarudza Muchena kubva pakurongwa kuti uchinje ruvara rwemavara mumasero A1 - E1 kusvika kuchena.
7. Simbisai masero A2 - E2 mubasa rekushanda.
8. Dzvanya paDzadza Ratidza Mifananidzo pane Bhuku Rekushandisa Bhurabha kuti uzarure maruva ekuderedza pasi.
9. Sarudza Chiedza cheGreen kubva pakurongwa kuti uchinje ruvara rwemukati wemasero A2 - E2 kusvika kune ruvara ruchena.
10. Svinura masero A3 - E14 pane pepa rekushanda.
11. Sarudza Format> AutoFormat kubva kumamenyu kuzarura AutoFormat dialog box.
12. Sarudza Nhamba 2 kubva pane zvakasarudzwa zvekuita masero masero A3 - E14.
13. Svinura masero A3 - E14 pane pepa rekushanda.
14. Dzvanya kuCentic optionicon paBuritsa Toolbar kuitira kuti pave nekubatanidza mashoko mumasero A3 kusvika E14.
15. Panguva ino, kana iwe wakatevera matanho ose emudzidzisi uyu nenzira yakakodzera, shanduro yako inofanira kufanana nespredishiti inoratidzwa muChitatu 1 chekudzidzisa.