Ukuhlunga Nokuhlunga Idatha Ekufinyeleleni: Umhlahlandlela wesinyathelo ngesinyathelo kanye nezibonelo ezisebenzayo

Ukuhlunga nokuhlunga idatha ekufinyeleleni kungenye yezinsika eziyisisekelo zokuphatha nokukhipha inani kunoma iyiphi isizindalwazi esihlobene. Uma unamakhulu noma izinkulungwane zamarekhodi, ukuthola ulwazi olufanele kungaba umsebenzi onzima uma ungawazi kahle amathuluzi okuhlunga nokuhlunga eliwanikezayo. Microsoft Finyelela.

Kulesi sihloko, ngichaza ngokuningiliziwe ukuthi ungahlunga kanjani futhi uhlele idatha yakho, uhlanganise zonke izinketho eziyisisekelo nezithuthukisiwe ezitholakala ku-Access. Kungakhathaliseki ukuthi ungumuntu osaqalayo noma onolwazi, ngemva kokufunda lokhu okuqukethwe, uzoba nombono ocacile wokuthi ungenza kanjani ngendlela oyifisayo ukubuka, imibuzo, nemibiko ukuze ubonise ulwazi oludingayo kuphela kuthebula ngalinye, ifomu, noma umbiko.

Kungani ukuhlunga nokuhlunga kubaluleke kangaka Ekufinyeleleni?

Ukufinyelela kuklanyelwe ukusebenza ngenqwaba yolwazi, lapho ukubukwa okusheshayo nokusesha okuphumelelayo kubalulekile. Uma uke wazithola ulahlekile ufuna irekhodi elithile, uyazi ukuthi kusho ukuthini ukungakwazi ukusebenzisa izihlungi. Izihlungi nokuhlunga kusebenza njengengilazi ekhulisayo nerula: zikuvumela ukuthi ugxilise futhi uhlele idatha yakho, zifihle okwesikhashana ongakudingi futhi zikusize ubone amaphethini namathrendi.

Ukuhlanganiswa kwazo zombili izinqubo kusiza ukuhlaziya, ukubika ngobungcweti kanye nokwenza izinqumo. ukwaziswaIlogi ehlungwe kahle futhi ehlelekile kulula kakhulu ukuyiqonda, ukwabelana, nokusebenzisa njengesisekelo semibuzo emisha noma imibiko.

Imiqondo Eyisisekelo: Kuyini ukuhlunga nokuhlunga idatha ekufinyeleleni?

Ngaphambi kokuqhubeka nokuzilolonga, kubalulekile ukucacisa imigomo:

• Hlunga Kusho ukubonisa esikrinini kuphela amarekhodi ahlangabezana nenqubo eyodwa noma ngaphezulu, ukufihla amanye okwesikhashana futhi angacekeli phansi.
• Ukuhleleka Kuhlanganisa ukuhlela kabusha ukuhlelwa kwamarekhodi ngokuvumelana nenani lenkambu eyodwa noma ngaphezulu, kungaba ngohlelo olukhuphukayo noma oluyehlayo.

Zombili lezi zenzo aziyiguquli ngokoqobo idatha egcinwe kuthebula, zishintsha kuphela ukuthi yethulwa kanjani ekubukeni kwakho okusebenzayo.

Ngingazisebenzisa kuphi izihlungi nokuhlunga kokuthi Ukufinyelela?

Cishe noma iyiphi into yokufinyelela—amathebula, imibuzo, amafomu, nemibiko—ikuvumela ukuthi uhlunge futhi/noma uhlele idatha. Kuye ngento, ezinye izici zifinyeleleka kalula noma zinikeza izinketho ezahlukene zokwenza ngokwezifiso. Ngokwesibonelo:

• Amabhodi: ilungele ukuhlunga okusheshayo kwedatha eluhlaza.
• Imibuzo: Ukuhlunga kungaba yingxenye yombuzo ngokwawo (imibandela kumugqa wokuklama).
• Amafomu: Ilungele kakhulu ukuhlunga ngokubukeka noma ngefomu, eyenzelwe umsebenzisi wokugcina.
• Imibiko: ikuvumela ukuthi usebenzise izihlungi ekuhloleni kuqala ngaphambi kokuphrinta noma ukuthekelisa.

