Mus dhau lub ntsiab lus ntawm cov txheej txheem tswj ntaub ntawv, Microsoft Office Access tso cai rau koj kom hloov ntau tus neeg siv kev ua. Koj tuaj yeem tsim daim ntawv thov tag nrho nrog nws. Ib qho ntawm cov khoom siv automation hauv Access yog macros.
Tsim nyog
Microsoft Chaw Nkag Mus
Cov Lus Qhia
Kauj ruam 1
Qhib cov uas twb muaj lawm lossis tsim cov ntaub ntawv tshiab ntawm Microsoft Office Access. Txhawm rau tsim ib qho chaw khaws ntaub ntawv, nias Ctrl + N lossis xaiv qhov "Tshiab …" hauv cov ntawv "File". Hauv vaj huam sib luag "Tsim cov ntaub ntawv" uas tshwm rau sab, nyem rau kab ntawv txuas "Cov ntaub ntawv tshiab …". Xaiv lub npe thiab phau ntawv khaws cia rau cov ntaub ntawv khaws cia hauv "Database Ntaub Ntawv". Nyem rau lub pob "Tshiab". Txhawm rau thauj cov ntaub ntawv uas twb muaj lawm, nyem Ctrl + O lossis xaiv "Qhib …" hauv seem "Cov Ntaub Ntawv" ntawm cov ntawv qhia zaub mov tseem ceeb. Mus rau cov ntawv yuav tsum tau, xaiv lub hauv paus ntawv, nyem khawm "Qhib"
Kauj ruam 2
Hloov mus rau seem kev tswj hwm ntawm lub chaw khaws ntaub ntawv. Ua li no, nthuav cov "Khoom" tab ntawm sab laug vaj huam sib luag thiab nyem rau ntawm cov khoom tsim nyog lossis xaiv "Macros" ntawm cov "Database khoom" ntu ntawm "Saib" cov ntawv qhia zaub mov
Kauj ruam 3
Tsim kev loj heev. Xaiv cov "Macro" rau hauv "Ntxig" seem ntawm cov ntawv qhia zaub mov tseem ceeb lossis nyem rau ntawm "Tshiab" khawm hauv ແຖບ cuab yeej ntawm lub qhov rai pib. Lub Macro Designer lub qhov rai yuav qhib
Kauj ruam 4
Txhais cov npe ntawm kev nqis tes ua los ntawm cov macro. Xaiv hom kev nqis tes ua hauv daim ntawv teev cia ntawm cov khoom hauv kab "Macro" ntawm tus tsim lub qhov rai. Teeb kev xaiv rau cov kev nqis tes no hauv cov kev tswj hwm uas tshwm sim hauv Pawg Tes Haujlwm sib cav
Kauj ruam 5
Txuag tsim macro. Nias Ctrl + S lossis xaiv "Txuag …" los ntawm cov ntawv qhia zaub mov. Sau lub npe rau macro hauv kev sib tham uas tshwm sim. Nyem OK
Kauj Ruam 6
Pib tsim cov ntawv sau hauv Visual Basic yog tias txoj haujlwm ntawm tus tsim macro tsis txaus rau kev daws cov haujlwm ntawm tes. Nias Alt + F11 lossis xaiv Cov Cuab Yeej, Macro, Visual Basic Editor los ntawm cov ntawv qhia zaub mov. Lub qhov rai ib puag ncig kev loj hlob yuav qhib
Kauj Ruam 7
Tsim ib qho qauv tshiab nyob rau hauv qhov project database tam sim no thauj khoom hauv Visual Basic. Xaiv qhov ntxig thiab Module los ntawm cov ntawv qhia zaub mov
Kauj ruam 8
Ua cov haujlwm uas yuav tsum tau ua. Ntxiv cov cai uas yuav tsum muaj rau lub qhov rais nrog cov ntawv sau ntawm cov qauv tsim
Kauj Ruam 9
Txuag tus qauv. Nias Ctrl + S lossis xaiv Txuag los ntawm Cov Ntawv Qhia File. Kaw qhov Visual Basic Editor. Yog tias tsim nyog, hu rau module ua haujlwm los ntawm macro.
