Access-imilo. Yenza uhlobo yokungena data

Access isicelo Windows enamandla, inkqubo yolawulo ledatha (DBMS ). injongo yawo - ukunikezela ulwazi kumsebenzisi ngendlela elula, imisebenzi esizisebenzelayo, adla ngokuphindaphindiweyo. Le nkqubo inceda lokubuyisa nokugcina data. Yonke le ikhutshwa phandle Access-imilo. Iifom Ukudala - umsebenzi olula, ezenzelwe ukunceda umsebenzisi kangangoko kunokwenzeka.

Xa ifomu Ukufikelela njenge window venkile, kulula ukubona kwaye ukuvula izinto ezinqwenelekayo. Ekubeni le fomu - yinto into evumela abasebenzisi ukongeza, ukuhlela kunye ukubonisa idatha egcinwe kwi Ufikelelo, imbonakalo yawo idlala indima ebalulekileyo.

Ukuba database Access izicelo classical asetyenziswa ngabasebenzisi ezininzi, ifom oluyilwe kakuhle - ukuchaneka kwedatha isitshixo kunye nocikizeko nomsebenzi kunye nabo.

Yenza iindlela

database Access unika umsebenzisi kunye indlela elula yokusebenza data. Olu Access-uhlobo olulodwa, nto leyo kakhulu lula ukungena, ukuhlela data, ebajonga. Basimisela into ekhethekileyo kwiziko ledatha yaye abe nendawo elikhulu ulawulo ngazo kukho esizisebenzelayo ingxelo, zigcinwe iitafile zesiseko sedata. Ezi amasimi yombhalo, iibhokisi ngetshekhi, amaqhosha erediyo, uluhlu drop-phantsi, njalo njalo.

Iindlela ukudala iifom kwi Ufikelelo zezi ngezilingo;

• ukudala iifom ezisekelwe iitafile kunye nemibuzo ezikhoyo;
• ngokudala iindlela blank;
• isimo comma;
• iifomu ne-Bar;
• Iifom Access-ilawulwe.

Yenza uhlobo ngokusebenzisa i iFomu Wizard, umyili okhethekileyo.

Baluncedo kakhulu xa, umzekelo, ukufaka idatha kufuneka wenziwe kwiimo ezikhethekileyo. Ngokuba lo hlobo fomu, intsimi ufakelo lweenkcukacha ngokukodwa benze okufanayo njengoko kwifom.

Uhlobo lwemali phezu kwetafise ekhoyo

Iifom e Access isekelwe phezu kwetafise ekhoyo Ukudala ilula kakhulu. Ukuze wenze oku, funda "Creating a" imfuneko nqakraza kwiqhosha "Form". Imeko ephambili kule meko kukudala lokuqala iitafile data, kwaye ukukhethwa kwayo kwingingqi lokuhla unyuka. Le fom ibonisa irekhodi kuphela mnye, ngokunjalo data table enxulumene.

Ukuze ukubonisa multiple amarekhodi ngokoluhlu kufuneka ibe iqhosha efanayo "Dala" ukukhetha "iziqalelo zimbalwa". Ngoko ke siya kuba nako ukubonisa ifom imihlaba wokubhaliweyo, iqela iirekhodi idatha onke amasimi itafile.

Ngokwesiseko kukho iintlobo indalo itheyibhile ezikhoyo kwi Ufikelelo kwakhona likuvumela ukuba ukuphuhlisa uhlobo elahluleleneyo. Le mbono, leyo kunye nokumelwa datha a ulawulo yokukhetha data ngokunxuseneyo ekwimo itafile. Ukudala ifomu yahlula, kuyimfuneko xa iqhosha le "Yenza" kukukhetha "Split Form".

Iifom ezinjalo zisenokungabonakali nakanye elifomatiweyo kunye nolawulo ezininzi. Amaninzi ezi Izakhi amasimi itekisi-line enye, leyo zixhonyiwe amaxabiso data egcinwe kwi emasimini itafile. Endaweni pre-efomatiweyo, ungenza iifomu engenanto.

