MS Access. MS Access egciniwe. MS Access 2007

MS Access - amaklayenti-server zingubudlelwane ngabaphathi semininingwane uhlelo (RDBMS) kusuka e-Microsoft. Zingubudlelwane kusho ukuthi kusekelwe amatafula. Sibheka lesi simiso kabanzi.

Kuyini database zingubudlelwane?

A database zingubudlelwane siqukethe iqoqo amatafula, phakathi okuyinto ukwakha ubudlelwane noma ukuxhumana. Database - igobolondo elikuvumela ukuthi idale iphinde futhi ukusetshenziswa yolwazi MS Access.

Cabanga ngebuhle nebubi we DBMS.

Izinzuzo DBMS Microsorf Finyelela

• Isikhombikubona elula enembile. Thola ukusebenza le database kungaba, nge akhethekile. Ngaphezu kwalokho, usizo imfundamakhwela ka eminingi izincwadi, ku-intanethi futhi izifundo ku-intanethi.
• MS Access egciniwe kahle aziwayo futhi ethandwa kakhulu PC ideskithophu. Lokhu kusho ukuthi ungahlala ukufuna usizo lomngane, Ubelokhu elisebenzisa leli database yemindeni ecela iseluleko, kanye umsebenzi ndawonye nomunye semininingwane kunethiwekhi.
• amathuba Cishe angenamkhawulo ukuthumela idatha: idatha kusuka amatafula okukodwa igundane angadluliselwa Excel, iZwi, ukuthekelisa-XML, ushicilela ku-PDF, ingasaphathwa yokuthi akukho izinkinga ukuhambisa izinto ezikhethiwe kwenye egciniwe.
• Intengo Okuphansi. Uma uthenga MS Access njengengxenye ngokugcwele iphakethe-Microsoft Office, njengoba kuqhathaniswa nezinye yolwazi esikhokhelwayo, intengo kuyoba ekhangayo.
• Kufanele kukhetfwe tinhlobo letibanti abaklami yamafomu isakhiwo, imibiko kanye nemibuzo, ungasebenzisa ukuhlunga idatha uphinde ukubonise ngendlela elula.
• Amathuba ukuze ungenise idatha, uma une idatha yethebula ngokusebenzisa igama processor MS Word noma MS Excel-spreadsheet processor, usebenzisa wizadi isuke wabayisa database wakho kalula. Imports, ngaphezu, kungenziwa kusuka idokhumenti elula umbhalo kusukela idokhumenti ye-XML, kanye amafayela semininingwane wadala kwezinye yolwazi (ezifana dBASE, indida).
• Amandla wenza iphasiwedi database wakho.
• Esakhelwe ngaphakathi ephezulu lelulwimi VBA.
• Ikhono ukurekhoda amamakhro.
• umhleli SQL.

Ukuze program Ungakhetha elinye inzuzo enkulu: core Finyelela JET 4 linamathele wokusebenza Microsoft, eziqala Windows-based 98. Lokhu kusho ukuthi isicelo usebenzisa database ezidalwe Finyelela, ungakwazi usiphathe kunoma iyiphi ikhompyutha ku-Windows. It izosebenza ngaphandle kokuba ukufaka DBMS uqobo. In an icala ngokwedlulele, badinga kuphela ukufaka isikhathi sokusebenza - inguqulo, okungaba nhlobo ukulanda kusuka kuwebhusayithi Microsoft.

Njengoba ubona, isithunzi DBMS MS Access iyatholakala. Kodwa zonke izinzuzo zingaba zinkulu nemibi ngempela ebalulekile. Ake sihlole kubo.

Okumbi Ukufinyeleleka DBMS Microsoft

• MS Access libhekisela database ifayela-server. Lokhu kusho ukuthi yonke idatha icutshungulwe ngqo umsebenzisi iklayenti ikhompyutha. Ingxenye iseva ye uthatha idatha futhi adlulisele kubo kwesidzingo. Lokhu kuholela yokuthi kunethiwekhi zendawo zazitholakala notshwala enkulu idatha, kanye inqwaba abasebenzisi ukusebenza database, kungase inethiwekhi ukuminyana. Classic ifayela-iseva izakhiwo zihlala akuhileli umkhiqizo ongaphakeme lapho inombolo enkulu abasebenzisi. Ngo MS Access 2010 version lolu daba kancane ukuxazululwa.
• Ukuswelakala kokusebenza ngokuhlanganyela okunokwethenjelwa amathuluzi yokuvikela idatha. Eqinisweni, kuphela iphasiwedi isetshenziswa ngesisekelo idatha nephasiwedi yomsebenzisi. Ukuze onguchwepheshe abanolwazi abalona nobunzima ukususa le Ukuvikelwa.
• Imodi yabadlali abaningi kungenzeka kuphela i inethiwekhi Yesikhashana noma iseva ifayela inethiwekhi.
• Ukuze wenze uhlelo lokusetshenziswa esibonakalayo ngokwezifiso liyadingeka ukuheha program.
• Umhleli imibuzo ye-SQL kuyinto bakudala, kungelula ukusebenzisa.
• Lokhu semininingwane akuyona khulula.
• MS Access ababoshiwe ngaphansi okusebenza izinhlelo Windows. Ukuzama ukusebenzisa idatha wadala database kwezinye izinhlelo zokusebenzisa (isibonelo, i-Linux), ube muhle olukhohlisayo. Vele uthumele idatha kwenye egciniwe.

