Ukudala iDatha yeDatha yoLwazi kuFikelelo

Enye yeenzuzo ezinkulu zeenkcukacha ezifana ne-Microsoft Access zikwazi ukugcina ubudlelwane phakathi kwamatafula eenkcukacha ezahlukeneyo. Amandla egciniweyo yenza ukuba kube lula ukulungelelana kwedatha ngeendlela ezininzi kwaye kuqinisekiswe ukuhambelana (okanye ukuthembeka kwetekethi ) kule datha kwitafile.

Khawucinge nge-database encinane eyenziwe kwi-"Business Simple" nkampani. Sifuna ukulandelela abaqeshwa bethu kunye namagunya ethu kumakhasimende. Singasebenzisa isakhiwo setafile ukwenza oku, apho umyalelo ngamnye udibene nomqeshwa othile. Olu lwazi luye lwaba lube nemeko efanelekileyo ekusebenziseni ubuhlobo beenkcukacha.

Ngokubambisana, unokudala ubudlelwane obuyalela i-database ukuba ikholomu yabaqeshwa kwitafile ze-Orders ihambelana nekhole yomqeshwa kwietafile zabasebenzi. Xa ulwalamano lwenziwe phakathi kwetafile ezimbini ezahlukeneyo, kuba lula ukudibanisa le datha kunye.

Makhe sijonge kwinkqubo yokwakha ubudlelwane obulula usebenzisa i-Microsoft Access database:

Indlela yokwenza ulwalamano lokufikelela

  1. Ngokufikelela kuvulekileyo, ngena kwimenyu yeThuluzi leDeskripthi phezulu kwenkqubo.
  2. Ukusuka ngaphakathi kwendawo yoBudlelwane , nqakraza okanye thinta ubudlelwane .
    1. Iwindow yeShow Table ibonakale. Ukuba ayithethi, khetha u- Bonisa iThebula kwiTeb yoyilo .
  3. Ukusuka kwikhompyutheni yeThebula, khetha ietafile ezifanele zibandakanyeke kulwalamano, uze uklikhazeze / thepha i- Add .
  4. Ungakwazi ukuvala iwindow Show Show .
  5. Hudula intsimi kwitafile enye ukuya kwelinye itafile ukwenzela ukuba iWindows Relations Relations window iqale.
    1. Qaphela: Ungabamba iqhosha le Ctrl ukukhetha amasimi amaninzi; udonsa enye kubo ukuhudula bonke ukuya kwelinye itafile.
  6. Khetha ezinye iinketho ozifunayo, njengokuQinisekisa iNgcaciso yokuHlonipha okanye iNdawo yokuThuthukiswa kweziNxulumaniso eziNxulumeneyo , uze uklikha uze uthinte Yakha .