Access-zoo lawm. Tsim ib daim ntawv rau cov ntaub ntawv nkag teb chaws

Access yog ib tug haib lub qhov rais daim ntawv thov, database system tswj (DBMS ). Nws lub hom phiaj - los qhia rau tus neeg siv nyob rau hauv ib tug yooj yim daim ntawv no, automation ua hauj lwm, uas yog feem ntau rov qab. Qhov kev pab cuam kuj yuav pab nyob rau hauv retrieving thiab khaws cia cov ntaub ntawv. Tag nrho cov no yog nqa tawm Access-zoo lawm. Tsim ntaub ntawv - yooj yim ua hauj lwm, tsim los pab cov neeg siv ntau li ntau tau.

Nyob rau hauv Access daim ntawv raws li ib tug kav qhov rais, nws yog yooj yim los mus saib thiab qhib cov yam khoom. Txij li thaum lub daim ntawv - yog ib tug kwv uas tso cai rau cov neeg siv mus ntxiv, kho kom raug thiab zaub cov ntaub ntawv khaws tseg nyob rau hauv Access, nws cov tsos plays ib qho tseem ceeb luag hauj lwm.

Yog hais tias lub database yog Access classical daim ntaub ntawv siv los ntawm ntau cov neeg, ib tug zoo-tsim daim ntawv - tus yuam sij ntaub ntawv raug thiab efficiency ntawm kev ua hauj lwm nrog lawv.

tsim ntaub ntawv

Access database muab tus neeg siv nrog ib tug yooj yim mechanism rau ua hauj lwm nrog cov ntaub ntawv. Qhov no tshwj xeeb Access-daim ntawv, uas muaj nuj nqis pab txhawb nkag teb chaws, cov ntaub ntawv editing, saib lawv. Lawv yog ib tug tshwj xeeb cov kwv nyob rau hauv lub database thiab muaj ib tug loj arsenal ntawm lwm yam uas nrog uas muaj automation ntawm qhia, muab cia rau hauv database ntxhuav. Cov no yog cov ntawv luam liaj teb, check thawv, xov tooj cua nyees khawm, poob-down npe, thiab thiaj li nyob.

Txoj kev uas yuav tsim ntaub ntawv nyob rau hauv Access yog manifold:

• tsim ntaub ntawv raws li nyob rau hauv uas twb muaj lawm ntxhuav thiab queries;
• tsim dawb paug ntaub ntawv;
• comma zoo lawm;
• ntaub ntawv uas muaj ntau hom nkag;
• Access-subordinate cov ntaub ntawv.

Tsim ib daim ntawv los ntawm kev siv lub Form Wizard, tshwj xeeb designer.

Lawv yog tshwj xeeb yog pab tau yog hais tias, piv txwv li, cov ntaub ntawv nkag teb chaws yuav tsum tau ua nrog tshwj xeeb cov ntaub ntawv. Rau no hom ntawm daim ntawv no, cov ntaub ntawv nkag teb chaws teb yeej ua tib yam li rau hauv daim ntawv.

Daim ntawv raws li nyob rau hauv ib tug uas twb muaj lawm rooj

Tsim ntaub ntawv nyob rau hauv Access raws li nyob rau hauv ib tug uas twb muaj lawm cov lus yog heev yooj yim. Ua li no, saib "Tsim ib tug" yuav tsum tau nias lub khawm "Form". Lub ntsiab mob nyob rau hauv cov ntaub ntawv no yog lub sij hawm luag creation ntawm cov ntaub ntawv lub rooj, thiab nws xaiv nyob rau hauv lub navigation cheeb tsam. Daim ntawv qhia txog tsuas yog ib cov ntaub ntawv, raws li tau zoo raws li ntaub ntawv hais txog lub rooj.

Yuav kom tso saib ntau cov ntaub ntawv nyob rau hauv rooj daim ntawv yuav tsum tau nyob rau hauv tib "Tsim" khawm kom xaiv "ob peb ntsiab". Yog li ntawd peb yuav tsum tau mus tso saib nyob rau hauv phau ntawv daim ntawv teb, ib tug xov tooj ntawm cov ntaub ntawv cov ntaub ntawv rau tag nrho cov rooj teb.

Nyob rau lub hauv paus ntawm ib tug uas twb muaj lawm rooj creation ntaub ntawv nyob rau hauv Access kuj tso cai rau koj los tsim ib tug muab faib daim ntawv. Qhov no saib, uas ua ke nrog cov ntaub ntawv sawv cev yog ib cov ntaub ntawv xaiv ntawm lwm yam uas nyob rau hauv thaum uas tig mus nyob rau hauv ib lub rooj ntawv no. Yuav kom tsim ib tug split daim ntawv no, nws yog tsim nyog nyob rau hauv lub "Tsim" khawm kom xaiv "Split Form".

Tej ntaub ntawv tshwm txawm ib zaug formatted nrog ntau yam ntawm lwm yam uas. Feem ntau cov feem ntau cov ntsiab yog ib leeg-kab ntawv nyeem teb, uas yog tso tawm kom pom nyob rau hauv lub cia cov ntaub ntawv tseem ceeb nyob rau hauv lub rooj teb. Es tsis txhob pre-formatted, koj yuav ua li cas lub empty cov ntaub ntawv.

layout Saib

Npaj-rau-siv translation rooj nyob rau hauv daim ntawv saib. Nyob rau hauv no hom, tsuas yog tus cov ntaub ntawv cov ntaub ntawv ntawm database ntxhuav yuav raug hloov, txav ntawm cov ntaub ntawv. Formatting nyob rau hauv no hom tsis pub, thiab cov creation ntawm cov ntaub ntawv Microsoft Access yuav tsum tau formatting ntawm lwm yam uas thiab daim ntawv nws tus kheej. Tag nrho cov no yuav ua tau, yog tias koj hloov mus rau Layout hom los yog tsim hom.

Layout hom yog txawv los ntawm tus tsim hom tsawg cib fim rau cov tsim ntawm cov ntaub ntawv. Txawm li cas los, nws yog yooj yim heev rau ceev formatting, yuav ua rau me kev hloov rau ntawm lwm yam uas: ntsug los yog kab rov tav kawm tuab si lug ntawm lawv, ntxiv ntxiv ntawv luam liaj teb, hloov cov ntaub ntawv ntawm cov style thiab thiaj li nyob. Nyob rau hauv Layout hom, koj yuav hloov tsis tau cov ntaub ntawv tso zis nyob rau hauv lub ntawm lwm yam uas, thaum lub sij hawm tsim hom muab tej ib lub sij hawm.

Qhov chaw rau hauv daim ntawv nyob rau hauv Tsim saib yog ntau thiab no:. Nyob rau hauv tas li ntawd, tsuas yog nyob rau hauv tsim hom yog muaj ib tug xov tooj ntawm cov ntsiab ntawm cov graphic design, raws li zoo raws li lwm yam uas: voos, kab, nyees khawm, combo thawv, xov tooj cua nyees khawm, thiab tshaj. Nyob rau hauv no hom, koj yuav hloov cov ntaub ntawv qhov twg los rau lub editable daim ntawv. Ntxiv mus, qhov no hom yuav muaj neeg xiam layout hom.

Ntxiv ib khawm rau hauv daim ntawv

Piv txwv li, koj yuav tau ntxiv ib lub pob rau hauv daim ntawv uas nws yuav muaj mus kaw. Nyob rau hauv lub tsim hom yog muaj rau ib tug tag nrho layout ntawm ntau yam tswj hais, cov uas yog ib lub pob. Yog hais tias koj ntxiv rau lub layout ntawm daim ntawv, tus database yuav tsim ib tug tswv tseem ceeb, uas yuav tshwm sim rau cov neeg siv lub thawv.

Qhov rai tsim nyees khawm muaj ib tug xaiv ntawm ob peb pawg, uas muaj cov npe ntawm cov kev ua. Nyob rau hauv cov ntaub ntawv no, koj yuav tsum xaiv qeb "Ua hauj lwm nrog rau hauv daim ntawv." Los ntawm no qeb txiav txim daim ntawv teev rau xaiv "Kaw rau hauv daim ntawv."

