Excel 2003 Database Tutorial

01 ya 09

Excel 2003 Database Overview

Nthawi zina, tifunika kusunga chidziwitso cha chidziwitso ndipo malo abwino kwa izi ndi mu fayilo ya mndandanda wa Excel. Kaya ndi mndandanda wa manambala a foni, mndandanda wa anthu omwe ali bungwe kapena timagulu, kapena mndandanda wa ndalama, makadi, kapena mabuku, fano lachinsinsi la Excel limapangitsa kukhala kosavuta kulowa, kusunga, ndi kupeza zambiri.

Excel yakhazikitsira zida kuti zikuthandizeni kufufuza deta ndikupeza tsatanetsatane pomwe mukufuna. Komanso, ndi mazenera ambirimbiri ndi mizere zikwi zambiri, Excel spreadsheet ikhoza kukhala ndi deta yochuluka kwambiri.

Onaninso maphunziro otsogolera: Excel 2007/2010/2013 Khwerero Gawo .

02 a 09

Matebulo a Deta

Makhalidwe oyambirira a kusungirako deta m'ndandanda wa Excel ndi tebulo. Mu tebulo, deta imalowa m'mizere. Mzere uliwonse umadziwika ngati mbiri .

Kamodzi patebulo lipangidwa, zida za data za Excel zingagwiritsidwe ntchito kufufuza, kutulutsa, ndi kufotela zolembedwa m'mabuku kuti mudziwe zambiri.

Ngakhale pali njira zingapo zomwe mungagwiritsire ntchito zipangizozi pa Excel, njira yosavuta yochitira zimenezi ndikulenga zomwe zikudziwika ngati mndandanda kuchokera ku deta.

Kuti mutengere phunziro ili:

• lowetsani deta monga ikusonyezedwera mu chithunzi pamwambapa.

Chizindikiro - Kuti mulowe msanga ID ya ophunzira:

1. Lembani zizindikiro ziwiri zoyambirira - ST348-245 ndi ST348-246 m'maselo A5 ndi A6 motsatira.
2. Onetsani ma ID omwewa kuti muwasankhe.
3. Dinani pazitsulo chodzaza ndi kukokera ku selo A13.
4. Zina zonse za ID ya Ophunzira ziyenera kulowa mu maselo A6 mpaka A13 molondola.

03 a 09

Kulowa Data molondola

Mukalowa mu deta, nkofunika kuonetsetsa kuti yalowa bwino. Zina kusiyana ndi mzere 2 pakati pa mutu wa spreadsheet ndi mutu wa mutuwo, musasiye mizere ina iliyonse yopanda kanthu mukalowa deta yanu. Ndiponso, onetsetsani kuti musasiye maselo opanda kanthu.

Zolakwitsa zapadera, zomwe zimayambitsidwa ndi zolakwika zosalowa, ndizo zimayambitsa mavuto ambiri okhudzana ndi kasamalidwe ka deta. Ngati deta imalowa bwino pamayambiriro, pulogalamuyi imakhala ikubwezeretsani zotsatira zomwe mukufuna.

04 a 09

Mizere ndi Records

Monga tanenera, mzere wa deta, m'datala amadziwika ngati zolemba. Mukalowetsa zolemba mumaganizo awa:

• Siyani mizere yosalongosola patebulo yomwe ikupangidwa, ngakhale pakati pa mutu ndi mzere woyamba wa deta.
• Zolemba zingakhale ndi deta za chinthu chimodzi chokha.
• Chiwerengero chiyenera kukhala ndi zonse ZONSE zomwe zili mu deta yokhudza chinthucho. Sipangakhale chidziwitso cha chinthu mu mzere umodzi.
  

05 ya 09

Mizati ndi Masamba

Ngakhale mizere m'ndandanda wa Excel imatchulidwa ngati zolemba, zipilala zimadziwika ngati minda . Chigawo chilichonse chikusowa mutu kuti mudziwe deta yomwe ili. Mitu imeneyi imatchedwa mayina akumunda.

• Mayina amtundu akugwiritsidwa ntchito kuti atsimikizire kuti deta ya mbiri iliyonse imalowa mofanana.
• Onetsetsani kuti zonse zomwe zili muzomwe zili m'kalembedwe zimalowa mofanana. Ngati mutayamba kulowa manambala monga chiwerengero (monga 10 kapena 20) chitetezeni. Musasinthe mbali yina ndikuyamba kulowa manambala monga mawu (monga khumi kapena makumi awiri). Khalani osasinthasintha.
• Siyani zitsulo zosalongosola patebulo.

06 ya 09

Kupanga List

Deta ikadalowa mu tebulo, ikhoza kutembenuzidwira mndandanda . Kuchita izi:

