Ndi imodzi mwamapulogalamu osadziwika bwino muofesi ya Microsoft 365, ngakhale idaphatikizidwa kuyambira mtundu wa 1992. Komabe, ndi chida zothandiza kwambiri. Mu positi iyi, tikufotokoza momwe tingagwiritsire ntchito. Kodi Microsoft Access ndi chiyani ndipo ndi chiyani?.
Mtundu waposachedwa kwambiri wa Microsoft Access, yomwe ndi yomwe tikambirana pano, idatulutsidwa pa Okutobala 5, 2021, kuti igwiritsidwe ntchito Windows 10 ndi Windows 11. Zimatengera pakati pa 44 MB ndi 60 MB ya hard drive space, kutengera zosankha zomwe zasankhidwa.
Kodi Microsoft Access ndi chiyani?
Microsoft ndi a kasamalidwe ka database Kuphatikizidwa mu Microsoft Office suite of applications (tsopano Microsoft 365). Ndi chida chothandizira ogwiritsa ntchito kupanga ndi kuyang'anira nkhokwe zosungira, kukonza, ndi kusanthula zambiri.
Chifukwa chomwe pulogalamuyi imagwiritsidwira ntchito pang'ono makamaka chifukwa chakuti zothandiza zake sizidziwika. Ogwiritsa ntchito ambiri amakhulupirira molakwika kuti chilichonse chomwe chachitika ndi Access chingathe kuchitidwa Excel.
Ngakhale ndizowona kuti mapulogalamu onsewa ali ndi mfundo zofanana, Excel ndiyoyenera kugwiritsa ntchito manambala komanso kuwerengera pa datayo. Kufikira, kumbali ina, imawonjezera luso lapadera ndikuphatikiza ntchito zinazake zoyang'anira mitundu yosiyanasiyana ya data. Kuphatikiza apo, imakupatsani mwayi woletsa ogwiritsa ntchito omwe amalowa m'gawo lililonse, komanso kulumikiza deta yokhudzana ndi matebulo angapo.
Ma database osungidwa ndi Microsoft Access amawonetsa fayilo yowonjezera «.accdb». Ngakhale izi ndizofala kwambiri komanso zaposachedwa kwambiri, ndizotheka kupeza zowonjezera zina («.mdbe» o «.mde»), zomwe zimagwirizana ndi matembenuzidwe asanafike 2007. Nthawi zina, kuti atsegule zowonjezera zamtunduwu, wogwiritsa ntchito ayenera kugwiritsa ntchito chida chosinthira kuti asinthe kukhala ".accdb».
Zinthu zomwe tingachite ndi Access
Kodi mungagwiritse ntchito bwanji Access kuyang'anira database? M'munsimu, tikufotokozera zina mwazochita zofala zomwe mungathe kuchita ndi chida ichi.
Pangani database
Pazenera lakunyumba la Access, dinani "Fayilo" ndikusankha "Chatsopano" kumanzere kwa zosankha. Pazosankha zosiyanasiyana zomwe zikuwonetsedwa pazenera, sankhani yomwe ili "Zatsopano." "Blank Desktop Database".
Nawonso database yomwe yangopangidwa kumeneyi ikhoza kupatsidwa dzina ngati chofunikira kuti mupeze ndikugwiritsa ntchito template yatsopano.
Pangani tebulo
Kuti muwonjezere tebulo la data ku database yomwe tapanga, muyenera kupita ku riboni yachida ndikudina pa tabu "Table". Mutha kuwonjezera magawo ambiri momwe mukufunira patebulo latsopanoli. Kuti muchite izi, dinani kumanja ndikusankha njirayo Dinani kuti muwonjezere.
Gawo la bokosi la combo limagwiritsidwa ntchito kutchula mitundu yosiyanasiyana ya data yomwe ingaperekedwe kumunda (mu Access ndizovomerezeka kupatsa mtundu wa data kumunda uliwonse).
Onjezani deta patebulo
Pali njira zambiri zowonjezera deta pa tebulo la Access: kugwiritsa ntchito mawonekedwe, kuitanitsa deta kuchokera ku fayilo yakunja, pogwiritsa ntchito SQL, kapena kulowetsa deta mwachindunji (ie, pamanja). Njira yodziwika kwambiri ndi lowetsani kudzera pamafayilo ".csv". Umu ndi momwe mumachitira:
- Mu riboni ya chida, dinani «Zida zakunja».
- Kenako timadina "Fayilo yolemba".
- Kenako timasankha fayilo yoyambira ndi tebulo lomwe tikupita.
- Tisanapitilize kuitanitsa, titha kuwunikanso tsatanetsatane wa fayilo (kugwiritsa ntchito nthawi kapena ma koma monga zowerengera, ndikofunikira kusiya magawo ena).
- Pomaliza, dinani batani "Kumaliza" kuyendetsa katundu.
Kuchokera apa, pali zambiri zomwe titha kuchita mukugwiritsa ntchito ndi matebulo osiyanasiyana omwe talowa. Mwachitsanzo, n’zotheka kupanga mgwirizano pakati pa matebulo kufunsa deta kuchokera kumatebulo osiyanasiyana. Mukhozanso kupanga a tebulo loyang'ana, yomwe ili ndi deta yotchulidwa ndi tebulo lina, kapena kupanga mafunso ovuta pamatebulo angapo okhala ndi mitundu yosiyanasiyana ya data.
Zochita zina zotheka ndi kupanga zosunga zobwezeretsera, pangani nkhokwe zomwe zingagwiritsidwe ntchito (zomwe ogwiritsa ntchito akunja sangathe kuzisintha) kupanga macro kukonza ntchito zovuta kapena kutumiza deta ku Excel, mwa zina zambiri.
Kuti muchite zonsezi, Microsoft Access imaphatikizapo ntchito wothandizira zomwe mosakayikira ndizothandiza kwambiri kwa omwe amagwiritsa ntchito pulogalamuyi koyamba.
Pomaliza
Microsoft Access ndi njira yovomerezeka kwambiri yamabizinesi ang'onoang'ono ndi apakatikati omwe amafunikira chida chosavuta komanso chosavuta kugwiritsa ntchito kasamalidwe ka data. Zoyenera kuchita monga gkasamalidwe ka zinthu kapena kutsatira polojekiti. Pazochitika zonsezi, ndikofunikira kuphunzira momwe mungagwiritsire ntchito.
Mkonzi wokhazikika pazaukadaulo komanso nkhani zapaintaneti yemwe ali ndi zaka zopitilira khumi pazama media osiyanasiyana. Ndagwira ntchito ngati mkonzi komanso wopanga zinthu pa e-commerce, kulumikizana, kutsatsa pa intaneti ndi makampani otsatsa. Ndalembanso pamawebusayiti azachuma, azachuma ndi magawo ena. Ntchito yanga ndi chidwi changanso. Tsopano, kudzera mu zolemba zanga mu Tecnobits, Ndimayesetsa kufufuza nkhani zonse ndi mwayi watsopano umene dziko laukadaulo limatipatsa tsiku lililonse kuti tisinthe miyoyo yathu.