Yuav ua li cas los tsim Database Relationships hauv Access

Cov txheej txheem:

Yuav ua li cas los tsim Database Relationships hauv Access
Yuav ua li cas los tsim Database Relationships hauv Access
Anonim

Yuav Paub

  • In Database Tools, mus rau Kev Sib Raug Zoo, xaiv cov ntxhuav, luag ib daim teb los ntawm ib lub rooj mus rau lwm qhov, thiab nyem Tsim.
  • Kev nkag mus txhawb peb hom kev koom nrog los ntawm tus wizard no: ib-rau-ib, ib-rau-ntau, thiab ntau-rau-ib.

Kab lus no piav qhia yuav ua li cas los tsim kev sib raug zoo siv Access rau Microsoft 365, Access 2019, Access 2016, thiab Access rau Mac.

Yuav Ua Li Cas Kev Sib Raug Zoo

  1. Nrog Access qhib, mus rau hauv Database Tools ntawv qhia zaub mov rau saum qhov program. Los ntawm hauv cheeb tsam Kev Sib Raug Zoo, xaiv Kev Sib Raug Zoo.

    Image
    Image
  2. Lub qhov rai Show Table yuav tsum tshwm sim. Yog tias tsis yog, xaiv Show Table los ntawm Tsim tab. Los ntawm Show Table screen, xaiv cov rooj uas koj xav kom koom nrog hauv kev sib raug zoo, thiab tom qab ntawd xaiv Add.

    Yog tias cov ntaub ntawv twb muaj kev sib raug zoo-feem ntau yog vim muaj cov ntaub ntawv uas twb muaj lawm, cov ntawv ceeb toom, lossis cov lus nug-ces Kev nkag mus hla qhov pop-up no thiab hloov mus ncaj nraim mus rau qhov Tsim Kev Pom Zoo ntawm Kev Sib Raug Zoo Qhov rai.

    Image
    Image
  3. Txiav ib daim teb los ntawm ib lub rooj mus rau lwm lub rooj kom lub qhov rais Tsim qhib. Yog tias koj lub database twb infers kev sib raug zoo, lub qhov rais no yuav populate nrog kev sib raug zoo.

    Tuav lub Ctrl tus yuam sij xaiv ntau qhov chaw; luag ib leeg los luag tag nrho mus rau lwm lub rooj.

    Image
    Image
  4. Xaiv lwm yam kev xaiv uas koj xav tau, xws li Tswj Kev Ncaj Ncees Kev Ncaj Ncees lossis Cascade Hloov Kho Cov Lus Qhia ntsig txog, thiab tom qab ntawd xaiv Create lossis Tsim tshiab.

    Xaiv tswj hwm kev ncaj ncees txhais tau tias cov ntaub ntawv yuav tsis lees txais cov ntaub ntawv uas tsis sib xws. Ob cascade kev xaiv yuam kom cov ntaub ntawv tshem tawm lossis hloov kho thaum cov ntaub ntawv hloov pauv. Piv txwv li, xaiv cascade hloov tshiab ntsig txog thaj chaw yuav ua rau cov ntaub ntawv kho tus nqi hauv cov lus cuam tshuam thaum tus nqi hauv lub rooj hloov pauv; yog tias nws tseem tsis tau txheeb xyuas, cov txiaj ntsig qub tseem nyob, thiab cov ntaub ntawv tshiab tau txais tus nqi tshiab.

    Image
    Image

Koom Hom

Kev nkag mus txhawb peb hom kev koom nrog los ntawm qhov wizard-ib-rau-ib, ib-rau-ntau, thiab ntau-rau-ib. Feem ntau, koj feem ntau yuav siv thawj hom kev koom nrog, uas txuas cov ntaub ntawv thaum cov ntaub ntawv hauv ib qho sib tw cov ntaub ntawv hauv lwm qhov.

Kev nkag mus txhawb lwm hom kev koom nrog, tab sis koj yuav tsum tau tswj cov khoom siv los ntawm cov cuab yeej siab, tsis yog los ntawm Kev Sib Raug Zoo.

Pom zoo: