Microsoft Access Database Reports Tutorial

Tafole ea basebetsi ke moo boitsebiso ba hau ba sebele bo bolokoang teng. Litlaleho ke seo Microsoft Access e kenyelletsang ho sona hore re ntlafatse ho bona data eo, joalo ka lipontšo, litlhaloso tse hatisitsoeng, litlaleho tsa tsamaiso, kapa esita le kakaretso e bonolo ea seo litafole li e emelang.

Tlaleho e ka ba le likarolo tsa sehlooho tse sebelisetsoang litlotla kapa litšoantšo tse akaretsang seo khoeli e se emelang, 'me tlaleho e' ngoe le e 'ngoe e hloka karolo ea lintlha tse fanang ka boitsebiso bo bonahalang bo tsoang ho database. Maoto a maoto a maoto ke khetho hape, e akaretsang data ho tloha karolong e qaqileng kapa e hlalosang linomoro tsa maqephe.

Lihlooho le lihlopha tsa lihlopha li lumelloa, tseo e leng libaka tse fapaneng tsa moetlo moo o ka kenyang data ea hau.

Ka tlase ke litaelo tsa ho theha litlaleho tse entsoeng ka mokhoa o hlophisehileng ka boitsebiso ka boitsebiso ba rona boitsebiso. Ke likonopo tse 'maloa feela.

Kamoo U ka Etsang Tlaleho ka MS Access

Mehato ea ho etsa litlaleho tsa MS Access e fapane hanyane ho itšetlehile ka phetolelo ea Access eo u e sebelisang:

Microsoft Access 2016

1. Ka tafoleng e bulehileng ho Fihlella, e-ea ho Etsa menu ebe u khetha konopo ea Tlaleho ho tsoa karolong ea Likarabo . \
2. Ela hloko karolo ea Lihlahisoa tsa Liphetoho tsa Hona joale e bonahalang ka holimo ho Microsoft Access:
   1. Tlhahiso: Sehlopha 'me u hlophise likarolo ho tlaleho, eketsa mongolo le li-link, kenngoa linomoro tsa leqephe,' me u fetole litšobotsi tsa shekha, har'a lintho tse ling.
   2. Lokisetsa: Fetola tafole hore e kenngoe ka majoe, tabular, joalo-joalo; mela e tsamaeang le litšiea holimo kapa ho le letšehali le ho le letona; kopanya le ho arola mela le mela; laola margins; 'me u tlise lintlha ho "ka pele" kapa "morao" ka mokhoa o behiloeng.
   3. Phatlalatso: Kenyeletsa lisebelisuoa tse tloaelehileng tsa ho etsa litlhaloso tsa lentsoe joaloka sebete, italic, underline, mongolo le mobala oa mokokotlo, nomoro le ho hlahisa letsatsi, mokhoa o lumellanang le maemo, joalo-joalo.
   4. Kemiso ea Leqephe: A u lumelle hore u fetole boholo ba leqephe la leqephe le ho fetola pakeng tsa naha le portrait.

Microsoft Access 2010

Haeba u sebelisa Access 2010, bona ho hlahisa Litlaleho ho Microsoft Access 2010 ho e-na le hoo.

Microsoft Access 2000

Bakeng sa thupelo ena e sebetsang feela ho MS Access 2000, re tla sebelisa database ea Northwind sample. Bona kamoo u ka kenya leboea la Northwind Sample Database pele re qala haeba u se u ntse u e-na le boitsebiso bona.

1. Hang ha o se o buletse Northwind, o tla hlahisa le menu e kholo ea database. Tsoela pele 'me u tobetse khetho ea Likarabo ho bona lenane la litlaleho tse fapa-fapaneng tseo Microsoft li kenyelletsoeng ho tsona tlhahisoleseding ea mohlala.
   1. Haeba u batla, penya habeli ho tsena tse seng kae 'me u utloe hore na litlaleho li shebahala joang le mefuta e sa tšoaneng ea tlhahisoleseding eo e nang le eona.
2. Hang ha u se u khotsofatsa thahasello ea hau, tobetsa konopo e Ncha 'me re tla qala mokhoa oa ho theha tlaleho ho tloha qalong.
3. Sesepa se hlahlamang se hlahang se tla u kopa ho khetha mokhoa oo u lakatsang ho o sebelisa ho etsa tlaleho. Re tla sebelisa " Wizard Report" e tla re tsamaisa ka mohato oa pōpo ka mohato.
   1. Ka mor'a hore u tsebe meriana, u ka 'na ua batla ho khutlela mohato ona' me u hlahlobe ho feto-fetoha ha maemo ho fanoeng ke mekhoa e meng ea pōpo.
4. Pele re tloha skrineng ena, re batla ho khetha mohloli oa data bakeng sa tlaleho ea rona. Haeba u batla ho fumana boitsebiso bo tsoang tafoleng e le 'ngoe, u ka e khetha ho tloha lebokoseng le theoha. Ntle le moo, bakeng sa litlaleho tse rarahaneng, re ka khetha ho theha tlaleho ea rona ho hlahisa lipotso tseo re neng re li entse pele.
   1. Bakeng sa mohlala oa rona, boitsebiso bohle boo re bo hlokang bo na le tafoleng ea Basebetsi , kahoo khetha tafole ena mme o tobetsa OK .