Yuav Paub
- In a database, mus rau Create thiab xaiv Query Wizard. Xaiv hom lus nug, xws li Yooj Yim Query Wizard, thiab xaiv OK.
- Xaiv lub rooj tsim nyog los ntawm cov ntawv qhia rub-down thiab xaiv cov teb kom tshwm sim hauv cov lus nug. Xaiv Next.
- Xaiv hom kev tshwm sim uas koj xav tau thiab xaiv Tom ntej . Ntxiv ib lub npe thiab xaiv Finish.
Kab lus no piav qhia yuav ua li cas los tsim cov lus nug yooj yim hauv Microsoft Access. Cov lus qhia siv rau Access rau Microsoft 365, Access 2019, Access 2016, thiab Access 2013.
Tsim cov lus nug yooj yim hauv Microsoft Access
Microsoft Access muaj cov lus nug muaj nuj nqi nrog kev kawm yooj yim-rau-kawm interface uas ua rau nws yooj yim rau rho tawm cov ntaub ntawv raws nraim koj xav tau los ntawm koj lub database.
Lub hom phiaj hauv qhov piv txwv no qhia yog los tsim cov lus nug uas teev cov npe ntawm tag nrho peb lub tuam txhab cov khoom, peb lub hom phiaj cov khoom lag luam qib thiab cov npe nqi rau txhua yam khoom. Siv Cov Lus Nug Wizard yooj yim rau cov txheej txheem.
-
Yog tias koj tsis tau teeb tsa Northwind qauv database, nco ntsoov ua li ntawd ua ntej pib ua haujlwm. Qhib cov ntaub ntawv ntawd lossis lwm cov ntaub ntawv koj xav siv.
Image -
Xaiv lub Create tab.
Image -
Xaiv Query Wizard hauv pawg lus nug. Lub qhov rais Query tshiab yuav qhib.
Lwm txoj hauv kev yog siv Cov Lus Nug Tsim, uas pab txhawb kev tsim cov lus nug ntau dua tab sis nyuaj rau siv.
Image -
Xaiv hom lus nug. Rau peb lub hom phiaj, peb yuav siv qhov Yooj Yim Query Wizard. Xaiv OK mus txuas ntxiv.
Image -
Xaiv lub rooj tsim nyog los ntawm cov ntawv qhia rub-down. Cov no yog cov ntaub ntawv siv tau rau koj cov lus nug tshiab. Hauv qhov piv txwv no, peb xav ua ntej xaiv Cov Khoom Muag Khoom uas muaj cov ntaub ntawv hais txog cov khoom peb khaws cia hauv peb cov khoom muag.
Image -
Xaiv teb koj xav kom tshwm sim hauv cov lus nug tshwm sim. Koj tuaj yeem ua qhov no los ntawm ob npaug nias rau lawv lossis xaiv qhov field name thiab tom qab ntawd ntawm > icon. Thaum koj ua li no, cov teb yuav txav los ntawm Cov Chaw Muaj Cov Ntawv Sau Npe mus rau Cov Ntawv Xaiv Fields. Hauv qhov piv txwv no, peb xav xaiv lub npe khoom npe, Daim Ntawv Teev Npe, thiab Lub Hom Phiaj los ntawm khoom tab.
Ceeb toom tias muaj peb lwm lub cim muaj. Lub >> icon yuav xaiv txhua qhov chaw muaj. Lub < lub cim tso cai rau koj tshem tawm cov ntsiab lus tseem ceeb los ntawm cov npe Xaiv Cov Fields thaum lub << icon tshem tawm txhua qhov chaw xaiv.
Image -
Rov ua kauj ruam 5 thiab 6 ntxiv cov ntaub ntawv los ntawm cov rooj ntxiv, raws li xav tau. Hauv peb qhov piv txwv, peb rub cov ntaub ntawv los ntawm ib lub rooj.
Koj tuaj yeem muab cov ntaub ntawv los ntawm ntau lub rooj thiab yooj yim qhia kev sib raug zoo. Txhua yam koj tau ua yog xaiv cov teb. Qhov no ua haujlwm vim tias Northwind database muaj kev sib raug zoo ntawm cov rooj. Yog tias koj tab tom tsim cov ntaub ntawv tshiab, koj yuav tsum tsim kom muaj kev sib raug zoo ntawm koj tus kheej.
- Thaum koj ua tiav ntxiv cov teb rau koj cov lus nug, xaiv Next mus txuas ntxiv.
-
Xaiv cov txiaj ntsig koj xav tsim. Peb xav tsim ib daim ntawv teev tag nrho ntawm cov khoom thiab lawv cov neeg muag khoom, yog li xaiv qhov kev xaiv nthuav dav ntawm no thiab xaiv lub Next khawm mus txuas ntxiv.
Image -
Muab koj cov lus nug ib lub npe. Xaiv ib yam dab tsi piav qhia uas yuav pab koj paub cov lus nug no tom qab. Peb mam li hu rau cov lus nug no Khoom Muag Khoom Muag.
Image -
Xaiv Tiav. Koj yuav raug nthuav tawm nrog cov lus nug tshwm sim hauv cov lus piav qhia saum toj no. Nws muaj cov npe ntawm peb lub tuam txhab cov khoom lag luam, cov khoom lag luam xav tau qib siab, thiab sau cov nqi. Daim ntawv ceeb toom tias lub tab qhia cov txiaj ntsig muaj lub npe ntawm koj cov lus nug.
Image
Zoo siab txais tos! Koj tau ua tiav koj cov lus nug thawj zaug siv Microsoft Access! Tam sim no koj tau riam phom nrog lub cuab yeej muaj zog los siv rau koj qhov kev xav tau database.
Yog tias koj siv qhov dhau los ntawm Access, muaj cov lus qhia tsim cov lus nug uas siv Access 2010 nrog rau cov ntawv qub ntawm Access.