Cov nram qab no yog tsim nyog los qhia rau tus neeg siv tias qhov no khawm yog lub luag hauj lwm rau lub kaw ntawm cov pwm. Koj ua tau tawm hauv cov ntawv nyeem nyob rau hauv lub khawm, thiab koj yuav qhia rau nws nrog lub icon (daim duab).

Tom ntej no, lub wizard qhia rau tus neeg siv yuav muab ib lub npe rau lub khawm, ces koj yuav tau nyem "Finish" - thiaj tau npaj khawm rau hauv daim ntawv, uas yuav cia nws mus kaw.

Yog hais tias koj tam sim no tau nyem rau ntawm cov Tsim khawm, koj sim hawm caij nyoog kom txuag tau tus database tsim nyob rau hauv daim ntawv ntawm cov kev hloov, thiab ces kaw nws. Nyob rau hauv Tsim pom, qhov no yog ib tug khawm yuav tsis ua hauj lwm. Nws tsuas ua hauj lwm nyob rau hauv lub hom ntawm formulation.

Nws tseem yog tsim nyog hais tias cov ntaub ntawv lawv tus kheej muaj peev xwm yuav tsim nyob rau kev siv ib tug tshwj xeeb wizard. Thaum lub sij hawm tsim kho ntawm lub tswv pwm xav xwb yuav txhais nrog nws chaw. Tom ntej no, tsim ib daim ntawv yooj yim format nyob rau ntawm lawv kev txiav txim tswv ntawm switching mus Layout hom thiab nyob rau hauv tsim hom.

subforms

Subform - lub caij ua lub complement ntawm lwm, lub ntsiab Access-zoo lawm. Tsim ntaub ntawv cuav - yog txoj kev loj hlob ntawm lub xaab siab qauv ntawm ob ntxhuav, reflecting lub hav zoov ntawm kev sib raug zoo ntawm cov ntaub ntawv.

Cov kev sib raug zoo nruab nrab ntawm lawv yuav sawv cev rau ib tug txawv hom ntawm kev sib txuas lus yog muaj nyob nruab nrab ntawm database ntxhuav, "ib tug-rau-ntau", "ntau-mus-muaj coob". Feem ntau cov kev sib raug zoo xav sectional kinship nrog lub xub ntiag ntawm leej niam leej txiv (puag) daim ntawv thiab ib tug subsidiary (qhev).

Yuav ua li cas yog ib tug subform

Tsim subforms nyob rau hauv Access yuav tau piav los ntawm ib qho piv txwv: daim ntawv no yuav ua tau ib daim ntawv ntawm buyer kom lub hauv internet khw.

Customer ntaub ntawv yog muaj nyob rau hauv ib lub rooj, thiab cov ntaub ntawv hais txog nws cov kev txiav txim yog nyob rau hauv lub lwm yam nyob rau kev twb kev txuas nrog cov normalization ntawm lub database tsim. Ib buyer raws li ob peb txiav txim, yog li txoj kev sib raug ntawm cov qhua tuaj noj mov thiab kev txiav txim lub rooj muaj kev cuam tshuam cov kev sib raug zoo "one-to-ntau". Nyob rau hauv cov ntaub ntawv no, lub puab sawv cev cov ntaub ntawv ntawm lub buyer, yuav los ua lub mainstream. Tus lwm sawv cev rau nws txiav txim cov ntaub ntawv yuav muab ntxiv rau cov tub ntxhais thiab yuav subordinate.

Muab tso rau hauv ib qhov chaw layout ntawm lub ntsiab thiab subordinate ntaub ntawv sau xwb txuam cov ntaub ntawv. Piv txwv li, yog tias lub rooj yog ib tug tshwj xeeb cov neeg buyer, thiab nyob rau hauv cov kev kawm nrog nws txiav txim rooj peb nkag txog, ces subform qhia tag nrho peb cov ntaub ntawv ntawm nws txiav txim.

