Microsoft Access Database Amalemba Tutorial

Tawuni yachinsinsi ndi kumene mauthenga anu enieni amasungidwa. Malipoti ndi zomwe Microsoft Access zimaphatikizapo kuti tiwone bwino deta, monga mafotokozedwe, mawonekedwe osindikizidwa, malipoti oyang'anira, kapenanso ngati mwachidule cha zomwe matebulo amaimira.

Lipoti likhoza kukhala ndi zigawo za mutu zomwe zimagwiritsidwa ntchito pa maudindo kapena zithunzi zomwe zimafotokozera mwachidule zomwe khola likuyimira, ndipo lipoti lirilonse limafuna gawo la tsatanetsatane lomwe limagwiritsa ntchito deta yoonekera kuchokera ku deta. Zolembapozo ndizomwe mungasankhe, zomwe zidule mwachidule deta kuchokera ku gawo la tsatanetsatane kapena zomwe zikufotokoza manambala a tsamba.

Mutu wa magulu ndi maulendo amaloledwa kupita, omwe ali osiyana ndi miyambo komwe mungagwirizanitse deta yanu.

M'munsimu muli malangizo opanga mauthenga ovomerezeka mwakhama kuchokera ku deta yathu. Ndi mabatani pang'ono chabe.

Mmene Mungapangire Mbiri mu MS Access

Njira zogwiritsira ntchito mauthenga a MS Access ndi osiyana kwambiri malingana ndi momwe mungagwiritsire ntchito:

Microsoft Access 2016

1. Ndi tebulo lotseguka mu Access, yendani ku Pangani menyu ndikusankha Bulu lolemba ku gawo la Reports . \
2. Tchulani gawo la Zolemba Zopanga Zolemba zomwe tsopano zikuwoneka pamwamba pa Microsoft Access:
   1. Mapangidwe: Gulu ndikukonzekera zinthu mu lipoti, kuwonjezera malemba ndi maunjano, kuyika manambala a tsamba, ndi kusintha zosintha za pepala, pakati pazinthu zina.
   2. Konzani: Sinthani tebulo kuti iphatikizedwe, tsamba, etc .; mizere yosanjikizana ndi zipilala mmwamba kapena kumanzere ndi kumanja; gwirizanitsani ndi kugawa mizere ndi mizere; sungani mitsinje; ndi kubweretsa zinthu ku "kutsogolo" kapena "kutsogolo" mu maonekedwe ake.
   3. Mafomu: Amaphatikizapo zida zamakono zojambula zojambula ngati mawu, bold, italic, pansi pamanja, malemba ndi mtundu wachibadwidwe, chiwerengero ndi chiwerengero cha tsiku, maonekedwe ovomerezeka, ndi zina zotero.
   4. Kukhazikitsa Tsamba: Kukuthandizani kusintha kukula kwake kwa tsamba ndikusintha pakati pa malo ndi zithunzi.

Microsoft Access 2010

Ngati mukugwiritsa ntchito Access 2010, onani Creating Reports ku Microsoft Access 2010 m'malo mwake.

Microsoft Access 2000

Kuti phunziroli likhale lothandiza kwa MS Access 2000, tidzatha kugwiritsa ntchito nambala yachinsinsi ya Northwind. Onani Mmene Mungakhazikitsire Chinyumba cha Northwind Sample tisanayambe ngati mulibe databaseyi.

1. Mutatsegula Northwind, mudzapatsidwa ndi mndandanda waukulu wa menyu. Pitirizani ndikudina pazokambirana za Reports kuti muone mndandanda wa malipoti osiyanasiyana omwe Microsoft akuphatikizidwa muzitsanzo zachinsinsi.
   1. Ngati mukufuna, dinani kawiri pazinthu izi ndikudzimva kuti mauthenga amawoneka bwanji ndi mitundu yosiyanasiyana ya zomwe ali nazo.
2. Mukangokwaniritsa chidwi chanu, dinani batani Yatsopano ndipo tiyambanso kulenga lipoti kuchokera pachiyambi.
3. Sewero lotsatira lomwe likuwonekera likufunsani inu kusankha njira yomwe mukufuna kugwiritsa ntchito kuti mupange lipoti. Tidzagwiritsa ntchito Report Wizard yomwe idzatiyendetsa pang'onopang'ono ndondomeko ya chilengedwe.
   1. Mutatha kudziwa mdierekezi, mungafune kubwerera ku sitepe iyi ndikuyang'ana kusintha komwe kumaperekedwa ndi njira zina zolengedwa.
4. Tisanachoke pulogalamuyi, tikufuna kusankha chitsimikizo cha deta yathu. Ngati mukufuna kutenga uthenga kuchokera pa tebulo limodzi, mungasankhe kuchokera ku bokosi lakutsikira. Mwinanso, pa malipoti ovuta, tikhoza kusankha kukhazikitsa lipoti lathu pa zotsatira za funso limene tinapanga kale.
   1. Kwa chitsanzo chathu, deta yonse yomwe tikusowa ili mu tebulo la ogwira ntchito , choncho sankhani tebulo ili ndipo dinani.