Kuumba Dhiyabhorosi Relationships in Access

Chimwe chezvinyorwa zvakakosha zvemashoko akadai seMicrosoft Access ndiyo kukwanisa kwavo kuchengetedza hukama pakati pematafura ezvinyorwa zvakasiyana. Simba re database rinoita kuti zvive nyore kugadzirisa dambudziko nenzira dzakawanda uye kuvimbisa kusagadzikana (kana kutendeseka kutendeseka ) kwe data iyi kubva patafura kusvika patafura.

Fungidzira kadhina kadiki yakagadzirirwa kambani ye "Business Simple". Tinoda kuongorora vose vatinoshanda nevatengi vedu. Isu tingashandisa tafura yemafura kuti tiite izvi, apo marongerwo ega ega anosangana nemushandi chaiye. Idzi ruzivo runowanikwa hunoita mamiriro akakwana ekushandiswa kweukama hwepa database.

Pamwe chete, unogona kuumba ukama hunorayira dhesi iyo iyo iyo yeHoveee column muDheta yeOrder inofanirana nekamuri yeVashandi mufurafura yeVashandi. Apo hukama hunoumbwa pakati pematafura maviri akasiyana, zvinova nyore kuunganidza iyo data pamwe chete.

Ngatitarise nzira yekuumba ukama huri nyore kushandisa database ye Microsoft Access:

Nzira Yokuita Sei Kuwana Ukama

  1. NeIndaneti yakasununguka, enda kuDesource Tools menu pane yepurogiramu.
  2. Kubva mukati meHurano hweNzvimbo, chovha kana kutora Ukama .
    1. Itawindo Rokuratidzira rinofanira kuonekwa. Kana ikasaiti, sarudza Ratidza Dhafura kubva Kubumbi tab.
  3. Kubva paRatidza Tafura yekona, sarudza tafura inofanira kuve yakabatanidzwa muhukama, uye ipapo bhura / tapota Wedzera .
  4. Iwe zvino unogona kuvhara yeWhenera Tables .
  5. Dragodza munda kubva pane imwe tafura kuenda pane imwe tafura kuitira kuti eHurano Relationships iwindo izarurire.
    1. Cherechedza: Unogona kubata Ctrl kiyi kuti usarudze minda mizhinji; Dhonzai imwe yei kuti muikudze yose kune imwe imwe tafura.
  6. Sarudza chero zvimwe zvingasarudzwa zvaunoda, sekumanikidzikisa Kuratidza Kuvimbika kana Kushandura Update Related Fields , uye ipapo bhura kana tapota Tanga .