Microsoft Access ine zvikamu zvitatu zvikuru: matafura, mibvunzo uye mafomu
Kwose kambani inodedzwa nedheta yakawanda yedhesi inoda kuongororwa kana nehurongwa hunoshandisa pepa pepaundi, mavara mavara kana sarashiti kuti uchengetedze ruzivo rwemashoko anokosha anogona kubatsirwa nokugadzirisa kushandiswa kwehuwandu hwemashoko. Sangano re database rine Microsoft Access 2010 rinogona kunge iro izvo kambani inoda.
Chii Chinodhindwa?
Panyaya yepamusoro, database yakarongeka yekuunganidza deta. A database database system (DBMS) yakadai seMicrosoft Access inokupa iwe mapurogiramu epurogiramu iwe unoda kuronga iyo data nenzira yakajeka. Inosanganisira zvivako zvekuwedzera, kugadzirisa uye kubvisa data kubva kune d database, bvunza mibvunzo pamusoro pe data yakachengetwa mu database uye kubudisa nhepfenyuro muchidimbu zvinyorwa zvakasarudzwa.
Microsoft Access 2010 Zvikamu
Microsoft Access 2010 inopa vashandisi nzira yeDBMS iri nyore uye yakajeka. Nguva dzose vashandisi vezvinhu zveMicrosoft vanoziva vanoziva maWindows kutarisa uye kunzwa uye kubatana kwakasimba nemimwe michina yemhuri yeMicrosoft Office.
Zvitatu zvezvikamu zvikuru zvekutsvaga izvo vazhinji vashandisi vebhuku rekusangana vanosangana mabheji, mibvunzo, uye mafomu. Kana iwe uchangobva kutanga ne Access uye usati wave neDhipatimendi reAcccess inofadza, verenga pamusoro peKusarudza Access Access 2010 kubva paChirangaridzo.
Tables Ndiyo Matombo Okuvaka
Tables ndiyo inokosha yezvivakwa zvekugadzira chero dheseti. Kana iwe ukazivana nema-spreadsheets, uchawana tafura yezvinyorwa zvakafanana. Chimwe chetafura chekudhinda zvinyorwa chingave nehuwandu hwevashandi, kusanganisira maitiro akaita sezita, zuva rekuberekwa uye zita. Ingave yakarongedzwa seyizvi:
- Dhiyabhorosi ID
- Zita rokupedzisira
- Zita rokutanga
- Title
- Kukwazisa
- Birth Date
Ongorora kuvakwa kwetafura uye uchaona kuti imwe imwe yetafura yefurafura inoenderana nemumwe munhu mushandi anoyevedza-kana maitiro mumagwaro e database. Mutsara mumwe nomumwe unofanana nemumwe mushandi uye ane mashoko ake. Ndizvo zvose zviripo kune iyo. Kana zvichibatsira, funga patafura imwe neimwe sepasheetet-mazita ekunyorwa kwemashoko.
Mitsva Yekudzorera Mashoko
A database inoshandiswa chete kuchengetedza ruzivo ingadai isingabatsiri; iwe unoda maitiro ekuwanazve mashoko zvakare. Kana iwe uchida kungoyeuka mashoko akachengetwa mutafura, Microsoft Access inokubvumira kuti uzarure tafura uye upfuure kuburikidza nezvinyorwa zviri mukati maro. Zvisinei, simba rechokwadi re database rinowanikwa mune zvarinokwanisa kupindura mibvunzo yakaoma. Kuwana mibvunzo inopa simba rekubatanidza nhamba kubva kumatafura akawanda uye nzvimbo nzvimbo chaiyo pane data yakadzorerwa.
Fungidzira kuti sangano rako rinoda nzira iri nyore yokugadzira urongwa hwezvinhu izvi zviriko zvino kutengesa pamusoro pemutengo wawo wepakati. Kana iwe uchingotora chigadzirwa chetafura yemuchina, kuzadzisa basa iri kunoda kuwanda kwekutsvaga kuburikidza nedheta uye kuita kuverenga nemaoko. Zvisinei, simba remubvunzo rinokubvumira kukumbira kuti Access idzoke chete iyo zvinyorwa zvinosangana nepamusoro-yepamusoro yepamutengo wemari. Uyezve, iwe unogona kurayiridza dheseti kuti uongorore chete zita uye chikwata chemutengo wechinhu chacho.
Kuti uwane mamwe mashoko pamusoro pesimba remibvunzo yepa database kubva muIndaneti, verenga Kuumba Chirwere Chirwere muMicrosoft Access 2010.
Forms Insert Information
Kusvika ikozvino, waverenga pamusoro pezvinangwa mushure mekugadzirisa ruzivo mune d database nekuwana mashoko kubva kune database. Iwe uchiri kuda nzira yekuisa ruzivo mumatafura ari munzvimbo yekutanga. Microsoft Access inopa nzira mbiri dzepamusoro pakuzadzisa chinangwa ichi. Nzira yekutanga ndeyokuunza tafura muhwindo nekunyanya-kuisa pairi. Zvadaro, wedzera ruzivo kune zvakaderera petafura, sezvaunogona kuwedzera mamwe mashoko kune pepafurasi.
Kutsvaga kunopawo unoshandiswa-user-friendly forms interface. Iyo inoshandiswa inobvumira vashandisi kupinda muchirongwa mufananidzo wakajeka uye vane ruzivo rwakapfurikidza rwakapfuura kune database. Iyi nzira isinganyanyi kutyisidzira iyo inopinda mudhipatimendi asi inoda kushanda zvishoma kune chikamu chemukuru we database. Kuti uwane mamwe mashoko, verenga Kuumba Mafomu muIkuwana 2010
Microsoft Access Reports
Mishumo inopa kukwanisa kuburitsa zvinyorwa zvakanakisisa zvakarongeka zve data iri mune imwe kana matafura akawanda nemibvunzo. Nokushandiswa kwetsika dzechepakati uye ma templates, vashandisi vekodhi vanoziva vanogona kugadzira mitsva munyaya yemaminitsi.
Ngatiti iwe unoda kubudisa bhuku rekugovana ruzivo ruzivo nevanowanikwa uye vanotarisira vatengi. Izvozvi ruzivo rungatorwa kubva kune dheta kuburikidza nekushandiswa kwakanaka kwemibvunzo. Zvisinei, ruzivo rwacho runoratidzwa mumutauro wechechi-kwete kunyanya kukosha kwekutengesa. Mishumo inobvumira kuiswa kwemaikirwo, maitiro akanaka, uye pagination. Kuti uwane mamwe mashoko, ona Creating Reports in Access 2010.