Yuav Tsim Cov Ntaub Ntawv Hluav Taws Xob Hauv Hluav Taws Xob Li Cas

Cov txheej txheem:

Yuav Tsim Cov Ntaub Ntawv Hluav Taws Xob Hauv Hluav Taws Xob Li Cas
Yuav Tsim Cov Ntaub Ntawv Hluav Taws Xob Hauv Hluav Taws Xob Li Cas

Video: Yuav Tsim Cov Ntaub Ntawv Hluav Taws Xob Hauv Hluav Taws Xob Li Cas

Video: Yuav Tsim Cov Ntaub Ntawv Hluav Taws Xob Hauv Hluav Taws Xob Li Cas
Video: Hluav taws xob tseem ceeb: Qhov yooj yooj yim txuag hluav taws xob 2024, Plaub Hlis Ntuj
Anonim

Cov chaw khaws ntaub ntawv yog cov ntaub ntawv cov ntaub ntawv uas muab khaws cia rau hauv hluav taws xob. Cov ntaub ntawv hauv cov ntawv khaws tseg yog khaws cia ua ntau hom: ntawv nyeem, hais txog zauv. Nws yog maximally nruj rau ntxiv ua thiab tshawb rau cov ntaub ntawv tsim nyog.

Yuav tsim cov ntaub ntawv hluav taws xob hauv hluav taws xob li cas
Yuav tsim cov ntaub ntawv hluav taws xob hauv hluav taws xob li cas

Tsim nyog

  • - khoos phis tawj;
  • - Qhov kev pab cuam MS Access.

Cov Lus Qhia

Kauj ruam 1

Pib Microsoft Access los tsim cov hluav taws xob hauv hluav taws xob. Koj tuaj yeem tsim nws hauv ib txoj hauv kev hauv qab no: tsim ib qho qauv siv qhov cuab tam, i.e. raws cov qauv uas xaiv tau. Hom qauv no yog qhov nrawm thiab yooj yim tshaj plaws thaum xaiv tau tag nrho raws li koj qhov yuav tsum tau ua. Tus template twb muaj cov ntxhuav, cov ntaub ntawv, lus nug thiab cov ntawv ceeb toom. Thaum kawg, koj tuaj yeem tsim qhov khoob ntawm koj tus kheej yam tsis muaj tus tsim qauv. Txhawm rau ua qhov no, koj yuav tsum ntxiv cov khoom uas xav tau thiab tom qab ntawd sau cov ntaub ntawv nrog cov ntaub ntawv.

Kauj ruam 2

Ua lub hauv paus tam sim ntawd tom qab pib qhov kev pab cuam, nyob rau hauv lub qhov rai uas tshwm, sau lub npe rau lub hauv paus thiab qhov chaw nws tau txais kev cawm. Tom ntej no, lub ntsiab Access Access yuav qhib, nyob rau hauv cov tab uas koj tuaj yeem tsim cov khoom database. Lub hauv paus ntawm ib qho chaw khaws ntaub ntawv yog ntxhuav, yog li koj yuav tsum pib nrog lawv.

Kauj ruam 3

Mus rau "Ntawv" tab, nyem rau khawm "Tsim". Xaiv "Kev Tsim Kho" xaiv, hom no tso cai rau koj los ua tus qauv thiab teeb tsa lub chaw rau lub rooj. Sau cov npe ntawm cov teb (kab ntawv) ntawm koj cov lus hauv qhov rai tsim. Ib daim teb yuav tsum yog qhov tseem ceeb, i.e. lub ntsiab ib. Thaj teb no yog nws tus kheej, i.e. yuav tsis muaj cov ntaub ntawv rov qab. Xaiv cov teb uas yuav tsum tau thiab nyem rau lub pob nrog tus yuam sij ntawm tus toolbar.

Kauj ruam 4

Teem cov hom teb rau txhua ntawm lawv nyob hauv Cov Ntaub Ntawv Hom. Nyem rau ntawm lub xovtooj ntawm khoob thiab xaiv hom xav tau los ntawm cov npe: cov ntawv sau (rau cov ntawv sau thiab cov ntaub ntawv tsis muaj kev hloov pauv), MEMO teb (rau kev nkag mus ntev ntawv lossis lej), cov lej (rau sau cov ntaub ntawv suav), hnub / sijhawm, txiaj ntsig, txee (cia li dhau los ua cov cim tshwj xeeb), boolean (cov ntaub ntawv tuaj yeem nqa ib qho ntawm ob qhov tseem ceeb - muaj / tsis muaj), OLE khoom (ntxig cov duab, cov duab kos, cov duab, cov duab), hyperlink, hloov tus wizard (tso cai rau koj los ntxig cov ntaub ntawv los ntawm ib lub rooj rau hauv lwm lossis tsim lub npov combo.

Kauj ruam 5

Tsim kom muaj kev sib txuas ntawm cov ntxhuav tsim, rau qhov no lawv yuav tsum muaj daim teb zoo ib yam. Piv txwv li, lub rooj "Cov Ua Haujlwm" nrog rau daim teb tseem ceeb "Tus lej ntawm tus Neeg Ua Haujlwm" tuaj yeem txuas nrog rau lub rooj "Cov Neeg Siv Khoom", uas txhua tus neeg siv nyiaj tau muab rau ib tus neeg ua haujlwm tshwj xeeb uas siv daim teb "Neeg ua haujlwm tus lej".

Kauj Ruam 6

Txhawm rau tsim kom muaj kev sib txuas, mus rau "Cov Ntaub Ntawv Txheej Txheem" qhov rai siv lub pob ntawm lub pob cuab tam thiab cab daim teb tseem ceeb ntawm ib lub rooj ("Cov Neeg Ua Haujlwm") mus rau thaj chaw zoo sib xws hauv lwm lub rooj ("Cov Neeg Tau Txais"). Nyob rau hauv lub qhov rai uas qhib, khij lub thawv "Cascade deletion of related fields", nyem "OK".

Pom zoo: