Cov lus qhia ua raws cov kauj ruam ua rau nkag mus
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 tshem tawm cov ntaub ntawv raws li qhov tsim nyog
Hais Txog Ntxiv Cov Ntaub Ntawv Tso Npe Ntawv Icon rau Lub Ceev Ntaub Ntawv Teeb Tseg
Cov ntaub ntawv nkag teb chaws yog ib qho ntawm Excel cov cuab yeej built-in. Siv nws tag nrho koj yuav tsum tau ua yog muab cov lus qhia kiag rau hauv koj cov ntaub ntawv, nyem rau Daim Ntawv Npe, thiab Excel yuav ua tus so.
Yuav ua rau tej yam yooj yim dua, txawm li ntawd los, txij li thaum Excel 2007, Microsoft tau xaiv tsis txhob suav cov Daim Ntawv Npe ntawm qhov xov.
Thawj kauj ruam siv cov ntaub ntawv nkag teb chaws yog ntxiv rau Daim Ntawv Tso Npe mus rau Quick Access Toolbar kom peb thiaj li siv tau.
Qhov no yog kev ua hauj lwm ib zaug. Ib zaug ntxiv, Daim Ntawv Npe icon tseem muaj nyob rau ntawm Quick Access Toolbar.
Nrhiav Kev Nkag Rau Cov Ntaub Ntawv Khawm
Qhov Quick Access Toolbar siv los khaws cov shortcuts rau nquag siv nta hauv Excel. Nws tseem yog qhov uas koj tuaj yeem tau ntxiv cov shortcuts rau Excel nta uas tsis muaj nyob rau ntawm txoj kab.
Ib qho ntawm cov nta no yog cov ntaub ntawv nkag teb chaws.
Cov ntaub ntawv no yog ib qho yooj yim thiab yooj yim txoj kev ntxiv cov ntaub ntawv rau ib qho Excel database.
Rau qee yam laj thawj, Microsoft tau xaiv tsis ntxiv rau daim ntawv rau ib qho ntawm cov kab ntawv pib ntawm Excel 2007.
Hauv qab no yog cov kauj ruam uas yuav qhia koj ntxiv rau Daim Ntawv Tso Npe mus rau hauv Quick Access Toolbar.
Ntxiv Daim Ntawv Npe Rau Cov Ntaub Ntawv Tso Siab Cuab Yeej
- Nias ntawm xub hauv qab kawg ntawm Quick Access Toolbar qhib qhov kev xaiv cia hauv tshuab raj.
- Xaiv dua lus txib los ntawm cov npe kom qhib qhov Customize Quick Access Toolbar dialog box .
- Nias ntawm xub hauv qhov kawg ntawm qhov Xaiv cov lus xaiv los ntawm txoj kab qhib lub tshuab raj.
- Xaiv Tag nrho Cov Lus Txib hauv daim ntawv los saib tag nrho cov lus txib nyob hauv Excel 2007 nyob rau sab laug tes.
- Tshooj ntawm qhov kev sau npe ntawm tus tsiaj ntawv no kom paub cov lus hais kom ua.
- Nias rau Ntxiv khawm ntawm qhov kev tshuav lus hais ntxiv los mus ntxiv cov lus hais kom ua rau qhov Quick Access Toolbar.
- Nyem OK .
Cov ntawv sau khawm tam sim no yuav tsum muab ntxiv rau Lub Ceev Ntaub Ntawv Qhia Tool.
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
Qhib Cov Ntaub Ntawv Tso Npe
Qhib Cov Ntaub Ntawv Tso Npe
- Nias ntawm tes A2 los ua nws lub xovtooj ntawm tes .
- Nias ntawm daim ntawv cim npe uas tau muab ntxiv rau Lub Ceev Ntaub Ntawv Cuam Tshuam ntawm phab 2.
- Txhawm rau ntawm daim ntawv cim npe yuav coj tau ib lub thawv ntawm Excel los ntawm ntau cov kev xaiv 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.
Muab Cov Ntaub Ntawv Cov Ntaub Ntawv Nrog Daim Ntawv
Muab cov ntaub ntawv sau tseg nrog daim ntawv
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 nyias txawv nyias) siv daim ntawv thiab muab tshuaj txhawm rau kom ceev thiab simplify cov ntaub ntawv nkag.
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.
Ntxiv Cov Ntaub Ntawv Cov Ntaub Ntawv Nrog Daim Ntawv (tsis yog)
Txhawm rau ntxiv cov ntaub ntawv ntxiv rau cov ntaub ntawv qhia, siv daim ntawv nkag mus so ntawm cov ntaub ntawv muaj nyob hauv daim duab no rau hauv hlwb A4 rau E11.
Siv Daim Ntawv Cuab Cov Ntaub Ntawv
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: Lub Restore button tsuas ua haujlwm li ntev tau thaum cov ntaub ntawv muaj 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.
Tshawb Nrhiav Cov Ntaub Ntawv Siv Ib Lub Npe Lub Npe
Txoj Cai Kaw pub rau koj tshawb nrhiav database rau cov ntaub ntawv uas siv ib los sis ntau dua cov npe ntawm lub npe, xws li lub npe, hnub nyoog, lossis kev kawm.
Tshawb Nrhiav Cov Ntaub Ntawv Siv Ib Lub Npe Lub Npe
- 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 Find Next button thib ob thiab peb zaug 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.
Cov kauj ruam tom ntej ntawm phau ntawv qhia no muaj xws li ib qho piv txwv ntawm kev tshawb nrhiav cov ntaub ntawv khaws tseg uas muaj ntau yam.
Kev Tshawb Fawb Rau Cov Ntaub Ntawv Siv Ntau Hom Npe
Hauv qhov ua pivtxwv no peb yuav tshawb nrhiav txhua tus menyuam kawm ntawv uas muaj hnub nyoog 18 xyoo thiab tau mus 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.
- Tshawb lub ntsiab lus khawm hauv daim ntawv.
- Nias lub hnub nyoog hnub nyoog thiab hom 18.
- Nias nyob rau hauv qhov kev pab cuam thiab kos duab.
- Nyem qhov Nrhiav Tom khawm. 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 qhov Tshawb Pom Tom Ntej dua zaum ob thiab cov ntaub ntawv rau J. Graham yuav tsum tshwm sim txij li thaum nws yog 18 xyoo thiab koom rau hauv Kev Kawm Txuj Ci.
- Nias qhov Tshawb Pom Tom Ntej peb zaug thiab cov ntaub ntawv rau J. Graham tseem yuav tsum pom txij thaum tsis muaj lwm cov ntaub ntawv uas ua kom haum 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.