Enye yezinzuzo ezinkulu ezigciniwe ezifana ne-Microsoft Access yikhono labo lokugcina ubudlelwane phakathi kwamatafula ahlukene wedatha. Amandla we-database enza kube lula ukuxhumanisa idatha ngezindlela eziningi futhi kuqinisekiswe ukuvumelana (noma ukuthembeka okungaguquguquki) kwale datha kusuka etafuleni kuya etafuleni.
Cabanga ngedatha encane eyakhiwe yenkampani "yebhizinisi elilula". Sifuna ukulandelela abasebenzi bethu kanye namakhasimende ethu. Singasebenzisa isakhiwo setafula ukwenza lokhu, lapho i-oda ngalinye lihlotshaniswa nesisebenzi esithile. Lolu lwazi luhamba phambili luveza isimo esiphelele sokusetshenziswa kobudlelwano be-database.
Ngokubambisana, ungadala ubudlelwane obonisa ukuthi ikholomu yomsebenzi etafuleni le-Orders ihambelana nekholomu yabaSebenzi kuthebula labasebenzi. Uma ubuhlobo buhlanganiswa phakathi kwamatafula amabili ahlukene, kuba lula ukuhlanganisa leyo datha ndawonye.
Ake sibheke inqubo yokwakha ubudlelwane obulula usebenzisa database Microsoft Access:
Indlela Yokwenza Ubuhlobo Bokufinyelela
- Ngokufinyelela okuvulekile, ngena kwimenyu yamathuluzi we- Database phezulu phezulu kohlelo.
- Kusuka ngaphakathi kwe- Relationships endaweni, chofoza noma thinta Ubudlelwano .
- Iwindi leThebula le- Show kufanele livele. Uma kungenjalo, khetha i- Show Table kusuka kuthebhu Yokwakha .
- Kusukela kusibonisi seThebula se-Show , khetha amatafula okufanele ahileleke ebuhlotsheni, bese uchofoza / thepha u- Engeza .
- Manje usungavala iwindi le- Show Tables .
- Hudula insimu kusuka etafuleni elilodwa kuya kwelinye itafula ukuze kuvule iwindi le- Edit Relations .
- Qaphela: Ungabamba ikhi Ctrl ukukhetha amasimu amaningi; Donsela enye yazo ukuhudula bonke kubo kwenye itafula.
- Khetha noma yiziphi ezinye izinketho ozifunayo, njenge- Ukuqinisekisa Ukuthembeka Okubhekayo noma Ukuvuselela Izinsimu Ezihlobene Njalo , bese uchofoza noma thinta Dala .