Izinhlobo ezihlukene zezihlungi ezinikezwa yi-Access

Ukufinyelela kuhlanganisa izindlela ezimbalwa zokuhlunga ukuze zivumelane nezimo ezihlukahlukene kanye namazinga okuhlangenwe nakho. Khetha uhlobo lwesihlungi olufaneleke kakhulu ngokusekelwe kubunkimbinkimbi balokho okufunayo:

Izihlungi ezijwayelekile

Ashesha kakhulu futhi aqonde kakhulu, njengoba i-Access ikunikeza izinketho zokusetha ngaphambilini ngokusekelwe ohlotsheni lwedatha kukholamu. Awudingi ukubhala imibandela noma amafomula. Kalula nje:

• Chofoza umcibisholo wokudonsela phansi kunhlokweni yekholomu noma inkambu ofuna ukuyihlunga.
• Ungakhetha/ungakhethi izinto ezithile, uhlunge ngobubanzi, noma ngezimo ezithile njengokuthi 'okulingana', 'kuqukethe', 'kuqala ngo', 'okukhulu kuno', njll.
• Ezinkambu zedethi, uzothola izihlungi ngezikhathi, inyanga, phakathi kwamadethi, namuhla, izolo, ngeviki eledlule, njll.
• Uma ukhetha "(Izikhala)", uhlunga amarekhodi angenalutho noma angenalutho kuleyo nkambu.

Le ndlela ilungele ukubuyekezwa okusheshayo noma uma udinga ukuhlunga ngombandela olula.

Hlunga ngokukhetha

Ikuvumela ukuthi uhlunge ngokusekelwe kunani elithile ngokumane ulikhethe kuseli. Isibonelo, uma uchofoza igama elithile bese ukhetha okuthi 'Hlunga ngokukhetha,' Ukufinyelela kuzofihla wonke amarekhodi ngaphandle kwalawo analelo nani langempela kuleyo nkambu. Ungakwazi:

• Khetha igama, ingxenye yombhalo, idethi noma inombolo, bese uhlunga ngokukhetha (isiqalo, isiphetho, siqukethe, njll.).
• Hlanganisa izihlungi eziningi ngokukhetha ezinkambini ezihlukene ukuze uqhubeke ucwenge umphumela.
• Ukuze ususe isihlungi, vele uchofoze okuthi 'Shintsha Isihlungi' noma 'Sula Zonke Izihlungi' kuthebhu yasekhaya, eqenjini elithi Hlunga & Hlunga.

Hlunga ngefomu

Lolu hlobo lwesihlungi lunamandla ikakhulukazi ekusesheni amarekhodi ahlangabezana nemibandela eminingi emikhakheni ehlukene. Ukufinyelela kudala inguqulo engenalutho yefomu noma isipredishithi, lapho ungagcwalisa khona izinkambu ngamavelu ofuna ukuwacinga (ungashiya okunye kungenalutho bese ugcwalisa adingekayo kuphela). Lokhu kulungele ukusesha okuyinkimbinkimbi njengalokhu:

• Bonke abantu idolobha labo "iMadrid" futhi isikhundla sabo sithi "Umphathi."
• Ungenza okunye ukusesha usebenzisa ithebhu ethi 'NOMA', okungukuthi, ukubonisa amarekhodi ahlangabezana nesethi yemibandela eyodwa noma enye (isb.: Country = 'Spain' NOMA Izwe = 'France').
• Njengazo zonke ezinye izindlela, ukususa isihlungi kulula njengokucindezela u-'Toggle Filter' futhi.

isihlungi esithuthukisiwe

Imodi ethuthukisiwe iyona esondele kakhulu ekuklameni umbuzo, ekuvumela ukuthi uveze izimo eziyinkimbinkimbi nezingokwezifiso kugridi yokuklama. Kunconywa uma unolwazi ngezinkulumo nemibandela:

