Yuav Siv Microsoft Access Li Cas (nrog Duab)

Cov txheej txheem:

Yuav Siv Microsoft Access Li Cas (nrog Duab)
Yuav Siv Microsoft Access Li Cas (nrog Duab)

Video: Yuav Siv Microsoft Access Li Cas (nrog Duab)

Video: Yuav Siv Microsoft Access Li Cas (nrog Duab)
Video: kablia vwj NCO Thaum 15 XYOOS tawm tshiab 2021-2022 2024, Plaub Hlis Ntuj
Anonim

Microsoft Access yog lub hauv paus tsim cov ntaub ntawv uas tso cai rau txhua tus kom yooj yim tswj thiab kho cov ntaub ntawv. Nws yog qhov tsim nyog rau txhua yam los ntawm cov phiaj xwm me me mus rau cov lag luam loj, thiab yog qhov program pom tau zoo heev. Qhov no ua rau nws zoo rau kev ua cov ntaub ntawv nkag, vim koj tsis tas yuav ua haujlwm nrog cov ntxhuav thiab cov ntawv nthuav tawm.

Cov kauj ruam

Ntu 1 ntawm 6: Tsim Tus Qauv Tshiab

Siv Microsoft Access Step 1
Siv Microsoft Access Step 1

Kauj Ruam 1. Nyem rau File tab thiab xaiv "Tshiab"

Cov ntaub ntawv khaws cia yog dab tsi yuav suav tag nrho koj cov ntaub ntawv hauv nws ntau yam. Koj tuaj yeem xaiv los tsim cov ntaub ntawv khoob, lub vev xaib tsis muaj dab tsi, lossis xaiv los ntawm ntau yam qauv.

  • Cov ntaub ntawv tsis muaj dab tsi yog tus txheej txheem Access database, thiab zoo rau kev siv hauv zos. Tsim cov ntaub ntawv khoob yuav tsim ib lub rooj ib yam nkaus.
  • Web databases tau tsim los ua kom sib xws nrog Access lub vev xaib cov cuab yeej tshaj tawm. Tsim cov ntaub ntawv khoob yuav tsim ib lub rooj ib yam nkaus.
  • Cov qauv yog cov ntaub ntawv tsim ua ntej tsim los rau kev siv ntau yam. Xaiv tus qauv yog tias koj tsis xav siv sijhawm ntau los tso cov qauv txheej txheem ua ke.
Siv Microsoft Access Step 2
Siv Microsoft Access Step 2

Kauj Ruam 2. Npe koj lub database

Thaum koj tau xaiv hom ntawv khaws cia, muab nws lub npe uas qhia txog nws yog dab tsi. Qhov no yuav pab tau tshwj xeeb tshaj yog tias koj yuav ua haujlwm nrog ntau lub chaw khaws ntaub ntawv sib txawv. Ntaus lub npe cov ntaub ntawv ntawm koj lub database hauv lub thawv "Cov Npe". Xaiv "Tsim" los tsim cov ntaub ntawv database tshiab.

Ntu 2 ntawm 6: Ntxiv Cov Ntaub Ntawv rau Database

Siv Microsoft Access Step 3
Siv Microsoft Access Step 3

Kauj Ruam 1. Txiav txim siab tus qauv zoo tshaj plaws rau koj cov ntaub ntawv

