Isingeniso Sezici Nezidingo
Ingabe udangele idatha enkulu eningi okumele ilandelwe enhlanganweni yakho? Mhlawumbe okwamanje usebenzisa uhlelo lokubhala iphepha, imibhalo yombhalo noma ispredishithi ukuze ulandele ulwazi lwakho olubucayi. Uma ufuna isistimu yokuphathwa kwedatha eguquguqukayo, i-database ingaba insindiso nje oyifunayo ne-Microsoft Access 2013 inikeza inketho enhle kakhulu.
Iyini i-Database?
Ezingeni eliyisisekelo, i-database imane nje iqoqo leqoqo lemininingwane. Uhlelo lwezokuphathwa kwedatha (i-DBMS) njenge-Microsoft Access, i-Oracle noma i- SQL Server inikeza ngamathuluzi esofthiwe okudingayo ukuhlela leyo datha ngendlela eguquguqukayo. Ihlanganisa izindawo zokwengeza, ukuguqula noma ukususa idatha kusuka ku-database, ubuze imibuzo (noma imibuzo) mayelana nedatha egciniwe bese uveza imibiko efingqa okuqukethwe okukhethiwe.
I-Microsoft Access 2013
I-Microsoft Access 2013 inikeza abasebenzisi ngesinye sezixazululo ezilula kakhulu neziguquguqukayo ze-DBMS emakethe namuhla. Abasebenzisi abavamile beMicrosoft bazojabulela ukubuka okujwayelekile kweWindows nokuzizwa kanye nokuhlanganiswa okuqinile nezinye imikhiqizo yomndeni waseMicrosoft. Ukuze uthole okwengeziwe kubonakala ku-Access 2010, funda Ukufinyelela Kwangaphakathi Kwama-User Yethu ka- 2013 .
Masiqale sihlole ezintathu zezingxenye ezinkulu zokufinyelela ezizohlangana nabasebenzisi abaningi basebenzi-amatafula, imibuzo kanye namafomu. Uma ungenayo i-database yokufinyelela, ungase ufune ukufunda ngokudala i-Database Access ye-2013 kusuka ku-Scratch noma Ukudala Idatha yokufinyelela ye-2013 kusuka kwisifanekiso.
I-Microsoft Access Tables
Amathebula ahlanganisa izakhiwo ezibalulekile zedatha yolwazi. Uma ujwayele amaspredishithi, uzothola amatafula egciniwe egciniwe kakhulu.
Ithebula le- database elivamile lingase liqukethe ulwazi lomsebenzi, kufaka phakathi izici ezinjengegama, usuku lokuzalwa nesihloko. Kungase ihlelwe kanje:
- I-ID yomsebenzi
- Isibongo
- Igama
- Isihloko
- Ukubonga
- Usuku lokuzalwa
Hlola ukwakhiwa kwetafula futhi uzothola ukuthi ikholomu ngayinye yetafula ihambelana nesici esithile somsebenzi (noma umphumela wemigomo yedatha). Umugqa ngamunye uhambelana nesisebenzi esisodwa futhi uqukethe ulwazi lwakhe. Yilokho okukhona kulokho! Uma kusiza, cabanga ngalunye lwalezi zibhebhe njengendlela yokwaziswa kwesitayela sesipredishithi. Ukuze uthole ulwazi oluthe xaxa, funda Ukungeza Ithebula ku-Idatha yokufinyelela ku-2013
Ukubuyiswa kolwazi kusuka ku-Database yokufinyelela
Ngokusobala, i-database egciniwe kuphela ilwazi ngeke ibe usizo - sidinga izindlela zokuthola ulwazi kanye. Uma ufuna ukukhumbula imininingwane egcinwe etafuleni, i-Microsoft Access ikuvumela ukuvula ithebula bese upheqa kumarekhodi akhona ngaphakathi kwalo. Noma kunjalo, amandla angempela e-database asemandleni akhe ukuphendula izicelo eziyinkimbinkimbi, noma imibuzo. Imibuzo yokufinyelela ihlinzeka ikhono lokuhlanganisa idatha kusuka kumatafula amaningi nokubeka izimo ezithile idatha ebuyisiwe.
Cabanga ukuthi inhlangano yakho idinga indlela elula yokwakha uhlu lwazo imikhiqizo okwamanje edayisa ngaphezu kwentengo yabo ejwayelekile. Uma uvele ususe ithebula lwazi lomkhiqizo, ukufeza lo msebenzi kungadinga inani elikhulu lokuhlunga idatha bese wenza izibalo ngesandla. Noma kunjalo, amandla ombuzo ikuvumela ukuba umane ucele ukuthi Ukufinyeleleka kuphela ukubuyisela lawo marekhodi ahlangabezana nesimo sezinga eliphezulu lesilinganiso. Ukwengeza, ungafundisa i-database ukuthi ihlule kuphela uhlu lwamanani neyunithi yento.
Ukuze uthole ulwazi oluthe xaxa emandleni emininingwane yedatha ekufinyeleleni, funda Ukudala Umbuzo Olula Ku-Microsoft Access 2013.
Ukufaka Ulwazi ku-Database Yokufinyelela
Kuze kube manje, ufunde imiqondo ngemuva kokuhlelwa kolwazi ku-database futhi uthola ulwazi oluvela ku-database. Sisadinga izindlela zokubeka ulwazi ematafuleni kuqala! I-Microsoft Access inikeza izindlela ezimbili eziyinhloko zokufeza lo mgomo. Indlela yokuqala ukumane ukhulise ithebula efasiteleni ngokuchofoza ngokuphindwe kabili kuwo futhi ungeze ulwazi phansi, njengoba nje umuntu engeza ulwazi kwipredishithi.
Ukufinyelela futhi kunikeza isikhombimsebenzisi esibonakalayo somsebenzisi esivumela ukuthi abasebenzisi bangene ulwazi efomini lesithombe esibonakalayo futhi babe nolwazi oludlulele ku-database. Le ndlela ayesabisa kakhulu umsebenzisi we- data entry kodwa idinga umsebenzi omncane engxenyeni yomlawuli wedatha . Ukuze uthole olunye ulwazi, funda Ukudala Amafomu Ekufinyeleleni ku-2013
I-Microsoft Access Reports
Imibiko inikeza amandla okukhiqiza ngokushesha izifinyezo ezihlelwe kahle zedatha equkethwe kwelinye lamatafula kanye / noma imibuzo. Ngokusebenzisa izinkomba nezinqamuleli zokuncishiswa, abasebenzisi be-database bangadala imibiko ngoqobo ngokoqobo imizuzu yamaminithi.
Ake sithi ufuna ukukhiqiza ikhathalogu ukwabelana ngolwazi lomkhiqizo namakhasimende anamanje nalabo abazoba khona. Ezingxenyeni ezedlule, safunda ukuthi lolu hlobo lwolwazi lungasuswa kusuka ku-database yethu ngokusebenzisa ukuhlakanipha kwemibono. Noma kunjalo, khumbula ukuthi lolu lwazi lunikezwe ngefomu le-tabular - hhayi ngqo into ekhangayo kakhulu yokuthengisa! Imibiko ivumela ukufakwa kwehluzo, ukufometha okuthakazelisayo nokuhlukunyezwa. Ukuze uthole olunye ulwazi, bheka Ukudala Imibiko Ekufinyeleleni 2013.