Ib qho Taw Qhia rau Cov Ntaus thiab Cov Qauv
Puas yog koj ntxhov siab los ntawm ntau qhov ntau ntawm cov ntaub ntawv uas yuav tsum tau muab khaws cia hauv koj lub koom haum? Tej zaum koj tab tom siv cov ntawv ua cov ntaub ntawv, cov ntaub ntawv los sis daim ntawv khom nqi kom thiaj li khiav tau koj cov ntaub ntawv tseem ceeb. Yog tias koj tab tom nrhiav kev yooj yim dua cov ntaub ntawv tswj xyuas, ib tug database tej zaum yuav yog qhov kev cawmdim uas koj tab tom nrhiav thiab Microsoft Access 2013 muab kev xaiv zoo.
Dab tsi yog qhov Database?
Nyob rau theem pib tshaj plaws, cov ntaub ntawv tsuas yog cov ntaub ntawv khaws tseg. Ib qhov system tswj system (DBMS) xws li Microsoft Access, Oracle los sis SQL neeg rau zaub mov muab koj nrog cov software cov cuab yeej koj yuav tsum tau npaj cov ntaub ntawv no kom txhij txhua. Nws suav cov chaw los ntxiv, hloov kho lossis rho tawm cov ntaub ntawv ntawm database, nug cov lus nug (lossis lus nug) txog cov ntaub ntawv khaws tseg hauv cov ntaub ntawv khaws tseg thiab tsim cov lus qhia txog cov ntsiab lus xaiv.
Microsoft Access 2013
Microsoft Access 2013 muab cov neeg siv nrog ib qho nyuaj thiab feem ntau yooj yim DBMS daws rau lub khw hnub no. Cov neeg siv Microsoft cov khoom siv yuav tau txais kev zoo siab thiab paub zoo nrog rau kev sib xyaw nrog lwm Microsoft Office family khoom. Yog xav paub ntxiv rau txoj kev Access 2010, nyeem peb cov neeg siv 2013 Cov Kev Siv Hauv Chaw Tshawb Xyuas .
Cia peb kuaj thawj zaug peb ntawm cov Cheeb Tsam Khoom Txuj Ci uas feem ntau cov neeg siv database yuav ntsib - ntxhuav, queries, thiab cov ntawv. Yog tias koj tsis tau muaj cov ntaub ntawv Access, koj tuaj yeem xav nyeem txog Tsim Kev Tshawb Nrhiav 2013 Database los ntawm Tsib lossis Tsim Kev Tshaj Tawm Ntawm Database los ntawm Template.
Microsoft Access Ntxhuav
Ntxhuav muaj cov qauv tsev ntawm cov database. Yog hais tias koj paub nrog spreadsheets, koj yuav pom cov rooj database zoo heev.
Cov ntaub ntawv ntau lub ntsiab lus yuav muaj cov neeg ua haujlwm cov ntaub ntawv, 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 tias txhua kem ntawm lub rooj sib raug zoo rau ib tus neeg ua haujlwm tus cwj pwm (los yog tus cwj pwm hauv cov ntsiab lus ntawm cov ntaub ntawv). 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 yam ntawm cov rooj ntawv no ua ib qho kev tshaj tawm cov ntawv xov xwm. Yog xav paub ntxiv, nyeem Ntxiv Cov Ntxig rau Kev Nkag Mus Rau Ib Ntej 2013
Rov Muab Cov Ntaub Ntawv los ntawm Access Access Database
Obviously, ib qho database uas tsuas khaws cov ntaub ntawv yuav tsis muaj txiaj ntsig - peb xav tau txoj kev los muab cov ncauj lus thiab. 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 zog ntawm ib tug database lies nyob hauv nws cov peev xwm los teb ntau txoj kev thov, los yog 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 tias koj tsuas tau 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 kev ua yog suav los ntawm tes. Txawm li cas los xij, lub hwj chim ntawm cov lus nug tau tso cai rau koj tsuas thov kom Access tsuas xa cov ntaub ntawv uas muaj raws li qhov nqi nruab nrab hauv nruab nrab. Tsis tas li ntawd, koj tuaj yeem qhia cov ntaub ntawv cia kom tsuas sau lub npe thiab tus nqi ntawm cov khoom.
Yog xav paub ntxiv txog lub hwjchim ntawm cov lus nug hauv database, nyeem Tsim cov lus nug yooj yim hauv Microsoft Access 2013.
Inserting Cov Ntaub Ntawv rau hauv Access Access Database
Li ntawd, nyob deb, koj twb kawm cov ntsiab lus tom qab cov ntaub ntawv nyob rau hauv ib qho chaw thiab khaws cov ntaub ntawv los ntawm ib tug database. Peb tseem xav tau cov tswv yim los muab cov lus qhia rau hauv cov rooj 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 kom coj lub rooj rau hauv lub qhov rais los ntawm ob-nias rau nws thiab ntxiv cov ntaub ntawv mus rau hauv qab ntawm nws, ib yam li ib tug xav ntxiv cov ntaub ntawv rau ib qho kev tshaj tawm.
Kev nkag tau kuj muaj kev sib txuas lus rau cov neeg siv uas cia cov neeg nkag mus rau hauv daim graphical daim ntawv 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 Cov Ntawv Sau Txog Cov Ntawv Nkag Rau Hauv 2013
Microsoft Access Reports
Cov ntawv tshaj tawm qhia qhov muaj peev xwm ua tau sai sai tsim cov ntsiab lus muaj nyob hauv ib los yog ntau lub rooj thiab / los yog kev nug. Los ntawm kev siv cov shortcut tricks thiab templates, cov neeg siv cov ntaub ntawv tuaj yeem tsim cov lus qhia hauv cov ntsiab lus 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. Nyob rau hauv tshooj dhau los, peb tau kawm tias cov ntaub ntawv no yuav raug muab rov qab los ntawm peb cov ntaub ntawv los ntawm kev siv cov lus nug. Txawm li cas los xij, nco qab tias cov ntaub ntawv no tau muab tso rau hauv ib daim ntawv hauv daim ntawv - tsis raws nraim cov khoom zoo tshaj plaws li cas! Cov ntaub ntawv tso cai rau kev xam nrog cov duab, cov kev ua kom zoo nkauj thiab cov pagination. Yog xav paub ntxiv, mus saib Cov Ntaub Ntawv Qhia Txog Kev Nkag Mus Rau Hauv 2013.