Indlela yokufaka i-Northwind Sample Database ku-Microsoft Access

Amafayela wesisekelo wesampula akunikeza ukuqala okuhle ukuthi ungasebenzisa kanjani uhlobo oluthile lwefayela ku-Microsoft Access, nolwazi olukhethwe kakade kuwe.

I-database ye-Northwind iyisisekelo samathuluzi amaningi nezincwadi zokusebenzisa i-Microsoft Access futhi iyithuluzi lokufunda elithandwayo kubasebenzisi abasha ku-Microsoft Access.

Indlela yokufaka i-Database ku-MS Access 2003

Uma ufaka iMicrosoft Office Access 2003, isampula yokufinyelela yeSampula ifakiwe kanye nayo. Le fayela ye- MDB ibizwa ngokuthi i- Northwind.mdb , futhi iphrojekthi ye- ADP ingokwama- NorthwindCS.adp .

Nakhu ukuthi ungayithola kanjani:

  1. Vula i-Microsoft Access.
  2. Kusukela kwimenyu yosizo , khetha Amamodeli eSebenzi.
  3. Khetha i- Northwind Sample Database ukuze uvule ifayela le- Northwind.mdb .
  4. Uma usuvele ufake i-Northwind, ivula ngokushesha. Uma ngabe okokuqala usebenzisa i-database, uzobe uhamba ngezinqubo zokufaka.
  5. Uma ucelwa ukuba wenze kanjalo, faka i-Microsoft Office CD eceliwe ngenqubo yokufaka.

Nansi indlela yokufaka iphrojekthi ye-Northwind yesipiliyoni sokufinyelela (ifayela le-ADP):

  1. Finyelela imenyu ye- Help > Sampula yolwazi .
  2. Khetha iphrojekthi yokufinyelela yesampula ye-Northwind .
  3. Landela izinyathelo zokufaka esibukweni.

Qaphela: Le miyalo i-Microsoft Access 2003. Bheka Ukufaka i-Northwind Sample Database ku-MS Access uma usebenzisa inguqulo entsha yokuFinyelela.

Iyini Database Database Northwind?

I-database yaseNorthwind ihambisa ngaphambi kokufakwa ngohlelo lokusebenza lwe-Microsoft Access 2003 futhi isekelwe enkampanini ekhohlisayo okuthiwa i-Northwind Traders, engenisa futhi ithumela ukudla okukhethekile emhlabeni jikelele.

I-database iqukethe amatafula amakhulu, isampula, imibiko, kanye nezinye izici ze- database . Ihlanganisa ukuthengiswa kwempahla phakathi kwenkampani namakhasimende ayo, kanye nemininingwane yokuthenga phakathi kwenkampani nabathengisi bayo.

Le database nayo inezibhebhe zokusungula, imiyalo, amakhasimende, abasebenzi, nokunye, okuyindlela ephelele yokufunda kabanzi mayelana nendlela yokusebenzisa i-MS Access.

Ungase ufune ukusebenzisa lolu datha oluthile ukuze uhlole imibuzo yokuklama usebenzisa ithebula le-oda, namanye amatafula ahlobene wokuhlaziywa komkhuba ngoba aqukethe amarekhodi enkathi yeminyaka emithathu.

Ngedatha yesampula yaseNorthwind, ungazisebenzisa ngamatafula, amafomu, imibiko , ama-macros, yokusungula, ama-invoyisi, nama-module we-VBA.

Ukusetshenziswa kwe-Microsoft Access

I-Microsoft Access inikeza indlela enamandla ezinkampani ezincane ukulandelela idatha namaphrojekthi. Kuthatha isikhathi esiningi ukufunda kunezinye izinhlelo ze-Microsoft ezifana ne-Excel ne-Word, kodwa futhi kukuvumela ukuba wakhe amaphrojekthi namabhajethi, nokukhula okubikezelayo.

Ukufinyelela kwenza kube lula ukuqhuba amashadi nemibiko ngokumelene nedatha yakho. Futhi, kuza nezifanekiso ukuze wenze inqubo-yomsebenzisi ibe mnandi.

Nge-Access, izinkampani zingalandelela lonke ulwazi lwawo wonke amaklayenti, kufaka phakathi ulwazi lwe-oda, amakheli, ama-invoyisi kanye nezinkokhelo. Izici ezithuthukisiwe zivumela ukumezwa kwamakheli amaklayenti ukuhlela imizila yokudiliva.

Ukufinyelela kungaphawula ulwazi lokuthengisa nokuthengisa. Ngolwazi lwamakhasimende olukhona ku-database, Ukufinyelela kwenza kube lula ukuthumela i-imeyili, amaflaya, amakhuphoni, kanye neposi ejwayelekile ukukhuthaza ukuthengisa noma okunikezwayo okukhethekile.