daim ntawv Wizard

Tsim ib tug hierarchical qauv ntawm cov ntaub ntawv nyob rau hauv Access, koj ua tau nyob rau hauv ntau txoj kev. Piv txwv li, siv cov scenario ntawm kev tsim thiab lub ntsiab thiab subordinate cov ntaub ntawv, koj muaj peev xwm chaw uasi mus rau kev siv cov daim ntawv Wizard.

Tsim ib lub ntsiab daim ntawv nyob rau hauv Access, muaj subordinate, siv lub wizard yuav tsis yooj yim. Nws yuav tsis tsuas tsim cov ntaub ntawv rau lawv tus kheej, tab sis kuj yuav khi lawv nrog cov kev tsim nyog cwj pwm. Yog hais tias tib lub scenario creation subform qhia ntxiv rau cov uas twb muaj lub ntsiab, ces koj yuav yog siv lub wizard, los yog tsuas yog luag thiab poob ib uas twb muaj lawm rooj rau ntawm lub ntsiab layout thiab ua rau nws subordinate.

Tsim ib daim ntawv cuav

Tsim subforms yog raws li nyob rau hauv ob yam rooj (sau phau ntawv thiab phau ntawv). Peb yuav tsum siv cov ntaub ntawv wizard. Thawj kauj ruam yuav qhib tus tswv nws tus kheej, pab neeg no kev ua tau zoo nyob rau hauv lub Access database (creation ntawm forms). Nyob rau hauv Access 2007, piv txwv li, nws muaj peev xwm yuav nrhiav tau nyob rau hauv lub nco-down daim ntawv teev cov yam khoom no "Lwm yam ntaub ntawv".

Wizard qhov rais uas qhib kom koj xaiv lub rooj rau cov uas koj yuav tsum tau tsim cov ntaub ntawv thiab teb (xaiv los ntawm ob-clicking), uas tus neeg siv yuav xav mus saib. Tom qab thawj rooj nyob rau hauv tib lub qhov rais, koj yuav tsum tau xaiv rau lwm lub, uas yog kev cob cog rua nrog rau cov thawj. Wizard yuav ntes cov kev sib raug zoo, thiab yog hais tias nws tsis tau ua nws, ces tsim tau ib subordinate daim ntawv nws tsuas yog tsis tau. Nyob rau hauv cov ntaub ntawv no, tus qhev yuav daim ntawv tsim nyob rau hauv lub hauv paus ntawm cov phau ntawv lub rooj.

Nyob rau hauv lub kauj ruam tom ntej ntawm lub wizard nug koj kom koj xaiv rau hauv daim ntawv ntawm cov ntaub ntawv. Peb yuav tsum tau xaiv lub "Subforms" thiab ces rov nias lub khawm "Tom ntej".

Cov kauj ruam tom ntej yuav tso cai rau peb mus xaiv cov tsos ntawm tsim cov ntaub ntawv: daim kab xev los yog lub rooj-raws li layout. Kuv yuav tsum hais tias daim kab xev yog richer rau yeej.

Nyob rau hauv lub xeem kauj ruam peb yuav tsum tau customize cov hau lus, thiab nias "Finish" - nyob twj ywm subordinate mus saib tau rau hauv daim ntawv. Tsim ntaub ntawv kom tiav.

Cov tsim qauv tej zaum yuav hloov nyob rau hauv tsim los layout saib. Nws yuav tsum tau format lub resulting teb, los yog ntxiv lwm yam ntawm lwm yam uas.

Tsim ib tug Switchboard daim ntawv nyob rau hauv Access

Qhov kuaj pom ntawm ib tug loj tus naj npawb ntawm cov ntxhuav nyob rau hauv cov database, raws li zoo raws li cov ntaub ntawv uas txuam nrog rau cov ntaub ntawv nyob rau hauv cov lub rooj, zoo heev complicates lub zuag qhia tag nrho database schema. Yuav kom pab txhawb zog ntawm puag cov ntaub ntawv, tsim lub thiaj li hu Main Switchboard daim ntawv. Qhov no yog ib qho lub caij, uas yuav tsum edited nyob rau hauv nws cov tib tug yam nyob rau hauv lub constructor. Peb hais tau tias, tsim ib Main Switchboard daim ntawv no, koj tau nqa tawm lub creation ntawm database ntaub ntawv nyob rau hauv Access, uas yog nws screen saver los yog cov homepage.