Yog tias koj tab tom tsim cov ntaub ntawv khoob, koj yuav xav txog txoj hauv kev zoo tshaj plaws los npaj koj cov ntaub ntawv, thiab ntxiv cov qauv tsim nyog. Muaj ntau txoj hauv kev uas koj tuaj yeem teeb tsa thiab cuam tshuam nrog koj cov ntaub ntawv hauv Access:

  • Cov Ntxhuav - Qhov no yog txoj hauv kev tseem ceeb uas cov ntaub ntawv khaws cia hauv koj lub database. Cov kab tuaj yeem muab piv rau daim ntawv nthuav tawm hauv Excel: cov ntaub ntawv tau teeb tsa ua kab thiab kab. Vim li no, kev xa cov ntaub ntawv los ntawm Excel thiab lwm cov phiaj xwm ntawv nthuav tawm yog cov txheej txheem yooj yim.
  • Cov Ntawv - Cov ntawv yog txoj hauv kev uas cov ntaub ntawv tau ntxiv rau koj cov ntaub ntawv. Thaum koj tuaj yeem nkag mus rau cov ntaub ntawv nkag rau hauv lub database ncaj qha rau hauv cov ntxhuav, siv cov ntawv tso cai rau nkag mus sai dua thiab pom tau cov ntaub ntawv ntau dua.
  • Kev Tshaj Qhia - Cov no suav nrog thiab nthuav tawm cov ntaub ntawv hauv koj cov ntaub ntawv khaws tseg. Cov ntawv ceeb toom yog txhawm rau txheeb xyuas cov ntaub ntawv thiab xa cov lus teb rau cov lus nug tshwj xeeb, xws li tau nyiaj ntau npaum li cas, lossis cov neeg siv khoom nyob qhov twg. Cov no feem ntau yog tsim los luam tawm.
  • Nug - Nov yog qhov koj khaws thiab lim koj cov ntaub ntawv. Koj tuaj yeem siv cov lus nug los tso saib cov npe tshwj xeeb los ntawm ntau lub rooj. Koj tseem tuaj yeem siv cov lus nug los tsim thiab hloov kho cov ntaub ntawv.
Siv Microsoft Access Step 4
Siv Microsoft Access Step 4

Kauj Ruam 2. Tsim koj thawj lub rooj

Yog tias koj tab tom pib sau cov ntaub ntawv tsis muaj dab tsi, koj yuav cia li pib nrog lub rooj dawb paug. Koj tuaj yeem pib nkag mus rau koj cov ntaub ntawv rau hauv lub rooj no, los ntawm txhais tes lossis los ntawm kev luam thiab muab tshuaj txhuam los ntawm lwm qhov chaw.

  • Txhua daim ntawv yuav tsum tau muab nws tus kheej kem (teb), thaum txhua cov ntaub ntawv yuav tsum yog kab sib cais. Piv txwv li, txhua kab yuav yog cov neeg siv khoom thaum txhua qhov haujlwm yuav sib txawv ntawm cov ntaub ntawv hais txog tus neeg siv khoom ntawd (lub npe, lub xeem, email chaw nyob, tus xov tooj, thiab lwm yam).
  • Koj tuaj yeem hloov npe cov npe kab ntawv kom yooj yim qhia qhov chaw yog dab tsi. Ob npaug nias rau kab lus kab lus kom hloov lub npe.
Siv Microsoft Access Step 5
Siv Microsoft Access Step 5

Kauj Ruam 3. Ntshuam cov ntaub ntawv los ntawm lwm qhov chaw

Yog tias koj xav tau ntshuam los ntawm cov ntaub ntawv txhawb nqa lossis chaw nyob, koj tuaj yeem teeb Kev Nkag mus rub cov ntaub ntawv thiab ntxiv nws rau koj lub database. Qhov no muaj txiaj ntsig zoo rau kev khaws cov ntaub ntawv tawm ntawm lub web server lossis qee qhov sib qhia siv.

  • Nyem rau Cov Ntaub Ntawv Sab Nraud tab.
  • Xaiv hom ntawv uas koj tab tom ntshuam. Hauv ntu "Ntshuam thiab Txuas", koj yuav pom qee qhov kev xaiv rau hom ntaub ntawv. Koj tuaj yeem nyem lub pob Ntxiv kom pom ntau txoj hauv kev. ODBC sawv rau Qhib Database Kev Sib Txuas, thiab suav nrog databases xws li SQL.
  • Nkag mus rau qhov chaw ntawm cov ntaub ntawv. Yog tias nws nyob ntawm server, koj yuav tsum tau muab chaw nyob server.
  • Hauv lub qhov rai tom ntej, xaiv "Qhia meej li cas thiab qhov twg koj xav khaws cov ntaub ntawv hauv cov ntaub ntawv tam sim no." Xaiv "OK." Ua raws cov kauj ruam rau import koj cov ntaub ntawv.
Siv Microsoft Access Step 6
Siv Microsoft Access Step 6

Kauj Ruam 4. Ntxiv lwm lub rooj

Koj yuav xav khaws koj cov ntaub ntawv sib txawv hauv cov ntaub ntawv sib txawv. Qhov no yuav pab ua kom koj cov chaw khaws ntaub ntawv ua haujlwm tau zoo. Piv txwv li, koj tuaj yeem muaj lub rooj ntawm cov ntaub ntawv cov neeg siv khoom thiab lwm lub rooj rau xaj cov ntaub ntawv. Tom qab ntawd koj tuaj yeem txuas tus neeg siv cov ntaub ntawv rau hauv cov lus xaj khoom.

