Tutorial 2003 Database Tutorial

01 na 09

Excel 2003 Database Overview

A wasu lokuta, muna buƙatar ci gaba da lura da bayanai da kuma kyakkyawan wuri ga wannan yana cikin fayil ɗin Excel. Ko yana da jerin lambobin lambobin waya, jerin lambobin sadaukarwa ga membobin kungiya ko ƙungiya, ko tarin tsabar kudi, katunan, ko littattafai, wani fayil na bayanan Excel ya sa ya sauƙi shigarwa, adana, da kuma samun bayanan bayani.

Excel ta gina kayan aiki don taimaka maka kiyaye bayanin bayanai da kuma samun bayanan bayani idan kana so. Bugu da ƙari, tare da daruruwan ginshiƙai da dubban layuka, ɗakin lissafin Excel zai iya ɗaukar adadin bayanai.

Har ila yau, duba tutorial da aka shafi: Excel 2007/2010/2013 Mataki na Mataki Database Tutorial .

02 na 09

Tables na Data

Mahimman tsari na adana bayanai a cikin wani shafin Excel shine tebur. A teburin, an shigar da bayanai a layuka. Kowane jere an san shi a matsayin rikodin .

Da zarar an halicci tebur, za'a iya amfani da kayan aikin na Excel don bincika, raba, da kuma tace fayiloli a cikin database don samun bayani na musamman.

Kodayake akwai hanyoyi da dama da zaka iya amfani da waɗannan kayan aiki na kayan aiki a Excel, hanya mafi sauki ta yin hakan shine ƙirƙirar abin da aka sani da jerin daga bayanai a tebur.

Don bi wannan koyawa:

• shigar da bayanai kamar yadda aka nuna a cikin hoton da ke sama.

Tip - Don shigar da dalibin ID da sauri:

1. Rubuta ID na farko na farko - ST348-245 da ST348-246 zuwa cikin sel A5 da A6.
2. Ƙarrafa abubuwan ID guda biyu don zaɓar su.
3. Danna kan cika cika kuma ja shi zuwa cell A13.
4. Sauran ID na ID ya kamata a shiga cikin sassan A6 zuwa A13 daidai.

03 na 09

Shiga Data Daidai

Lokacin shigar da bayanai, yana da muhimmanci a tabbatar da an shigar da shi daidai. Baya ga jere 2 tsakanin maɓallin lissafi da kuma rubutun shafi, kada ku bar kowane layuka marar launi lokacin shigar da bayanai. Har ila yau, tabbatar da cewa ba za ku bar kowane nau'in komai ba.

Kuskuren bayanai, lalacewa ta hanyar shigar da bayanai ba daidai ba, sune tushen matsala masu yawa dangane da gudanar da bayanai. Idan an shigar da bayanai daidai a farkon, shirin zai iya ba ku sakamakon da kuke so.

04 of 09

Rows ne Records

Kamar yadda aka ambata, layuka na bayanai, a cikin bayanan da aka sani da rubutun. Lokacin shigar da rubuce-rubucen kiyaye waɗannan sharuɗɗa a tuna:

• Kada a bar layuka marar launi a cikin tebur da aka halitta, ba ma tsakanin maƙallan da jere na farko na bayanai ba.
• Mai rikodin zai iya ƙunsar bayanai game da abu ɗaya kawai.
• Dole ne rikodin ya ƙunshi dukkanin bayanai a cikin database game da wannan abu. Ba za'a iya samun bayani game da abu a cikin jere fiye da ɗaya ba.
  

05 na 09

Gumomin suna Fields

Duk da yake layuka a cikin wani shafin Excel an kira su a matsayin littattafai, ana kiran ginshiƙai a matsayin filayen . Kowace shafi yana buƙatar wata don gano bayanan da ya ƙunshi. Wadannan maƙallan suna kiransa sunayen filin.

• Ana amfani da sunaye don tabbatar da cewa an shigar da bayanai don kowane rikodin a cikin jerin.
• Tabbatar cewa an shigar da dukkanin bayanai a cikin wani shafi ta yin amfani da wannan tsari. Idan ka fara shigar da lambobi kamar lambobi (kamar 10 ko 20) kiyaye shi. Kada ku canza hanyar hanya ta hanyar shiga lambobi kamar kalmomi (kamar goma ko ashirin). Kasancewa.
• Kada ku bar ginshiƙai a cikin tebur.

06 na 09

Samar da Jerin

Da zarar an shigar da bayanai a cikin tebur, za'a iya canza shi zuwa jerin . Don yin haka:

