Indlela ukudala uvimba in Access. Ukusebenza kunye database Access

Uninzi lwabantu balapho baziwa nguwuphi kwenye alarm kwixesha lenyuka ukusuka kwi-Ofisi MS 2007 ujongano lungiswa, yaye yintoni na ezinamanzi developer kwayo! "Guru" wakhala into yokuba yisuti ye ofisi intsha 'nzima yaye ingumnqa ", kodwa ngenxa yokuba ngokuzithemba kwangaphambili kwelungiselelo kunye nabasebenzisi zisabonakala iyonke.

Akukho nto! Ekubeni kwakungekho nto Kwathi, phezu koko, ngokukhawuleza kakhulu kwacaca ukuba ukusetyenziswa "Office" inguqulelo entsha iye yaba lula kwaye kulula kakhulu.

Kwaye ngenxa yokuba (njengoko kulindelwe) utshintsho, ezona zinto zifuneka kuqala ukuze ayayilwa kwi "Office 2007" hayi kuphela kushukunyiswa ngempumelelo subsistence wayo omtsha, kodwa wafumana uphuhliso ubhalo bakhe. Kungenxa yoko le nto uguqulelo 2010 uthandwa kakhulu phakathi kubasebenzisi abaziingcali.

Utshintsho kwi kwinguqulelo entsha ye Access

Kakhulu utshintsho ezibalulekileyo zenziwa kwaye abadumileyo isicelo ekudaleni zolwazi. Ngokusebenzisa icandelo Sparklines ezintsha, ungenza kwaye uhlele oluninzi ulwazi. Kwaye ngenxa ngesixhobo isihluzi unalo ithuba fast kunye nokuhamba lula nkqu zolwazi ezinkulu. Kwaye zonke ngenxa umgangatho ophezulu olucingisiswe zivulelwe nama nkqubo.

Ukongeza, ababhekisi phambili ngendikongezile nokudityaniswa okungcono kunye Excel, uyakwazi ukungenisa ulwazi oluninzi ngqo kuzo. Noko ke, abasebenzisi abo basandula kuqalisa rhoqo uzibuze ukuba ukudala indlela database Access.

Yintoni le

Ukuze ngokufanelekileyo kumisa iinqwelwana, kufuneka kuqala siqonde ubuntu babo. Database ebizwa amalungiselelo ngokungqongqo isakhiwo eyenzelwe ukugcina nokuqokelela ulwazi. Isenokuba izinto ezahlukeneyo kakhulu, kodwa icandelo labo ubhalo yitafile.

umahluko zazo eziphambili kwiziseko ezifanayo kumhleli spreadsheet kukuba zihlobene. Ukuvelisa-cinci ku fana na element, uya umkhwetha ngokuzenzekelayo ukutshintshwa bonke amaqhina oqhagamshelwano kunye nezakhiwo ezinxulumene. Ngamafutshane, akusekho mfuneko naxhala ngesandla ukuhlela iitafile omkhulu ulwazi.

Into onokuyenza ngoncedo MS Access?

Musa ukucinga ukuba isicelo luhlobo "phambili ubhalo» Excel. Ukuba nokwenzeka kwale nkqubo ekuthethwa ibanzi kakhulu. Ngokukodwa, nayiphi na indalo-lwazi MS Access ufuna nzulu ukwakhiwa kolwazi uxwebhu ethile, khangela ingqibelelo idatha yoqobo, kwaye asebenzise olu lwazi ukuze akwazi imibuzo, iifomu kunye neengxelo.

Umzekelo udale

Ngoko ke indlela yokwenza uvimba kwi Ufikelelo kwaye usebenzise i 'Wizard "yenza kube lula kubasebenzisi abo basandula kuqalisa, inkqubo zintsonkothe ethile akukho ezahlukeneyo. Kodwa besiya singacebisi ukuhamba ngaloo ndlela, ekubeni zonke iinkqubo kufuneka iqondwe ukuba ibe nemveliso.

Okokuqala ozakusebenza isicelo. incoko ukuvela kwiskrini ukwenza uxwebhu olutsha. Kuyo umele ukhethe "sedata New". Xa i "igama Wefayile" lokuQala iqondakala. Ziphephe amagama phindo kunye nenjongo nto: njengoko ngenxa yaso nasiphi na isiphoso okanye nokunganaki yakhe, ungaphulukana ngokulula inkcazelo ebalulekileyo.

"Yenza" emva eli qhosha licinezelwe. Ngokukhawuleza emva koko, lo esweni iya kuvela ibhokisi yencoko yababini ukwenza itheyibhile entsha ulwazi, wena uya ukwenza iprojekthi yakho kuzo.