Hauv qhov Tsim ntu ntawm Tsev tab, nyem rau ntawm lub rooj khawm. Ib lub rooj tshiab yuav tshwm rau hauv koj lub database. Koj tuaj yeem sau cov ntaub ntawv ib yam nkaus li koj tau ua rau thawj lub rooj

Ntu 3 ntawm 6: Teeb Rooj Sib Txheeb

Siv Microsoft Access Step 7
Siv Microsoft Access Step 7

Kauj Ruam 1. Nkag siab tias cov yuam sij ua haujlwm li cas

Txhua lub rooj yuav muaj thawj qhov tseem ceeb uas txawv rau txhua qhov nkag. Los ntawm lub neej ntawd, Access tsim kab ID uas nce tus lej rau txhua qhov nkag. Qhov no tau teeb tsa ua tus yuam sij thawj. Cov kab ntawv kuj tseem tuaj yeem muaj tus yuam sij txawv teb chaws. Cov no yog cov teb uas txuas nrog lwm lub rooj hauv lub database. Cov teb txuas yuav muaj tib cov ntaub ntawv.

  • Piv txwv li, hauv koj daim ntawv xaj, koj yuav muaj Tus Neeg Siv Khoom ID txhawm rau taug qab cov neeg siv khoom xaj khoom twg. Koj tuaj yeem tsim kev sib raug zoo rau daim teb ntawd nrog daim ID hauv koj li lus Cov Neeg Siv khoom.
  • Kev siv kev sib raug zoo pab khaws koj cov ntaub ntawv zoo ib yam, muaj txiaj ntsig, thiab nyeem tau.
Siv Microsoft Access Step 8
Siv Microsoft Access Step 8

Kauj Ruam 2. Nyem rau Database Tools tab

Nyem rau khawm Kev Sib Txheeb hauv ntu Kev Sib Txheeb. Qhov no yuav qhib lub qhov rai tshiab nrog kev txheeb xyuas tag nrho ntawm cov ntxhuav hauv lub database. Txhua daim teb yuav raug teev tseg hauv qab nws lub npe lub npe.

Koj yuav tsum tau tsim thaj chaw rau tus yuam sij txawv teb chaws ua ntej koj tsim kev sib raug zoo. Piv txwv li, yog tias koj xav siv Tus Neeg Siv Khoom ID ntawm Orders table, tsim thaj chaw hauv Cov lus xaj khoom hu ua Cov Neeg Siv Khoom thiab tso nws tseg. Nco ntsoov nws yog tib hom ntawv uas koj tab tom txuas (cov lej hauv qhov no)

Siv Microsoft Access Step 9
Siv Microsoft Access Step 9

Kauj Ruam 3. Luag daim teb uas koj xav siv ua tus lej txawv teb chaws

Tso nws mus rau qhov chaw uas koj tau tsim rau tus yuam sij txawv teb chaws. Nyem Tsim hauv lub qhov rai uas tshwm los teeb tsa kev sib raug zoo rau cov haujlwm. Ib txoj kab yuav tshwm ntawm ob lub rooj, txuas cov teb.

Khij lub npov rau "Tswj Kev Ncaj Ncees Kev Ncaj Ncees" thaum tsim kev sib raug zoo. Qhov no txhais tau tias yog cov ntaub ntawv raug hloov pauv hauv ib daim teb, lwm qhov chaw tau hloov kho tshiab. Qhov no yuav pab khaws koj cov ntaub ntawv kom raug

Ntu 4 ntawm 6: Ua Lus Nug

Siv Microsoft Access Step 10
Siv Microsoft Access Step 10

Kauj Ruam 1. Nkag siab lub luag haujlwm ntawm cov lus nug

Cov lus nug yog qhov ua uas cia koj saib sai, ntxiv, thiab hloov cov ntaub ntawv hauv koj lub database. Muaj ntau yam kev nug hom, xws li los ntawm kev tshawb nrhiav yooj yim rau kev tsim cov ntxhuav tshiab raws cov ntaub ntawv uas twb muaj lawm. Cov lus nug yog cov cuab yeej tseem ceeb rau kev tsim cov ntawv tshaj tawm.

Cov lus nug tau tawg ua ob hom tseem ceeb: Xaiv thiab Ua. Xaiv cov lus nug rub cov ntaub ntawv los ntawm cov ntxhuav thiab tuaj yeem suav tau. Cov lus nug tuaj yeem ntxiv, kho, thiab rho tawm cov ntaub ntawv los ntawm cov ntxhuav

Siv Microsoft Access Step 11
Siv Microsoft Access Step 11

Kauj Ruam 2. Siv Quiz Wizard los tsim qhov yooj yim Xaiv cov lus nug

Yog tias koj xav tsim lub hauv paus xaiv cov lus nug, siv Quiz Wizard taug kev koj los ntawm cov kauj ruam. Koj tuaj yeem nkag mus rau Quiz Wizard los ntawm Tsim tab. Qhov no yuav tso cai rau koj saib cov haujlwm tshwj xeeb los ntawm lub rooj.

Tsim Xaiv Cov Lus Nug nrog Cov Qauv

Siv Microsoft Access Step 12
Siv Microsoft Access Step 12

Kauj Ruam 1. Qhib Cov Lus Nug Tsim cov cuab yeej

Koj tuaj yeem siv cov txheej txheem txhawm rau nqaim koj cov lus nug xaiv thiab tsuas yog tso tawm cov ntaub ntawv koj xav tau. Txhawm rau pib, nyem rau Tsim tab thiab xaiv Cov Lus Nug.

Siv Microsoft Access Step 13
Siv Microsoft Access Step 13

Kauj Ruam 2. Xaiv koj lub rooj

Lub Show Show box yuav qhib. Nyem ob npaug rau lub rooj uas koj xav ua cov lus nug, thiab tom qab ntawd nyem Kaw.

Siv Microsoft Access Step 14
Siv Microsoft Access Step 14

Kauj Ruam 3. Ntxiv cov teb kom tau txais

Nyem ob npaug rau txhua daim teb hauv lub rooj uas koj xav ntxiv rau cov lus nug. Cov teb yuav raug ntxiv rau Daim phiaj Tsim.

Siv Microsoft Access Step 15
Siv Microsoft Access Step 15

Kauj Ruam 4. Ntxiv koj cov txheej txheem

Koj tuaj yeem siv ntau hom kev sib txawv, xws li cov ntawv lossis cov haujlwm. Piv txwv li, yog tias koj xav tsuas yog tso tawm tus nqi siab dua $ 50 los ntawm koj li "Tus Nqi" teb, koj yuav nkag mus

=50

rau hauv cov txheej txheem. Yog tias koj xav tsuas yog qhia cov neeg siv khoom los ntawm UK, koj yuav ntaus

UK

mus rau hauv qhov Kev Ntsuas.

Koj tuaj yeem siv ntau yam kev ntsuas ib nqe lus nug

Siv Microsoft Access Step 16
Siv Microsoft Access Step 16

Kauj Ruam 5. Nyem Khiav kom pom koj cov txiaj ntsig

Khiav lub khawm nyob ntawm Tus Tsim tab. Koj cov lus nug yuav tshwm rau ntawm lub qhov rais. Nias Ctrl + S kom txuag tau cov lus nug.

Tsim Xaiv Cov Lus Nug nrog Parameters

Siv Microsoft Access Step 17
Siv Microsoft Access Step 17

Kauj Ruam 1. Qhib Cov Lus Nug Tsim cov cuab yeej

Cov lus nug ntsuas yuav tso cai rau koj qhia qhov koj xav tau kom rov ua dua txhua lub sijhawm nug cov lus nug. Piv txwv li, yog tias koj muaj cov ntaub ntawv khaws cia nrog cov neeg siv khoom los ntawm ntau lub nroog, koj tuaj yeem ua cov lus nug ntsuas kom nug lub nroog twg uas koj xav pom cov txiaj ntsig rau.

Siv Microsoft Access Step 18
Siv Microsoft Access Step 18

Kauj Ruam 2. Tsim cov lus nug xaiv thiab qhia cov lus (s)

Ntxiv cov teb kom tau txais hauv cov lus nug los ntawm ob-nias rau lawv hauv cov lus qhia ntxaws.

Siv Microsoft Access Step 19
Siv Microsoft Access Step 19

Kauj Ruam 3. Ntxiv qhov ntsuas rau ntu Cov Qauv