1. Sanya siffofin A3 zuwa E13 a cikin takardun aiki.
2. Danna kan Bayanai> Lissafi> Ƙirƙirar List daga menu don bude akwatin zane na Creative .
3. Duk da yake akwatin maganganun ya buɗe, kullun A3 zuwa E13 a kan takarda ya kamata a kewaye da tururuwa masu tafiya.
4. Idan tururuwa suna tafiya kewaye da kwayoyin, danna Ok a cikin akwatin zane.
5. Idan tururuwa masu tafiya ba su kewaye wuri mai kyau na sel ba, suna nuna haskakawa a cikin takardun aiki sa'annan ka danna Ok a cikin akwatin zane.
6. Dole ne a rufe teburin da iyakokin duhu da kuma sauke kiban da aka haɓaka kusa da kowane filin filin.

07 na 09

Yin Amfani da Bayanan Kayan Gida

Da zarar ka ƙirƙiri bayanan, za ka iya amfani da kayan aikin da ke ƙarƙashin jerin kiban da ke gefen kowane filin filin don tsara ko tace bayananka.

Bayaniyar Bayanai

1. Danna kan arrow mai saukewa kusa da Sunan Yanan Sunan.
2. Danna kan Zaɓuɓɓukan Ascending wanda za a iya raba jerin bayanai daga A zuwa Z.
3. Da zarar an ware shi, Graham J. ya kasance farkon rikodin a teburin kuma Wilson R. ya zama na karshe.

Bayanin Juyawa

1. Danna kan maɓallin da aka saukewa kusa da sunan filin Shirin .
2. Latsa Zaɓin Kasuwanci don sharewa kowane ɗalibai, ba cikin shirin kasuwanci ba.
3. Danna Ya yi.
4. Sai kawai dalibai biyu - G. Thompson da F. Smith ya kamata a bayyane tun lokacin da suke kawai ne kawai a cikin shirin kasuwanci.
5. Don nuna duk rubutun, danna kan gefen saukewa kusa da sunan filin Shirin .
6. Danna kan Zaɓin Duk .
   

08 na 09

Ƙara fadan Database

Don ƙara ƙarin rubutun to your database:

• Rashin jigon da ke dauke da wani alama (Kwayoyin A14 zuwa E14) an kara zuwa kasan bayanan lokacin da aka halicce shi.
• Ƙarin bayanai za a iya kara da su a cikin database ta yin amfani da wannan jere.
• Ƙara bayanai masu zuwa:
  
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Kimiyya

09 na 09

Ana kammala Databaseing

Lura : Wannan mataki ya shafi yin amfani da gumaka da aka samo a kan Toolbar , wadda aka saba kasancewa a saman allo na Excel 2003. Idan ba a nan ba, karanta yadda za a sami kayan aiki na Excel don taimaka maka gano shi.

1. Fassara sel A1 zuwa E1 a cikin takardun aiki.
2. Danna kan Ƙungiya da Cibiyar Cibiyar a kan Toolbar Tsarin don zartar da take.
3. Tare da Kwayoyin A1 zuwa E1 har yanzu an zaba, danna kan gunkin Ƙunƙasa a kan Toolbar Tsarin (ya zama kamar fenti) don buɗe lissafin layi mai launi.
4. Zaba Sea Green daga jerin don canza launin launi na sel A1 - E1 zuwa duhu kore.
5. Latsa gunkin Font Color a kan Toolbar Tsarin (shi ne babban harafi "A") don buɗe jerin layi na launi.
6. Zaɓi Fira daga jerin don canza launi na rubutun a cikin kwayoyin A1 - E1 zuwa farar fata.
7. Sanya siffofin A2 - E2 a cikin takardun aiki.
8. Danna kan gunkin Ƙaƙwalwar Launi a kan Toolbar Tsarin don buɗe layin layi na launi.
9. Zaɓi haske mai haske daga lissafi don canza launin launi na sel A2 - E2 zuwa haske kore.
10. Fassara sel A3 - E14 a kan takardun aiki.
11. Zabi Tsarin> AutoFormat daga menu don bude akwatin maganganun AutoFormat .
12. Zabi Lissafi 2 daga jerin jerin zaɓuɓɓuka don tsara jikin A3 - E14.
13. Fassara sel A3 - E14 a kan takardun aiki.
14. Danna kan zaɓi na Cibiyar a kan Toolbar Tsarin don zartar da rubutu a cikin kwayoyin halitta A3 zuwa E14.
15. A wannan lokaci, idan kun bi duk matakai na wannan koyaswar daidai, toshe ɗinku ya kamata ya zama kama da maƙallan da aka hoton a Mataki na 1 na wannan tutorial.