Kanjani ukwakha database Access. Ukusebenza uhlu Finyelela

Abantu abaningi bendawo zaziwa okuyinto ngesikhathi esisodwa alamu wavuka MS Office 2007 esibonakalayo kushintshwe okuthile kulo bese lokho akusho bazithela nonjiniyela wayo! "Guru" kuzikhalela yokuthi entsha office suite kwaba "ngingafaneleki futhi uyinqaba", kodwa ngoba ngokuqiniseka wabikezela ukuqothulwa futhi inani abasebenzisi la mavangeli.

Lutho! Njengoba kwenzeka lutho, kunalokho, ngokushesha kakhulu kwaba sobala ukuthi ukusetshenziswa entsha "Ihhovisi" inguqulo sekulula kakhulu futhi kuwusizo kakhudlwana.

Futhi ngenxa yokuthi (njengoba kulindeleke) izinguqulo, izimfanelo okuyiwona adalwe ku "Office 2007" hhayi kuphela uthuthwa ngokuphumelelayo ku bezinga wawo omusha, kodwa wabuye wathola ngendlela enengqondo yakhe. Yingakho-2010 version isibe yathandeka kakhulu phakathi abasebenzisi professional.

Izinguquko in version entsha ye-Finyelela

Kakhulu izinguquko eziphawulekayo kwenziwa futhi isicelo odumile ngokudala yolwazi. Through the Sparklines elisha lengxenye, ungakha bese uhlela esiningi ulwazi. Futhi sibonga ithuluzi Slicer ithuba fast and navigation lula ngisho yolwazi enkulu. Futhi zonke sibonga izinga okusezingeni futhi ukucabangela ubukele uhlelo filtration.

Ngaphezu kwalokho, onjiniyela wanezela ukuhlanganiswa kangcono nge-Excel, ngokuqondile lapho ungakwazi ukungenisa esiningi ulwazi. Noma kunjalo, abasebenzisi imfundamakhwela ngaphezulu ngizibuze mayelana nendlela ukudala database Access.

Yini lena

Ukuze kahle usethe lezisekelo, kufanele uqale uwuqonde essence yabo. Database ngokuthi isakhiwo ngokuqinile ihlelwe yakhelwe ukugcina ubuye uhlelembise lwati. Kungaqukatha izinto ezahlukene kakhulu, kodwa iyunithi yabo okunengqondo yitafula.

umehluko ngokuyinhloko kusukela izakhiwo efanayo kumhleli spreadsheet ukuthi kuhlobene. Ukukhiqiza ukushintshashintsha iyiphi isici, uyoba ngokuzenzakalela Ukuqala indawo zonke kuhlobene ne izakhiwo ezihlobene nazo. Ngamafuphi nje, wena akusadingeki ukhathazeke ngesandla ukuhlela omkhulu Imininingwane amatafula.

Ongakwenza ngosizo MS Access?

Ungacabangi ukuthi isicelo uhlobo "ukuqhubeka okunengqondo» Excel. The kungenzeka uhlelo okukhulunywa ubanzi kakhulu. Ikakhulukazi, iyiphi ukudalwa yolwazi MS Access kudingeka acabangisise kahle sakhiwo selwati idokhumenti ethile, hlola ubuqotho idatha yoqobo, futhi lolu lwazi belingisa imibuzo, amafomu kanye nemibiko.

isibonelo ngokwakha

Ngakho indlela ukudala database Finyelela futhi angasebenzisa "Iseluleki" kwenza kube lula abasebenzisi imfundamakhwela, inqubo eyinkimbinkimbi ethile alihlukile. Kodwa thina ngeke batusa ukuya ngaleyo ndlela, njengoba zonke izinqubo kumele kuvisiseke kutsi ukhicite.

Okokuqala ukusebenzisa isicelo. inkhulumomphendvulwano lizovela esikrinini ukuze udale idokhumenti entsha. Kuyo kufanele ukhethe "Database okusha". Esikhathini "Igama lefayela" sivela ke okunenjongo. Gwema amagama ephindaphindwayo futhi lutho lutho: ngenxa nganoma isiphi isiphambeko noma ngobudedengu siqu, ungakwazi kalula ulahlekelwe ulwazi olubalulekile.

"Yakha" ngemva le nkinobho icindezelwa. Ngokushesha ngemva kwalokho, qapha izovela ebhokisini lengxoxo ukuze udale ithebula entsha ulwazi, kusuka lapho futhi ngeke ukudala iphrojekthi yakho.