Cov kev ntsuas tau hais los ntawm "" ib puag ncig ntawm qhov ntsuas. Cov ntawv nyob hauv kab zauv yuav qhia hauv qhov hais kom sai uas tshwm thaum cov lus nug tau khiav. Piv txwv li, kom sai rau lub nroog, nyem rau Cov Cai Sib Piv rau lub nroog, thiab ntaus

[Lub nroog twg?]

Koj tuaj yeem xaus qhov ntsuas nrog "?" lossis ":", tab sis tsis nrog "!" sau “.”

Siv Microsoft Access Step 20
Siv Microsoft Access Step 20

Kauj Ruam 4. Ua cov lus nug ntau yam

Koj tuaj yeem siv ntau qhov ntsuas los tsim qhov kev cai ntau rau koj cov lus nug. Piv txwv, yog tias daim teb yog Hnub Teb, koj tuaj yeem xa rov qab ntau yam ntawm cov hnub tim los ntawm kev ntaus ntawv

Nruab nrab ntawm [Sau hnub pib:] Thiab [Sau hnub xaus:]

. Koj yuav tau txais ob qho lus sai thaum koj ua cov lus nug.

Tsim Tsim Cov Lus Nug

Siv Microsoft Access Step 21
Siv Microsoft Access Step 21

Kauj Ruam 1. Nyem rau Tsim tab thiab xaiv Cov Lus Nug Tsim

Koj tuaj yeem siv cov lus nug los rub cov ntaub ntawv tshwj xeeb los ntawm cov ntxhuav uas twb muaj lawm thiab tsim lub rooj tshiab nrog cov ntaub ntawv no. Qhov no muaj txiaj ntsig tshwj xeeb tshaj yog tias koj xav qhia qee qhov tshwj xeeb ntawm koj cov ntaub ntawv khaws tseg, lossis tsim cov ntawv tshwj xeeb rau cov hauv qab ntawm koj li database. Koj yuav tsum tsim cov lus nug xaiv ib txwm ua ntej.

Siv Microsoft Access Step 22
Siv Microsoft Access Step 22

Kauj Ruam 2. Xaiv cov lus uas koj xav rub cov ntaub ntawv los ntawm

Nyem ob npaug rau ntawm cov ntxhuav uas koj xav rub koj cov ntaub ntawv los ntawm. Koj tuaj yeem rub los ntawm ntau lub rooj yog tias tsim nyog.

Siv Microsoft Access Step 23
Siv Microsoft Access Step 23

Kauj Ruam 3. Xaiv cov teb uas koj xav khaws cov ntaub ntawv los ntawm

Nyem ob npaug rau txhua daim teb uas koj xav ntxiv los ntawm cov lus qhia ntxaws. Nws yuav raug ntxiv rau koj daim ntawv nug.

Siv Microsoft Access Step 24
Siv Microsoft Access Step 24

Kauj Ruam 4. Teeb koj cov txheej txheem

Yog tias koj xav qhia cov ntaub ntawv tshwj xeeb los ntawm daim teb, siv ntu ntu kev teeb tsa los lim. Saib "Tsim Kev Xaiv Cov Lus Nug nrog Cov Qauv" ntu saum toj no kom paub meej ntxiv.

Siv Microsoft Access Step 25
Siv Microsoft Access Step 25

Kauj Ruam 5. Kuaj koj cov lus nug kom ntseeg tau tias nws rov qab tau cov txiaj ntsig koj xav tau

Ua ntej koj tsim koj lub rooj, khiav cov lus nug kom ntseeg tau tias nws tau rub tag nrho cov ntaub ntawv raug. Kho koj cov txheej txheem thiab cov haujlwm kom txog thaum koj tau txais tag nrho cov ntaub ntawv uas koj xav tau.

Siv Microsoft Access Step 26
Siv Microsoft Access Step 26

Kauj Ruam 6. Khaws cov lus nug

Nias Ctrl + S kom khaws cov lus nug rau siv tom qab. Nws yuav tshwm nyob rau hauv koj kab lus taw qhia ntawm sab laug ntawm lub vijtsam. Nyem rau ntawm cov lus nug kom xaiv nws dua thiab tom qab ntawd nyem rau ntawm Tsim tab.

Siv Microsoft Access Step 27
Siv Microsoft Access Step 27

Kauj Ruam 7. Nyem rau “Ua Rooj” khawm hauv Pawg Lus Nug Hom

