Kupanga Chiyanjano Chiyanjano mu Kupeza

Imodzi mwazinthu zazikuluzikulu zamabuku monga Microsoft Access ndizokhoza kusunga maubwenzi pakati pa matebulo osiyanasiyana. Mphamvu ya deta imathandiza kuthetsa deta m'njira zosiyanasiyana ndikuonetsetsa kuti kusagwirizana (kapena kusasunthika ) kwa deta iyi kuchokera pa tebulo kufika pa tebulo.

Tangoganizani deta yaing'ono yokonzedweratu ku kampani ya "Business Simple". Tikufuna kufufuza antchito athu ndi makasitomala athu. Tingagwiritse ntchito kapangidwe ka gome kuti tichite zimenezi, pomwe dongosolo lililonse likugwirizana ndi wogwira ntchito. Chidziwitso ichi chikupezeka bwino kwambiri kuti mugwiritse ntchito ubale wachinsinsi.

Palimodzi, mukhoza kupanga mgwirizano womwe umalongosola deta kuti Mzere wa Employee mu tebulo la Malamulo umagwirizana ndi ndondomeko ya ogwira ntchito mu tebulo la antchito. Pamene ubale umapangidwa pakati pa matebulo awiri, zimakhala zosavuta kuphatikiza deta pamodzi.

Tiyeni tiwone momwe polojekiti ikukhalira yosavuta kugwiritsa ntchito database ya Microsoft Access:

Mmene Mungapangire Ubale Wofikira

  1. Ndi Access yotseguka, pitani ku Tools Tools menyu pamwamba pa pulogalamu.
  2. Kuchokera mkati mwa Relationships area, dinani kapena kugwirana Ubale .
    1. Mawindo a Show Show ayenera kuwonekera. Ngati simutero, sankhani Onetsani Zamaphatikizidwe kuchokera ku Tabu Yopanga .
  3. Kuchokera pawonekera pazenera, onetsani matebulo omwe ayenera kukhala nawo mu chiyanjano, ndiyeno dinani / pangani Add .
  4. Mukutha tsopano kutseka mawindo a Show Tables .
  5. Kokani munda kuchokera pa tebulo limodzi kupita ku gome lina kuti mawonekedwe a Edit Relationships ayambe .
    1. Dziwani: Mungathe kusunga makina a Ctrl kuti musankhe minda yambiri; Kokani imodzi mwa iwo kuti iwagwedeze onsewo kupita ku gome lina.
  6. Sankhani zina zomwe mungasankhe, monga Kuyimikitsa Kukhulupirika Kapena Kusintha Zowonjezera Minda , ndiyeno dinani kapena pangani Pangani .