Indlela ukukhetha imo?

A itafile ingafakwa ngeendlela ezininzi ezahlukeneyo, kodwa siya kucebisa 'uMyili ", ekubeni kulula ukulawula yonke inkqubo kwaye ngcono ukuqonda isakhiwo yonke yangaphakathi lolu xwebhu.

Sebenzisa lenguqu "Uhlobo-uMyili 'ukuya kuyo. Emva koko kubhaliwe ilawulwa kufuneka ethile igama letheyibhile. Ekubeni kusenokufuneka ngaphezu kwesinye, sicebisa kwakhona ukuba usebenzise amanye amagama anentsingiselo.

Ngoku, eneneni, inkqubo ngokwayo. Indlela ukudala uvimba in Access? Inyathelo lokuqala kukukhetha kunye ufakele amagama amasimi, ukuchaza iindidi zedata, kwakunye intsimi elichanekileyo isitshixo. Kuphela ke ungaqala ngokugcwalisa umbhalo kwi table.

Ukuze wenze oku, sebenzisa umyalelo 'indlela yemboniselo itafile. " Ziqapheleni! Ukuba endle "ikhowudi object" kwimeko yakho kuyimfuneko "Counter", uze ugcwalise entsimini ethile ayikho imfuneko. Xa sele ugqibile umsebenzi kusungulo lolwazi, oko masivalwe. Ukuba database ngokukodwa itafile yesibini, oko wahlanganisa iqela 'Creation kwetafile yoyilo. "

imizekelo neziseko

Konke oku kungentla bekuya kuba ileta ofileyo ngaphandle ukuninika iinkcukacha "ngamava intsimi", bangenayo Access database lokuposa. nixoxe Imizekelo kule ndawo phantse ongapheliyo, kodwa siya kugxininisa kwifom, angafaka lula ukuhamba inkqubo yokufunda.

Ngokufutshane chaza nokudalwa uxwebhu kwi ikharityhulam. Yintoni ekufuneka ukuba ndiqale kuquka? Oku kufuneka kuquke amasimi zilandelayo: ikhowudi okukhethekile, inombolo iqela, yaye ootitshala bezifundo. Nceda uqaphele: amasimi "Subject" yaye "umfundisi" kufuneka ezinxulumene iitafile olongezelelweyo, apho le nkqubo iya kukha ulwazi olufanelekileyo.

na kwenziwa njani?

Okokuqala, ukwenza zonke izenzo ngokungqinelana le miyalelo ilapha ngentla. Yiya kwi "Design", uqala ku gcwalisa imihlaba. Ngokuhambelana ikhowudi idatha ethile uyichwetheza kufuneka ziphawulwe ngokuthi "counter, intsimi key".

I 'Group "kunye imigca efanayo yohlobo intsimi obizwa ngokuba" umbhalo. " Kodwa amasimi "Subject" yaye "umfundisi" kufuneka ukhethe "Lookup Wizard". Musa Ungakhathazeki: kamsinya nje ukhetha eli xabiso, inkqubo iya kubonisa ukuba ibhokisi yencoko yababini. Emva imiyalelo yakhe, uyakwazi ukwenza ikhonkco ezinye iitheyibhile. Njengoko usazi, kufuneka amiselwe kwangaphambili.

Xa unqakraza kwiqhosha "Gqiba", isilumkiso uboniswa phambi kwakho ukuba ufuna ukwenza uqhagamshelwano ukugcina itafile. Qinisekisa le senzo.

Nokwakha ubuhlobo phakathi iitafile

Sele sathetha ngalo yokuba osebenza kwiziko ledatha Access kufuna ubukho unxulumano ngqo phakathi spreadsheets ezininzi. Ngoko njani ukudala kubo?

Ukuze wenze oku, vula uxwebhu oyifunayo, uze emva koko uye endleleni, "Ukusebenza kunye sogcino - Scheme Data". Yokufumanisa Ukuseta uhlobo lobudlelane, kufuneka-nqakraza kabini ekhohlo iqhosha le mouse kwi kwibhokisi yencoko "Tshintsha Association." Emva koko kufuneka klikha kwiqhosha "Kulungile". Ngenxa yoko, ngaba umisela oku ekunokukhethwa olungagqibekanga, "ezininzi".

Ngoko Wajonga umbuzo indlela yokwenza uvimba in Access. Sinethemba ezi nkcukacha ziya kuba luncedo kuwe.