MS Access. MS Access Database. MS Access 2007

MS Access - yeGmail.END_STRONG-Server ndeyeukama Database utariri hurongwa (RDBMS) kubva Microsoft. Ndeyeukama zvinoreva kuti zvakavakirwa pamatafura. We funga ino zvizere.

Chii chinonzi ndeyeukama Database?

A ndeyeukama Database inoumbwa chine matafura, pakati iyo kuvaka ukama kana kukurukurirana. Database - a goko unokubvumira kusika uye kushandisa Databases MS Access.

Funga zvakanakira nekuipira kuti DBMS.

Zvakanakira DBMS Microsorf Access

• Simple uye nzwisisa inowanikwa. Wana kushanda pamwe Database ichi kunogona, pasina unyanzvi. Uyewo, ruzivo achitsigira mabhuku akawanda, online uye is mapoka.
• MS Access Database Zvinozivikanwa uye mukurumbira zvikuru pakombiyuta PC. Izvi zvinoreva kuti iwe unogona kutsvaka rubatsiro nguva dzose kubva shamwari, yave kushandisa Database ichi mazano, uyewo basa pamwe chete Database pamusoro pemambure.
• Zvinenge risingaperi chinotipa Export date: mashoko kubva matafura imwe watinya pakati negonzo zvinogona kuchinjirwa Excel, Shoko, ekisipoti kuti XML, kubudisa kuti PDF, tisingatauri chokwadi kuti hapana matambudziko kufamba vakasarudzwa zvine mumwe Database.
• Low mutengo. Kana ukatenga MS Access sechikamu zvizere Microsoft Office pasuru, sezvo zvichienzaniswa nedzimwe akabhadhara Databases, mutengo achava anokwezva kwazvo.
• A akasiyana vakasarudzwa vagadziri zvokuvaka siyana, mishumo uye queries, unogona kushandisa dzinobvisa Data uye tiratidze navo imwe nzira.
• Mikana kupinza data, kana uine tabular Data nokushandisa shoko processor MS Word kana MS Excel spreadsheet processor, iwe kushandisa muuki richabva muvira Database wako nyore. Kupinzwa, mukuwedzera, zvinogona kuitwa kubva nyore rugwaro pepa kubva XML gwaro, uyewo Database mafaira zvakasikwa mune dzimwe Databases (akadai dBASE, Paradox).
• Kugona munhu pasiwedhi nokuda Database yenyu.
• Akavaka-nemutauro mukuru-azvipire VBA.
• Kugona vanyore macro.
• SQL mupepeti.

For programmers anogona kusarudza mumwe chinokosha zvinobatsira: makirisito Access Jet 4 midzi muna Microsoft anodawo mugadziriro, kutangira Windows anotsanangura 98. Izvi zvinoreva kuti application achishandisa Database kusikwa Access, unogona kutakura nyore chero kombiyuta iri Windows. Zvichaita kushanda usina kuisa DBMS pachayo. Mune imwe nyaya akaipisisa, chete vanofanira kuisa Runtime - shanduro, iyo inogona kusununguka zvachose kukopa kubva Microsoft Website.

Sezvaunogona kuona, chiremera DBMS MS Access iripo. Asi zvose zvazvakanakira vanogona kupfuura zvikuru zvinokosha payakaipira. Ngationgororei navo.

Zvazvakashatira DBMS Microsoft Access

• MS Access zvinoreva faira-Server Database. Izvi zvinoreva kuti mashoko ose chinogadzirwa zvakananga pamusoro yeGmail.END_STRONG kombiyuta user. The Server chikamu anobvisa humboo uye transmits pamusoro kudiwa. Izvi zvinotungamirira kuti uri yomunzvimbo rezvebonde Dzinogara guru mashoko Rwako, uye ane vakawanda vanoshandisa kushanda pamwe Database, kungava Network kuzara. The klassiske faira-Server mapurani nguva rinobatanidza yakaderera zvibereko apo vakawanda vanoshandisa. In MS Access 2010 shanduro mubvunzo uyu zvishoma kugadziriswa.
• Kushaya akavimbika date kudzivirira Ezvemutauro. Kutaura chokwadi, rimwe chete pasiwedhi rinoshandiswa pachishandiswa humboo uye rokushandisa password. Nokuti ruzivo nyanzvi hakuna kuipa chero dambudziko kubvisa kudzivirira ichi.
• Multiplayer muoti zvinogoneka chete chiziviso hoc zvakarukwa kana mumidziyo faira Server.
• Kutanga tsika inowanikwa runodiwa kukwezva programmers.
• Editor SQL queries zviri chinyakare, zvakavaomera kushandisa.
• Database ichi haana kusununguka.
• MS Access mujeri pasi Windows kushanda hurongwa. Kuedza kushandisa umboo vakasikwa Database nedzimwe kushanda nehurongwa (somuenzaniso, Linux), vane runako runonyengera. Simply uchatamisa Data mumwe Database.

