I-Microsoft Access inezixhobo ezintathu eziphambili: itafile, imibuzo kunye neefom
Nayiphi na inkampani ephazamiseke yimininzi yedata efuna ukulandelwa okanye inkqubo esebenzisa iphepha lokubhala iphepha, iimpepha zetekisi okanye ispredishithi ukugcina umkhondo wenkcazelo ebalulekileyo inokuzuza xa wenza utshintsho kwinkqubo yolawulo lweenkcukacha. Inkqubo yesiseko sedatha njengoMicrosoft Access 2010 ingaba yinto efunekayo yinkampani.
Yintoni iDatabase?
Kwinqanaba elisisiseko, isiseko sedatha eqokelelweyo yolwazi. Inkqubo yokulawulwa kwedatha (iDBMS) efana ne-Microsoft Access ikubonelela ngezixhobo zesoftware ozifunayo ukulungiselela loo datha ngendlela eguquguqukayo. Iquka izixhobo zokongeza, ukuguqula nokususa idatha kwi-database, ubuze imibuzo malunga nedatha egciniweyo kunye nokuvelisa iingxelo zishwankathela okuqukethwe okukhethiweyo.
Microsoft Access 2010 Izixhobo
I-Microsoft Access 2010 inikezela abasebenzisi ngesisombululo seDBMS esilula kunye neziguquguqukayo. Abasebenzisi abaqhelekileyo beMicrosoft baxabisa ukubukeka kweWindows kunye nokuziva kunye nokuhlanganiswa ngokuqinile kunye nezinye iimveliso zentsapho yaseMicrosoft.
Amathathu eenxalenye eziphambili zoFikelelo apho abaninzi abasebenzisi beenkcukacha zeenkcukacha zidibeneyo ziingcongolo, imibuzo kunye neefom. Ukuba uqala nje ngoFumanelo kwaye ungenayo isiseko sokufikelela kwi-Inthanethi, funda malunga nokudala iData yeDiskritha ye-2010 kwi-Scratch.
Iifayile ZiyiBloko zokwakha
Iifayili zezibhloko zokwakha ezisisiseko naluphi na ulwazi. Ukuba uyazazi ama-spreadsheets, uza kufumana iithebula zeenkcukacha ezifanayo. Itafile egciniweyo yedata ingaqulethe ulwazi lomqeshwa, kuquka iimpawu ezifana negama, umhla wokuzalwa kunye nesihloko. Inokuthi ihlelwe ngolu hlobo lulandelayo:
- I-ID yomqeshwa
- Ifani
- Igama lokuqala
- Isihloko
- U buliso
- Usuku lokuzalwa
Hlola ukwakhiwa kwetafile uze ufumane ukuba ikholomu nganye yetafile ihambelana nomsebenzi othile-okanye umxholo kwimigangatho yolwazi. Umqolo ngamnye uhambelana nomqeshwa othile kwaye uqulethe ulwazi lwakhe. Kukho konke okukuyo. Ukuba kunceda, cinga ngetafile nganye njengoluhlu lwesipredishithi soluhlu lweenkcukacha.
Imibuzo Ukufumana ulwazi
Idatha egciniweyo egcina ulwazi kuphela ayiyi kuba ncedo; ufuna iindlela zokufumana ulwazi ngokunjalo. Ukuba ufuna ukukhumbula ulwazi olugcinwe kwitheyibhile, iMicrosoft Access ikuvumela ukuba uvule itafile uze uphewule kwiirekhodi ezikulo. Nangona kunjalo, amandla okwenene egciniweyo akwazi ukuphendula imibuzo enzima. Imibuzo yokufikelela inikezela amandla okudibanisa idatha ukusuka kwiitheyibhile ezininzi kunye neemeko ezithile kwi-data efunyenwe.
Khawucinge ukuba inhlangano yakho idinga indlela elula yokwenza uluhlu lwezo zinto zithengisa ngaphezu kwexabiso lawo eliqhelekileyo. Ukuba ufumana kuphela itafile yolwazi lomveliso, ukuzalisekisa lo msebenzi kuya kufuna umlinganiselo omkhulu wokuhlenga idatha kunye nokwenza izibalo ngesandla. Nangona kunjalo, amandla ombuzo uvumela ukuba ucele ukuFikelela ukubuyisela kuphela ezo rekhodi ezidibana nomgangatho wexabiso ophezulu. Ukongezelela, unokuyalela i-database ukuba ubhale kuphela igama kunye nexabiso leyunithi yento.
Ukufumana ulwazi oluthe xaxa ngamandla eenkcukacha zeenkcukacha kwi-Access, funda Ukudala Umbuzo Olula kwi-Microsoft Access 2010.
Ifomu Ukufaka iNgcaciso
Kuze kube ngoku, ufunde malunga neengcinga emva kokuhlela ulwazi kwiziko lokugcina kunye nokufumana ulwazi oluvela kwisiseko sedatha. Usadinga iindlela zokubeka ulwazi kwitafile kwindawo yokuqala. I-Microsoft Access inikezela iindlela ezimbini eziphambili zokuphumeza le njongo. Indlela yokuqala ukuvelisa itafile kwifestile ngokuchofoza kabini kuyo. Emva koko, faka ulwazi kwizantsi kwetafile, njengokuba ungeze ulwazi kwi-spreadsheet.
Ufikelelo lukwabonelela ngolwazi olufanelekileyo lomsebenzisi. I-interface ivumela abasebenzisi ukungenisa ulwazi kwifom yesalathisi kwaye babe nolwazi oludlulileyo kwi-database. Le ndlela ayisabisi kakhulu kumsebenzisi wokungena kwedatha kodwa idinga umsebenzi omncinci kwinqanaba lomlawuli wedatha . Ukufumana ulwazi oluthe vetshe, funda Ukudala iiFomu kwi-2010
IMicrosoft Access Reports
Iingxelo zinika amandla okuvelisa izishwankathelo ezifomathiweyo ezichanekileyo zedatha equlethwe kwelinye okanye ngaphezulu kweetable nemibuzo. Ngokusebenzisa iindlela zobuqhetseba kunye neetemplates, abasebenzisi beenkcukacha zobungakwazi ukudala iingxelo kwimizuzu embalwa.
Cinga ukuba ufuna ukuvelisa ikhathalogu ukwabelana ngolwazi ngemveliso kunye nabaxhamli bangoku kunye nabathengi. Olu hlobo lwazi lungasuswa kwiziko ledatha ngokusetyenziswa ngokufanelekileyo kwemibono. Nangona kunjalo, ulwazi lubekwe kwifom yefomula-kungeyona into ebalulekileyo yokuthengisa. Iingxelo zivumela ukuba kufakwe imifanekiso, ukufometha okukhangayo kunye nokuhedeni. Ukufumana ulwazi oluthe vetshe, funda Ukudala iiNgxelo kwi-Access 2010.