Ib lub qhov rai yuav tshwm sim nug koj lub npe lub npe tshiab. Sau lub npe rau lub rooj thiab nyem OK.

Siv Microsoft Access Step 28
Siv Microsoft Access Step 28

Kauj Ruam 8. Nyem rau Khiav khawm

Koj lub rooj tshiab yuav raug tsim nrog cov lus nug koj tsim. Cov lus yuav tshwm nyob rau hauv koj daim duab qhia chaw ntawm sab laug.

Tsim Cov Lus Nug Ntxiv

Siv Microsoft Access Step 29
Siv Microsoft Access Step 29

Kauj Ruam 1. Qhib cov lus nug uas tau tsim yav tas los

Koj tuaj yeem siv cov lus nug ntxiv los ntxiv cov ntaub ntawv rau lub rooj uas twb muaj los ntawm lwm lub rooj. Qhov no muaj txiaj ntsig yog tias koj xav tau ntxiv cov ntaub ntawv rau lub rooj koj tsim nrog ua cov lus nug.

Siv Microsoft Access Step 30
Siv Microsoft Access Step 30

Kauj ruam 2. Nyem rau Append khawm hauv Tsim tab

Qhov no yuav qhib Cov lus sib txuas ntxiv. Xaiv lub rooj koj xav ntxiv.

Siv Microsoft Access Step 31
Siv Microsoft Access Step 31

Kauj Ruam 3. Hloov cov txheej txheem ntawm koj cov lus nug kom phim qhov koj xav ntxiv

Piv txwv li, yog tias koj tsim lub rooj nrog cov txheej txheem “2010” rau Xyoo Xyoo, hloov nws mus rau xyoo koj xav ntxiv, xws li “2011”.

Siv Microsoft Access Step 32
Siv Microsoft Access Step 32

Kauj Ruam 4. Teeb qhov chaw uas koj xav tau cov ntaub ntawv txuas ntxiv

Nco ntsoov teeb tsa thaj chaw raug rau txhua kab ntawv uas koj txuas ntxiv. Piv txwv li, thaum siv cov kev hloov pauv saum toj no, cov ntaub ntawv yuav tsum txuas ntxiv mus rau Xyoo Xyoo ntawm Cov Ntawv Ntxiv rau kab.

Siv Microsoft Access Kauj Ruam 33
Siv Microsoft Access Kauj Ruam 33

Kauj Ruam 5. Khiav cov lus nug

Nyem rau Run khawm ntawm Deign tab. Cov lus nug yuav raug khiav thiab cov ntaub ntawv yuav raug ntxiv rau lub rooj. Koj tuaj yeem qhib lub rooj los txheeb xyuas tias cov ntaub ntawv tau ntxiv raug.

Ntu 5 ntawm 6: Tsim thiab Siv Cov Ntawv

Siv Microsoft Access Step 34
Siv Microsoft Access Step 34

Kauj Ruam 1. Xaiv lub rooj uas koj xav tsim daim ntawv rau

Cov ntawv tso cai rau koj yooj yim pom cov ntaub ntawv rau txhua qhov haujlwm, ntxiv rau hloov pauv sai ntawm cov ntaub ntawv lossis tsim cov ntawv tshiab. Cov ntawv yog qhov tseem ceeb rau ncua sijhawm nkag mus rau cov ntaub ntawv, vim tias tib neeg feem ntau pom lawv yooj yim dua los ua haujlwm nrog ntau dua li cov rooj.

Siv Microsoft Access Step 35
Siv Microsoft Access Step 35

Kauj Ruam 2. Nyem rau daim ntawv khawm hauv Tsim tab

Qhov no yuav tsim ib daim ntawv raws li cov haujlwm muaj nyob hauv lub rooj tau txais. Kev nkag mus ua haujlwm zoo nkauj zoo ntawm kev tsim cov teb uas yog qhov loj me, tab sis koj tuaj yeem hloov kho thiab txav ib puag ncig ib qho ntawm daim ntawv uas koj xav tau.

  • Yog tias koj tsis xav kom thaj chaw tshwj xeeb tshwm rau ntawm daim foos, koj tuaj yeem nyem rau ntawm nws thiab xaiv Rho tawm.
  • Yog tias koj cov rooj muaj kev sib raug zoo, cov ntawv yuav tshwm hauv qab txhua cov ntaub ntawv, qhia cov ntaub ntawv sib txuas. Koj tuaj yeem hloov kho koj cov ntaub ntawv txuas nrog txoj kev no yooj yim dua. Piv txwv li, txhua tus muag khoom muag hauv koj lub database yuav muaj cov neeg siv khoom siv txuas nrog rau lawv cov ntaub ntawv.