layout View

Ukulungele-to-ukusetyenziswa translation etafileni imbonakalo. Kule mo, oku kungatshintshwa kuphela iirekhodi data kanye iitafile zesiseko sedata, ukuhamba phakathi iirekhodi. Ifomathi kule imo akuvumelekanga, kunye nokudalwa iintlobo ze Microsoft Access kufuna ufomato ulawulo kunye ifomu ngokwayo. Konke oku kunokwenziwa, ukuba utshintshela imo Layout okanye imo yoyilo.

indlela Layout yahlukile amathuba imo yoyilo ezimbalwa ukwenzela kuyilo iifom. Noko ke, kulula kakhulu ngokufomata ekhawulezayo, ukuba enze utshintsho olungephi ukuya ulawulo: ulungelelwaniso kubo nkqo okanye zilaliswe, ukudibanisa amasimi itekisi ezongezelelweyo, ukutshintsha iintlobo isimbo, njalo njalo. Kwindlela Layout, awukwazi ukutshintsha imveliso data kwi ulawulo, lo gama imo yoyilo kunika ithuba enjalo.

Icwangcisa fomu Design mbono ezinokuntsonkotha kakhulu. Ukongeza, kuphela imo yoyilo ifumaneka linani lweziqalelo loyilo graphic, kwakunye nolawulo: iingxande, imigca, amaqhosha, bhokisi ze combo, amaqhosha unomathotholo, kunye nangaphezulu. Kule mo, unako ukutshintsha umthombo data ye fomu ukuhlelwa. Ngaphezu koko, le imo kungenziwa bekhubazekile indlela sebhodi.

Idibanisa iqhosha le fomu

Umzekelo, kufuneka Ukudibanisa iqhosha le fomu nge apho kuya kufuneka ukuba sivale. Xa imo yoyilo ifumaneka ku epheleleyo yobume izinto zolawulo, iphakathi apho iqhosha. Ukuba zizakuwela ubeko ifom, kuvimba iza kudala ngokuzenzekelayo master isitshixo, eya kuvela kwi ibhokisi lwabasebenzisi.

amaqhosha Window ukudala wosondeza ukhetho kweendidi eziliqela, eziquka uluhlu lwezinto. Kulo mzekelo, kufuneka ukhethe udidi "Ukusebenza kunye ifomu." Kolu luhlu didi intshukumo ukukhetha "Vala ifomu."

Kulandelayo kuyimfuneko ukwazisa umsebenzisi ukuba eli qhosha unoxanduva ukuvalwa sokubumba. Unga ushiye okubhaliweyo kwi iqhosha, kwaye uyakwazi xelela nge icon (umfanekiso).

Okulandelayo, i wizard uyabakhokela umsebenzisi ukunika igama iqhosha, ngoko unga nqakraza "Gqiba" - ukuze ufumane iqhosha ulungele kwifom, nto leyo eza kuvumela ukuba sivale.

Ukuba ngoku nqakraza kwi Yenza iqhosha, uza kuyalelwa ukuba asindise kuvimba wadala ngokohlobo utshintsho, uze uvale ngayo. E yoyilo, eli qhosha akusayi kusebenza. Isebenza kuphela indlela kuqulunqo.

Kuyimfuneko ukuba bathi iifom ngokwabo nga kuyilwa ngokusebenzisa i wizard okhethekileyo. Ngexesha ukwakhiwa inkosi sokubumbela mfuneko zichazwe kuphela kunye nezicwangciso zayo. Okulandelayo, uchake ngokulula i ifomu ukufomata kwenkosi yazo ngokokubona ngokuthi kokutshintshela ubeko imo kwaye imo yoyilo.

subforms

Ekwifom - into ibe ngumphelelisi omnye, engundoqo Access-imilo. Ukudala ukuzithoba iifom - luphuhliso yesakhiwo oluneqela elinegunya iitafile ezimbini, ebonisa ubukho yonxulumano phakathi kweentlobo.

