How kusika munhu Database muna Access. Kushanda ane Access Database

Vazhinji veko vanozivikanwa iri imwe nguva aramu akamuka kubva MS Office 2007 dzakachinjwa inowanikwa, uye chii asingadi akanwisa yokuvaka ayo! "Guru" chema ndechokuti itsva hofisi Suite aiva "kusagadzikana shamisa", asi nokuti nechivimbo vakafanotaura kuparadzwa uye nhamba yokukanganwa vanozvishandisa.

Hapana! Sezvo hapana chakaitika, nekusiyana, zvikuru nokukurumidza zvakava pachena kuti kushandiswa itsva "Office" shanduro kwava nyore uye zvinobatsira.

Uye nekuti (Sezvaitarisirwa) kuchinja, kuti prerequisites idzo vakasikwa mu "Office 2007" kwete chete zvinobudirira dzapinda ayo subsistence itsva, asi akapiwa zvinotevedzana yake. Ndokusaka 2010 shanduro rava nevakawanda zvikuru pakati vanoshandisa unyanzvi.

Zvakachinja itsva shanduro Access

Very kuchinja vakaitwa uye akakurumbira chikumbiro kusika Databases. Kuburikidza itsva Sparklines chazvo, wagadzira uye aongorore yakawanda mashoko. Uye nemhaka chombo Slicer mukana kutsanya uye nyore kufamba kunyange huru Databases. Uye kuvonga zvose kune yepamusoro uye kufunga zvirire hurongwa filtration.

Uyezve Developers vakawedzera kusangana nani Excel, zvakananga paunogona kutenga yakawanda mashoko. Zvisinei, ruzivo vanoshandisa kakawanda vanonetseka nezvokuti sei kuti pave Database muna Access.

Chiiko ichi

To nemazvo kumisa nezvigadziko, unofanira kutanga kunzwisisa chaizvo yavo. Database rinonzi zvachose rakarongeka mamiriro yakagadzirwa yokuchengetera uye kuronga mashoko. It ingasanganisira zvinhu zvakasiyana chaizvo, asi avo musoro chikwata ndiro tafura.

musiyano wavo chikuru kubva zvakafanana hurongwa ari spreadsheet mupepeti ndechokuti vari zvinodyidzana. Kubudisa kusiyana upi ichocho, iwe vachangoerekana atange yaitsiva zvose interconnected pamwe kuyeuka hurongwa. Zvichitaurwa zviri nyore, imi havachafaniri kunetseka pamusoro manually Editing guru mashoko pamatafura.

Chii chaungaita tichibatsirwa MS Access?

Usafungidzira kuti chikumbiro rudzi "inonzwisisika kuenderera» Excel. Mukana purogiramu yacho mubvunzo zvakawanda zvikuru. Zvikurukuru, chero kusikwa Databases MS Access zvinoda kunyatsofunga mashoko sechivako yakananga gwaro, tarisa kuvimbika yepakutanga data, uye kushandisa ruzivo urwu kuti vatevedzere mashoko queries, siyana nemishumo.

muenzaniso rakasikwa munhu

Saka sei kuti pave Database muna Access uye vanogona kushandisa "Wizard" inoita kuti zvive nyore ruzivo vanoshandisa, muitiro zvikuru kunzwisisa hakuna kusiyana. Asi isu hatingavatengeri dzinokurudzira kuenda nenzira, sezvo zvose kwemasayendisiti zvinofanira kunzwisiswa kuti zvibereko.

mhanya application First. Nhaurirano achaonekwa pamusoro chidzitiro kuumba gwaro idzva. Mariri unofanira sarudza "Database New". Mu "File zita" hunosumwa nezvarinoreva. Dzivisa yokudzokorora. chakunoreva mazita chinhu pamusana kusina kutadza kana pachake hanya, unogona kurasikirwa nyore mashoko anokosha.

"Sikai" pashure bhatani ichi rikazvisundira. Pakarepo pashure paizvozvo, tarisisa achaonekwa ari nhaurirano bhokisi itsva tafura mashoko, izvo iwe uye achasika ramunoda kusika.