Siv Microsoft Access Kauj Ruam 36
Siv Microsoft Access Kauj Ruam 36

Kauj Ruam 3. Txheeb koj daim ntawv tshiab

Cov xub xub nyob hauv qab txav los ntawm cov ntaub ntawv khaws cia. Cov teb yuav suav nrog koj cov ntaub ntawv khaws tseg thaum koj hloov ntawm lawv. Koj tuaj yeem siv cov nyees khawm nyob ntawm ntug kom txav mus rau thawj daim ntawv lossis zaum kawg.

Siv Microsoft Access Step 37
Siv Microsoft Access Step 37

Kauj Ruam 4. Nyem rau lub pob ntawv pob kom siv lub rooj

Nov yog nyob rau ntawm kaum sab laug, thiab yuav tso cai rau koj kom pib hloov qhov txiaj ntsig ntawm koj lub rooj los ntawm kev siv daim ntawv.

Siv Microsoft Access Step 38
Siv Microsoft Access Step 38

Kauj Ruam 5. Hloov pauv cov ntaub ntawv uas twb muaj lawm

Koj tuaj yeem hloov kho cov ntawv hauv txhua qhov chaw ntawm txhua cov ntaub ntawv los hloov cov ntaub ntawv hauv lub rooj. Cov kev hloov pauv yuav cuam tshuam ncaj qha rau ntawm lub rooj, ntxiv rau hauv txhua lub rooj sib txuas.

Siv Microsoft Access Step 39
Siv Microsoft Access Step 39

Kauj Ruam 6. Ntxiv cov ntaub ntawv tshiab

Nyem rau "Ntxiv Cov Ntaub Ntawv" khawm nyob ze cov ntawv qhia kom tsim cov ntaub ntawv tshiab tom kawg ntawm daim ntawv. Tom qab ntawd koj tuaj yeem siv cov teb los nkag cov ntaub ntawv rau hauv cov ntaub ntawv khoob hauv lub rooj. Nov yog txoj hauv kev yooj yim dua ntxiv cov ntaub ntawv tshiab dua li los ntawm lub rooj saib.

Siv Microsoft Access Step 40
Siv Microsoft Access Step 40

Kauj Ruam 7. Txuag daim ntawv thaum ua tiav

Nco ntsoov khaws koj daim ntawv los ntawm nias Ctrl + S kom koj tuaj yeem nkag tau yooj yim dua tom qab. Nws yuav tshwm nyob rau hauv koj kab lus taw qhia ntawm sab laug ntawm lub vijtsam.

Ntu 6 ntawm 6: Tsim Kev Tshaj Qhia

Siv Microsoft Access Step 41
Siv Microsoft Access Step 41

Kauj Ruam 1. Xaiv koj lub rooj lossis lus nug

Cov ntawv ceeb toom tso cai rau koj kom ceev cov ntsiab lus ntawm koj cov ntaub ntawv. Lawv feem ntau siv rau cov nyiaj tau los thiab xa tawm cov ntawv tshaj tawm, thiab tuaj yeem ua raws li kev siv xwb. Cov ntawv ceeb toom kos cov ntaub ntawv los ntawm ob lub rooj lossis cov lus nug uas koj tau tsim.

Siv Microsoft Access Kauj Ruam 42
Siv Microsoft Access Kauj Ruam 42

Kauj ruam 2. Nyem rau Tsim tab

