Isingeniso kwiMpawu kunye neziNqobo
Ngaba ugxininiswe yimininzi yedata efuneka ukuba ilandelwe kwintlangano yakho? Mhlawumbi ngoku usebenzisa iphepha lokufakela iphepha, iimpepha zombhalo okanye ispredishithi ukuze ulandele ulwazi lwakho olubalulekileyo. Ukuba ufuna i-system management management system, i-database ingaba yintsindiso oyifunayo kwaye iMicrosoft Access 2013 inika ithuba elihle.
Yintoni iDatabase?
Kwinqanaba elisisiseko, i-database imele iqokelele idatha eqokelelweyo. Inkqubo yokulawulwa kwedatha (iDBMS) njenge-Microsoft Access, i-Oracle okanye i- SQL Server ikunikezela ngezixhobo zesoftware ozifunayo ukulungiselela loo datha ngendlela eguquguqukayo. Iquka izixhobo zokudibanisa, ukuguqula okanye ukususa idatha kwi-database, ubuze imibuzo (okanye imibuzo) malunga nedatha egcinwe kwiziko ledatha kwaye ivelise iingxelo ngokufingqa izinto ezikhethiweyo.
Microsoft Access 2013
I-Microsoft Access 2013 inikezela abasebenzisi esinye sezixazululo ezilula kunye neziguquguqukayo zeDBMS kwimarike namhlanje. Abasebenzisi abaqhelekileyo bemveliso yeMicrosoft baya kuvuyela i-Windows ebonakalayo ebonakalayo kunye nokuziva kunye nokudibanisa ngokufanayo kunye nezinye iimveliso zeentsapho ze-Microsoft Office. Ukufumana okungakumbi kwi-interface ye-Access 2010, funda ukuTyelela kwaBasebenzisi be-Interface yo-2013 .
Masiqale sihlole ezintathu zezona zinto ziyinxalenye yoFikelelo oluninzi lwabasebenzisi beenkcukacha eziza kubonisana nazo-ithala, imibuzo kunye neefom. Ukuba awunayo i-database yokufikelela, unokufuna ukufunda malunga nokudala iDatabase ye-Access 2013 ukusuka kwiSkratch okanye Ukudala iData ye-2013 yokuThola kwiSifanekiso.
IMicrosoft Access Tables
Iifayile ziquka iibhloko zokwakha ezisisiseko naluphi na ulwazi. Ukuba uyazazi ama-spreadsheet, uza kufumana iithebula zeenkcukacha ezifanayo.
Itafile egciniweyo ye-database ingabandakanya 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 okukho kuyo! Ukuba kunceda, cinga ngalunye lwetafile njengoluhlu lwesipredishithi soluhlu lweenkcukacha. Ukufumana ulwazi oluthe vetshe, funda Ukongeza iiTable kwiData ye-2013 yokuSebenza
Ukubuyisela ulwazi kwi-Database Access
Kucacile ukuba, isiseko sedatha esilugcina kuphela ulwazi aluyi kuba ncedo - sidinga 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 izicelo ezinzima, okanye imibuzo. 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 ufunyenwe ithebula leenkcukacha zetekisi, ukuzalisekisa lo msebenzi kuya kufuna umlinganiselo omkhulu wokuhlenga idatha kunye nokwenza izibalo ngesandla. Nangona kunjalo, amandla ombuzo uvumela ukuba ucele ukuba iFinyelelo ibuyisele kuphela ezo rekhodi ezidibana nomgangatho wexabiso eliphezulu. 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 2013.
Ukufakela ulwazi kwi-Database Access
Kuze kube ngoku, ufunde le ngqiqo emva kokulungiswa kolwazi kwiziko ledatha kunye nokufumana ulwazi oluvela kwisiseko sedatha. Sisafuna iindlela zokubeka ulwazi kwitafile kwindawo yokuqala! I-Microsoft Access inikezela iindlela ezimbini eziphambili zokuphumeza le njongo. Indlela yokuqala ukukhupha itafile kwifestile ngokuchofoza kabini kuyo kwaye ungeze ulwazi kwizantsi kwayo, njengokuba enye ingongeza ulwazi kwi-spreadsheet.
Ufikelelo lukwabonelela nge-interface-friendly friendly interface evumela abasebenzisi ukungenisa ulwazi kwifom ebonisa imifanekiso 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-Access 2013
IMicrosoft Access Reports
Iingxelo zibonelela ngokukhawuleza ukuvelisa izishwankathelo ezifomathiweyo ezichanekileyo zedatha equlethwe kwelinye okanye ngaphezulu kweetafile kunye / okanye imibuzo. Ngokusebenzisa iindlela zobuqhetseba kunye neetemplates, abasebenzisi beenkcukacha bangenza iingxelo ngokubhekiselele kwimizuzu yemizuzu.
Cinga ukuba ufuna ukuvelisa ikhathalogu yokwabelana ngolwazi ngemveliso kunye nabaxhasi abaxhamlayo kunye nabathengi. Kwimihlathi edlulileyo, sifunde ukuba lolu hlobo lwazi lungasuswa kwi-database yethu ngokusebenzisa ukusetyenziswa ngokufanelekileyo kwemibono. Nangona kunjalo, khumbula ukuba olu lwazi lubekwe kwifom yefomula - kungeyona into ekhangayo kakhulu yokuthengisa! Iingxelo zivumela ukuba kufakwe imifanekiso, ukufometha okukhangayo kunye neentlanga. Ukufumana ulwazi oluninzi, funda Ukudala iiNgxelo kwi-Access 2013.