Excel Data Entry Form

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:

Hais Txog Ntxiv Cov Ntaub Ntawv Tso Npe Ntawv Icon rau Lub Ceev Ntaub Ntawv Teeb Tseg

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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

Nkag mus rau Daim Ntawv Xaiv Tsev Kawm Ntawv hauv Excel. © Ted Fabkis

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

  1. Nias ntawm xub hauv qab kawg ntawm Quick Access Toolbar qhib qhov kev xaiv cia hauv tshuab raj.
  2. Xaiv dua lus txib los ntawm cov npe kom qhib qhov Customize Quick Access Toolbar dialog box .
  3. Nias ntawm xub hauv qhov kawg ntawm qhov Xaiv cov lus xaiv los ntawm txoj kab qhib lub tshuab raj.
  4. 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.
  5. Tshooj ntawm qhov kev sau npe ntawm tus tsiaj ntawv no kom paub cov lus hais kom ua.
  6. Nias rau Ntxiv khawm ntawm qhov kev tshuav lus hais ntxiv los mus ntxiv cov lus hais kom ua rau qhov Quick Access Toolbar.
  7. Nyem OK .

Cov ntawv sau khawm tam sim no yuav tsum muab ntxiv rau Lub Ceev Ntaub Ntawv Qhia Tool.

Muab Database Field Names

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

Qhib Cov Ntaub Ntawv Tso Npe

  1. Nias ntawm tes A2 los ua nws lub xovtooj ntawm tes .
  2. Nias ntawm daim ntawv cim npe uas tau muab ntxiv rau Lub Ceev Ntaub Ntawv Cuam Tshuam ntawm phab 2.
  3. 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.
  4. 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.
  5. 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

Nkag mus Siv Cov Ntaub Ntawv Siv Ib Daim Ntawv hauv Excel. © Ted Fabkis

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.

  1. 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)

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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:

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:

Tshawb Nrhiav Cov Ntaub Ntawv Siv Ib Lub Npe Lub Npe

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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

  1. Nias rau ntawm Txoj Cai hauv khawm hauv daim ntawv.
  2. Txhawm rau ntawm Txoj Cai Tus Khawm clears tag nrho daim teb tab sis tsis tshem tawm cov ntaub ntawv ntawm database.
  3. 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.
  4. 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.
  5. 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

Siv Daim Ntawv Xaiv Sau Cov Ntaub Ntawv hauv Excel. © Ted Fabkis

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.

  1. Tshawb lub ntsiab lus khawm hauv daim ntawv.
  2. Nias lub hnub nyoog hnub nyoog thiab hom 18.
  3. Nias nyob rau hauv qhov kev pab cuam thiab kos duab.
  4. 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.
  5. 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.
  6. 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.