Lus Cim: Qhov kev nyeem no yog rau Microsoft Access 2000. Yog tias koj tab tom siv tus txheej txheem tshiab, Mus nyeem Tsim cov lus nug yooj yim hauv Microsoft Access 2010.
Koj puas tau xav muab cov ntaub ntawv los ntawm ntau cov ntxhuav hauv koj cov ntaub ntawv tso ua ke? Microsoft Access muaj ib qho lus nug uas muaj peev xwm ua tau yooj yim nrog rau txoj kev yooj yim-rau-kev kawm uas ua rau nws tau txais ib qho rho tawm kom tau raws nraim cov lus qhia uas koj xav tau los ntawm koj tus database. Hauv no nyeem, peb yuav tshawb txog cov lus nug yooj yooj yim.
Hauv qhov ua piv txwv no, peb yuav siv Access 2000 thiab Northwind qauv database rau hauv CD-ROM installation. Yog tias koj siv ib daim ntawv ua ntej dhau los, koj tuaj yeem pom tias qee qhov ntawm cov ntawv xaiv zaub mov thiab cov duab ntxoov ntxoo ntawm cov phom yog txawv me ntsis. Txawm li cas los xij, tib cov ntsiab lus tseem ceeb yuav raug siv rau txhua lub sij hawm Access (nrog rau feem ntau cov kev sib xyuas tshuab).
Cov Txheej Txheem Nqis Tes Ua Ntej
Wb tshawb cov txheej txheem step-by-step. Peb lub hom phiaj ntawm qhov kev nyeem no yog los tsim ib qho lus nug cov npe ntawm tag nrho peb cov khoom lag luam, cov khoom ntsuas tam sim no thiab lub npe thiab xov tooj ntawm txhua qhov chaw muag khoom.
Qhib koj cov ntaub ntawv. Yog tias koj tsis tau muab cov ntaub ntawv hauv Northwind ua tus ntsia tuaj, cov lus qhia no yuav pab koj . Txwv tsis pub, mus rau ntawm Cov Ntawv Thov, xaiv Qhib thiab nrhiav cov Northwind database ntawm koj lub computer.
Xaiv cov queries tab. Qhov no yuav coj cov npe ntawm cov lus nug uas Microsoft muaj nyob rau hauv cov qauv database nrog rau ob txoj kev los tsim cov lus nug tshiab.
Ob-nias rau "tsim cov lus nug los ntawm kev siv tus neeg ua haujlwm." Cov lus nug wizard simplifies cov creation ntawm kev queries tshiab. Peb yuav siv nws hauv no nyeem los ua kom paub lub tswv yim ntawm cov lus nug creation. Nyob hauv cov kev qhia tom qab, peb mam li xyuas cov qauv tsim uas tswj kev tsim cov lus nug ntau dua.