Microsoft Access ili ndi zigawo zitatu zazikulu: magome, mafunso ndi mafomu
Kampani iliyonse yomwe ili ndi zida zambirimbiri zomwe zimafunikira kufufuza kapena njira yomwe imagwiritsa ntchito mapepala, malemba kapena spreadsheet kuti muzindikire zambiri zofunikira zingapindule mwa kupanga kusintha kwa dongosolo la kasamalidwe ka data. Ndondomeko yachinsinsi monga Microsoft Access 2010 ikhoza kukhala zomwe kampani ikufunikira.
Kodi Chidziwitso N'chiyani?
Pakati pazimenezi, malo osungirako zinthu ndizokusonkhanitsa deta. Dongosolo la kasamalidwe ka deta (DBMS) monga Microsoft Access ikukuthandizani zipangizo zamakono zomwe mukufunikira kuti mugwirizanitse detayo mosavuta. Zimaphatikizapo zipangizo zowonjezera, kusintha ndi kuchotsa deta kuchokera ku databata, funsani mafunso okhudza deta yosungidwa mumasitomalayi ndi kutulutsa malipoti mwachidule zosankhidwa.
Microsoft Access 2010 Components
Microsoft Access 2010 imapereka ogwiritsa ntchito yankho losavuta komanso losinthasintha la DBMS. Ogwiritsa ntchito mankhwala a Microsoft nthawi zonse amayamikira mawonekedwe a mawonekedwe a Windows ndi kumverera komanso kuyanjana kwakukulu ndi zinthu zina za Microsoft Office.
Zitatu mwa zigawo zazikuru za Kupeza komwe anthu ambiri ogwiritsa ntchito mabungwe omwe akugwiritsidwa ntchito pamasamba ali magome, mafunso, ndi mawonekedwe. Ngati mutangoyamba kumene ndi Access ndipo mulibenso malo osungirako zowonjezerako muzonde, werengani za kupanga Creating Access 2010 Database kuchokera ku Scratch.
Matebulo Ndizo Zomangira
Ma tebulo ndizomwe zimakhazikitsidwa mndandanda wamatabwa. Ngati mumadziŵa kale mapepala, mudzapeza tebulo lachinsinsi ndi ofanana. Ma tebulo omwe ali ndi deta akhoza kukhala ndi mauthenga ogwira ntchito, kuphatikizapo zizindikiro monga dzina, tsiku la kubadwa ndi mutu. Chikhoza kukhazikitsidwa motere:
- ID ya ogwira ntchito
- Dzina lomaliza
- Dzina loyamba
- Mutu
- Moni
- Tsiku lobadwa
Penyani ntchito yomanga tebulo ndipo mudzapeza kuti chigawo chilichonse cha tebulo chikugwirizana ndi khalidwe linalake la wogwira ntchito-kapena chidziwitso cha malemba. Mzere uliwonse umagwirizana ndi wogwira ntchito wina ndipo uli ndi chidziwitso chake. Ndizo zonse zomwe zilipo. Ngati izo zithandiza, ganizirani pa tebulo lililonse ngati ndondomeko ya mawonekedwe a spreadsheet.
Mafunso Akutsani Zomwe Mukudziwa
Mndandanda wachinsinsi womwe umangosunga zinthu zokhazokha ungakhale wopanda pake; mukusowa njira kuti mutenge zambiri. Ngati mukungofuna kukumbukira zomwe zili mu tebulo, Microsoft Access ikulolani kuti mutsegule tebulo ndikupyolera m'mabuku omwe ali mkati mwake. Komabe, mphamvu yeniyeni ya deta yapamwamba imakhala ndi mphamvu zowonjezera mafunso ovuta. Mauthenga obwereza amapereka mwayi wophatikizapo data kuchokera pa matebulo angapo ndi malo oyenera pa deta yomwe yatengedwa.
Tangoganizani kuti bungwe lanu likufuna njira yosavuta kupanga mndandanda wa zinthu zomwe zikugulitsidwa panopa pamwamba pa mtengo wawo. Ngati mutangotenga tebulo lamtunduwu, kukwaniritsa ntchitoyi kungafune kuchuluka kwadongosolo kupyolera mu deta ndikupanga kuwerengera ndi dzanja. Komabe, mphamvu ya funsoli imakulolani kuti muzipempha kuti Kupeza kubwererenso zolemba zomwe zikugwirizana ndi chikhalidwe cha mtengo wapamwamba. Kuonjezerapo, mungathe kuphunzitsa mndandanda wachinsinsi kuti mulembe dzina ndi mtengo umodzi wa chinthucho.
Kuti mudziwe zambiri pa mphamvu ya mafunso a m'mabuku a masamba mu Access, werengani Kupanga Funso Losavuta mu Microsoft Access 2010.
Mafomu Alowetsani Mauthenga
Pakalipano, mwawerenga za malingaliro omwe akukonzekera zowonongeka mu deta ndikupeza mfundo kuchokera ku database. Mukufunikirabe njira zowonjezera zowonjezera m'ma tebulo. Microsoft Access imapereka njira ziwiri zoyambirira kukwaniritsa cholinga ichi. Njira yoyamba ndiyo kubweretsera tebulo pawindo podindikiza pawiri. Kenaka, onjezerani zambiri pansi pa tebulo, monga momwe mungaperekere chidziwitso ku spreadsheet.
Kuphatikizanso kumaperekanso mawonekedwe a mawonekedwe abwino. Mawonekedwewa amavomereza ogwiritsa ntchito kuti alowe mu chidziwitso chowonetserako ndikudziwitsani mosapita m'mbali nkhaniyi. Njira iyi ikuwopseza kwambiri munthu woyendetsa deta koma pamafunika ntchito yambiri pa gawo la woyang'anira deta. Kuti mudziwe zambiri, werengani Kupanga Fomu mu Access 2010
Microsoft Access Reports
Malipoti amachititsa kuti apange zidule zochititsa chidwi za deta yomwe ili mu tebulo limodzi kapena zambiri. Kupyolera mukugwiritsa ntchito njira zamakono ndi zizindikiro zamakono, ogwiritsa ntchito mabungwe odziwa zambiri akhoza kupanga malipoti mu mphindi zochepa.
Tiyerekeze kuti mukufuna kupanga kabukhu koti mudziwe zambiri za mankhwala ndi makasitomala omwe alipo komanso omwe akuyembekezera. Zambiri zamtunduwu zikhoza kutengedwa kuchokera ku databata pogwiritsa ntchito mafunso mwanzeru. Komabe, chidziwitsochi chikufotokozedwa mu mawonekedwe apamwamba-osati ndondomeko yokongola kwambiri yogulitsira. Malipoti amalola kulowetsedwa kwa mafilimu, maonekedwe okongola, ndi chikunja. Kuti mudziwe zambiri, onani Creating Reports in Access 2010.