• Finyelela inketho ethi 'Isihlungi Esithuthukisiwe noma Hlunga' phakathi kweqembu elithi 'Hlunga & Hlunga'.
• Engeza izinkambu ofuna ukuzihlunga kugridi futhi ucacise imibandela kumugqa 'wemibandela' (ungasebenzisa ama-opharetha anengqondo, imisebenzi, izinkulumo ezifana nemibuzo).
• Sebenzisa umugqa othi 'NOMA' uma ufuna ukusetha enye indlela yokunquma.
• Ungakwazi ukulayisha imibandela embuzweni odlule noma ulondoloze lesi sihlungi njengombuzo omusha ozosisebenzisa esikhathini esizayo.

Ukusebenzisa izihlungi isinyathelo ngesinyathelo ngokuya ngohlobo lwento

Hlunga kumathebula

Ake sithi unetafula labasebenzi futhi ufuna ukubona kuphela labo abanamaholo angaphezu kwama-€50.000:

1. Vula ithebula ekubukeni kwe-Datasheet.
2. Chofoza umcibisholo kunhlokweni yekholomu 'Yomholo'.
3. Khetha okuthi 'Izihlungi Zenombolo' bese ukhetha okuthi 'Kukhulu kunoku', faka u-50000.
4. Ukufinyelela kuzobonisa kuphela abasebenzi abahlangabezana naleso simo.

Ungakwazi ukuhlanganisa izihlungi kwamanye amakholomu, isibonelo: department = 'Sales' KANYE nomholo > 50000, usebenzisa isihlungi sefomu.

Hlunga imibuzo

Imibuzo ikuvumela ukuthi ungeze umbandela ngokuqondile kumugqa wokuklama, ukuze isikhathi ngasinye lapho uqhuba umbuzo, Ukufinyelela kubonise kuphela idatha ehlungiwe. Isibonelo, ukubuka ukuthengiswa kwama-euro angu-1000:

1. Vula umbuzo ekubukeni komklamo.
2. Kumugqa 'wemibandela' ngaphansi kwenkambu ethi 'Inani', thayipha okuthi ">1000".
3. Qalisa umbuzo ukuze ubuyisele kuphela imiphumela efanayo.

Ungahlanganisa imibandela eminingi usebenzisa okuthi 'AND' noma 'NOMA' ukuze uqhubeke ucwenge.

Ukuhlunga idatha kumafomu

Amafomu enzelwe ulwazi lomsebenzisi olunembile. Ukuhlunga kusuka lapha kulula njengokuchofoza kudatha oyithandayo nokusebenzisa isihlungi, noma ukusebenzisa isihlungi sefomu ukusesha okuthuthukile.

Izihlungi emibikweni

Uma unombiko (isibonelo, uhlu lwabasebenzi), ungahlunga ekubukeni kombiko ngokwawo ngaphambi kokuwuphrinta:

1. Chofoza kwesokudla kudatha (isb., isibongo) bese ukhetha 'Izihlungi Zombhalo > Iqala ngayo'.
2. Faka uhlamvu noma umbhalo bese wamukela.

Ungaphrinta umbiko ngokuhlunga kuphela ingxenye yedatha oyithandayo ngaleso sikhathi. Ukuze ulondoloze isihlungi njengombuzo futhi usisebenzise kabusha, sebenzisa isici esithi 'Isihlungi Esithuthukisiwe noma Hlunga' ngaphakathi kweribhoni.

Uzikhipha kanjani noma uzisebenzise kanjani izihlungi

Ukukhipha isihlungi kulula: vele ucindezele inkinobho ethi 'Guqula Isihlungi' kubha ephezulu. Lokhu kususa isihlungi okwesikhashana kodwa kusishiye silondoloziwe, ukuze ukwazi ukusenza sisebenze futhi ngokunye ukuchofoza. Uma unquma ukusula isihlungi (usebenzisa 'Sula Zonke Izihlungi'), Ukufinyelela kukhohlwa okukhethiwe, futhi kuyodingeka ukusebenzise kabusha uma ukudinga ngezikhathi ezizayo.

Ilondoloza izihlungi ukuze ziphinde zisetshenziswe

