I-Microsoft Access Data Reports Tutorial

Itafile yedatha yilapho ulwazi lwakho lwangempela lugcinwa khona. Iingxelo zeziphumo zeMicrosoft Access zibandakanya ngathi ukuba sibone kangcono loo datha, njengokuba kubonakaliswe, ifomathi eziprintwayo, iingxelo zolawulo, okanye nokuba sisishwankathelo esicacileyo sezinto ezithethiweyo.

Ingxelo ingaba neziqendu zezihloko ezisetyenziselwa izihloko okanye iimifanekiso ezishwankathela oko kukho ikholomu imele, kwaye yonke ingxelo ifuna icandelo leenkcukacha eligcina idatha ebonakalayo evela kwisiseko sedatha. Amagqabantshintshi ayenako ukhetho, olufingqa idatha ukusuka kwicandelo leenkcukacha okanye ezichaza amanani ephepha.

Iintloko zeqela kunye neenyawo zivunyelwe ukuba, ziindawo ezihlukeneyo zenkcubeko apho unokwenza iqela idatha yakho.

Ngezantsi imiyalelo yokudala iingxelo ezifomathiweyo ngokuzenzekelayo kwi-database yolwazi. Kuphela nje amaqhosha ambalwa.

Indlela yokwenza ingxelo kwi-MS Access

Amanyathelo okwenza iingxelo ze-MS Access ahluke ngokuxhomekeke kwenguqu yeFumaneka usebenzisa:

Microsoft Access 2016

1. Ngetafile evulekile kwi-Access, yiya kwi- Yenza imenyu uze ukhethe inkcazo yeNgxelo kwiqendu leNgxelo . \
2. Qaphela inxalenye yeCandelo loLungiselelo lweNgxelo ngoku ngokubonakalayo phezulu kwi-Microsoft Access:
   1. Ukuyila: Iqela kwaye uhlele izinto kwi-ingxelo, engeza itekisi kunye namanqaku, faka iinombolo zephepha, kwaye uguqule iimpahla zephepha, phakathi kwezinye izinto.
   2. Hlela: Lungisa itafile ukuba ibanjwe, ityala, njl .; ukuhambisa imigqa kunye nekholomu phezulu okanye ngakwesobunxele nakwesokudla; ukudibanisa nokwahlula iikholomu kunye nemigqa; lawula i mijelo; kwaye uzisa izinto kwi "phambili" okanye "ngasemva" kwifom yokubeka.
   3. Ifomathi: Kuquka izixhobo zokufomathiza eziqhelekileyo zeprogram ezifana nesibindi, isalic, umgca, umyalezo kunye nombala wesiqalo, inombolo kunye nokufometha komhla, ukufomathiweyo kwemiqathango, njl njl.
   4. Ukusekwa kwekhasi: Kukuvumela ulungelelanise ubungakanani bephepha jikelele kwaye uguqule phakathi kweendawo kunye neefoto.

Microsoft Access 2010

Ukuba usebenzisa i-Access 2010, khangela Ukudala iiNgxelo kwi-Microsoft Access 2010 esikhundleni.

Microsoft Access 2000

Kule khokelo echaphazelekayo kuphela kwi-MS Access 2000, siya kusebenzisa i-database ye-Northwind yesampula. Jonga indlela yokufaka iNgcaciso yeSampula ye-Northwind ngaphambi kokuba siqale ukuba awunayo le database.

1. Emva kokuba uvule iNorthwind, uya kuboniswa kwimenyu ephezulu yedatha. Qhubekisa kwaye uklikha kwi- Reports selection ukuze ubone uludwe lweengxelo ezahlukeneyo zeMicrosoft zifakwe kwisiseko seenkcukacha.
   1. Ukuba ufuna, nqakraza kabini kwizinto ezimbalwa zale nto kwaye uzive ukuba zeziphi iingxelo zibukeka ngathi kunye neentlobo ezahlukeneyo zolwazi abazinayo.
2. Emva kokuba unelisekile umnqweno wakho, nqakraza iqhosha elitsha kwaye siza kuqala inkqubo yokudala ingxelo ukususela ekuqaleni.
3. Isikrini esilandelayo esiya kuvela siya kukucela ukuba ukhethe indlela ofuna ukuyisebenzisa ukudala ingxelo. Siza kusebenzisa i- Report Wizard ehamba nathi ngokusebenzisa inkqubo yokudala inyathelo-nge-nyathelo.
   1. Emva kokuba uye wazi kakuhle idilesi, ungase ufune ukubuyela kule nyathelo kwaye uhlolisise ukuguquguquka kwemimoya enikezelwa yindlela enye yokudala.
4. Ngaphambi kokushiya esi sikrini, sifuna ukukhetha umthombo wedatha yengxelo yethu. Ukuba ufuna ukufumana ulwazi kwitafile enye, ungayikhetha kwibhokisi ehlayo. Ngaphandle koko, ngenxa yeengxelo eziyinkimbinkimbi, sinokukhetha ukusekela ingxelo yethu kwisiphumo sombuzo esasilungiselele ngaphambili.
   1. Ngokomzekelo wethu, yonke idatha esiyidingayo iqulethwe kwitheyibhile yabasebenzi , ngoko ukhethe le tafile uze uklikhe i- OK .