Iifayile zeenkcukacha zesiseko zinika isicwangciso esilungileyo malunga nendlela yokusebenzisa uhlobo oluthile lwefayile kwi-Microsoft Access, kunye neenkcukacha ezisele zikhethwa kuwe.
Isiseko seNorthwind sisiseko seemfundo ezininzi kunye neencwadi ekusebenziseni iMicrosoft Access kwaye ithuluzi lokufunda elithandwayo kubasebenzisi abatsha kwi-Microsoft Access.
Indlela yokufaka i-Database kwi-MS Access 2003
Xa ufaka iMicrosoft Office Access 2003, i-sample sample Access access ifakwe kunye nayo. Le fayile ye- MDB ibizwa ngokuthi iNorthwind.mdb , kunye neprojekthi ye- ADP yiyo ibizwa ngokuba yiNyakathoWindCS.adp .
Nantsi indlela yokuyifumana:
- Vula iMicrosoft Access.
- Ukusuka kwimenyu yoNcedo , khetha iSampuli yolwazi.
- Khetha iDepwind yeSample Database ukuvula ifayile yaseNorthwind.mdb .
- Ukuba usuvele ufake i-Northwind, ivula ngokukhawuleza. Ukuba le yithuba lokuqala usebenzisa i-database, uza kuhamba ngokusebenzisa inkqubo yokufaka.
- Ukuba unyanzelekile ukwenza njalo, faka iMicrosoft Office CD eceliwe ngenkqubo yokufakela.
Nantsi indlela yokufaka isampula ye-Northwind isampula yokufikelela (ifayile ye-ADP):
- Finyelela Uncedo > Imenyu yolwazi lweSampula.
- Khetha Iprojekthi yokuFikelela kweSampula ye-Northwind .
- Landela amanyathelo okufaka kwi-screen.
Qaphela: Le miyalelo yi-Microsoft Access 2003. Bona ukufaka iStatomenti yeSampula yeNorthwind kwi-MS Access ukuba usebenzisa i-version entsha ye-Access.
Yintoni i-Northwind Database?
I-database yaseNorthwind ithupha ngaphambi kokufakwa kwi-Microsoft Access 2003 kwaye isekelwe kwinkampani ekhohlakeleyo egama lingu-Northwind Traders, elithumela ngaphandle nokuthumela ukutya okhethekileyo kwihlabathi jikelele.
Idatha iqulethe iithayibhile ezinkulu, iimbuzo, iingxelo, kunye nezinye iinkcukacha zeenkcukacha . Iquka ukuthengiswa kwentengiso phakathi kwenkampani kunye nabathengi bayo, kunye neenkcukacha zokuthenga phakathi kwenkampani kunye nabathengisi bayo.
Esi sikhululo sinezicwangciso ze-inventory, imiyalelo, abathengi, abasebenzi kunye nokunye, yindlela epheleleyo yokufunda ngakumbi malunga nendlela yokusebenzisa i-MS Access.
Unokufuna ukusebenzisa le nkcukacha efanelekileyo ukuze uzame ukuyila imibuzo usebenzisa itafile zee-Orders, kunye nezinye iitheyibhile ezihambelana nokuhlalutya kohlobo njengoko ziqulethe irekhodi leminyaka emithathu.
Ngomxholo wesampula waseNorthwind, unokuziqhelanisa neetafile, iifom, iingxelo , ii-macros, i-inventory, i-invoyisi kunye ne-modules ze-VBA.
Usetyenziso lweMicrosoft Access
I-Microsoft Access inikezela ngendlela enamandla kwiinkampani ezincinci ukulandelela idatha kunye neeprojekthi. Kuthatha ixesha elingakumbi ukufunda kunezinye iinkqubo zeMicrosoft ezifana ne-Excel kunye neLizwi, kodwa kwakhona kukuvumela ukuba wakhe iiprojekthi kunye nebhajethi, kunye nokubikezela ukukhula.
Ukufikelela kwenza kube lula ukuqhuba iitshathi kunye neengxelo ezichasene nedatha yakho. Ngaphezu koko, kuza neemplates ukwenzela inkqubo yokwenza umsebenzisi.
Nge-Access, iinkampani ziyakwazi ukulandelela lonke ulwazi kubo bonke abathengi, kubandakanywa ulwazi lwe-oda, idilesi, ii-invoyisi kunye neentlawulo. Iimpawu eziphambili zivumela ukuba imephu yamakheli eklayenti ihlele iindlela zokuhambisa.
Ukufikelela kungakujonga ulwazi lokuthengisa nokuthengisa. Ngolwazi olukhoyo lwabaxumi kwi-database, Ukufikelela kwenza kube lula ukuthumela i-imeyile, iiflaya, ii-khononi, kunye neposi ngokukhawuleza ukukhuthaza ukuthengisa okanye izibonelelo ezizodwa.