MS Access. MS Access Nawonso achichepere. MS Access 2007

MS Access - kasitomala-Seva ubale dongosolo Nawonso achichepere kasamalidwe (RDBMS) ku Microsoft. Chiyanjano zikutanthauza kuti zachokera magome. Tikambirana dongosolo mwatsatanetsatane.

Kodi Nawonso achichepere ubale?

A Nawonso achichepere ubale imakhala ya matebulo, pakati omangapo asapita kapena mauthenga. Nawonso achichepere - chipolopolo kuti amalola kuti alenge ndi ntchito zinasokoneza makompyuta MS Access.

Taonani ubwino ndi kuipa kwa DBMS.

Ubwino DBMS Microsorf Access

• Zambiri ndi mwachilengedwe mawonekedwe. Pezani ntchito ndi Nawonso achichepere zingakhale, ndi luso palibe wapadera. Komanso, chithandizo novice wa mabuku ochuluka, Intaneti ndi maphunziro olumikizidwa ku makina.
• MS Access Nawonso achichepere ndi odziwika ndi otchuka kwambiri PC pa kompyuta. Izi zikutanthauza kuti nthawi zonse amafuna thandizo ku mnzake, wakhala akugwiritsa ntchito Nawonso achichepere izi malangizo, komanso ntchito pamodzi ndi Nawonso achichepere wina pa Intaneti.
• mwayi pafupifupi zopanda malire Tumizani deta: deta ku matebulo limodzi ndi zipangizo zamakono akhoza anasamutsa kuti kupambana, Mawu, katundu ndi XML, kufalitsa kwa PDF, osanenapo chakuti palibe mavuto kusuntha zinthu anasankha Nawonso achichepere wina.
• Low mtengo. Ngati inu kugula MS Access monga gawo la utumiki phukusi Microsoft Office, poyerekeza zinasokoneza makompyuta ena analipira, mtengo adzakhala wokongola kwambiri.
• A kusankha lonse opanga likamanena nyumba, malipoti ndi mafunso, mukhoza kugwiritsa ntchito zosefera deta ndi kusonyeza iwo mu njira yachidule.
• Mwayi kuitanitsa deta, ngati muli deta tabular pogwiritsa ntchito mawu purosesa MS Mawu kapena MS kupambana spreadsheet purosesa, mumagwiritsa ntchito mfitiyo kusamutsa iwo mu Nawonso achichepere anu mosavuta. Imports, kuwonjezera, zikhoza kutheka kwa chikalata yosavuta malemba kuchokera chikalata ndi XML, komanso owona Nawonso achichepere analengedwa zinasokoneza makompyuta ena (monga dBASE, chododometsa).
• Luso kulenga achinsinsi kwa Nawonso achichepere wanu.
• Anamanga-mu chinenero waudindo VBA.
• ankatha kulemba macros.
• mkonzi SQL.

Pakuti mapulogalamu akhoza kusankha ntchito ina yofunika: pachimake Access ndege 4 ophatikizidwa mu kachitidwe opaleshoni Microsoft, kuyambira 98 Windows ofotokoza. Izi zikutanthauza kuti kugwiritsa ntchito ntchito Nawonso achichepere analengedwa Access, inu mosavuta kunyamula pa kompyuta pa Windows. Ndi ntchito popanda kukhazikitsa ndi DBMS yokha. Mu nkhani kwambiri, muyenera kukhazikitsa pulogalamu yowongolera - Baibulo, zimenezi mfulu kwathunthu download webusaiti ya Microsoft.

Monga mukuonera, uzirwi wa DBMS MS Access lilipo. Koma ubwino onse angathe kuposa kuipa kwambiri ndithu. Tiyeni tione iwo.

Kuipa DBMS Microsoft Access

• MS Access amatanthauza file-Seva Nawonso achichepere. Izi zikutanthauza kuti deta onse kukonzedwa mwachindunji wosuta kasitomala kompyuta. Seva mbali ya akutenga deta ndi transmits iwo pa akumufuna. Zimenezi zimabweretsa chakuti pa Intaneti m'dera zimadutsa deta utuluke lalikulu, ndi ambiri owerenga ntchito ndi Nawonso achichepere, zikhonza kukhala maukonde kuchulukana. The tingachipeze powerenga file-Seva zomangamanga nthawi zonse kumatanthauza zokolola otsika pamene ambiri owerenga. Mu MS Access 2010 Baibulo nkhani imeneyi pang'ono mwake.
• Chosowa zipangizo odalirika deta chitetezo. Ndipotu chabe achinsinsi ntchito pa maziko a deta ndi achinsinsi ndi malangizo. Pakuti katswiri wodziwa si angabweretse vuto kuchotsa chitetezo izi.
• Oswerera angapo mumalowedwe n'chotheka mu ntchito chisawawa maukonde kapena Seva maukonde file.
• Kukhala mawonekedwe mwambo chofunika kukopa mapulogalamu.
• Editor SQL mafunso ali wosazindikira, kungakhale kovuta ntchito.
• Nawonso achichepere Izi si ufulu.
• MS Access m'ndende pansi machitidwe zikugwira ntchito Windows. Kuyesa kugwiritsa ntchito deta analengedwa Nawonso achichepere ndi kachitidwe ina imene imachitika (mwachitsanzo, Linux), ndi wokongola lachinyengo. Mwachidule kusamutsa deta kuti Nawonso achichepere wina.