Siv cov nyees khawm nyob rau ntawm nws yooj yim heev rau koj tsiv ntawm lub ntsiab, raws li txhua khawm yog txuam nrog ib tug nyias muaj nyias ib daim ntawv no. Nyem rau ntawm qhov khawm ua rau lub database ua rau txoj kev hloov mus rau lub txuam khawm rooj.

Ua hauj lwm nrog cov

Nyob rau hauv Access, cov creation ntawm lub Main Switchboard daim ntawv los ntawm ib tug tshwj xeeb xws li. Dispatcher Switchboard daim ntawv no yog nyob rau hauv kev ua hauj lwm nrog databases. Yog hais tias nws yog thawj lub sij hawm, koj yuav tsis nrhiav tau Switchboard daim ntawv thiab qhia rau koj los ua ib tug. Pop-up qhov rais wizard muaj ob peb cov nyees khawm los ntawm uas koj yuav xaiv tau lub "Change". Yog li ntawd koj yuav tau mus rau lub teeb kev sib txuas lus muaj nuj nqi keypad cov ntaub ntawv thiab lwm yam muaj nyob puag cov ntaub ntawv.

Piv txwv li, ntxiv ob nyees khawm - "khawm 1" thiab "khawm 2" - nyob rau Main Switchboard daim ntawv. Cov nyees khawm Hu daim ntawv Authors1 thiab phau ntawv, uas yog subordinate. By xaiv "Tshiab", peb yuav qhib ib tug dialog box uas peb qhia hais tias qhov kev kawm lub npe ntawm tus khawm thiab qhov kev txiav txim uas peb yuav tsum tau ua ( "Qhib daim ntawv hloov"). Nyob rau hauv lub thib peb teb, sau rau hauv daim ntawv uas peb xav mus txuas ntxiv nyees khawm.

Kaw lub chaw qhov rais, peb pom hais tias peb Switchboard daim ntawv nyob rau hauv lub navigation qhov rais. Xaiv nws nyob rau hauv lub navigation pane, qhib lub qhov rais thiab pom tau tias nws muaj ib tug yooj yim tsim style, thiab ob nyees khawm. Txhaj rau cov nyees khawm yuav ua rau lub database qhib rau hauv daim ntawv uas lub khawm yog txuas.

muab faib ntxhuav

Nyob rau hauv lub muab faib rooj tom qab lub lag luam yuav tsum pom mus ntxiv ib tug tshiab rooj hu ua Switchboard khoom. Nws khw muag khoom rau tag nrho cov chaw txuam nrog kev tsim ib tug Switchboard daim ntawv. Nyob rau hauv peb cov ntaub ntawv muaj no tsuas muaj ib Switchboard daim ntawv nrog ob tug cov nyees khawm, li ntawd nws yog muab tso rau xwb peb nkag:

• cov ntaub ntawv ntawm cov nyees khawm muaj nyob rau hauv daim ntawv,
• cov kev ua txuam nrog lawv,
• ib cov ntaub ntawv ntawm cov feem ntau Switchboard daim ntawv.

tsim hom

Tsim Switchboard tau daim ntawv nyuab los ntawm formatting nws nyob rau hauv Tsim saib cov ntsiab lus. Siv nws rau ntawm qhov chaw koj yuav ntxiv ntau lwm yam tseem ceeb lwm yam uas.

Main Switchboard daim ntawv kuj muaj lub peev xwm mus txuas nrog rau lwm cov uas zoo sib xws daim. Qhov no yog ib tug pab tau feature rau teem zaus ntawm ntaub ntawv nyob rau hauv ib tug heev loj database qhov twg muaj chaw rau ib tug ntau yam ntawm seem thiab pawg.