Ukufinyelela kukhumbula izihlungi ezisebenzayo lapho uvala amathebula, amafomu, noma imibiko, ukuze ukwazi ukusebenzisa kabusha ngokuzenzakalelayo isihlungi esifanayo kuseshini yakho elandelayo.

• Ukuze uqinisekise ukuthi isihlungi sihlala sisetshenziswa lapho into ivulwa, hamba eshidini lesakhiwo bese unika amandla inketho ye-'FilterOnLoad'.
• Funda kabanzi mayelana nemibuzo ethuthukisiwe ekufinyeleleni kokuhlunga nokuhlunga idatha..

Izibonelo ezisebenzayo zokuhlunga Ekufinyeleleni

Ukuhlunga okulula

Uma unetafula loku-oda futhi ufuna ukubona kuphela lawo afakwe enyangeni edlule:

1. Hlunga ikholomu 'Yosuku Lwe-oda' ngokukhetha inyanga ehambisanayo kuzihlungi zedethi.

Ukuhlunga okuyinhlanganisela noma ngokwezifiso

Bona kuphela abasebenzi abanamaholo angaphezu kwama-euro angama-50.000 futhi abasebenza ngokuthengisa:

• Faka isihlungi esiyinhlanganisela esivela kumenyu ethuthukisiwe: iholo > 50000 KANYE nomnyango = 'Ukuthengisa'.

Noma, uma uthanda, sebenzisa ngokugcwalisa zombili izinkambu ngamavelu owafunayo.

Hlunga imibiko ukuze iphrinte

Hlunga umbiko ukuze ubonise amakhasimende asuka edolobheni elithile kuphela:

• Vula umbiko ekubukeni okuphrintiwe, chofoza inkambu yedolobha, bese usebenzisa isihlungi sombhalo esithi 'Equals' noma 'Iqukethe'.

Phrinta noma uthumele umbiko ohlungiwe njengoba kudingeka.

Ihlunga idatha kokuthi Ukufinyelela

Ukuhlunga idatha kubaluleke ngokulinganayo ekwethulweni nasekuqondeni, kungaba kumathebula, imibuzo, noma imibiko.

Hlunga ngamathebula

1. Vula ithebula ekubukeni kwe-Datasheet.
2. Chofoza unhlokweni wekholomu ofuna ukuyihlunga.
3. Chofoza isithonjana sokuhlunga (enyukayo) noma eyehlayo (ZA).

Ungakwazi ukuhlunga ngamakholomu amaningi, nakuba eyinhloko kuzoba yileyo ekhethwe kuqala.

Hlunga ngemibuzo

Ekubukeni kwe-Design, kumugqa othi 'Hlunga', khetha ukuthi uyafuna yini ukuhlunga okwenyukayo noma ukwehla ngenkambu eyodwa noma ngaphezulu.

Isibonelo: Hlunga kuqala ngegama lomkhiqizo (onyukayo) bese kuba ngedethi (ukwehla), ukuze uhlaziye ukuthengiswa kwakamuva komkhiqizo ngamunye.

Hlunga ngemibiko

Finyelela izinketho zokuhlunga ezicini zombiko noma sebenzisa ukubuka kwe-Design ukuze ucacise imibandela yokuhlunga yezindawo eziningi.

Ukuhlanganisa izihlungi nezinhlobo zokuhlaziya okuthuthukile

Amandla eqiniso okufinyelela asekuhlanganiseni ukuhlunga nokuhlunga, udale ukubuka okwenziwe ngendlela oyifisayo okukuvumela ukuthi uvule okuthrendayo noma uhlaziye ibhizinisi lakho ngokujulile.

• Okokuqala, hlunga idatha yokhiye ukuze unciphise ukubuka kwakho, isibonelo, ukuthengisa ngaphezu kuka-€2000.
• Bese uhlunga ngedethi, ngomsebenzi, ngomkhiqizo, nanoma iyiphi enye inkambu efanele.
• Ungalondoloza lokhu kulungiselelwa njengombuzo ozophinda uwusebenzise uma kudingeka.

Ukuphikelela kokucushwa nokusebenzisa kabusha