How kusarudza nzira?

A tafura anogona kuiswa munzvimbo dzakasiyana, asi isu kuti mazano "Mugadziri", sezvo zviri nyore kudzora yose muitiro uye nani kunzwisisa yose womukati nemamiriro gwaro.

Shandisa Kuchinja "Type-Designer" kuenda kwaari. Zvadaro kwakanyorwa chinotarisirwa zvaida tafura zita chairo. Sezvo vangada kupfuura rimwe, tinoratidza zvakare kushandisa mamwe mazita zvakunoreva.

Zvino, chaizvoizvo, muitiro pacharo. How kusika munhu Database muna Access? Danho rokutanga kusarudza uye wonyora mazita minda, vanoti mashoko mifananidzo, uyewo kuisa yakarurama anokosha munda. Chete ipapo unogona kutanga uchinyora mashoko ari patafura.

Kuti aite izvi, kushandisa murayiro "maonero muoti tafura." Teererai! Kana munda "chinhu bumbiro" panyaya yako zvakafanira kuti "Counter", ipapo zadza ari rwebasa hakusi zvakakodzera. Kana wapedza basa iri pakatanga mashoko, chinogona kuvharwa. Kana imwe Database inoda tafura rechipiri, izvozvo akaunganidza chikwata "Creation imwe tafura zvakagadzirwa."

mienzaniso nezvigadziko

Vose pamusoro yaizova tsamba akafa asina kukupa nezvokuzadziswa "munda ruzivo", vanopinda batsira Access Database. unogona kukurukura mienzaniso munzvimbo iyi zvinenge magumo, asi tichakurukura muchimiro, izvo zvinogona zvakakomba aivabatsira unyatsoshanda hwekudzidza.

tsanangura muchidimbu kusikwa gwaro iri hweutungamiri. Chii chandichiri kushayiwa zvinosanganisira? Izvi zvinofanira kusanganisira zvinotevera minda: dzakagadzirirwa code, nhamba boka, uye nyaya vadzidzisi. Tapota ona: minda "Subject" uye "mudzidzisi" anofanira chokuita mamwe matafura, umo purogiramu achaswedera yakakodzera mashoko.

iri sei kuitwa?

Chokutanga, kuita zviito zvose maererano pamusoro mirayiridzo. Enda "Design", unotanga zadza muminda. Maererano bumbiro chaizvo Data kutaipa nayo inofanira se "pakaunda, kiyi munda".

The "Group" uye zvakafanana akarongwa munda mhando anonzi "chinyorwa." Asi minda "Subject" uye "mudzidzisi" vanofanira kusarudza "Lookup Wizard". Usanetseke: pamunongopinda wasarudza kukosha ichi, chirongwa ndikuratidzei bhokisi nhaurirano. Zvichitevera mirayiridzo yake, unogona kuumba kubatana nemamwe pamatafura. Sezvaunoziva, unofanira ichasimbiswa pachine.

Kamwe iwe tinya "Finish" bhatani, yambiro unoratidzwa pamberi penyu kuti unofanira kusika akwirwe rokuponesa tafura. Zadzisai chiito ichi.

Kuumba ukama pakati matafura

Tatotaura pamusoro chokwadi kuti kushanda ane Access Database zvinoda kuvapo Links zvakananga pakati vakawanda Spreadsheets. Saka sei kuti pave kwavari?

Kuti aite izvi, svinudzai zvaaida gwaro, uye ipapo uende munzira, "Kushanda Databases - Data Scheme". Kuti uone akaisa yezvakaita ukama, unofanira watinya kaviri kuruboshwe negonzo bhatani iri nhaurirano mubhokisi "Change Association." Pashure paizvozvo unofanira tinya "OK" bhatani. Somugumisiro, iwe wakaisa default sarudzo, "mumwe kune vazhinji".

Saka isu akatarisa mubvunzo sei kuti pave Database muna Access. Tinovimba mashoko achava richishanda kwauri.