Tika anayang'ana pa ubwino ndi kuipa kwa MS Access, chitsanzo cha Baibulo 2007 adzakupatsani ena malangizo mofulumira mwayi wa Nawonso achichepere izi.

Kupanga matebulo

Palibe mosavuta kuposa jambulani tebulo latsopano ntchito MS Access 2007:

1. "Creation," kupita tsamba pambuyo kutsegula Nawonso achichepere a.
2. Dinani chizindikiro "Table", ndi woyamba kumanzere.
3. Patsogolo pathu chifaniziro zithunzi tebulo ndi muyezo dzina "Table 1" ndi galimoto-incrementing munda "Code".
4. Inu mukhoza kuyamba deta athandizira kuti ndime yachiwiri. Utatha mzere, muyenera akanikizire Lowani kiyi. mzati ndi basi anadzatchedwa kuti "Field 1," "Code" munda atenge mtengo wa mayunitsi lidzakhala lilipo deta athandizira mu mzere lotsatira.
5. Kuti Sinthani dzina mzati, kungodinanso pa izo ndi mbewa kawiri. Ndi zofunika kuti mwachindunji maina ndime ndi malo ayi!
6. Womanga matebulo mu Access 2007, anzeru kwambiri. M'pofunikanso inu mu mzere woyamba wa tebulo watsopano kulowa mtengo munda wa mtundu "Tsiku", monga mu mzere zotsatirazi mu ndime yomweyo inu adzakhala basi anaitanidwa ntchito kalendala.
7. Kumaliza chilengedwe pa tebulo kuti ayenera kupulumutsidwa mwa kuwonekera pa mafano yoyenera kapena osakaniza kiyi Ctrl + S.

Ambiri owerenga yabwino kupita ku boma la "Mlengi" zambiri mwachilengedwe ntchito pa minda ya tebulo, chifukwa mode, mukhoza mwachindunji mitundu ya minda, zoletsa makhalidwe. Mu mode, mukhoza kupita pa nthawi iliyonse ntchito ndi gome, chabe akanikizire batani lolingana pa gulu la.

Kupanga kafufuzidwe ndi

Taganizirani mmene kulenga mafunso mu MS Access. Adzalenga mu 2007, kafufuzidwe kumodzi Design view:

1. Pa "Menyu" pane, alemba pa "Pangani" batani "akafufuzidwe Mlengi" tabu.
2. Apa inu nthawi yomweyo kuona matebulo zenera kusankha. Dinani pa aliyense tebulo limene deta iyenera anasankha. Tiyenera kukumbukira kuti kusankha mudzatha kuchita pokhapokha ngati tebulo kuposa wina akhoza nawatsimikizira zogwirizana ndi mzake ndi mmunda uliwonse.
3. Ngati mwasankha tebulo kuposa wina, muyenera kukhala ndi mgwirizano pakati pawo, akupereka mzere ndi mbewa ku munda wina mu tebulo lina munda kukhala zogwirizana ndi zina.
4. Tsopano iwiri Dinani mundawo kwa aliyense tebulo kuti mukufuna kuona zotsatira.
5. Menyu bala pa "Design" tabu, kodolani pa chizindikiro chachikulu modabwa. Musanayambe kuwonekera tabular kupanga zotsatira za masankhidwe anu.

Ichi ndi chilinganizo ambiri polenga mafunso. Pakuti mafunso kwambiricho, onani Thandizo pa mwambowu kapena ntchito zothandizira wapadera.

Nthawi zina ngakhale wosuta novice ndikanafuna kuti deta yanu mtundu zothandiza kwambiri kuposa tebulo yosavuta. Kenako amathandiza a MS Access chida - "Zinthu".

mawonekedwe mfiti

Pa Access 2007 Mwachitsanzo, mmene mungagwiritsire ntchito Fomu mfiti:

1. Pa "Pangani" tsamba, pansi "Zinthu" kupita "Fomu mfiti" mwa "Mitundu ina".
2. Sankhani kuchokera mndandanda dontho-pansi, tebulo kapena afunsa amene mukufuna kuti akonze mawonekedwe zithunzi.
3. Gwiritsani ntchito ">" ndi ">>" wa chipika kutengerapo "Mungatenge minda" masiku a mizati mu chipika "Anasankha minda" ndi chimodzi kapena zonse mwakamodzi, motero. Dinani pa "Kenako" batani.
4. Sankhani maonekedwe a mawonekedwe ntchito magetsi.
5. Kenako sankhani mtundu kalembedwe, ndipo mukhoza akanikizire "mapeto" batani. Apa ndiye tebulo kapena funso lanu deta mu mtundu chidwi.

Kulenga akalumikidzidwa zovuta koposa ntchito constructor yoyenera.

Poganizira malangizo awa, tinganene kuti MS Access - ichi ndi mpata wabwino kwa mtengo wochepa. Friendly mawonekedwe kuchuluka kwa akatswiri ophatikizidwa thandizo ndi amisiri - zonsezi mosavuta kupanga Nawonso achichepere ndi ndi ntchito ndi izo.