Abasebenzisi abaningi abazi ukuthi Ukufinyelela kukuvumela ukuthi ulondoloze isihlungi futhi uhlele izilungiselelo, unikeze igama, futhi ufinyelele ngokuqondile lokho kubuka ngokwezifiso kumaseshini azayo. Thatha ithuba lesi sici ukuze uhlale uhlaziya idatha engukhiye ngaphandle kokuthi uphinde ulungise yonke into kusukela ekuqaleni.

Izihlungi nokuhlunga ngamafomu nolwazi lwazo lomsebenzisi

Ngamafomu, ungasebenzisa izihlungi ezivela kusixhumi esibonakalayo ngokwaso, ngamamenyu anembile noma izinkundla zokusesha eziqondile.

• Khetha inkambu noma inani bese uhlunga kumenyu yokuqukethwe.
• Sebenzisa izihlungi zefomu uma udinga ukuhlanganisa imibandela ezinkambini eziningi.
• Izinketho zingatholakala kubha yamathuluzi, amaribhoni okufinyelela ngokushesha, noma kumamenyu aqondene nefomu elithile.

Ukuzivocavoca kanye nezimo ezingokoqobo zokuhlunga nokuhlunga

Ukukusiza uqonde ngokugcwele ukusebenzisana kwezinto ezihlukahlukene kwe-Access, nazi ezinye izivivinyo nezibonelo ezingakusiza uzilolonge:

Ukuzivocavoca okusebenzisanayo

• Impahla yesitolo: Hlunga imikhiqizo enesitoko esingaphansi kuka-10 futhi uyihlele ngentengo eyehlayo.
• Ukuphathwa Kwephrojekthi: Bonisa kuphela imisebenzi elindile futhi uyihlele ngokwenyusa usuku olumisiwe.
• Ukulandelela ikhasimende: Hlunga amakhasimende ukuthengwa kwawo kokugcina kwaba ngaphezu kwezinyanga ezintathu ezedlule futhi uwahlele ngesimo sobulungu.

Izifundo zecala

• HR: Hlunga abasebenzi bomnyango wezokuthengisa bese ubahlunga ngokwehlisa iholo.
• Ukuhlaziya ukuthengisa: Hlunga kuphela okuthengisiwe kusuka kwikota yokugcina futhi ukuhlele ngobuningi okwehlayo.
• Ucwaningo lwezemfundo: Hlunga amaphrojekthi amanje futhi uwahlele ngedethi yokuqala.

Amathiphu athuthukile nemikhuba ehamba phambili yedatha enkulu

Uma isizindalwazi sakho siqala ukukhula futhi izihlungi noma ukuhlunga kuthatha isikhashana, qaphela lezi zincomo:

• Izinkomba ezilungiselelwe kahle: Khomba amakholomu azohlunga futhi ahlunge kaningi ukuze usheshise ukusesha.
• Faka isihlungi kuqala, bese uhlela: Ukucubungula amarekhodi ambalwa kuhlala kushesha.
• Gwema izihlungi eziyinkimbinkimbi kakhulu embuzweni owodwa. Zihlukanise zibe imibuzo elula futhi uzihlanganise kamuva uma kudingeka.
• Khetha kuphela amakholomu odinga ukuwabonisa; gwema 'khetha konke' ukuze uthuthukise ukusebenza kahle.
• Khubaza ukubuyekeza okuzenzakalelayo ekubukeni komklamo ngemibuzo eyinkimbinkimbi futhi usebenze ngesampula.
• Uma uphatha idatha eningi, cabanga ukuhlukanisa ulwazi kumathebula amaningana ahlobene.

Izici ezengeziwe zezihlungi ekufinyeleleni

Ungakhohlwa ukuthi Ukufinyelela kukubonisa uma kukhona isihlungi esisebenzayo esinesithonjana sefaneli kunhlokweni yekholomu nakubha yokuzulazula yokurekhoda.

Uma uhambisa phezulu kwesihloko senkambu ehlungiwe, uzobona ithiphu yethuluzi elinemibandela yokuhlunga esetshenziswayo njengamanje. Lokhu kuyasiza ekukhumbuleni izimo ngokushesha ngaphandle kokubuyekeza zonke izilungiselelo.