Microsoft Access muaj peb yam loj: cov qauv, cov lus nug thiab cov ntaub ntawv
Txhua lub tuam txhab uas ntxhov siab los ntawm ntau cov ntaub ntawv uas yuav tsum tau muaj kev taug los yog los ntawm lub kaw lus uas siv cov ntawv xa, cov ntaub ntawv los sis ntawv khawm kom ceev cov ntaub ntawv tseem ceeb yuav tau txais txiaj ntsim ntawm kev hloov mus rau cov ntaub ntawv tswj xyuas. Ib cov ntaub ntawv database xws li Microsoft Access 2010 yuav yog qhov uas lub tuam txhab xav tau.
Dab Tsi Yog Database?
Nyob rau theem pib tshaj plaws, cov ntaub ntawv database yog cov ntaub ntawv khaws tseg ntawm cov ntaub ntawv. Ib qhov system tswj xyuas qhov system (DBMS) xws li Microsoft Access muab koj nrog cov software cov cuab yeej koj yuav tsum tau npaj cov ntaub ntawv no kom txhij txhua. Nws suav nrog cov chaw ntxiv, hloov kho thiab rho tawm cov ntaub ntawv ntawm database, nug cov lus nug txog cov ntaub ntawv khaws cia hauv cov ntaub ntawv thiab tsim cov lus qhia tawm cov ntsiab lus xaiv.
Microsoft Access 2010 Tshooj
Microsoft Access 2010 muab cov neeg siv nrog DBMS kua yooj yim thiab yooj yim. Cov neeg siv Microsoft cov khoom ua haujlwm zoo siab rau qhov kev paub zoo tshaj plaws hauv Windows thiab xav thiab cov kev sib koom ceev nrog rau lwm yam Microsoft Office khoom tsev.
Peb ntawm cov Cheeb Tsam Cheeb Tsam Feem ntau uas cov neeg feem coob tau siv cov ntaub ntawv database yog cov ntxhuav, queries, thiab cov ntawv. Yog tias koj tab tom pib nrog Kev Nkag Mus thiab tsis tau muaj cov ntaub ntawv Access nyob rau hauv thov, nyeem txog Tsim Tsa Ntawv Tshawb Xyuas Xyoo 2010 los ntawm Tsoo.
Cov Ntxhais Yog Lub Tsev Blocks
Ntxhuav yog cov qauv tsev ntawm cov database. Yog hais tias koj paub nrog spreadsheets, koj yuav pom cov rooj cav yeej zoo ib yam. Ib qho qauv database yuav muaj cov neeg ua haujlwm, suav nrog cov cwj pwm xws li lub npe, hnub yug thiab lub npe. Nws yuav raug teeb tsa raws li nram no:
- Tus Neeg Ua Num Tus Neeg Ua Haujlwm
- Lub Xeem
- Thawj Lub Npe
- Lub npe
- Salutation
- Hnub Yug
Tshawb xyuas kev tsim kho ntawm lub rooj thiab koj yuav pom tau tias txhua kem ntawm lub rooj sib raug zoo mus rau ib tus neeg ua haujlwm tus cwj pwm-los yog tus cwj pwm hauv cov lus teev tseg. Txhua kab sib raug mus rau ib tus neeg ua haujlwm thiab muaj nws cov lus qhia. Yog tag nrho nws muaj nws. Yog tias nws pab, xav txog txhua lub rooj ua ib qho kev tshaj tawm cov ntawv xov xwm.
Cov lus nug Retrieve
Ib cov ntaub ntawv uas tsuas yog khaws cov ntaub ntawv xav tau xwb; koj xav tau txoj kev los muab cov lus qhia kom zoo. Yog tias koj tsuas xav khaws cov ntaub ntawv khaws cia rau hauv ib lub rooj, Microsoft Access tso cai rau koj qhib lub rooj thiab txheeb los ntawm cov ntaub ntawv hauv nws. Txawm li cas los xij, lub hwj chim tiag tiag ntawm ib tug database lus dag hauv nws cov peev xwm los teb cov lus queries. Kev nkag tau queries muab qhov muaj peev xwm los ua ke cov ntaub ntawv los ntawm ntau cov ntxhuav thiab muab ib qho chaw hauv cov ntsiab lus ntawm cov ntaub ntawv khaws tseg.
Xav txog tias koj lub koom haum xav tau ib txoj hauv kev yooj yim los tsim cov npe ntawm cov khoom uas tam sim no muag saum lawv qhov nqi nruab nrab. Yog hais tias koj tsuas muab cov lus qhia cov lus qhia, ua kom tiav cov hauj lwm no yuav xav tau ntau cov kev faib tawm ntawm cov ntaub ntawv thiab cov laij zauv los ntawm tes. Txawm li cas los xij, lub hwj chim ntawm cov lus nug tau tso cai rau koj thov kom Cov Ntaub Ntawv Xa rov qab tsuas yog cov ntaub ntawv ua tau raws li qhov nqi nruab nrab. Tsis tas li ntawd xwb, koj tuaj yeem qhia cov ntaub ntawv teev npe rau lub npe thiab tus nqi ntawm cov khoom.
Yog xav paub ntxiv txog lub hwj chim ntawm cov lus nug hauv database, nyeem Tsim cov lus nug yooj yim hauv Microsoft Access 2010.
Cov Ntaub Ntawv Ntxig Cov Ntaub Ntawv
Li ntawd, nyob deb, koj tau nyeem txog cov ntsiab lus tom qab cov txheej xwm hauv cov ntaub ntawv thiab khaws cov ntaub ntawv los ntawm lub database. Koj tseem xav tau cov tswv yim tso rau hauv cov ntxhuav hauv thawj qhov chaw. Microsoft Access muab ob lub tswv yim ua haujlwm los ua kom tiav lub hom phiaj no. Thawj txoj kev yog coj mus rau saum rooj hauv qhov rais los ntawm ob npaug rau ntawm nws. Tom qab ntawd, ntxiv cov ntaub ntawv rau hauv qab ntawm lub rooj, ib yam li koj yuav ntxiv cov ntaub ntawv rau ib qho kev tshaj tawm.
Kev mus saib kuj muab cov ntaub ntawv rau tus neeg siv-phooj ywg. Lub interface pub rau cov neeg siv nkag mus rau hauv cov ntawv graphical thiab muaj cov ntaub ntawv nkag mus rau lub database. Hom no yog qhov tsis txaus ntshai rau cov ntaub ntawv tus neeg teb xov tooj , tab sis yuav tsum tau ua hauj lwm me ntsis ntxiv rau ntawm tus thawj tswj hwm database. Yog xav paub ntxiv, Nyeem Ua Cov Ntawv Hauv Txuas Rau Xyoo 2010
Microsoft Access Reports
Cov ntawv tshaj tawm qhia txog qhov muaj peev xwm tsim cov ntsiab lus ntawm cov ntaub ntawv muaj nyob hauv ib lossis ntau lub rooj thiab cov lus nug. Los ntawm kev siv cov shortcut tricks thiab cov qauv, cov neeg siv kev paub ntaub ntawv muaj peev xwm tsim cov lus qhia hauv ib qho teeb meem ntawm feeb.
Xav tias koj xav tsim ib phau ntawv qhia txog cov khoom siv nrog cov neeg tam sim no thiab cov neeg xav tau. Cov ntaub ntawv no yuav raug muab los ntawm cov ntaub ntawv los ntawm kev siv cov lus nug. Txawm li cas los xij, cov ntaub ntawv muaj nyob rau hauv daim ntawv sau-tsis raws nraim cov khoom siv zoo tshaj plaws. Cov ntaub ntawv tso cai rau kev xam nrog cov duab, kom paub zoo nkauj, thiab pagination. Yog xav paub ntxiv, mus saib Cov Ntawv Tshaj Tawm ntawm Access 2010.