1. Sungani maselo A3 mpaka E13 mu tsamba la ntchito.
2. Dinani pa Data> Mndandanda> Pangani Mndandanda kuchokera pa menyu kuti mutsegule Pangani Lembali .
3. Pamene bokosili liri lotseguka, maselo A3 mpaka E13 ali pa tsambalo ayenera kumayendetsedwa ndi nyerere.
4. Ngati nyerere zikuyenda kuzungulira maselo oyenera, dinani Ok mu Bukhu Loyenera Lembali .
5. Ngati nyerere siziyenda mozungulira maselo oyenera, onetsetsani maulendo oyenerera pazomwe mukulembazo, ndiyeno dinani Ok mu Bukhu la zokonza Lembali .
6. Gome liyenera kuzunguliridwa ndi malire a mdima ndikugwetsa mivi yomwe ikuwonjezedwa pambali pa dzina lililonse.

07 cha 09

Kugwiritsa Ntchito Zida Zida

Mukadapanga deta, mungagwiritse ntchito zida zomwe zili pansi pa mizere yoponya pansi pambali pa dzina lililonse lamasamba kuti musankhe kapena kusungani deta yanu.

Dongosolo la Kusankha

1. Dinani kumsana wotsika pansi pafupi ndi dzina la Last Name field.
2. Dinani pa Mtundu Wokwera ukutchulidwa kuti muyambe mndandanda wazamasamba kuchokera ku A mpaka Z.
3. Kamodzi akakonzedwa, Graham J. ayenera kukhala olemba woyamba pa tebulo ndipo Wilson R. ayenera kukhala womaliza.

Kusuta Data

1. Dinani pamsana wotsika pansi pafupi ndi Name Field field.
2. Dinani pa Bzinthu kusankha kuti muwonetsere ophunzira aliyense, osati mu pulogalamu yamalonda.
3. Dinani OK.
4. Ophunzira awiri okha - G. Thompson ndi F. Smith ayenera kuoneka popeza ndi awiri okha omwe amalembetsa pulogalamu yamalonda.
5. Kuti muwonetsere zolemba zonse, dinani pamsana wotsika pansi pafupi ndi Name Field field.
6. Dinani pazochita Zonse .
   

08 ya 09

Kukulitsa Zambiri

Kuwonjezera zolemba zina ku database yanu:

• Mzere wopanda kanthu umene uli ndi asteriski (maselo A14 mpaka E14) umawonjezeredwa pansi pa database pamene adalengedwa.
• Deta yowonjezera ikhoza kuwonjezeredwa ku databata pogwiritsa ntchito mzere wopanda kanthu.
• Onjezani deta ili:
  
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Sayansi

09 ya 09

Kumaliza Kulemba Mapu

Zindikirani : Khwerero iyi ikuphatikizapo kugwiritsa ntchito zithunzi zomwe zili pa Formatting toolbar , yomwe imapezeka pamwamba pa screen Excel 2003. Ngati palibe, werengani momwe mungapezere zida za Excel zomwe zingakuthandizeni kupeza.

1. Sungani maselo A1 mpaka E1 mu tsamba la ntchito.
2. Dinani pa Chithunzi choyanjana ndi Chigawo pa Kukonza Toolbar kuti muthe mutuwo.
3. Ndi maselo A1 mpaka E1 adakali osankhidwa, dinani pajambula Yodzaza Mtundu pa Formatting Toolbar (amawoneka ngati utoto ukhoza) kutsegula mndandanda wotsika pansi.
4. Sankhani Zobiriwira M'nyanja kuti musinthe mtundu wa maselo A1 - E1 mpaka wobiriwira.
5. Dinani pa chithunzi cha mtundu wa Zojambula pa Formatting Toolbar (ndilo kalata yaikulu "A") kuti mutsegule mndandanda wazithunzi.
6. Sankhani White kuchokera pa mndandanda kuti musinthe mtundu wa malemba m'maselo A1 - E1 kuti akhale oyera.
7. Onetsetsani maselo A2 - E2 mu tsamba la ntchito.
8. Dinani pajambula Yodzaza Masikono pa Kukonza Toolbar kuti mutsegula mndandanda wotsika pansi.
9. Sankhani Kuwala Kochokera ku mndandanda kuti musinthe mtundu wa maselo A2 - E2 kuti ukhale wobiriwira.
10. Onetsetsani maselo A3 - E14 pa tsamba la ntchito.
11. Sankhani Format> AutoFormat kuchokera menus kuti mutsegule AutoFormat dialog box.
12. Sankhani Mndandanda wa 2 kuchokera mndandanda wa zosankhidwa kuti musinthe maselo A3 - E14.
13. Onetsetsani maselo A3 - E14 pa tsamba la ntchito.
14. Dinani ku Center optionicon pa Formatting Toolbar kuti mugwirizanitse mawu m'ma maselo A3 mpaka E14.
15. Panthawiyi, ngati mwatsatira ndondomeko yonse ya phunziro ili molondola, tsamba lanu liyenera kufanana ndi spreadsheet yomwe ikuwonetsedwa mu Gawo 1 la phunziroli.