Uhlelo lokushintsha umbuzo we-Microsoft Access lufana nenqubo yokudala eyodwa endaweni yokuqala. Imibuzo ingashintshwa ngokusebenzisa i-Design View noma i-SQL View, noma kunjalo-awukwazi ukusebenzisa i-Query Wizard ukushintsha umbuzo okhona.
Qala ngokuchofoza ngakwesokudla umbuzo wakho ohlosiwe ngaphakathi kwephaneli lezinto ngakwesobunxele kwesikrini ngaphakathi kwedatha yakho. Emenyu ye-pop-up, khetha u- Design View. Umbuzo uvulwa ku-Datasheet View. Uma uchofoza ngokuqondile igama lombuzo emgqeni wethebhu ngenhla kokukhipha kweDatasheet View, ungashintsha imodi yokubuka. Ngokuzenzakalelayo, usekuDatasheet, engakwazi ukuhlelwa ngokuhlelekile (nakuba ungafaka futhi ususe idatha kulo mbono). Kusuka noma yikuphi ukubuka kwe-SQL noma ukuklama, kepha ungahlela isakhiwo sombuzo bese ulondoloza noma ulondoloza-njengoba into eguquliwe iyadingeka.
Ukubuka kweMiklamo
I-Design View ivula isikrini sokuhlukanisa okuzenzekelayo. Ingxenye ephezulu ibonisa ama-rectangles abamele yonke ithebula noma umbuzo odla umbuzo oyishintshayo. Amasimu ayisihluthulelo-ngokujwayelekile isichazamazwi esiyingqayizivele isici esincane segolide eduze kwabo. Ngamanye ama-rectangles ajoyina amanye ama-rectangle ngokusebenzisa imigqa exhuma amasimu kwelinye itafula emasimini kwenye.
Le migqa ibonisa ubuhlobo. Ku-Design View, ukuchofoza ngakwesokudla emgqeni kukuvumela ukuthi ushintshe ubuhlobo. Ungakhetha kusuka kwenye yezinketho ezintathu:
- Imigqa lapho izinsimu ezihlangene kuzo zombili amathebula zilingana
- Imigqa lapho ithebula elisele kwesokunxele libuyisela yonke imiphumela kanye netafula elilungile libonisa imiphumela ehambisanayo
- Imigqa lapho ithebula elilungile kakhulu libuyisela yonke imiphumela kanye netafula lesobunxele likhombisa imiphumela efanayo
Lezi zinhlobo ezintathu zokujoyina (ngaphakathi, kwesobunxele, kwesokudla) yi-subset yebanga eliphelele lokujoyina ukuthi i-database ingayenza. Ukuze wenze ukuqubuzana okuningi okunzima, uzodinga ukuthuthela ku-SQL View.
Uma uxhuma amathebula akho akhethiwe ngolayini wobudlelwane, uzobona isigamu esingaphansi kwesikrini sibonisa uhlu lwegridi zonke izinkambu ezizobuyela kulo mbuzo. I-Display ibhokisi ibonisa noma icindezela insimu lapho umbuzo usebenza-ungakwazi ukuhlunga umbuzo ngokusekelwe emasimini angaboniswa. Ungakwazi futhi ukwengeza ngesandla noma ukuguqula ukuhleleka okuhlelekile ukuze uhlele imiphumela ekhuphuka noma ehla, nakuba i-Microsoft Access izokwenziwa ngezinqubo eziningana ngokulandelana kwesokunxele kuya kwesokudla phakathi kwamasimu. Ungakwazi ukuhlela kabusha amakholomu ngokuwahudula ngakwesobunxele noma ngakwesokudla ngaphesheya kwegridi, ukuphoqa iphethini elithile lohlobo.
Ibhokisi lokunquma le-Design View likuvumela ukuba ufake izimiso ezinciphisa, njengokuthi lapho umbuzo usebenza, ubonisa kuphela i-subset yedatha efana nesihlungi sakho. Isibonelo, embuzweni mayelana nama-oda womkhiqizo ovulekile, ungangezela umgomo = 'MI' kumkholomu wombuso ukukhombisa kuphela ama-oda avela eMichigan. Ukwengeza amazinga ezinkambiso, sebenzisa noma amabhokisi ngaphakathi kwekholomu noma wengeze imigomo kwamanye amakholomu.
Ukubuka kwe-SQL
Kubukwa be-SQL, i-Microsoft Access ithatha indawo yedatha ye-datasheet ne-Syntax ye-Structured Query Language ukuthi i-Access ihamba ukuze inqume ukuthi iyiphi idatha yokudonsa emthonjeni, nokuthi yimiphi imithetho yebhizinisi.
Izitatimende ze-SQL ngokuvamile zilandela ifomu lokuvimba:
HLOLA ithebula1. [Fieldname1], Ithebula2. [Fieldname2]
KUKATHEPHA1 KUPHELA HLELA I-Table2 KU-Table 1. [Key1] = Ithebula2. [Ikhi2]
LAPHO Ithebula1. [Fieldname1]> = "I-FilterValue"
Abathengisi be-database abahlukene basekela izinguqulo ezahlukene ze-SQL. I-standard standard, ebizwa ngokuthi i-syntax ye-ANSI-ehambisanayo, kufanele ikwazi ukusebenza kuzo zonke izimo zemininingwane. Noma kunjalo, abathengisi ngabanye bafaka i-standard ye-SQL namathebula ayo. I-Microsoft, isibonelo, isebenzisa i-Jet Database Engine ngaphakathi kwe-Access. I-Microsoft ibuye isekele iSQL Server. Abanye abathengisi basebenzisa izindlela ezahlukene, ngakho-ke i-SQL ngokuvamile ayinakuphikisana njengoba izindinganiso zisekela.
Uma ungajwayele i-syntax ye-Jet Database Engine yokuqaliswa kokusebenza kwe-SQL, bese uvula i-SQL View ingaphula imibuzo yakho. Namathela ekubukeni kwenkambiso, kunalokho. Kodwa-ke, ngenxa ye-tweaks esheshayo, ngezinye izikhathi kulula ukulungisa i-SQL engaphansi kunokuguqula isimiso se-Design View. Uma abanye abahlaziyi benkampani yakho befuna ukwazi ukuthi uthola kanjani umphumela, ukubathumelela nokunamathisela kwesitatimende sakho se-SQL kunciphisa ukudideka mayelana nokuklama kombuzo.
Ukulondoloza Umsebenzi Wakho
Ku-Microsoft Access 2016, ungagcina bese ubhala phansi umbuzo wamanje ngokuchofoza ngakwesokudla ithebhu yayo bese ukhetha Gcina. Ukuze ulondoloze umbuzo obuyekeziwe njengamanye amagama, uvumela umbuzo wamanje ukuba uqhubeke, chofoza ithebhu yefayela, khetha u- Save njenge- Save Object As.