Excel 2003 Tutorial Database

01 ea 09

Excel 2003 Database Overview

Ka linako tse ling, re lokela ho boloka tlaleho ea tlhahisoleseding le sebaka se setle ho sena ke faele ea hau ea database ea Excel. Ebang ke lethathamo la botho la linomoro tsa fono, lethathamo lethathamong la litho tsa mokhatlo kapa sehlopha, kapa pokello ea chelete ea tšepe, likarete, kapa libuka, file ea Excel database e etsa hore ho be bonolo ho kena, ho boloka le ho fumana boitsebiso bo tobileng.

Excel e hahile lisebelisoa ho u thusa ho boloka tlaleho ea data le ho fumana tlhahisoleseding e tobileng ha ue batla. Hape, ka mela ea eona e makholo le mela e likete, Excel spreadsheet e ka tšoara lintlha tse ngata haholo.

Hape sheba thuto e amanang le eona: Excel 2007/2010/2013 Step by Step Database Tutorial .

02 ea 09

Mehala ea Ditaba

Sebopeho sa motheo bakeng sa ho boloka dintlha diferenkong ya Excel ke tafole. Tafole, data e kenngoa ka mela. Mohala ka mong o tsejoa e le rekoto .

Hang ha tafoleng e bōpiloe, lisebelisoa tsa data tsa Excel li ka sebelisoa ho batla, ho hlophisa, le ho hlophisa litlaleho tse fumanehang ho database ho fumana boitsebiso bo tobileng.

Le hoja ho na le litsela tse 'maloa tseo u ka sebelisang lisebelisoa tsena tsa data ho Excel, tsela e bonolo ka ho fetisisa ea ho etsa joalo ke ho bopa se tsejoang e le lenane le tsoang litabeng tsa tafole.

Ho latela thupelo ena:

• kena ka data joalokaha e bontšoa setšoantšong se ka holimo.

Tlhahiso - Ho kenya ID ea seithuti ka potlako:

1. Ngola li-ID tsa pele tse peli - ST348-245 le ST348-246 ho lisele tsa A5 le A6 ka ho latellana.
2. Totobatsa li-ID tse peli ho li khetha.
3. Tobetsa mohope o tlatsitsoeng ebe o o hulela seleng ea A13.
4. Tse ling tsa ID ea Liithuti li lokela ho kenngoa ka lisele tsa A6 ho A13 ka nepo.

03 ea 09

Ho kenya Ditaba ka Nepo

Ha o kenya data, ke habohlokoa ho netefatsa hore e kenngoa ka nepo. Ntle ho mohala 2 pakeng tsa sehlooho sa spreadsheet le lihlooho tsa lihlooho, u se ke ua tlohela mela e meng e sa hlajoeng ha u kenya data ea hau. Hape, etsa bonnete ba hore ha u tlohele lisele tse se nang letho.

Litsekola tsa data, tse bakoang ke ho kenngoa ha lits'ebeletso tse fosahetseng, ke mohloli oa mathata a mangata a amanang le tsamaiso ea data. Haeba data e kenngoa ka nepo qalong, lenaneo le na le monyetla o moholo oa ho u khutlisetsa liphetho tseo u li batlang.

04 ea 09

Melao ke Records

Joalokaha ho boletsoe, mela ea ditshwantsho, e databoleng e tsejoa e le litlaleho. Ha u kena litlalehong u boloke tataiso ena ka kelellong:

• Tlohela mela e se nang letho tafoleng e bōpiloeng, esita le pakeng tsa lihlooho le mola oa pele oa lintlha.
• Tlaleho e ka ba le data e mabapi le ntho e le 'ngoe feela.
• Tlaleho e tlameha ho ba le litlhaloso tsohle LINTHO TSE KOPITSOANG. Ho ke ke ha e-ba le tlhahisoleseding e mabapi le ntho e fetang mola o le mong.
  

05 ea 09

Li-columns ke Masimo

Le hoja melapo ea database ea Excel e bitsoa litlaleho, litšiea li tsejoa e le masimo . Karolo ka 'ngoe e hloka hlooho ho khetholla data eo e nang le eona. Lihlooho tsena li bitsoa mabitso a tšimo.

• Mabitso a masimo a sebelisetsoa ho netefatsa hore lintlha tsa tlaleho e 'ngoe le e' ngoe li kenngoa ka tatellano e lekanang.
• Etsa bonnete ba hore boitsebiso bohle bo kentsoeng bo kenngoa ka mokhoa o tšoanang. Haeba u qala ho kenya linomoro e le litekanyetso (tse kang 10 kapa 20) li boloke. U se ke ua fetola karolo ea karolo ka hare 'me u qala ho kena linomoro joaloka mantsoe (a kang a leshome kapa a mabeli). E-ba ea tsitsitseng.
• Tlohela li-columns tse se nang letho tafoleng.

06 ea 09

Ho theha Lethathamo

Hang ha data e kentsoe tafoleng, e ka fetoloa lethathamong . Ho etsa joalo:

