Microsoft Access Database Reports Tutorial

Pane tafura yezvinyorwa zvepamusoro yepamusoro apo iwe pachako mashoko echokwadi akachengetwa Mishumo ndeyo iyo Microsoft Access inosanganisira kwatiri kuti tione zviri nani deta, sezviitiko, zvinyorwa zvinyorwa, zvinyorwa zvekutungamira, kana kunyange sechidimbu chemashoko acho.

Mushumo unogona kuva nezvikamu zvepamusoro zvinoshandiswa kune zvinyorwa kana mifananidzo zvinopfupikisa zvinowirirwa neholoni, uye mushumo wega wega unoda chikamu chezvinyorwa chinotora data yakaonekwa kubva pane d database. Mafambiro isarudzowo zvakare, iyo inopfupikisa data kubva muchikamu chezvinyorwa kana iyo inotsanangura mapeji epaji.

Boka misoro nevanotsika vanobvumirwa kuenda, izvo zvakasiyana nedzimwe nzvimbo iyo iwe unogona kuunganidza deta yako.

Pasi pane mirayiridzo yekugadzira mamiriro ekudzidzira maitiro akangoerekana awanikwa kubva kumashoko edu e database. Ingongova zvishomanana zvishoma chete.

Nzira Yokuita Nayo Nhoroondo mu MS Access

Matanho ekuita mishumo ye MS Access yakasiyana zvishoma zvichienderana neshanduro yeAka Access iwe uri kushandisa:

Microsoft Access 2016

1. Ne tafura yakazaruka muAka Access, enda kune Yakaita mapeji uye osarudza Bhuku reMashoko kubva muchikamu cheRe Reports . \
2. Tora nhamba yeChikamu cheMashoko ekuGadzira Zvimwe zvino zvinoonekwa kumusoro kweMicrosoft Access:
   1. Kugadzirirwa: Gulu uye sarudza zvinhu mumushumo, kuwedzera mashoko uye kubatanidza, kuisa nhamba dzemaji, uye kuchinja mapepa acho, pakati pezvimwe zvinhu.
   2. Saronga: Ruramisa tafura kuti ive yakatorwa, tabular, etc ;; famba mitsetse uye mapuranga kumusoro kana kuruboshwe uye kurudyi; kuungana uye kuparadzanisa misoro nemirasi; kudzora margins; uye kuunza zvinyorwa kune "mberi" kana "kumashure" mumutauro wekuisa.
   3. Fomu: Inosanganisira izwi rechigadziro remapurogiramu ekugadzirisa mashandisirwo akaita shanduro, italic, inonyorera, mutsara uye ruvara rwemukati, nhamba uye kuiswa kwezuva, kuumbwa kwemamiriro ezvinhu, nezvimwewo.
   4. Kuisa Peji: Kukubvumira kugadzirisa huwandu hwemaji eji uye kushandura pakati pezvenyika uye mifananidzo.

Microsoft Access 2010

Kana uri kushandisa Access 2010, ona Creating Reports mu Microsoft Access 2010 pane.

Microsoft Access 2000

Nokuti iyi tutori inoshanda chete kune MS Access 2000, tichazoshandisa database yeNorthwind sample. Ona Nzira Yokuisa Nayo Northwind Sample Database tisati tatanga kana iwe usati uine database iyi.

1. Kana wambozarura Northwind, iwe uchazoiswa neyo huru database yemenu. Enda mberi uye chengeta pane sarudzo dzeRe Reports kuti uone urongwa wemishumo yakasiyana-siyana yaMicrosoft inowanikwa mune imwe shanduro yedhesi.
   1. Kana iwe uchida, kaviri-cheka pane zvishomanana zvei uye uwane kunzwa nekuda kwemitauriro yakaita seyi uye mhando dzakasiyana dzemashoko zvavari.
2. Kana iwe wanyatsogutsa chido chako, chengetedza Bhodhi Itsva uye isu tichatanga nzira yekusika mushumo kubva pakutanga.
3. Chirongwa chinotevera chinowanikwa chichakukumbira kuti usarudze nzira yaunoda kushandisa kuti ugadzire mushumo. Tichashandisa iyo Rapport Wizard iyo inotitungamira kuburikidza nekugadzira zvishoma-nhanho.
   1. Mushure mekunge wanyatsoziva wizard, unogona kudzokera kune chigamba ichi uye ongorora kushanduka kunoitwa nemamwe nzira dzezvisikwa.
4. Tisati tabva pano, tinoda kusarudza nzvimbo ye deta repoti redu. Kana iwe uchida kutora mashoko kubva kune rimwe tafura, unogona kuzvisarudza kubva kubhokisi rezasi. Zvimwewo, kune mamwe maitiro akaoma, tinogona kusarudza kuisa mushumo wedu pamusoro pekubuda kwemubvunzo watakambogadzira.
   1. Nokuda kwemuenzaniso wedu, data yose yatinoda iri mukati mefurafura yeVashandi , saka sarudza tafura iyi uye chengeta OK .