Uma sabuka ngokucophelela ngobuhle nangobubi bawo MS Access, isibonelo 2007 version uyonika ezinye imiyalelo esheshayo amathuba le database.

Ukudala amathebula

Akukho lutho kulula kuka ukuze udale ithebula ezintsha usebenzisa MS Access 2007:

1. "Creation," uye kuthebhu kokuvula egciniwe.
2. Chofoza isithonjana "Table", kuba owokuqala ngakwesokunxele.
3. Phambi kwethu kuvumelana kwetinhlavu etafuleni enegama ejwayelekile "Table 1" kanye auto-incrementing ensimini "Ikhodi".
4. Ungakwazi baqale kwedatha yokufaka ikholomu yesibili. Ngemuva kokufaka emgqeni, kufanele ucindezele Enter. Ikholomu ngokuzenzakalelayo kabusha kuya ku- "Field 1," "Ikhodi" ensimini kuzothatha ukubaluleka amayunithi kuyoba idatha okokufaka etholakala emgqeni olandelayo.
5. Ukuqamba kabusha ikholomu, vele uchofoze ngayo igundane kabili. Kuyinto efiselekayo ibeka amagama ikholomu kungabikho izikhala!
6. Builder amatafula ku-Finyelela 2007, sihlakaniphe kakhulu. Kuwufanele wena emgqeni wokuqala we ithebula elisha ukungena ukubaluleka emkhakheni uhlobo "Usuku", njengoba ku ulayini olandelayo kukholomu efanayo ngeke ngokuzenzakalelayo ukumenywa ukusebenzisa ikhalenda.
7. Ukuqedela ukudalwa etafuleni kufanele ilondolozwe ngokuchofoza isithonjana efanele noma inhlanganiselazihlonzi CTRL S.

Abasebenzisi abaningi kuwusizo kakhudlwana ukuya umbuso "Umklami" umsebenzi enembile amasimu kwetafula, ngoba kule modi, ungacacisa izinhlobo amasimu, imigoqo amagugu. Kule modi, ungaya nganoma yisiphi isikhathi ukusebenza etafuleni, umane cindezela inkinobho ohambelana on iphaneli.

Ukudala nombuzo

Cabanga indlela ukudala imibuzo MS Access. Ngo-2007 kuzodala nombuzo elula e Design umbono:

1. On the "Imenyu" ifasitelana, chofoza "Yakha" inkinobho "Umbuzo Umklami" ithebhu.
2. Lapha uzothola ngokushesha ubone amatafula Ukukhetha iwindi. Chofoza etafuleni ngalinye kusukela okumele idatha ekhethiwe. Kufanele kukhunjulwe ukuthi choice uzokwazi ukuba afeze kuphela uma etafuleni ezingaphezu kweyodwa kungenziwa ngokunengqondo exhumene nomunye by iyiphi inkundla.
3. Uma oyikhethile ithebula ezingaphezu kwesisodwa, kufanele ukwakha isibopho phakathi kwabo, uhlehlise Ngokuvumelana igundane kusukela inkambu kuthebula olulodwa ensimini kokuba exhumene omunye.
4. Manje chofoza kabili emkhakheni etafuleni ngalinye ofuna ukubona umphumela.
5. Kubha imenyu "Design" ithebhu, chofoza elikhulu umbabazi. Ngaphambi avele tabular yakha imiphumela okukhethile.

Lona ifomula jikelele ngokudala imibuzo. Ukuze uthole olunye imibuzo eziyinkimbinkimbi, bheka Usizo hlelo, noma ukusebenzisa izinsiza ekhethekile.

Ngezinye izikhathi ngisho imfundamakhwela umsebenzisi angathanda ukwethula idatha yakho ngefomethi wusizo nakakhulu kunalawo atholakala etafuleni elula. Khona-ke efika ukusiza MS Access ithuluzi - "Amafomu".

ifomu Iseluleki

On isibonelo Finyelela 2007, cabangela indlela yokusebenzisa Wizard Ifomu:

1. On the "Dala" ithebhu, ngaphansi kwesithi "Amafomu" yiya engxenyeni ethi "Ifomu Iseluleki" ngokusebenzisa "Ezinye izinhlobo".
2. Khetha kusukela uhlu olwehlayo, itafula noma umbuzo ofuna ukwakha ifomu ezibukwayo.
3. Sebenzisa ">" futhi ">>" of ukudluliselwa block "Amasimu Iyatholakala" izinsuku lamakholomu block "Kukhethwe Amasimu" elilodwa noma ngesikhathi esisodwa, ngokulandelana. Chofoza inkinobho ethi "Okulandelayo".
4. Khetha ukubukeka ifomu usebenzisa inkinobho.
5. Okulandelayo, khetha isitayela ifomu, futhi ungacindezela inkinobho ka- "Qedile". Nansi etafuleni noma nombuzo idatha yakho ngefomethi ezithakazelisayo.

Ukuze wakhe bobunjwa eziyinkimbinkimbi kufanele asebenzise umakhi ezifanele.

Njengoba lezi ziqondiso, singaphetha ngokuthi MS Access - lena ithuba elihle izindleko ezincane. isikhombikubona enobungane, ukwanda okushunyekiwe ukwesekwa onjiniyela nabakhandi - konke lokhu kwenza kube lula ukuklama database futhi sisebenze ngokubambisana naso.