1. Totobatsa lisele tsa A3 ho ea ho E13 mosebetsing.
2. Tobetsa ho Data> Lethathamo> Bopa Lenane ho tsoa ho menu ho bula lebokose la boitsebiso la Letoto la ho Etsa .
3. Le hoja lebokose la lebokose le bulehile, lisele tsa A3 ho E13 tse leqepheng la lipampiri li lokela ho pota-potiloe ke likokoanyana tse tsamaeang.
4. Haeba likokoanyana tse tsamaeang li pota-potile litekanyo tse nepahetseng tsa lisele, tobetsa Ok ho lebokoseng la lebokose la ho etsa lethathamo .
5. Haeba likokoanyana tse tsamaeang li sa pota-potile litekanyo tse nepahetseng tsa lisele, li totobatsa marang-rang a nepahetseng kahare ea leqephe ebe u tobetsa Ok ho lebokoseng la lebokose la ho etsa lethathamo .
6. Tafole e lokela ho pota-potiloe ke moeli o lefifi 'me o theole metsu e hlahang haufi le lebitso le leng le le leng la tšimo.

07 ea 09

Ho sebelisa Li-Database Tools

Hang ha u se u entse database, u ka sebelisa lithulusi tse ka tlas'a metsu e theoha ka thōko ho lebitso le leng le le leng ho hlophisa kapa ho hlophisa lintlha tsa hau.

Dintlha tsa ho hlophisa

1. Tobetsa motsu o theoha o haufi le lebitso la Last Name field.
2. Tobetsa Mohlophong o Ntseng o nyolohela ho kgetha lethathamo la basebeletsi ho tloha ho A ho ea ho Z.
3. Hang ha e hlophisitsoe, Graham J. e lokela ho ba tlaleho ea pele tafoleng 'me Wilson R. e lokela ho ba oa ho qetela.

Ho hlakola Dintlha

1. Tobetsa motsu o theohelang haufi le lebitso la Lenane la Lenaneo .
2. Tobetsa Khoebo ho khetha ho hloekisa liithuti leha e le life, eseng lenaneong la khoebo.
3. Tlanya OK.
4. Ke liithuti tse peli feela - G. Thompson le F. Smith ba lokelang ho bonahala hobane ke bona feela ba ngolisitsoeng lenaneong la khoebo.
5. Ho bonts'a litlaleho tsohle, tobetsa motsu o theohelang haufi le lebitso la Lenane la Lenaneo .
6. Tobetsa ho Kgetho Eohle .
   

08 ea 09

Ho atolosa Boitsebiso

Ho eketsa litlaleho tse ling ho lintlha tsa hau:

• Moro o se nang letho o nang le asterisk (lisele tse A14 ho E14) o kenngoa ka tlaase ho database ha e bōptjoa.
• Lintlha tse eketsehileng li ka kenngoa ho database ho sebelisa mola o se nang letho.
• Kenya data e latelang:
  
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Saense

09 ea 09

Ho tlatsa Formatting Database

Tlhokomeliso : Mohato ona o kenyelletsa ho sebelisa litšoantšo tse hlahisitsoeng ho Formatting toolbar , e tloaelehileng e ka holimo ho skrine ea Excel 2003. Haeba e le sieo, bala kamoo u ka fumanang li-toolbar tsa Excel ho u thusa ho li fumana.

1. Totobatsa lisele tsa A1 ho E1 kahare ho leqephe.
2. Tobetsa ho setšoantšo sa ho kopanya le setsi ho Setting Toolbar ho theha sehlooho.
3. Kaha lisele tsa A1 ho E1 li sa ntsane li khethiloe, tobetsa Setšoantšo sa Phatlalatso se Tlatsang ho Setting Toolbar (se shebahala eka pente e ka khona) ho bula lenane la ho theola mebala ea mokokotlo.
4. Khetha Green Green ho tsoa lethathamong ho fetola mobala o ka morao oa lisele tse A1 - E1 ho lefifi le lefifi.
5. Tobetsa Setšoantšo sa Lebokose la Font ka Setting Toolbar (ke lengolo le leholo "A") ho bula lenane la theoha la mebala ea mebala.
6. Khetha White ho lethathamong ho fetola 'mala oa temana liseleng tsa A1 - E1 ho ea tšoeu.
7. Totobolla lisele tsa A2 - E2 kahare ho leqephe.
8. Tobetsa Letšoao la Matla a Tlatsang ho Setting Toolbar ho bula lenane la ho theola mebala ea mokokotlo.
9. Khetha Light Light ho tloha lethathamong ho fetola mmala o ka morao oa lisele A2 - E2 ho fihlela e le tala.
10. Totobatsa lisele tsa A3 - E14 leqepheng la mosebetsi.
11. Khetha Format> AutoFormat ho tloha menus ho bula AutoFormat dialog box.
12. Khetha Lethathamo la 2 ho tsoa lethathamong la dikgetho tse tla fetisa lisele tsa A3 - E14.
13. Totobatsa lisele tsa A3 - E14 leqepheng la mosebetsi.
14. Tobetsa ho Centeric optionicon ho Setting Toolbar ho kenya mohaho o lumellanang le mongolo ho li-cell A3 ho ea ho E14.
15. Hona joale, haeba u latetse mehato eohle ea thupelo ena ka nepo, sepache sa hao se lokela ho tšoana le spreadsheet e tšoantšetsoang Mohato oa 1 oa thuto ena.