Xaiv hom kev tshaj qhia uas koj xav tsim. Muaj ob peb txoj hauv kev sib txawv uas koj tuaj yeem mus txog kev tsim daim ntawv tshaj tawm. Kev nkag tau tuaj yeem tsim koj daim ntawv qhia rau koj tau txais, lossis koj tuaj yeem tsim qhov kev cai.

  • Qhia-Qhov no yuav tsim qhov pib-qhia nrog txhua cov ntaub ntawv los ntawm koj qhov chaw. Tsis muaj dab tsi yuav muab ua pawg, tab sis rau cov ntaub ntawv me me qhov no yog qhov txaus rau qhia qhov koj xav tau.
  • Daim Ntawv Qhia Tsis Tau - Qhov no yuav tsim cov ntawv ceeb toom uas koj tuaj yeem sau nrog koj cov ntaub ntawv raws li koj pom zoo. Koj yuav tuaj yeem xaiv los ntawm ib qho haujlwm uas muaj los tsim cov ntawv qhia kev cai.
  • Tus Kws Qhia Txuj Ci - Tus kws qhia ntawv qhia yuav qhia koj txog txheej txheem kev tsim tsab ntawv ceeb toom, tso cai rau xaiv thiab pab pawg koj cov ntaub ntawv, thiab tom qab ntawv ua raws nws.
Siv Microsoft Access Step 43
Siv Microsoft Access Step 43

Kauj Ruam 3. Teem lub hauv paus rau daim ntawv tsis txaus ntseeg

Yog tias koj tau xaiv los tsim tsab ntawv ceeb toom dawb, koj yuav tsum xaiv lub hauv paus rau nws. Ua ntej tshaj, nyem rau Arrange tab thiab tom qab ntawd xaiv Cov Ntawv Cov Khoom. Xwb, koj tseem tuaj yeem nias alt="Duab" + Nkag mus.

Nyem rau xub xub nyob ib sab ntawm Cov Ntaub Ntawv Cov Ntaub Ntawv. Cov npe ntawm koj cov ntxhuav thiab cov lus nug yuav tshwm. Xaiv ib qho thiab nws yuav raug xa mus rau daim ntawv tshaj tawm

Siv Microsoft Access Step 44
Siv Microsoft Access Step 44

Kauj Ruam 4. Ntxiv cov teb rau koj daim ntawv tshaj qhia

Thaum koj muaj lub hauv paus, koj tuaj yeem pib ntxiv cov teb los ntawm nws rau koj daim ntawv tshaj tawm. Nyem rau ntawm Format tab, thiab tom qab ntawd nyem Ntxiv Cov Ntawv Cuam Tshuam. Daim Ntawv Teev Npe yuav tshwm nyob rau sab xis.

  • Nyem thiab luag cov teb koj xav ntxiv rau hauv Tus Qauv Tsim. Cov ntaub ntawv yuav tshwm nyob rau hauv daim ntawv tshaj tawm. Raws li koj ntxiv cov teb ntxiv, lawv yuav tau kab ua ke nrog cov teb uas twb muaj lawm.
  • Koj tuaj yeem hloov kho thaj chaw los ntawm txhaj rau ntawm ntug thiab rub tus nas.
  • Rho tawm cov teb los ntawm daim ntawv tshaj tawm los ntawm txhaj rau kab lus thiab nyem qhov rho tawm.
Siv Microsoft Access Step 45
Siv Microsoft Access Step 45

Kauj Ruam 5. Ntxiv pab pawg rau koj daim ntawv tshaj tawm

Cov pab pawg tso cai rau koj txheeb xyuas cov ntaub ntawv hauv daim ntawv tshaj tawm sai sai, vim tias lawv tso cai rau koj los npaj cov ntaub ntawv cuam tshuam nrog. Piv txwv li, koj yuav xav pab pawg muag khoom los ntawm ib cheeb tsam lossis los ntawm tus muag khoom. Pawg tso cai rau koj ua qhov no.

  • Nyem rau Tsim tab, nyem rau Group & Sort khawm.
  • Txoj cai-nias ntawm ib feem ntawm thaj chaw koj xav ntxiv rau ib pab pawg. Xaiv Pawg On los ntawm cov ntawv qhia zaub mov.
  • Lub taub hau yuav raug tsim rau pab pawg. Koj tuaj yeem hloov kho lub taub hau rau txhua yam uas koj xav sau rau pawg.
Siv Microsoft Access Step 46
Siv Microsoft Access Step 46

Kauj Ruam 6. Txuag thiab qhia koj cov ntaub ntawv

Thaum koj daim ntawv tshaj tawm tiav, koj tuaj yeem khaws nws thiab tom qab ntawd muab nws lossis luam tawm zoo li ib daim ntawv. Siv qhov no los qhia cov tuam txhab kev ua haujlwm nrog cov tub ua lag luam, tiv toj cov ntaub ntawv rau cov neeg ua haujlwm, thiab ntau ntxiv.

Pom zoo: