Ndondomeko yosinthira funso la Microsoft Access ndi ofanana ndi ndondomeko yolenga imodzi pamalo oyamba. Mayankho angasinthidwe pogwiritsa ntchito Design View kapena SQL View, komabe-simungagwiritse ntchito Query Wizard kuti musinthe funso lomwe liripo.
Yambani mwakulumikiza molondola phokoso lanu lololedwa mkati mwazanja zamanja kumanzere kwa chinsalu mkati mwachinsinsi chanu. M'masewera apamwamba, sankhani Zojambula Pangani. Funso likuyamba mu Datasheet View. Mukamagwiritsa ntchito ndondomeko yoyenera pa dzina la funsoli mumzere wotsatila pamwamba pa Datasheet View output, mungasinthe mawonekedwe. Mwachibadwidwe, muli mu Datasheet, zomwe sizingasinthidwe (ngakhale mutha kulowa ndi kuchotsa deta kuwona). Kuchokera ku ma SQL kapena Mapulani, komabe mungasinthe momwe polojekitiyo ikuyendera ndikusunga kapena kusunga-ngati chinthu chosinthidwa.
Zojambula Zojambula
Kukonzekera Pangani kutsegula chithunzi chosagawanika. Hafu yapamwamba imasonyeza makateni omwe akuimira tebulo lililonse kapena funso loyesa funso limene mukusintha. Masewera ofunikira-kawirikawiri chizindikiro chodziŵika chachitsulo chachitsulo kakang'ono ka golide pafupi nawo. Mzere uliwonse umagwirizanitsa ndi makina ena pogwiritsa ntchito mizere yolumikiza masamba mu tebulo limodzi ku minda ina.
Mizere imeneyi ikuimira maubwenzi. Mu Design View, kulumikiza molondola pa mzere kukuthandizani kusintha chiyanjano. Mukhoza kusankha kuchokera pa chimodzi mwazigawo zitatu:
- Amayang'ana kumene magulu awiri omwe ali nawo m'matawuni onsewa ali ofanana
- Imafika kumene gome lamanzere likubwezera zotsatira zonse ndipo gome lolondola likuwonetsa zotsatira zofanana
- Mzere pamene tebulo lalikulu labwino libwezera zotsatira zonse ndi tebulo lakumanzere likuwonetsa zotsatira zofanana
Zitatu izi zimagwirizanitsa (mkati, kumanzere, kumanja) ndi gawo limodzi lazowonjezereka zomwe database ikhoza kuchita. Kuti muchite zovuta zambiri, muyenera kusamukira ku SQL View.
Mukamagwirizanitsa matebulo anu osankhidwa ndi mazere a ubale, mudzawona theka lachiwonetserocho likuwonetsera gululi mndandanda zonse zomwe funsoli lidzabwezere. Bokosi lawonetsera likuwonetsa kapena kuthetseratu munda pamene funso likuyendetsedwa-mukhoza kusakaniza funso lochokera m'minda yomwe sali kuwonetsedwa. Mwinanso mungawonjezere kapena kusintha ndondomeko yanu kuti muwone zotsatira zowonjezera kapena zowonjezera, ngakhale Microsoft Access idzakonza mitundu ingapo kumanzere kupita kumanja. Mukhoza kukonzanso mapulaneti mwa kuwakokera kumanzere kapena kudutsa galasi, kukakamiza mtundu wina wa mtundu.
Bokosi la Cholinga cha Design View limakulowetsani zolemba zoyenera, kotero kuti pamene funso likuyendetsedwa, limangowonjezera gawo lomwe likugwirizana ndi fyuluta yanu. Mwachitsanzo, mu funso lokhudza machitidwe otseguka, mukhoza kuwonjezera chotsatira = 'MI' ku khola la boma kuti uwonetsere malamulo ochokera ku Michigan. Kuti uwonjezere mayendedwe, gwiritsani ntchito kapena mabokosi omwe ali m'ndandandawo kapena kuwonjezera zofunikira kuzitsulo zina.
SQL View
Mu SQL view, Microsoft Access imalowetsa datasheet ndi syntax ya Structured Query Language kuti Access akufufuza kuti adziwe chidziwitso chomwe angachoke ku gwero, komanso ndi malamulo amtundu wanji.
Mafotokozedwe a SQL ambiri amatsatira mawonekedwe a mawonekedwe:
ONSE Table 1. [Fieldname1], Table2. [Dzina la2]
Kuchokera pa Table1 KUMOYO PEZANI Table2 ON Table 1. [Key1] = Table2. [Key2]
PAMENE Pulogalamu 1. [Fieldname1]> = "Masewu Owonetsera"
Ogulitsa malonda osiyanasiyana amathandiza SQL zosiyana. Miyeso ya maziko, yotchedwa syntax ya ANSI-yovomerezeka, iyenera kugwira ntchito mu malo onse okhala ndi deta. Komabe, wogulitsa aliyense amalumikiza muyezo wa SQL ndi mawonekedwe ake omwe. Mwachitsanzo, Microsoft imagwiritsa ntchito Jet Database Engine mkati. Microsoft imathandizanso SQL Server. Ogulitsa ena amagwiritsa ntchito njira zosiyana, kotero SQL zambiri sizingagwirizanitse monga momwe miyezo ikuthandizira.
Ngati simukudziwa bwino mawu a Jet Database Engine of implementation of SQL, ndiye kusintha kwa SQL View kungathetse mafunso anu. Onetsetsani Kukonzekera Pangidwe, mmalo mwake. Komabe, kuti tipewe msanga kwambiri, nthawi zina zimakhala zosavuta kusintha SQL yeniyeni kusiyana ndi kusintha ndondomeko ya Design View. Ngati akatswiri ena mu kampani yanu akufuna kudziwa momwe muli ndi zotsatira, kuwatumizira kudula ndi kusunga mawu anu a SQL kumachepetsa chisokonezo pazokambirana.
Kusunga Ntchito Yanu
Mu Microsoft Access 2016, mukhoza kusunga ndi kulemba mndandanda wamakono powasindikiza pomwepo ndikusankha Sungani. Kusunga funso lokonzedwanso monga dzina lina, kulola funsoli kuti likhalepo, dinani Fayilo la Fayilo, sankhani Kusunga Monga ndikusunga Object As.