Inkqubo yokuguqula umbuzo weMicrosoft Access iyafana nenkqubo yokudala enye kwindawo yokuqala. Imibuzo ingatshintshwa ngokusebenzisa i-Design View okanye i-SQL View, nangona kunjalo-awukwazi ukusebenzisa iWebware yeWebard ukuguqula umbuzo okhoyo.
Qala ngokuchofoza ngokuchanekileyo umbuzo wakho ojoliswe ngaphakathi kwiipaneli zento ngakwesobunxele kwesikrini ngaphakathi kwedatha yakho. Kwimenyu ephumayo, khetha I- View View. Umbuzo uvulwa kwiDatasheet View. Xa unqakraza ngokufanelekileyo igama lombuzo kumgca wethebhu ngaphaya kweDatasheet View output, ungatshintsha indlela yokujonga. Ngokungagqibekanga, useDatasheet, ezingenakulungiswa ngokutsha (nangona ungafaka kwaye ususe idatha kulo mbono). Ukususela kwi-SQL okanye kwi-Design, ke, unokuhlela isakhiwo sombuzo kwaye ulondoloze okanye ulondoloze-njengento eguquliwe njengoko kuyimfuneko.
I-View View
I-View View ivula isikrini sokuhlukanisa esingenanto. Isiqingatha esiphezulu sibonisa ii-rectangles ezimele zonke iitheyibhile okanye umbuzo osondeza umbuzo owuguqulayo. Amacandelo abalulekileyo-ngokuqhelekileyo umkhomba-mpawu oyingqayizivele owona mncinci wegolide. Ngamanye amanqwanqwa ahlangene namanye amacangca ngeendlela zokudibanisa imimandla kwelinye itafile kwiindawo kwelinye.
Le miqolo ibonisa ubudlelwane. Kwi-Design View, ukuchofoza ngakwesokudla kumgca kukuvumela utshintshe ubudlelwane. Unokukhetha kwenye yeendlela ezintathu:
- Iimilo apho iindawo ezidibeneyo kuzo zombini iitheyibhile zilingana
- Iidolo apho iithayibhile ezisekhohlo zibuyela kuzo zonke iziphumo kunye netafile efanelekileyo ibonisa iziphumo ezifanayo
- Iindonga apho iithayibhile ezilungileyo zibuyela kuzo zonke iziphumo kunye netafile ekhohlo zibonisa iziphumo ezihambelana
Ezi zintathu zidibanisa iintlobo (zangaphakathi, ezisekhohlo, kunene) ziziqendu zoluhlu olupheleleyo lwezinto zokudibanisa eziza kwenziwa. Ukwenza ukwenziwa komsebenzi obunzima, uzakufuneka uhambe kwiSQL View.
Xa udibanisa iitheyibhile zakho ezikhethiweyo kunye nemida yobudlelwane, uya kubona isiqingatha esiphantsi seskrini sibonisa uluhlu lwegridi zonke iinkalo eziza kubuya umbuzo. Ibhokisi yokubonisa okanye ukucima insimba xa umbuzo usebenza-ungakucoca umbuzo ngokusekelwe kwiindawo ezingabonakaliyo. Ungakwazi ukongeza ngesandla okanye uguqule umyalelo wokuhlela ukuba ulandele iziphumo ekunyuka okanye ekuhlahleni, nangona i-Microsoft Access iya kucwangcisa iintlobo ezininzi kwi-oda elisekhohlo ukuya ngasekunene kwimida. Unokwenza ulungelelanise iikholomu ngokuwadonsa ngakwesobunxele okanye ngasekunene kwegridi, ukunyanzelisa iphethini ethile yohlobo.
Ibhokisi leCriteria ye-Design View ikuvumela ukuba ufake imilinganiselo yokunciphisa, okokuba xa umbuzo usebenza, ubonisa kuphela i-subset yedata efana nefayile yakho. Umzekelo, kumbuzo malunga nemiyalelo yomkhiqizo ovulekileyo, unokongeza i-criterion = 'MI' kwikholomu yomhlaba ukubonisa kuphela imiyalelo evela eMichigan. Ukongeza amazinga okubaluleka, sebenzisa okanye iibhokisi ngaphakathi kwikholamu okanye wongeze iikhrayitheriya kwezinye iikholomu.
SQL View
Ngombono we-SQL, iMicrosoft Access ithatha indawo ye-datasheet kunye ne-syntax yoLwimi oluCwangcisiweyo lweeNgxelo zokuFikelela ukuFikelela ukucacisa ukuba yiyiphi idatha yokukrazula kwimvelaphi, kwaye yiyiphi imithetho yezoshishino.
Izitatimende ze-SQL ngokubanzi zilandela ifom yebhloko:
HLOLA ITHEPHA1. [Igama lomnxeba1], iThebhile2. [Ifowuni2]
KUSUKA ITHEBULI NGOKUBHEKA NGOKUBHEKA I-Table2 KWI-Table 1. [Key1] = Itheyibhile2. [Isicatshulwa2]
LAPHA Itafile1. [Igama lomnxeba1]> = "I-FilterValue"
Abathengisi beenkcukacha ezahlukeneyo baxhasa iinguqu ezahlukeneyo zeSQL. Umgangatho wesiseko, obizwa ngokuba yi-ANSI-ehambelanayo ne-syntax, kufuneka ukwazi ukusebenza kuyo yonke indawo. Nangona kunjalo, umthengisi ngamnye uhlawula umgangatho we-SQL kunye nama-tweaks ayo. UMicrosoft, umzekelo, uqeshe iNjini yeData yeJet ngaphakathi kwiFinyelelo. UMicrosoft uxhasa iSQL Server. Abanye abathengisi basebenzisa iindlela ezahlukeneyo, ngoko ke i-SQL ngokubanzi ayinakuxhatshazwa njengemigangatho yokuxhasa.
Ukuba awuqhelanga ne-syntax ye-Jet Database ye-Intanethi yokuphunyezwa kwe-SQL, ngoko u-tweaking i-SQL View ingawaphula imibuzo yakho. Bambelela kwi-View View, endaweni yoko. Nangona kunjalo, ngokukhawuleza ngokukhawuleza, ngamanye amaxesha kulula ukulungelelanisa i-SQL engaphantsi kunokuguqula iSimmatic View Design. Ukuba abanye abahlalutyi kwinkampani yakho bafuna ukwazi ukuba unesiphumo sini, ukubathumela isinqununu kunye nokunamathisela kwe-SQL yakho isitatimende kunciphisa ukudideka malunga nokucwangciswa kombuzo.
Ukugcina Umsebenzi Wakho
Kwi-Microsoft Access 2016, ungagcina kwaye ubhale ngaphezulu umbuzo okhoyo ngokuchofoza ngokuchanekileyo kwithebhu yayo kwaye ukhetha Gcina. Ukugcina umbuzo ohlaziyiweyo njengamanye amagama, ukuvumela ukuba umbuzo wangoku uqhubeke ucofe, qhosha kwifayile yefayile, khetha u- Save njenge kwaye Gcina Izinto Njengaye.