Ubudlelwane phakathi kwabo lingakumela uhlobo ezahlukeneyo zokunxibelelana ifumaneka phakathi iitafile zesiseko sedata, "one-to-ezininzi", "abaninzi-to-ezininzi". Amaxesha amaninzi ezi ubudlelwane kuqwalaselwa nomini wecandelo kunye nobukho umzali (isiseko) fom kunye oluncedisayo (likhoboka).

Yintoni a ekwifom

subforms Ukubunjwa Access kungachazwa umzekelo: le fom ibe luhlobo lomthengi uyala ukuba ivenkile online.

ulwazi Customer iqulethwe itafile enye, kunye nolwazi malunga nemiyalelo yayo zigcinwa kwi enye ngokunxulumene kuqheleke koyilo ledatha. Enye umthengi idibana imiyalelo eziliqela, ngoko ubudlelwane phakathi umthengi nemiyalelo theyibhile zibonisa ukuzalana "one-to-ezininzi". Kulo mzekelo, imilo ukumela ulwazi lomthengi, uya kuba eziqhelekileyo. Enye imele kwakhe data odolo ziya kudityaniswa core kwaye ilawulwe.

Mayifakwe kwenye ubeko kwisithuba iifom eziphambili naphantsi okuphela data enxulumene. Umzekelo, ukuba itafile na umthengi umthengi ekhethekileyo, kwaye kweso sifundo naye imiyalelo itheyibhile amangeno ezintathu ezinxulumene, ngoko ekwifom imiboniso zonke zontathu iingxelo imiyalelo yakhe.

ifomu Wizard

Yenza isakhiwo oluneqela iifom e Access, ungakwazi ngeendlela ezahlukeneyo. Umzekelo, ukuphumeza imeko yokudala iintlobo aphambili naphantsi, uyakwazi ukubhenela usebenzisa i Wizard Form.

Ukudala uhlobo ephambili Access, equlethe owayamileyo, usebenzisa i wizard akuyi kuba lula. Akayi kuphela ukudala iifomu ngokwabo, kodwa Zinxibe kunye sengqondo kuyimfuneko. Ukuba ekwifom enye indalo imeko icebisa yokuyifaka engundoqo ekhoyo, ngoko ungakwazi noba ukusebenzisa iwizard, okanye tsala ngokulula kwaye uwuyeke netafile ezikhoyo ubeko engundoqo kwaye wenze kube ilawulwe.

Yenza i komphuta

Yenza subforms kusekelwe iitafile ezimbini ezinxulumeneyo (Authors kunye Books). Siya kusebenzisa le fom wizadi. Inyathelo lokuqala iza kuvula i inkosi ngokwakhe, ukusebenza iqela ifumaneka kwiziko ledatha Ukufikelela (ukudalwa forms). Xa Access 2007, umzekelo, ingafunyanwa kwi yotsalo-phantsi uluhlu item "Ezinye iintlobo".

window Wizard evulayo likucela ukuba ukhethe etafileni apho ufuna ukwenza iintlobo kunye namasimi (ukhetho enqakraza kabini), apho umsebenzisi angathanda ukubona. Emva itafile yokuqala kwi window enye, kuya kufuneka ukhethe enye, oludityaniswe kunye kuqala. Wizard liya ayinakubhaqa ulwalamano, kwaye ukuba angakwazi ukuyenza loo nto, ngoko udale iphetshana owayamileyo ngayo nje akakwazi. Kulo mzekelo, isicaka sobe ngohlobo kwenziwa ngokuthi kususelwe kwetafile yeeNcwadi.

In kwinyathelo elilandelayo le wizard likucela ukuba ukhethe uhlobo lwe data. Kufuneka ukhethe i "Subforms 'uze kwakhona ucofe iqhosha" Landelayo ".

Inyathelo elilandelayo kuza kusenza sikwazi ukukhetha imbonakalo iifom esekwe: tape okanye ubeko-sikalini lomxholo-based. Ndimele nditsho ukuthi khasethi entle ukuba iZimbo.

Kule inyathelo lokugqibela kufuneka ukuba wenze izihloko, kwaye nqakraza "Gqiba" - uhlale phantsi ukufikelela kule fomu. Ukwenza iifom.

