Microsoft Access e na le likarolo tse tharo tse kholo: litafole, lipotso le liforomo
Khamphani leha e le efe e tsietsing ke lintlha tse ngata tse lokelang ho latelloa kapa ka mokhoa o sebelisang pampiri ea pampiri, litokomane tsa mongolo kapa spreadsheet ea ho boloka lethathamo la boitsebiso bo bobe bo ka rua molemo ka ho etsa phetoho tsamaisong ea tsamaiso ea data. Lenaneo la basebetsi joaloka Microsoft Access 2010 le ka ba feela seo khamphani e se hlokang.
Sebaka sa Boitsebiso ke Eng?
Ka tekanyo ea motheo, database e hlophisitsoe ea data. Tsamaiso ea tsamaiso ea ditshwantsho (DBMS) e kang Microsoft Access 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 le ho tlosa dintlha ho tswa ho database, botsa lipotso mabapi le boitsebiso bo bolokiloeng ka lebenkeleng le ho hlahisa litlaleho tse akaretsang likarolo tse khethiloeng.
Microsoft Access 2010 likarolo
Microsoft Access 2010 e fana ka tharollo e bonolo le e feto-fetohang ea DBMS. Basebelisi ba kamehla ba lihlahisoa tsa Microsoft ba ananela mokhoa o tloaelehileng oa ho sheba le ho ikutloa ha Windows le ho kopanngoa ka thata le lihlahisoa tse ling tsa lelapa la Microsoft Office.
Tse tharo tsa likarolo tse kholo tsa Ts'ebetso eo basebelisi ba bangata ba basebetsi ba kopanang le eona ke litafole, lipotso le liforomo. Haeba u qala ho kena le Access 'me u se u ntse u e-na le database ea Access ka kopo, bala ka Creating Access to 2010 Database ho tloha Scratch.
Lisebelisoa ke Liboho
Lisebelisoa ke mehaho ea motheo ea mobu leha e le ofe oa boitsebiso. Haeba u tloaelane le li-spreadsheets, u tla fumana litafole tsa database tse tšoanang. Tsela e tloaelehileng ea tafole ea basebetsi e ka 'na ea e-ba le boitsebiso ba basebetsi, ho akarelletsa le litšobotsi 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 mokhoa o itseng oa basebetsi-kapa boikutlo ba ho boloka litaelo. Mongolo o mong le o mong o lumellana le mosebetsi o mong mme o na le tlhahisoleseding ea hae. Ke sona sohle seo u leng ho sona. Haeba e thusa, nahana ka tafole ka 'ngoe e le lethathamo la boitsebiso ba mokhoa oa spreadsheet.
Lipotso Tl'o Fumana Boitsebiso
Dataiso e bolokang boitsebiso feela e tla ba e se nang thuso; u hloka mekhoa ea ho fumana boitsebiso hape. 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 teng ka bokhoni ba eona ba ho araba lipotso tse rarahaneng. 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 o mpa o fumana tafole ea tlhahiso ea sehlahisoa, ho phetha 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 lumella hore u kope hore Access e khutlele feela litlalehong tse finyellang boemo ba thekiso ea theko e boletsoeng ka holimo. Ho phaella moo, o ka laela lekunutu hore le thathamise feela lebitso le tekanyo ea theko ea thepa.
Bakeng sa tlhahisoleseling e eketsehileng mabapi le matla a ditshwantsho tsa basekarete ho Fihlella, balang Ho hlahisa Potso e Bonolo ho Microsoft Access 2010.
Mefuta e kenya lintlha
Ho fihlela joale, u balile ka maikutlo a ka mor'a ho hlophisa boitsebiso boitsebisong le ho fumana boitsebiso bo tsoang boitsebisong. U ntse u 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 tlisa tafoleng ka fensetere ka ho penya habeli ho eona. Ebe, eketsa tlhahisoleseding ho ea tlaase tafoleng, feela joalokaha u ka eketsa tlhahisoleseding ho spreadsheet.
Puo e boetse e fana ka sebopeho sa mefuta-futa ea liforomo. Sebopeho sena se lumella basebedisi ho kenyelletsa tlhahisoleseling ka foromo e hlakileng mme ba na le tlhahisoleseding eo e fetisetsweng hosaense. 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 tlhahisoleseding e eketsehileng, baleng Ho bopa Foromo ho Fihlella 2010
Microsoft Access Reports
Litlaleho li fana ka bokhoni ba ho hlahisa litlhaloso tse hlophisitsoeng hantle tsa data e fumanoang tafoleng e le 'ngoe kapa ho feta. Ka ts'ebeliso ea maqheka le mekhoa ea mekhoa e metsoako, basebelisi ba tsebo ba tsebo ba ka etsa litlaleho ka taba ea metsotso.
A re ha u batla ho hlahisa lethathamo la libuka ho arolelana tlhahisoleseding ea sehlahisoa le batho ba teng hona joale le bao u tla ba le bona. Boitsebiso ba mofuta ona bo ka fumanoa boitsebisong ba marang-rang ho sebelisa lipotso tse bohlale. Leha ho le joalo, boitsebiso bona bo hlahisoa ka mokhoa o itseng oa sebopeho-eseng hantle boitsebiso bo hohelang ka ho fetisisa. Litlaleho li lumella ho kenngoa ha litšoantšo, mekhoa e metle, le bohetene. Bakeng sa tlhahisoleseling e eketsehileng, sheba Creating Reports in Access 2010.