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:
- Vula i-Microsoft Access.
- Kusukela kwimenyu yosizo , khetha Amamodeli eSebenzi.
- Khetha i- Northwind Sample Database ukuze uvule ifayela le- Northwind.mdb .
- Uma usuvele ufake i-Northwind, ivula ngokushesha. Uma ngabe okokuqala usebenzisa i-database, uzobe uhamba ngezinqubo zokufaka.
- Uma ucelwa ukuba wenze kanjalo, faka i-Microsoft Office CD eceliwe ngenqubo yokufaka.
Nansi indlela yokufaka iphrojekthi ye-Northwind yesipiliyoni sokufinyelela (ifayela le-ADP):
- Finyelela imenyu ye- Help > Sampula yolwazi .
- Khetha iphrojekthi yokufinyelela yesampula ye-Northwind .
- 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.