Excel tsis muaj peev xwm tswj hwm cov ntaub ntawv ntawm cov kev sib raug zoo database xws li SQL Server thiab Microsoft Access. Qhov nws tuaj yeem ua tau, txawm li cas los xij, yog ua cov ntaub ntawv yooj yim uas ua tiav cov kev tswj xyuas cov ntaub ntawv.
Hauv Excel, cov ntaub ntawv raug teeb tsa siv cov kab thiab kab hauv ib daim ntawv ua haujlwm. Lub rooj feature ua kom yooj yim nkag mus, kho, thiab tswj cov ntaub ntawv.
Cov lus qhia no siv rau Excel versions 2019, 2016, 2013, 2010, thiab Excel rau Microsoft 365.
Cov ntsiab lus ntawm cov ntaub ntawv: Cov Ntaub Ntawv, thiab Fields
A database is a collection of related information stored in one or more computer files. Feem ntau cov ntaub ntawv raug teeb tsa rau hauv cov ntxhuav hauv txoj hauv kev uas nws tuaj yeem hloov kho tau yooj yim, txheeb xyuas, kho, thiab lim.
Ib qho yooj yim database, xws li Excel, tuav tag nrho cov ntaub ntawv hais txog ib qho kev kawm hauv ib lub rooj. Relational databases, ntawm qhov tod tes, muaj ntau lub rooj nrog txhua tus muaj cov ntaub ntawv hais txog qhov sib txawv, tab sis muaj feem xyuam nrog cov ncauj lus.
Records
In database terminology, a record tuav tag nrho cov ntaub ntawv lossis cov ntaub ntawv hais txog ib qho khoom tshwj xeeb hauv cov ntaub ntawv. Hauv Excel, txhua lub xov tooj ntawm tes hauv daim ntawv ua haujlwm muaj ib yam ntawm cov ntaub ntawv lossis tus nqi.
Teb
Txhua yam ntawm cov ntaub ntawv hauv cov ntaub ntawv khaws cia, xws li tus lej xov tooj lossis tus lej xov tooj, raug xa mus rau field. Hauv Excel, tus kheej lub hlwb ntawm daim ntawv ua haujlwm ua haujlwm ua haujlwm, vim tias txhua lub xovtooj tuaj yeem muaj ib daim ntawv qhia txog ib yam khoom.
Teb npe
Nws yog ib qho tseem ceeb los npaj cov ntaub ntawv kom koj tuaj yeem txheeb lossis lim cov ntaub ntawv kom pom cov ntaub ntawv tshwj xeeb. Ntxiv cov kab ntawv kab lus, hu ua cov npe teb, ua kom yooj yim rau kev nkag mus rau cov ntaub ntawv hauv tib qhov kev txiav txim rau txhua cov ntaub ntawv.
Sample Database
Nyob hauv daim duab saum toj no, txhua tus menyuam kawm ntawv muaj ib kab sib cais hauv lub rooj uas muaj tag nrho cov ntaub ntawv muaj txog lawv.
Txhua lub xovtooj ntawm ib kab yog ib daim teb uas muaj ib daim ntaub ntawv. Cov npe ntawm cov npe hauv kab hauv qab pab xyuas kom cov ntaub ntawv nyob twj ywm los ntawm kev khaws tag nrho cov ntaub ntawv ntawm ib lub ntsiab lus tshwj xeeb, xws li lub npe lossis hnub nyoog, nyob rau hauv tib kem rau txhua tus tub ntxhais kawm.
Excel's Data Management Tools
Ntxiv rau, Microsoft muaj ntau yam ntaub ntawv los ua kom yooj yim rau kev ua haujlwm nrog ntau cov ntaub ntawv khaws cia hauv Excel cov lus thiab pab kom nws nyob zoo.
Siv daim ntawv rau cov ntaub ntawv
Ib qho ntawm cov cuab yeej yog cov ntaub ntawv. Koj tuaj yeem siv nws los nrhiav, kho, nkag, lossis tshem tawm cov ntaub ntawv, hauv cov ntxhuav uas muaj txog 32 daim teb lossis txhua kab.
Daim ntawv ua ntej suav nrog cov npe ntawm cov npe hauv qhov kev txiav txim uas lawv tau teem rau hauv lub rooj, kom ntseeg tau tias cov neeg siv nkag mus rau cov ntaub ntawv raug. Ib sab ntawm txhua daim teb lub npe yog lub thawv ntawv rau nkag lossis kho cov ntaub ntawv ib leeg.
Thaum nws muaj peev xwm tsim cov ntaub ntawv kev cai, tsim thiab siv daim ntawv qub feem ntau yog txhua yam uas xav tau.
Tshem tawm cov ntaub ntawv duplicate
Ib qho teeb meem nrog txhua qhov databases yog cov ntaub ntawv yuam kev. Ntxiv rau qhov yooj yim sau yuam kev lossis cov ntaub ntawv ploj lawm, cov ntaub ntawv luam tawm tuaj yeem ua rau muaj kev txhawj xeeb vim tias cov ntaub ntawv loj hlob tuaj.
Lwm yam ntawm Excel cov ntaub ntawv cov cuab yeej siv tau los tshem tawm cov ntaub ntawv duplicate - txawm tias qhov tseeb lossis ib nrab duplicates.
Sorting Data in Excel
Sorting txhais tau hais tias kom rov teeb tsa cov ntaub ntawv raws li cov cuab yeej tshwj xeeb, xws li txheeb cov lus ntawm cov tsiaj ntawv los ntawm cov npe lossis raws sijhawm los ntawm tus hlob mus rau tus yau.
Excel cov kev xaiv muaj xws li kev txheeb xyuas los ntawm ib lossis ntau qhov chaw, kev cai sorting, xws li hnub tim lossis lub sijhawm, thiab txheeb xyuas los ntawm kab uas ua rau nws tuaj yeem hloov pauv cov teb hauv ib lub rooj.