Kamwe isu akatarira zvayakanakira nezvayakaipira pamusoro MS Access, muenzaniso ra2007 shanduro uchapa dzimwe mirayiridzo anokurumidza pamusoro yaibvira Database ichi.

Kuumba matafura

Hapana nyore pane kuti pave tafura idzva kushandisa MS Access 2007:

1. "Creation," enda Tab pashure nokuvhura Database.
2. Click on icon "Table", ndicho chokutanga kuruboshwe.
3. Pamberi pedu kutarisana cherudo tafura mureza zita "Table 1" uye motokari-incrementing munda "Code".
4. Unogona kutanga chiyamuro umboo rechipiri mbiru. Tapinda mutsetse, unofanira achizviendesa Enter kiyi. Mbiru ari kuchinja zita kuti "munda 1," "Code" munda achatora ukoshi vezvikwata vachava kuwanikwa chiyamuro Data inotevera mutsetse.
5. Kuti rename wechikamu, chete tinya pamusoro paro negonzo kaviri. Zviri chinodiwa kuti kutaridzwa mbiru mazita dzisina dzezvimwe!
6. Muvaki mabwendefa Access 2007, vakachenjera kwazvo. Zvakakodzera kwamuri mutsara patafura itsva kupinda munda kukosha mhando "Date" wokutanga, sapamazuva zvinotevera rwokuyera chete mbiru iwe vachangoerekana kukumbirwa kushandisa karenda.
7. Kupedza pakusikwa tafura kunofanira kuponeswa nekudzvanya pamusoro yakakodzera kuvake kana anokosha pamwe Ctrl + S.

vanozvishandisa zhinji yamunenge kuenda hurumende "Mugadziri" mamwe nzwisisa kushanda pamusoro paminda tafura, nekuti nzira iyi, unogona kutaridzwa mhando yeminda, kurambidzwa tsika. In nzira iyi, munogona kuenda chero nguva kushanda pamwe patafura, anongoti achizviendesa runoenzanirana bhatani pamusoro pemapuranga.

Kutanga mubvunzo

Funga kuti asike queries muna MS Access. Muna 2007 achasika mumwe mubvunzo nyore muna Design maonero:

1. On the "Menu" the pane, tinya "Sikai" bhatani "Query Mugadziri" Tab.
2. Pano uchateerera pakarepo kuona hwindo kusarudzwa pamatafura. Click on neimwe tafura umo mashoko anofanira kusarudzwa. Zvinofanira kurangarirwa kuti sarudzo uchakwanisa kuita chete kana tafura vanopfuura mumwe anogona zvine musoro chokuita mumwe nokuda chero munda.
3. Kana wasarudza tafura kupfuura rimwe, iwe unofanira kuvaka chisungo pakati pavo, pakukoka maererano negonzo kubva kumunda tafura mumwe munda kuitwa chokuita kune vamwe.
4. Zvino watinya kaviri munda kubva patafura imwe neimwe kuti unoda kuona mugumisiro.
5. Ari Muterere pakapuranga pamusoro "Design" Tab, tinya guru Kudanidzira chiratidzo. Usati kuonekwa mune tabular zvinoumba migumisiro pakusarudza.

Ndiwo vakawanda payakavakirwa kusika queries. Kuti uwane queries yakaoma, ona Chinobatsira chirongwa, kana kushandisa anobatsira.

Dzimwe nguva kunyange ruzivo User vangada kupa umboo venyu zvikuru Manyorerwo kupfuura nyore tafura. Ipapo anouya kuzobatsira MS Access mudziyo - "Forms".

chimiro Wizard

On the Access 2007 muenzaniso, funga sei kushandisa Form Wizard:

1. On the "Sikai" Tab, pasi "Forms" enda "Form Wizard" kuburikidza "Zvimwe siyana".
2. Sarudza kubva donhwe-pasi pasi, tafura kana mubvunzo kuti izvo zvaunoda kuti pave kuona chimiro.
3. Shandisa ">" uye ">>" pamusoro chidhina kuchinjirwa "Available minda" mazuva mbiru vari kugumbura 'akasarudzwa minda "mumwe kana vose kamwe, ukuwo. Click on "Next" bhatani.
4. Sarudza pakuonekwa fomu achishandisa chinja.
5. Next, sarudza muchimiro manyorerwo, uye iwe unogona achizviendesa "Finish" bhatani. Heino renyu tafura kana mubvunzo Data mu inonakidza format.

Kusika zvimwe zvitarisiko dzakaoma tinofanira kushandisa rakakodzera constructor.

Zvatakurukura mirayiridzo iyi, tinogona kugumisa kuti MS Access - uyu mukana wakanaka nokuda diki mari. Friendly inowanikwa, kuwanda midzi rutsigiro mainjiniya uye mhizha - izvi zvose zvinoita kuti zvive nyore kuti vagoronga Database uye kushanda nayo.