Nhanganyaya kune Zvimwe zvinhu uye zvinokosha
Iwe unotambudzika nehuwandu hwe deta dzinoda kuwanikwa musangano rako here? Zvichida iwe uri kushandisa papepa yokunyora mapepa, zvinyorwa zvemashoko kana pepadheti kuti uchengetedze ruzivo rwemashoko ako anokosha. Kana uri kutsvaga mamwe mafashandisirwo ehutano hwehutungamiri hwehurongwa, dhesi rekushandisa ingangova ruponeso rwamunenge uchida uye Microsoft Access 2013 inopa imwe nzira yakanakisisa.
Chii Database?
Panyaya yepamusoro, dhesi yekusungirirwa inongova kuunganidza zvakarongeka kwedata. A database database system (DBMS) yakadai seMicrosoft Access, Oracle kana SQL Server inokupa iwe matanho ezvinhu zvaunoda kuronga iyo data nenzira yakajeka. Inosanganisira zvivako zvekuwedzera, kushandura kana kubvisa data kubva pane d database, bvunza mibvunzo (kana mibvunzo) pamusoro pe data yakachengetwa mu database uye kubudisa nhepfenyuro inopfupikisa zvakasarudzwa zviri mukati.
Microsoft Access 2013
Microsoft Access 2013 inopa vashandisi chimwe chezvinhu zvakajeka uye zvakajeka zveDBMS pamusika nhasi. Nguva dzose vashandisi veMicrosoft zvigadzirwa vachafarira maitiro eWindows maonero uye manzwiro pamwe nekubatanidzwa kwakasimba nemimwe michina yemhuri yeMicrosoft. Kana uchida mamwe mashoko pamusoro peInterface 2010 interface, shandisa Access Our User Interface Tour .
Ngatitangei tiongorore zvitatu zvezvikamu zvikuru zveKutsvaga iyo vazhinji vashandisi vepa database vanosangana - matafura, mibvunzo, uye mafomu. Kana iwe usati wava neAccount database, unogona kuverenga pamusoro pekugadzira Access Access Database 2013 kubva kuChirangaridzo kana Kugadzira Access Access Database kubva muGeeklate.
Microsoft Access Tables
Tafura inosanganisira zvivako zvekuvakwa zvekodhidhi yega yega. Kana iwe uchiziva maspredishiti, iwe uchawana tafura dzekudhinda dzakafanana zvakanyanya.
Rimwe tafura yezvinyorwa zvese inogona kuva nehuwandu hwevashandi, kusanganisira maitiro akaita sezita, zuva rekuberekwa uye musoro. Ingave yakarongedzwa seyizvi:
- Dhiyabhorosi ID
- Zita rokupedzisira
- Zita rokutanga
- Title
- Kukwazisa
- Birth Date
Ongorora kuvakwa kwetafura uye uchaona kuti imwe imwe yetafura yefurafura inofanana nemumwe mushandi unofanirwa (kana kuti chirevo mumagwaro e database). Mutsara mumwe nomumwe unofanana nemumwe mushandi uye ane mashoko ake. Ndizvo zvose zviripo kune iyo! Kana zvichibatsira, funga nezve rimwe nerimwe rematafura aya sepasheetet-mazita ekunyorwa kwemashoko. Kuti uwane mamwe mashoko, verenga Kuwedzera Tables kusvika kune Access 2013 Database
Kudzokorora Mashoko kubva kune Access Database
Zviri pachena, dhesiyo inongochengetedza ruzivo chete inenge isingabatsiri - tinoda nzira yekuwanazve 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 zvikumbiro zvakaoma, kana mibvunzo. 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 ukangowanazve chigadziro chetafura yemufananidzo, kuzadzisa basa iri kunoda kuwanda kwekutsvaga kuburikidza nedhidhiyo uye kuita kuverenga nemaoko. Zvisinei, simba remubvunzo rinokubvumira kungokumbira kuti Access idzorere zvinyorwa izvo zvinosangana nepamusoro pemaonero emutengo wemari. Uyezve, iwe unogona kurayiridza dhesiyo kuti uongorore chete zita uye chikwata chemutengo wechinhu chacho.
Kuti uwane mamwe mashoko pamusoro pesimba remibvunzo yebhuku rekushandisa muIndaneti, verenga Kuumba Chirwere Chirwere muMicrosoft Access 2013.
Kuisa Mashoko muIndaneti Yakachengetedzwa
Kusvika ikozvino, wakadzidza mafungiro mushure mekugadzirisa ruzivo mune d database nekuwana mashoko kubva kune database. Tichiri kuda nzira yekuisa ruzivo mumatafura panzvimbo yekutanga! Microsoft Access inopa nzira mbiri dzepamusoro pakuzadzisa chinangwa ichi. Nzira yekutanga ndeyekusimudza tafura muhwindo nekunyanya-kuvhara pairi uye kuwedzera ruzivo kusvika pasi payo, sezvinongoita munhu aizowedzera ruzivo kune pepanheti.
Kutsvaga kunopawo unoshandiswa-user-friendly forms interface iyo inobvumira vashandisi kupinda muchirongwa mufananidzo wakajeka uye vane ruzivo irworwo rwakapfuurira kune database. Iyi nzira isinganyanyi kutyisidzira iyo inopinda mudhipatimendi asi inoda kushanda zvishoma kune chikamu chemukuru we database. Kuti uwane mamwe ruzivo, verenga Kuumba Mafomu muKutsvaga 2013
Microsoft Access Reports
Mishumo inopa kukwanisa kukurumidza kubudisa zvinyorwa zvinotaridzika zvakarongwa zve data iri mune imwe kana matafura akawanda uye / kana mibvunzo. Nokushandiswa kwetsika dzitsvaga uye ma templates, vashandisi ve database vanogona kugadzira mitsva mumutauro chaiyo nyaya yemaminitsi.
Ngatiti iwe unoda kuburitsa bhuku rekugovana ruzivo rwekugadzirwa kwezvinhu uye ikozvino uye vanotarisira vatengi. Muzvikamu zvakapfuura, takadzidza kuti ruzivo rwemhando iyi rungatora kubva kubhuku redu rekushandisa kuburikidza nekushandiswa kwakanaka kwemibvunzo. Zvisinei, yeuka kuti ruzivo urwu rwakave rwuri muhuwandu hwemavara - kwete kunyanya kukosha kwekutengesa zvinhu! Mishumo inobvumira kuiswa kwemaikirwo, maitiro akaisvonaka uye pagination. Kuti uwane mamwe mashoko, ona Creating Reports mu Access 2013.