Nzira yekugadzirisa mhinduro yeMicrosoft Access yakafanana neyokugadzira imwe panzvimbo yekutanga. Mhinduro dzingashandurwa uchishanda kana Design View kana SQL View, zvisinei-haugoni kushandisa Query Wizard kugadzirisa mhinduro iripo.
Tanga nekukanda-cheta mhinduro yako yakagadzirirwa mukati mezvinhu zvepanepa kuruboshwe rwekona mukati me database yako. Munzvimbo ye-pop-up, sarudza Design View. Mhinduro inotanga kuDatasheet View. Paunonyatsotsinzina zita remubvunzo mumutsetse wepamusoro pamusoro peDatasheet View output, unogona kuchinja maonero. Nokusingaperi, uri muDatasheet, iyo isingagoni kugadziriswa yakarongeka (kunyange iwe unogona kuisa uye kubvisa deta kubva maonero aya). Kubva pane SQL kana Kuburitsa maonero, zvisinei, iwe unogona kugadzirisa sarudzo yechiratidzo uye kuchengetedza kana kuchengetedza-sechinhu chakachinjwa sezvinodiwa.
Design View
Chigadziro Chekuona chinotanga kuzarura split screen. Iyo hafu yepamusoro inoratidza marangire anomiririra tafura imwe neimwe kana mubvunzo unofambisa mhinduro iwe uri kugadzirisa. Minda mikuru-inowanzove yakasiyana-siyana-chinzvimbo chekidiki kadi yegoridhe iri pedyo navo. Chimwe chezvikwangwani chinopindirana kune mamwe maketani nenzira yemitsara inobatanidza masimi mune imwe tafura kuminda mune imwe.
Iyi mitsetse inomirira hukama. MuChirongwa Chekuona, kurongedza kwakarurama pamutsara kunoita kuti uchinje ukama. Iwe unogona kutora pane chimwe chezvinhu zvitatu zvinosarudzwa:
- Nzira iyo iyo yakabatana neminda mumatafura ose maviri akaenzana
- Nzira uko kuruboshwe-yakawanda tafura inodzorera mhinduro dzose uye tafura yakarurama inoratidza mamiriro akafanana
- Mharapa iyo iyo yakawanda-tafura yakawanda inodzorera mhinduro dzose uye tafura yakasara inoratidza kuenzanirana nemigumisiro
Izvi zvitatu zvakabatana nemhando (mukati, kuruboshwe, kurudyi) i-subset yehuwandu hwakazara hwekubatanidza iyo database inogona kuita. Kuti uite zvakawanda zvakaoma kunzwisisa, iwe uchada kutamira kuSQL View.
Paunosangana matafura ako akasarudzwa neukama hwomukati, uchaona chikamu chepakati chechirwisi chinoratidza grid rine mazita ose masimba ayo mubvunzo uchadzoka. The Show box inoratidzira kana inopedza munda apo mubvunzo unotanga-unogona kufuta mubvunzo unobva paminda isingaratidzi. Iwe unogonawo kuwedzera kana kuchinja kurongeka kwakadaro kurongedza zvawanikwa mukukwira kana kuburuka, kunyange zvazvo Microsoft Access ichishanda nzira dzakasiyana-siyana kurudyi kusvika kuruboshwe muminda. Iwe unogona kugoverazve mapuranga nekutakudza avo vari kuruboshwe kana kurudyi kune gridi, kumanikidzira imwe rudzi rwemhando.
Bhokisi reConner View's Criteria rinoita kuti iwe uise maitiro ekudzivirira mitemo, yakadai apo kana mubvunzo uchitanga, unongoratidzira subset ye data inofanana nefaira yako. Somuenzaniso, mubvunzo pamusoro pemirairo yakasununguka yemiti, unogona kuwedzera mutsara = 'MI' kuenda kune imwe koromo yehurumende kunongoratidzira mirairo kubva kuMichigan. Kuti uwedzere mazinga ezvirongwa, shandisa iyo kana mabhokisi mukati memutsetse kana kuwedzera zviyero kune mamwe ma column.
SQL View
MuSQL kuona, Microsoft Access inotsiva datasheet neStructured Query Language syntax iyo Access inosarudza kuziva kuti dheti inodhonza kubva kune imwe nzvimbo, uye nemitemo ipi yebhizimisi.
SQL zvinyorwa zvese zvinotevera fomu yebato:
Sarudza Table1. [Fieldname1], Table2. [Fieldname2]
KUBVA TEKI1 RONO KUTI TARI2 ONI TABLE1. [Key1] = Table2. [Key2]
PANE PANE 1. [Fieldname1]> = "FilterValue"
Vakasiyana-siyana vevatengesi vekodzero vanotsigira zvinyorwa zvishoma zveSQL. Nheyo yepamusoro, inonzi ANSI-inoenderana nechidimbu, inogona kukwanisa kushanda mune imwe nharaunda yezvinyorwa. Zvisinei, mutengesi mumwe nomumwe anoshandisa SQL yakawanda neyoyo tweaks. Microsoft, somuenzaniso, inoshandisa Jet Database Engine mukati. Microsoft inotsigirawo SQL Server. Vamwe vatengesi vanoshandisa nzira dzakasiyana, saka SQL yakawanda haisi inopindirana sezvo mitemo inotsigira.
Kana iwe usingazivi nheyo yeJet Database Engine yekushandiswa kweSQL, zvino kubvarura SQL View kunogona kuputsa mibvunzo yako. Gadzirira Kuona Maonero, pane. Zvisinei, nokuda kwechimbichimbidzika zvishoma, dzimwe nguva zviri nyore kugadzirisa SQL iri pasi pane kugadzirisa Chirongwa cheGadzira View. Kana vamwe vatsvakurudzo vari muboka rako vachida kuziva kuti wakawana sei mugumisiro, kuvatumira kudonhwa-uye-kusina kweSquL yako mazwi kunoderedza kupesana pamusoro pemibvunzo yekugadzira.
Kuchengetedza Basa Renyu
MuMicrosoft Access 2016, unogona kuchengetedza uye kubhadhara mubvunzo wemazuva ano kuburikidza nechokuita pane tab uye kusarudza Save. Kuti uchengetedze mhinduro yakadzokororwa seimwe rimwe zita, uchibvumira mubvunzo wemazuva ano kuti urambe uchisimbirira, chengeta File tab, sarudza Save As uye ipapo Save Object As.