Tlhaloso ea Likarolo le Lintho tsa bohlokoa
Na u sithabelitsoe ke boitsebiso bo bongata ba lintlha tse lokelang ho fumanoa mokhatlong oa hau? Mohlomong u ntse u sebelisa mokhoa oa ho kenya pampiri, litokomane tsa mongolo kapa spreadsheet ho boloka tlaleho ea boitsebiso ba hao bo bobebe. Haeba o ntse o batlisisa tsamaiso ea ho laola data, boemo bo ka ba poloko eo ue batlang mme Microsoft Access 2013 e fana ka kgetho e babatsehang.
Database ke eng?
Ka tekanyo ea motheo, database e mpa e le pokello ea data e hlophisitsoeng. Tsamaiso ea tsamaiso ea ditshwantsho (DBMS) e kang Microsoft Access, Oracle kapa SQL Server e fana ka lisebelisoa tsa software tseo u li hlokang ho hlophisa ditaba ka tsela e tsitsitseng. E kenyeletsa mehaho ea ho eketsa, ho fetola kapa ho tlosa dintlha ho tswa ho database, botsa lipotso (kapa dipotso) mabapi le dintlha tse bolokiloeng databoleng mme o hlahisa ditlaleho tse akaretsang dikarolo tse khethiloeng.
Microsoft Access 2013
Microsoft Access 2013 e fana ka tharollo e bonolo ka ho fetisisa ea DBMS marakeng kajeno. Basebelisi ba kamehla ba lihlahisoa tsa Microsoft ba tla thabela mokhoa oa ho sheba le ho ikutloa ha Windows, hammoho le ho kopana ka thata le lihlahisoa tse ling tsa lelapa la Microsoft Office. Bakeng sa boitsebiso bo eketsehileng mabapi le sebopeho sa Access 2010, bala Ponahalo ea rona ea Interface ea 2013 ea Interface .
A re qaleng ka ho hlahloba likarolo tse tharo tse kholo tsa Ts'ebetso eo basebelisi ba bangata ba basebetsi ba tla kopana le eona - litafole, lipotso le mefuta. Haeba u se u ntse u e-s'o na le database ea Access, u ka 'na ua batla ho bala ka Creating Access to 2013 Database ho tloha Scratch kapa Ho theha Access Access 2013 Database ho tloha Template.
Lisebelisoa tsa Microsoft Access
Lisebelisoa li kenyelletsa mehaho ea motheo ea konkaete leha e le efe. Haeba u tloaelane le li-spreadsheets, u tla fumana litafole tsa basebetsi tse tšoanang haholo.
Tafole e tloaelehileng ea thepa ea basebetsi e ka ba le tlhahisoleseding ea basebetsi, ho kenyelletsa le litšoaneleho tse kang lebitso, letsatsi la tsoalo le tlotla E ka 'na ea hlophisoa ka tsela e latelang:
- ID ea Basebetsi
- Fane
- Lebitso la pele
- Sehlooho
- Lumeliso
- Letsatsi la tsoalo
Hlahloba ho hahoa ha tafole 'me u tla fumana hore karolo e' ngoe le e 'ngoe ea tafole e lumellana le sebopeho se itseng sa basebetsi (kapa sebopeho sa melaetsa). Mongolo o mong le o mong o lumellana le mosebetsi o mong mme o na le tlhahisoleseding ea hae. Ke tsohle tseo ho leng ho tsona! Haeba e thusa, nahana ka e 'ngoe le e' ngoe ea litafole tsena e le lenane la tlhahisoleseding ea mokhoa oa spreadsheet. Bakeng sa tlhahisoleseding e eketsehileng, balla Ho eketsa Mathala ho ea Basebetsi ba 2013
Ho Fumana boitsebiso bo tsoang ho Database Access
Ho totobetse hore, database e bolokang boitsebiso feela e ke ke ea e-ba ea bohlokoa - re hloka mekhoa ea ho fumana boitsebiso hammoho. Haeba u batla feela ho hopola boitsebiso bo bolokiloeng tafoleng, Microsoft Access e u lumella hore u bule tafoleng ebe u phallela litlaleho tse ka hare ho eona. Leha ho le joalo, matla a sebele a database a na le bokhoni ba ho araba likōpo tse rarahaneng, kapa lipotso. Lipotso tsa ho fihlella li fana ka matla a ho kopanya data ho tloha tafoleng e mengata le sebaka sa maemo a khethehileng ho data e fumanoeng.
Nahana hore mokhatlo o hlophisitsoeng o hloka mokhoa o bonolo oa ho etsa lethathamo la lihlahisoa tseo hona joale li rekisoang ka holimo ho theko ea bona e tloaelehileng. Haeba u mpa u tlosa tafole ea tlhahiso ea sehlahisoa, ho phethahatsa mosebetsi ona ho tla hloka chelete e ngata ea ho hlophisa data le ho etsa lipalo ka letsoho. Leha ho le joalo, matla a potso a u lumella hore feela u kope hore Access e khutlisetse litlaleho tseo tse finyellang boemo bo phahameng ba thekiso ea theko. Ho phaella moo, o ka laela lethathamong ho ngola feela lebitso le tefo ea litekanyetso tsa thepa.
Bakeng sa tlhahisoleseding e eketsehileng mabapi le matla a ditshwantsho tsa ditshwantsho ho Fihlella, baleng Ho Etsa Potso e Bonolo ho Microsoft Access 2013.
Ho kenya tlhahisoleseding ho ya Database Access
Ho fihlela joale, o ithutile likhopolo tsa ho hlophisa boitsebiso boitsebisong le ho fumana boitsebiso bo tsoang boitsebisong. Re sa ntsane re hloka mekhoa ea ho beha tlhahisoleseding ka har'a litafole pele! Microsoft Access e fana ka mekhoa e 'meli e ka sehloohong ho finyella pakane ena. Mokhoa oa pele ke ho hlahisa tafoleng ka fensetere ka ho penya habeli ho eona le ho eketsa tlhahisoleseding ho ea tlase ho eona, feela joalokaha motho a ka eketsa tlhahisoleseding ho spreadsheet.
Puo e boetse e fana ka sebopeho sa mefuta-futa se sebelisoang ke mochine e lumellang basebedisi ho kena boitsebiso ka foromo e hlakileng 'me ba na le boitsebiso boo bo fetisitsoeng ka mokhoa o hlakileng ho database. Mokhoa ona ha o tšabe letho bakeng sa ho kena ho data empa o hloka mosebetsi o seng mokae karolong ea mookameli oa databases. Bakeng sa tlhahisoleseling e eketsehileng, baleng Ho bopa Foromo ho Fihlella 2013
Microsoft Access Reports
Litlaleho li fana ka matla a ho potlakela ho hlahisa litlhaloso tse hlophisitsoeng hantle tsa data e fumanoang tafoleng e le 'ngoe kapa ho feta le / kapa lipotso. Ka ts'ebeliso ea maqheka le mekhoa ea mekhoa e metsoako, basebelisi ba basekarete ba ka etsa litlaleho ka ho toba taba ea metsotso.
Ha re re u batla ho hlahisa lethathamo la libuka bakeng sa ho arolelana tlhahisoleseding ea sehlahisoa le batho ba teng hona joale le bao u tla ba le bona. Likarolong tse fetileng, re ithutile hore boitsebiso ba mofuta ona bo ka fumanoa ho tloha ka boitsebiso ba rona ka ho sebelisa lipotso ka bohlale. Leha ho le joalo, hopola hore tlhahisoleseling ena e ne e hlahisoa ka mokhoa o itseng - eseng hantle ka ho fetisisa boitsebiso bo rekisoang! Litlaleho li lumella ho kenngoa ha litšoantšo, mekhoa e metle le mokhoa oa bohetene. Bakeng sa tlhahisoleseling e eketsehileng, sheba Creating Reports in Access 2013.