Indlela ukukhetha imodi?

A ithebula ingafakwa ngezindlela eziningi ezahlukene, kodwa siyobe ukweluleka "Umklami", njengoba kulula ukulawula yonke le nqubo futhi baqonde kangcono wonke Sakhiwo sangekhatsi idokhumenti.

Sebenzisa inguquko "yohlobo Umklami" ukuya kuye. Ngemva kwalokho iqondiswa edingekayo ethize igama lethebula. Njengoba kungase kudingeke okungaphezu kokukodwa, sincoma futhi ukusebenzisa amanye amagama okunenjongo.

Manje, empeleni, inqubo ngokwalo. Kanjani ukwakha database Access? Isinyathelo sokuqala ukuba ukhethe bese ugcwalisa amagama Amasimu, ichaze izinhlobo idatha, kanye ukusetha lesifanele ensimini ukhiye. Kungaleso sikhathi kuphela lapho ungaqala ngokugcwalisa idatha ku etafuleni.

Ukuze wenze lokhu, sebenzisa umyalo "etafuleni yokubuka." Nakani! Uma ngabe inkambu "ikhodi into" esimweni sakho kubalulekile "Counter", bese ugcwalisa lwalowo akudingekile. Lapho usuqedile umsebenzi ukwethulwa kolwazi, kungaba ivalwe. Uma database ethile idinga itafula yesibili, wabuthela ithimba "Ukudalwa itafula design."

izibonelo lezisekelo

Konke okungenhla kungaba incwadi efile ngaphandle akunika imininingwane "ensimini isipiliyoni", okuyinto singaba usizo kabi Finyelela egciniwe. ungakwazi ukuxoxa izibonelo kule ndawo cishe akupheli, kodwa sizogxila ifomu, okungase sina lula ukugeleza inqubo yokufunda.

Chaza kafushane ukudalwa idokhumenti phezu lwezifundo. Yini ngidinga zihlanganisa? Lokhu kumele kufake mikhakha elandelayo: ikhodi okukhethekile, inombolo iqembu kanye nabafundisi ndaba. Sicela uqaphele: amasimu "Isihloko" futhi "uthisha" kufanele ihlotshaniswe ne amatafula ezengeziwe, okuvela kulo hlelo ngizodonsela ulwazi olufanele.

Lokhu kwenziwa kanjani?

Okokuqala, ukwenza zonke izenzo ngokuhambisana imiyalelo ngenhla. Iya "Design", uqala ugcwalise izinkambu. Ngokuvumelana ikhodi idatha ethile uthayiphe kumele kumakwe ngale "counter, ukhiye yensimu. '

I "Iqembu" futhi eziwundendende ezazikhuluma ngento efanayo yohlobo ensimini ubizwa ngokuthi "umbhalo." Kodwa emasimini "Isihloko" futhi "uthisha" Kufanele ukhethe "Lookup Iseluleki". Ungakhathazeki: ngokushesha lapho ukhetha le value, uhlelo izokubonisa ibhokisi lengxoxo. Ukulandela iziqondiso zakhe ngokuzithandela, ungakha isixhumanisi kwamanye amathebula. Njengoba wazi, kufanele isungulwe kusengaphambili.

Uma uchofoza inkinobho ka- "Qedile", isixwayiso uboniswa phambi kwakho ukuthi udinga ukudala uxhumano ukulondoloza etafuleni. Qinisekisa lesi senzo.

Ukudala ubudlelwano phakathi amatafula

Sesixoxile mayelana lokuthi ukusebenza database Finyelela kudinga ukuba khona izixhumanisi ngqo phakathi ama-spreadsheet amaningi. Ngakho indlela ukudala kubo?

Ukuze wenze lokhu, vula idokhumenti oyifunayo, bese iya endleleni, "Ukusebenza yolwazi - Data Scheme". Ukuze sithole bese usetha ubunjalo ubuhlobo, kufanele chofoza-double inkinobho yesinxele ebhokisini lengxoxo "Shintsha Association." Ngemva kwalokho kufanele chofoza inkinobho "OK". Ngenxa yalokho, wena ukusetha inketho ezenzakalelayo, "umuntu ezingozini eziningi".

Ngakho sabuka umbuzo kanjani ukwakha database Access. Sithemba ulwazi kuyoba wusizo kuwe.