Mmene Mungakhazikitsire Sukulu ya Northwind Sample ku Microsoft Access

Zitsanzo zosungiramo madontho a deta zimakupatsani chiyambi choyamba cha momwe mungagwiritsire ntchito mtundu wina wa fayilo ku Microsoft Access, ndi deta yomwe mwasankha kale.

Ndalama ya Northwind ndiyo maziko a maphunziro ambiri ndi mabuku ogwiritsira ntchito Microsoft Access ndipo ndi chida chodziwika bwino chogwiritsa ntchito ogwiritsa ntchito Microsoft Access.

Mmene Mungakwirire Zina mwa MS Access 2003

Mukaika Microsoft Office Access 2003, chitsanzo cha Access Access chikuikidwa pamodzi ndi icho. Fayilo iyi ya MDB imatchedwa Northwind.mdb , ndipo ntchito ya ADP imatchedwa NorthwindCS.adp .

Nazi momwe mungapezere:

  1. Tsegulani Microsoft Access.
  2. Kuchokera Menyu yothandizira, sankhani Zitsanzo Zamatabuku.
  3. Sankhani Dongosolo la Northwind Sample kuti mutsegule fayilo ya Northwind.mdb .
  4. Ngati mwakhazikitsa Northwind, imatsegula mwamsanga. Ngati iyi ndi nthawi yoyamba yomwe mukugwiritsira ntchito deta, mudzayendetsa polojekitiyi.
  5. Ngati mukulimbikitsidwa kuchita zimenezi, lembani CD Office ya Microsoft yofunsidwa ndi ndondomekoyi.

Pano pali njira yothetsera Northwind sample Access project (file ADP):

  1. Pezani Zothandizira > Zitsanzo Zamatabuku Zitsanzo .
  2. Sankhani Ntchito Yopangitsira Chitsanzo cha Northwind .
  3. Tsatirani ndondomeko zowonjezera zowonekera.

Zindikirani: Malangizo awa ndi a Microsoft Access 2003. Onani Kuika Northwind Sample Database ku MS Access ngati mukugwiritsa ntchito njira yatsopano ya Access.

Kodi North Database ndi chiyani?

Ndalama ya Northwind imatumizidwa kale ndi Microsoft Access 2003 ndipo imachokera ku kampani yonyenga yotchedwa Northwind Traders, yomwe imaitanitsa ndi kutumiza zakudya zapadera padziko lonse lapansi.

Mndandanda wazitsulo uli ndi matebulo abwino kwambiri, mafunso, malipoti, ndi zina zomwe zimakhala ndi deta . Zimaphatikizapo kugulitsa kwa malonda pakati pa kampani ndi makasitomala ake, pamodzi ndi kugula zinthu pakati pa kampani ndi ogulitsa ake.

Masewu awa ali ndi matebulo olemba, maulamuliro, makasitomala, antchito, ndi zina, zomwe ndi njira yabwino yophunzirira zambiri za momwe mungagwiritsire ntchito MS Access.

Mungafune kugwiritsa ntchito deta yanuyi kuti muyesere kupanga mapepala pogwiritsa ntchito tebulo la Malamulo, ndi matebulo ena okhudzana ndi kusanthula kachitidwe chifukwa ali ndi zolemba za zaka zitatu.

Ndi malo osungirako zitsanzo za Northwind, mukhoza kuchita ndi matebulo, mawonekedwe, malipoti , macros, inventory, invoices, ndi VBA modules.

Zochita za Microsoft Access

Microsoft Access imapereka njira yamphamvu kwa makampani ang'onoang'ono kuti azitsata data ndi mapulojekiti. Zimatenga nthawi yochuluka kuphunzira kuposa mapulogalamu ena a Microsoft monga Excel ndi Mawu, komanso zimakulolani kumanga ntchito ndi bajeti, ndikuwonetseratu kukula.

Kufikira kumapangitsa kukhala kosavuta kuyendetsa masati ndi mauthenga otsutsana ndi deta yanu. Ndiponso, imadza ndi ma templates kuti apange njira yogwiritsira ntchito.

Ndi Kupeza, makampani angayang'ane zonse zomwe ali ndi kasitomala, kuphatikizapo kulongosola zambiri, maadiresi, mavoti ndi malipiro. Zapamwamba zimapatsa mapu a aderesi maadiresi kukonzekera maulendo kuti aperekedwe.

Kufikira kumatha kuyang'ana malonda ndi malonda. Ndili ndi makasitomala omwe alipo omwe alipo mumasitomala, Kupeza kumawunikira kutumiza imelo, mapepala, makalata, ndi makalata nthawi zonse pofuna kulimbikitsa malonda kapena malonda apadera.