01 ntawm 08
Siv Ib Daim Ntawv Rau Cov Ntaub Ntawv Nkag Hauv Excel
Siv Excel ua tau nyob rau hauv cov ntaub ntawv nkag teb chaws yog ib qho yooj yim thiab yooj yim txoj kev nkag mus rau cov ntaub ntawv rau hauv Excel database .
Siv daim ntawv tso cai rau koj:
- pib cov ntaub ntawv tshiab los yog ntxiv cov ntaub ntawv tshiab rau ib tus uas twb muaj lawm
- taug qab los ntawm cov ntaub ntawv khaws tseg ib zaug ib zaug
- nrhiav cov ntaub ntawv uas muaj cov ncauj lus qhia
- kho kom raug lossis rho tawm ntaub ntawv yog tias tsim nyog
Saib cov ntaub ntawv hais txog: Excel 2010/2007 Cov Ntaub Ntawv Tso Npe Kawm Ntawv .
02 ntawm 08
Muab Database Field Names
Raws li hais dhau los, txhua yam peb yuav tsum tau ua kom siv cov ntaub ntawv nkag teb chaws hauv Excel yog muab cov lus qhia kiag lub npe los yog cov npe ntawm lub npe los siv rau peb cov ntaub ntawv.
Qhov yoojyim tshaj ntxiv rau cov npe rau hauv daim ntawv no yog muab lawv tso rau hauv hlwb hauv koj daim ntawv ua haujlwm . Koj tuaj yeem suav nrog 32 lub npe rau hauv daim ntawv.
Sau cov npe hauv qab no rau hauv hlwb A1 rau E1:
StudentID
Lub Xeem
Initial
Hnub nyoog
Qhov kev pab cuam
03 ntawm 08
Qhib Cov Ntaub Ntawv Tso Npe
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
- Nias ntawm tes A2 los ua nws lub xovtooj ntawm tes .
- Nyem ntawm cov ntaub ntawv> Daim ntawv nyob hauv cov ntawv qhia zaub mov.
- Qhib daim ntawv no yuav xub sau ib kab lus los ntawm Excel uas muaj ntau txoj kev xaiv hais txog kev muab cov npe rau hauv daim ntawv.
- Vim peb twb ntaus hauv cov npe ntawm peb lub npe uas peb xav siv raws li lub npe txhua yam peb tau ua yog Nyem OK nyob rau hauv lub thawv ntawv.
- Daim ntawv uas muaj tag nrho cov npe ntawm lub npe yuav tsum tshwm sim ntawm qhov screen.
04 ntawm 08
Muab Cov Ntaub Ntawv Cov Ntaub Ntawv Nrog Daim Ntawv
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
Thaum cov ntaub ntawv cov npe tau raug ntxiv rau daim ntawv ntxiv rau cov ntaub ntawv khaws tseg rau cov ntaub ntawv database tsuas yog ib qho teeb meem ntawm kev sau hauv cov ntaub ntawv nyob rau hauv qhov kev txiav txim kom yog rau hauv daim teb.
Piv txwv Cov Ntaub Ntawv
Ntxiv cov ntaub ntawv nram qab no rau cov ntaub ntawv los ntawm kev nkag mus rau cov ntaub ntawv rau hauv cov lus teb ntawm ib sab ntawm lub ncauj lus tseeb. Nias ntawm khawm Tshiab tom qab nkag mus rau thawj daim ntawv xwv kom luaj lub teb rau daim ntawv thib ob.
StudentID : SA267-567
Lub Npe : Jones
Initial : B.
Hnub nyoog : 21
Qhov Kev Kawm : Lus
StudentID : SA267-211
Xeem Lub Xeem : Williams
Thawj kauj ruam : J.
Hnub nyoog : 19
Qhov Kev Kawm : Science
Tswv Yim: Thaum nkag mus rau cov ntaub ntawv uas zoo sib xws xws li tus menyuam kawm ntawv tus lej ID (tsuas yog cov lej tom qab lub tsoo hluav taws sib txawv), siv daim ntawv thiab muab tshuaj txhawm rau kom ceev thiab simplig cov ntaub ntawv nkag.
05 ntawm 08
Ntxiv Cov Ntaub Ntawv Cov Ntaub Ntawv Nrog Daim Ntawv (Tsis yog)
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
Txhawm rau ntxiv cov ntaub ntawv ntxiv rau cov ntaub ntawv qhia, siv daim ntawv kom nkag mus rau seem ntawm cov ntaub ntawv pom hauv daim duab saum toj no rau hauv hlwb A4 rau E11.
06 ntawm 08
Siv Daim Ntawv Cuab Cov Ntaub Ntawv
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
Ib qhov teeb meem loj nrog cov ntaub ntawv database yog tswj hwm qhov ncaj ncees ntawm cov ntaub ntawv raws li cov ntaub ntawv loj hlob tuaj. Qhov no yuav tsum:
- kho cov ntaub ntawv yuam kev lossis kho dua ib tus neeg cov ntaub ntawv
- tshem cov ntaub ntawv tsis raug cai lossis muab luam tawm
Cov ntaub ntawv nkag teb chaws muaj ntau cov cuab yeej raws sab tes xis uas ua rau nws yooj yim mus nrhiav thiab kho los yog rho tawm cov ntaub ntawv los ntawm lub database.
Cov cuab yeej no yog:
- Qhov Tshawb Pom Tawm thiab Nrhiav Cov Nyees Nyuam Tom Ntej - Cov no cia koj mus rau pem hauv ntej thiab rov qab los ntawm cov ntaub ntawv database ib zaug.
- Lub Delete khawm - qhov no yog siv los rho tawm cov ntaub ntawv los ntawm lub database.
- Tus Restore khawm - Lub khawm no siv tau los hloov cov kev hloov rau cov ntaub ntawv uas raug kho. Qee zaum, peb ua qhov hloov ntawm cov ntaub ntawv lossis hloov kho cov ntaub ntawv tsis raug cai zoo. Yog li, lub khawm rov qab tuaj yeem siv los hloov cov kev hloov no.
- Lus Cim: qhov khawm rov qab ua haujlwm tsuas yog ua haujlwm ntev li cov ntaub ntawv nyob hauv daim ntawv. Thaum koj nkag mus rau lwm daim ntawv los yog kaw daim ntawv, lub khawm rov qab ua rau tsis voos.
- Txoj Cai Nkaus pub rau koj tshawb nrhiav database rau cov ntaub ntawv raws li tej yam kev cai, xws li npe, hnub nyoog, lossis kev kawm. Ib qho piv txwv ntawm kev siv Cov Cai Txhawm yog tso rau hauv theem tom ntej ntawm kev nyeem.
07 ntawm 08
Tshawb Nrhiav Cov Ntaub Ntawv Siv Ib Lub Npe Lub Npe
Tus Txheem Nyiam tso cai rau koj mus nrhiav tus database rau cov ntaub ntawv uas siv ib los yog ntau dua cov npe ntawm lub npe - xws li lub npe, hnub nyoog, lossis qhov kev zov me nyuam.
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
- Nias rau ntawm Txoj Cai hauv khawm hauv daim ntawv.
- Txhawm rau ntawm Txoj Cai Tus Khawm clears tag nrho daim teb tab sis tsis tshem tawm cov ntaub ntawv ntawm database.
- Nias rau ntawm qhov kev zov me nyuam thiab cov txuj ci Askiv thaum peb xav tshawb nrhiav rau tag nrho cov tub ntxhais kawm hauv cov khoos kas Arts hauv kev kawm.
- Nias rau ntawm Qhov Nrhiav Tom ntej . Cov ntaub ntawv khaws tseg rau H. Thompson yuav tsum tau tshwm sim hauv daim ntawv thaum nws mus koom rau hauv Kev Kawm Txuj Ci.
- Nias rau ntawm Tom Ntej Tshawb nrhiav qhov thib ob thiab zaum peb thiab cov ntaub ntawv rau J. Graham thiab W. Henderson yuav tsum tshwm sim tom qab sib koom ua ke uas lawv tseem kawm tau hauv Kev Kawm Txuj Ci.
Kauj ruam tom ntej ntawm kev nyeem ntawv muaj xws li piv txwv ntawm kev tshawb nrhiav cov ntaub ntawv khaws tseg uas muaj ntau yam ntawm cov txheej xwm.
08 ntawm 08
Kev Tshawb Fawb Rau Cov Ntaub Ntawv Siv Ntau Hom Npe
Tus Txheem Nyiam tso cai rau koj mus nrhiav tus database rau cov ntaub ntawv uas siv ib los yog ntau dua cov npe ntawm lub npe - xws li lub npe, hnub nyoog, lossis qhov kev zov me nyuam.
Lus Cim: Rau kev pabcuam ntawm tus qauv no, saib daim duab saum toj no.
Hauv qhov ua piv txwv no, peb yuav tshawb nrhiav txhua tus menyuam kawm ntawv uas muaj hnub nyoog 18 xyoo thiab tau kawm rau hauv cov khoos kas Arts. Tsuas yog cov ntawv teev lus uas ua rau ob qho tib si yuav tsum tau muab tso rau hauv daim ntawv.
- Nias rau ntawm Txoj Cai hauv khawm hauv daim ntawv.
- Nias lub hnub nyoog hnub nyoog thiab hom 18 .
- Nias ntawm qhov kev zov me nyuam thiab kev ua yeeb yam.
- Nias rau ntawm Qhov Nrhiav Tom ntej . Cov ntaub ntawv rau H. Thompson yuav tsum tshwm ntsej muag rau hauv daim ntawv txij li thaum nws muaj hnub nyoog 18 xyoo thiab tau tso npe rau hauv Kev Kawm Txuj Ci.
- Nias rau ntawm Find Tom khawm ob zaug thiab cov ntaub ntawv rau J. Graham yuav tsum tshwm sim txij li thaum nws yog 18 xyoo thiab tau tso npe rau hauv Kev Kawm Txuj Ci.
- Nias rau ntawm Find Next khawm peb zaug thiab cov ntaub ntawv rau J. Graham tseem yuav tsum pom txij thaum tsis muaj lwm cov ntaub ntawv uas phim ob qho tib si.
Cov ntaub ntawv rau W. Henderson yuav tsum tsis txhob pom nyob rau hauv qhov piv txwv vim tias, txawm tias nws tau kawm rau hauv Kev Ua Yeeb Yam, nws tsis yog 18 xyoo kom nws tsis ua raws ob qho kev tshawb nrhiav.