Nzira yekuisa nayo Northwind Sample Database ku Microsoft Access

Sample database mafaira anokupa mavambo akanaka ekushandisa shanduko yakasiyana yefaira muMicro Access, ine deta yakagadzirirwa iwe.

Nheyo dzeNorthwind ndeye hwaro hwezvidzidzo zvakawanda uye mabhuku pakushandisa Microsoft Access uye inove yakakurumbira yekudzidzira vashandi vatsva ku Microsoft Access.

Nzira yekuisa sei Database mune MS Access 2003

Paunoshandisa Microsoft Office Access 2003, samples Access Access yakaiswa pamwe chete nayo. Iyi faira reMMB inonzi Northwind.mdb , uye chirongwa che ADP ndechokuti inonzi NorthwindCS.adp .

Heino nzira yekuitora nayo:

1. Vhura Microsoft Access.
2. Kubva Muchibatsira menyu, sarudza Sample Databases.
3. Sarudza Northwind Sample Database kuti uzarure file yeNorwind.mdb .
4. Kana iwe watoisa Northwind, inotanga pakarepo. Kana iyi ndiyo nguva yokutanga iwe uri kushandisa dhesiyo, iwe uchave uchifamba nenzira yekugadzirisa.
5. Kana akakurudzirwa kuti uite kudaro, shandisa Microsoft Office CD yakakumbira nenzira yekuisa.

Heino nzira yekuisa nayo Northwind samples Access project (ADP file):

1. Tsvaga rubatsiro > Mifananidzo yeSample database .
2. Sarudza Northwind Sample Access Project .
3. Tevera zvinyorwa zve-screen-screen.

Cherechedza: Mirayiridzo iyi ndeyeMicrosoft Access 2003. Ona Kuisa Northwind Sample Database mu MS Access kana uri kushandisa shanduro itsva ye Access.

Chii Chinonzi Northwind Database?

Nheyo yeNorthwind inotanga kushandiswa mberi neyoMicrosoft Access 2003 kushandiswa uye yakabva kune kambani inonyengera inonzi Northwind Traders, iyo inotengeserana uye inotengesa zvokudya zviduku munyika yose.

Dheedhi yacho ine mimwe mienzaniso yakawanda yematafura, mibvunzo, zvinyorwa, nezvimwe zvinhu zvepa database . Inosanganisira kutengesa kwekutengesa pakati pekambani nevatengi vayo, pamwe chete nemashoko ekutenga pakati pekambani nevatengesi vayo.

Iyi database yakave nematafura ekutsvaga, mairairo, vatengi, vashandi, nezvimwe, iyo inzira yakakwana yekudzidza zvakawanda nezvekushandisa MS Access.

Iwe unogona kushandisa kushandisa iyi dheedheni kuti uedze kugadzira mibvunzo uchishandisa Tafura yeAraders, uye mamwe matafura akafanana ekutsvakurudza kwemaitiro sezvo ane zvinyorwa zvemakore matatu emakore.

Ne database yeNorthwind, iwe unogona kudzidzira nematafura, mafomu, nhoroondo , macros, inventory, invoice, uye VBA modules.

Microsoft Access Uses

Microsoft Access inopa nzira yakasimba yemakambani maduku kutevera data nemapurojekiti. Zvinotora nguva yakawanda kuti udzidze pane dzimwe sangano reMicrosoft seExcel neShoko, asi rinokubvumirawo kuvaka mishonga nemabhajethi, nekufananidzira kukura.

Kuwanika kunoita kuti zvive nyore kumhanya matikiti nemishumo inopesana nedheta rako. Uyezve, inouya neema templates kuita shanduro-user-friendly.

NeAkawana, makambani anokwanisa kutarisa mashoko ose evanhu vose, kusanganisira kurongedza ruzivo, aderesi, invoice uye kubhadhara. Zvinhu zvakagadzirwa nepamusoro zvinobvumira mapikicha evateresi mazita kuti vagadzire migwagwa yekuendesa.

Kutsvaga kunogona kutarisa kutengesa uye kutengesa mashoko. Nekuwanikwa kwekambani yemashoko mu database, Access inoita kuti zvive nyore kutumira email, mapurisa, makonti, uye tsamba nguva dzose kuti ikurudzire kutengesa kana zvipo zvakakosha.