Isakhiwo zavela uvulwe kuyilo okanye Ubeko view. Kuya kufuneka ukuba ukufomata intsimi onesiphumo, okanye ukongeza ezinye ulawulo.

Ukudala ifomu Swi kwi Ufikelelo

Ubukho kukho inani elikhulu amacwecwe database, kwakunye iifom ezinxulumene data kwezi theyibhile, nzima kakhulu le onokuyi database lulonke. Ukuze kube lula intshukumo phakathi kwezi ntlobo isiseko, ukudala ekuthiwa-form Main Swi. Le yeyona nto eqhelekileyo, leyo ezinokulungiswa ngokubona kwayo kwi kokwakha. Esinokubangela ukuba uthi, ukudala ifom Swi Main, wathimba ngaphandle nokudalwa kweefom ledatha e Access, nto leyo seyiva wayo wekhusi okanye lasekhaya.

Sebenzisa amaqhosha ibekwe phezu kube lula kakhulu ukuba ukuhamba phakathi elements, njengoko iqhosha ngalinye lu dityanisiwe ifom eyahlukileyo. Nqakraza kwiqosha abangela ledatha ukuba enze inguqu netafile iqosha enxulumene.

Ukusebenza kunye

E Access, ukudalwa ifom Main Swi ngendlela ekhethekileyo umlawuli. Dispatcher ifomu Swi uphantsi ukusebenza kunye zolwazi. Ukuba kwixesha lokuqala, uya kufumana ifomu Swi kwaye ekwenza ukuba ukudala. Pop-up window wizard iqulethe amaqhosha eziliqela ungakhetha i "Change" apho. Ngoko ke hamba uye iifom iphedi yamaqhosha umsebenzi yababini yonxibelelwano kunye nezinye iintlobo ezikhoyo kwisiseko.

Umzekelo, ukongeza amaqhosha amabini - "Button 1" kunye "Button 2" - kwifom Main Swi. Ezi amaqhosha Qhagamshelana ifomu Authors1 kunye Iincwadi, nto leyo ezincane. Ngokukhetha "Entsha", siya kuzakuvula ibhokisi yencoko yababini apho sibonisa igama wacela iqhosha kwaye intshukumo ukuba kufuneka enze ( "ifomu Vula ukutshintsha"). Endle wesithathu, ngenisa ifomu esifuna ukudibanisa ukudibanisa amaqhosha.

Ukuvala izicwangciso window, sifumanisa ukuba uhlobo yethu Swi wabonakala kwi window yokukhangela. Ukukhetha kulwahlulo yokukhangela, vula ifestile ubone ukuba iqulathe indlela elula uyilo, kunye amaqhosha amabini. Ukunqakraza ku amaqhosha aya kubangela ledatha ukuvula ifomu iqhosha inxulumene.

iitafile ukwahlukanisa

Kwitheyibhile ulwahlulo emva kotyando inokufumaneka ukudibanisa itafile entsha ebizwa ngokuba Swi Izinto. Igcina zonke izicwangciso ezinxulumene ekudaleni ifom Swi. Kwimeko yethu kukho ifomu Swi kuphela elinye kunye amaqhosha amabini, ngoko ibekwe amangenelo ezintathu kuphela:

• iirekhodi amaqhosha eziqulethwe kwifom,
• izenzo ezinxulumene nazo,
• irekhodi ngohlobo kakhulu Swi.

imo yoyilo

ifomu Swi Created ibe nzima ukufometha kuyo kwimboniselo umxholo Design. Ukuyisebenzisa phezu ungadibanisa ezinye ulawulo ezininzi luncedo.

ifomu Swi Main unalo ikhono ukuze alunxulumanise nezimo okanye ezinye iimilo ezifanayo. Lo msebenzi osemqoka uluncedo kakhulu sicwangcise ukuguquka phakathi kweentlobo kwidathabheyisi enkulu kakhulu apho kukho indawo kwiintlobo ngeentlobo kumacandelo kunye neendidi.