Access-mawonekedwe. Pangani mawonekedwe a kulowa deta

Access Ichitu Windows ntchito, kasamalidwe dongosolo Nawonso achichepere (DBMS ). cholinga chake - kupereka uthenga kwa wosuta mu mawonekedwe yabwino, ntchito zokha, amene mobwerezabwereza. Pulogalamu athandiza retrieving ndi kasungidwe ka deta. Zonsezi ikuchitika Access-mawonekedwe. Kupanga mitundu - ntchito yosavuta, ithandiza wosuta ngati kuli kotheka.

Mu mawonekedwe Access monga zenera la sitoloyo, ndi yabwino kuona ndi kutsegula zinthu ankafuna. Popeza mawonekedwe - ndi chinthu chimene chimathandiza owerenga kuwonjezera, Sinthani ndi kuwonetsera deta kusungidwa mu Access, maonekedwe ake amagwira ntchito yofunika kwambiri.

Ngati Nawonso achichepere ndi Access ntchito chakale ntchito ogwiritsa ntchito angapo, bwino cholinga mawonekedwe - deta kiyi molondola ndi dzuwa la ntchito ndi iwo.

Kupanga njira

Access Nawonso achichepere amapereka wosuta ndi njira yabwino ntchito deta. Izi wapadera Access kwambiri, zomwe kwambiri atsogolere kulowa, deta kusintha, n'kumawaona. Iwo ali chinthu chapadera mu Nawonso achichepere ndi kukhala zida lalikulu amazilamulira amene pali zokha Nkhani, kusungidwa mu magome Nawonso achichepere. Awa ndi minda malemba, mabokosi cheke, mabatani wailesi, mndandanda kusiya-pansi, ndi zina zotero.

Njira kulenga mitundu mu Access ndi zobwezedwa:

• kulenga njira yochokera matebulo ndi mafunso alipo;
• kulenga mafomu osalembapo;
• koma mawonekedwe;
• mitundu ndi zolemba angapo;
• Access-Kumvetsela mitundu.

Pangani mawonekedwe pogwiritsa ntchito Fomu mfiti, mlengi wapadera.

Iwo ali othandiza makamaka ngati, mwachitsanzo, kulowa deta iyenera kuchitika ndi njira yapadera. Kwa mtundu uwu wa mawonekedwe, deta kulowa m'munda makamaka kuchita chimodzimodzi monga mawonekedwe.

Fomu potengera tebulo alipo

Kupanga njira mu Access potengera tebulo alipo lophweka. Kuti achite zimenezo, mukuona "Kujambula" kufunika dinani batani "Fomu". Mkhalidwe waukulu mu nkhani iyi ndi chilengedwe kuyambirira matebulo deta ndi kusankha wake m'dera navigation. mawonekedwe amasonyeza umboni umodzi wokha, komanso deta zokhudzana tebulo.

Kusonyeza timva angapo mu mawonekedwe tebulo ayenera kukhala yemweyo "Pangani" batani kusankha "zinthu zochepa". Choncho tidzatha aziwoneka mu malemba minda mawonekedwe, nambala za mbiri deta ndi minda yonse tebulo.

Pamaziko a wogwila mitundu chilengedwe tebulo Access imaperekanso inu kukhala wogawanika mawonekedwe. Zimenezi, amene pamodzi ndi chifaniziro deta ndi amazilamulira deta kusankha mu kufanana ndi mawonekedwe tebulo. Kuti akonze kugawanika mawonekedwe, m'pofunika mu "Pangani" batani kusankha "Gawa Fomu".

mitundu ina amaoneka ngakhale kamodzi Onani m'magazini ndi amazilamulira angapo. Nthawi zambiri zinthu izi ndi wosakwatiwa mzere minda malemba, omwe amalembedwa pa mfundo kusungidwa deta m'minda tebulo. M'malo chisanadze Onani m'magazini, mungachite mitundu kanthu.

Kamangidwe View

Wokonzeka kugwiritsa ntchito yomasulira tebulo view Fomu. Ali wopanikizika, yekha mbiri leni deta matebulo Nawonso achichepere zikhoza kusintha, kuti amuchotse pakati pa zolembedwa. Zokongoletsa mu mode izi sikuloledwa, ndi chilengedwe cha mitundu ya Microsoft Access amafuna amazilamulira masanjidwe ndi mawonekedwe yokha. Zonse izi zikhoza kutheka, ngati inu kusinthana kwa Kamangidwe mode kapena kamangidwe mode.

mode Kamangidwe chosiyana ndi mwayi kapangidwe mode ochepa mapangidwe a mitundu. Komabe, kwambiri yabwino kwa masanjidwe mwamsanga, kusintha zing'onozing'ono amazilamulira kuti: ofukula kapena yopingasa mayikidwe a iwo, kuwonjezera minda zina lemba, kusintha mitundu ya kalembedwe ndi zina zotero. Mu mode Kamangidwe, simungathe kusintha linanena bungwe posonkhanitsa deta amazilamulira, pamene kapangidwe mode yapereka mwayi wotero.

Atakhala mawonekedwe mu Design view zinasintha kwambiri ndi kwambiri. Komanso okha mode mamangidwe alipo ambiri mfundo za kamangidwe likutipatsa, komanso amazilamulira: rectangles, mizere, mabatani, mabokosi kasakanizidwe, mabatani wailesi, ndi zambiri. Mu mode, mungathe kusintha gwero deta kwa mawonekedwe editable. Komanso, mode izi zikhoza wolemala mode Kamangidwe.

Kuwonjezera batani mawonekedwe

Mwachitsanzo, muyenera kuwonjezera batani mawonekedwe ndi umene ayenera kutseka. Mu mode mamangidwe kupezeka kwa Kamangidwe lonse la zinthu zosiyanasiyana kulamulira, lomwe ndi batani. Ngati inu kuwonjezera kwa mawonekedwe ya mawonekedwe, Nawonso achichepere adzakhala basi kulenga fungulo lotsegula, amene adzaoneka bokosi wosuta.

Zenera kulenga mabatani kupereka kusankha Magulu angapo, amene ali mndandanda wa zochita. Pankhaniyi, muyenera kusankha gulu "Kugwira ntchito ndi mawonekedwe." Kuyambira lero mndandanda gulu kanthu kusankha "Tsekani mawonekedwe."

Ndime zotsatirazi ndi zofunika kudziŵitsa wosuta kuti batani izi ndi udindo kutseka kwa nkhungu. Mukhoza kusiya lemba pa batani, ndipo inu mukhoza kudziwa ndi chizindikiro (chithunzi).

Kenako, mfitiyo kukuchititsa wosuta kupereka dzina batani, ndiye inu mukhoza dinani "mapeto" - choncho konzekerani batani mawonekedwe, zomwe zingathandize kuti kutseka.

Ngati inu tsopano alemba pa Pangani batani, inu amafika kupulumutsa Nawonso achichepere analengedwa mu mawonekedwe a kusintha, kenako kutseka izo. Mu Design view, ichi ndi batani sizigwira ntchito. Iwo amagwira ntchito kokha mu mawonekedwe a chiphunzitso.

M'pofunikanso kunena kuti mitundu okha akhoza kupangidwa pogwiritsa ntchito mfiti wapadera. Pomanga mbuye nkhungu Tiyenera umakhala ndi zoikamo ake. Kenako, kulenga mawonekedwe mosavuta mtundu pa nzeru mbuye wawo kusintha kwa Kamangidwe mode ndi mode kamangidwe.

subforms

Subform - mchitidwe pokhala athandize ena, waukulu Access-mawonekedwe. Kupanga njira kugonjera - ndi chitukuko cha dongosolo masanjidwe wa matebulo awiri, kunyezimiritsa kuli bwino pakati pa mitundu.

Kubverana kwawo amaimira mtundu wosiyana kulankhulana akupezeka pakati pa matebulo Nawonso achichepere, "limodzi ndi ambiri" "ambiri ndi ambiri". Nthawi zambiri asapita izi poganizira yachigawo zimakhalira pachibale ndi kukhalapo kwa kholo (m'munsi) mawonekedwe ndi wocheperapo (kapolo).

ndi subform Kodi

Kupanga subforms mu Access singalifotokoze chitsanzo: mawonekedwe akhoza kukhala mtundu wa wogula akulamula sitolo Intaneti.

Makasitomala mudziwe ali tebulo limodzi ndipo nkhani zokhudza malamulo ake zasungidwa mu ena mwa normalization wa kapangidwe Nawonso achichepere. wogula imodzi wakumana malamulo angapo, kotero ubale kasitomala ndi malamulo matebulo amasonyeza ubale "limodzi ndi ambiri". Mu nkhani iyi, mawonekedwe woimira deta ya wogula, adzakhala ambiri. The zina za malangizo ake deta zidzawonjezedwa kwa pakati ndipo adzakhala pansi pa ulamuliro.

Anaika mu mawonekedwe wina danga la zazikulu ndi Kumvetsela mitundu chionetsero yekha kugwirizana deta. Mwachitsanzo, ngati tebulo ndi wapadera wogula kasitomala, ndi phunziro naye malamulo tebulo zolemba zitatu zokhudzana, ndiye subform kusonyezedwa zolembedwa zonse zitatu za malangizo ake.

mawonekedwe mfiti

Pangani dongosolo masanjidwe mitundu mu Access, mungathe m'njira zosiyanasiyana. Mwachitsanzo, ndikukhazikitsa nkhani ya kulenga maonekedwe ndi zazikulu ndi wamng'ono, mukhoza amachita ntchito Fomu mfiti.

Kujambula fomu chachikulu Access, munali wamng'ono, pogwiritsa ntchito mfiti, silidzakhala Lofewa. Iye osati kulenga mitundu okha, komanso kwa Muwamange mtima kutero. Ngati chomwecho sewero chilengedwe subform zikusonyeza kuwonjezera kuti zazikulu alipo, ndiye inu mukhoza mwina ntchito mfiti, kapena kungoti Kokani ndikuponya ndi tebulo analipo kamangidwe chachikulu ndi kuzipanga izo wamng'ono.

Pangani mawonekedwe kugonjera

Pangani subforms zachokera matebulo awiri ofanana (Olemba ndi Books). Tidzakhalanso ntchito njira mfiti. Chinthu choyamba adzatsegula mbuye yekha, ntchito gulu ili mu Access Nawonso achichepere (chilengedwe cha mitundu). Mu Access 2007 Mwachitsanzo, angapezeke mu dontho-pansi mndandanda item "Mitundu ina".

Mfiti zenera kuti akutsegula akakupempha kusankha tebulo lomwe mukufuna kulenga maonekedwe ndi minda (Kusankha ndi iwiri kuwonekera), zomwe wosuta mukufuna kuona. Pambuyo pa tebulo yoyamba zenera lomwelo, muyenera kusankha mtundu wina, umene chikugwirizana ndi loyamba. Mfitiyo kudziwa ubale, ngati iye sangakhoze kuchita izo, ndiye analenga mtundu wamng'ono ndi kungoti amalephera. Pankhaniyi, kapolo ati apange analenga pamaziko a tebulo Books.

Mu sitepe yotsatira a mfiti akufunsa inu kusankha mtundu wa deta. Ife tisowa kusankha "Subforms" ndiyeno kachiwiri akanikizire batani "Kenako".

Chotsatira ungatithandize kusankha maonekedwe a mitundu anakhazikitsa: tepi kapena Kamangidwe tebulo ofotokoza. Ine ndiyenera kunena kuti tepi ndi watanthauzo kwa Mikhalidwe.

Mu sitepe otsiriza tiyenera ikonza yakeyi, ndi kumadula "mapeto" - kukhala pansi kulumikiza mawonekedwe. Kupanga njira anamaliza.

Kapangidwe analenga akhoza kugwiritsa zomangidwa kapena Kamangidwe view. Iwo ayenera mtundu wa kumunda chifukwa, kapena kuwonjezera amazilamulira ena.

Kujambula Switchboard fomu Access

Kupezeka kwa ambiri matebulo mu Nawonso achichepere, komanso mitundu kugwirizana ndi deta matebulo awa, kwambiri complicates wonse Nawonso achichepere chithunzithunzi. Kuti atsogolere gulu pakati pa mitundu m'munsi, kupanga otchedwa Main Switchboard mawonekedwe. Ichi ndi chinthu wamba, sipangakhalenso lolembedwa nzeru zake chokhacho constructor lapansi. Tikhoza kunena kuti, kupanga Main Switchboard mawonekedwe, inu ikuchitika chilengedwe cha mitundu Nawonso achichepere mu Access, ndilo chophimba chake mowasungira kapena tsamba lofikira.

Gwiritsani ntchito mabatani ili pa izo sizivuta kusamukira pakati pa zinthu, monga aliyense batani amagwirizana ndi maonekedwe osiyana. Dinani pa batani amachititsa Nawonso achichepere kuchita kusintha kwa kugwirizana tebulo batani.

Kugwira ntchito ndi

Mu Access, kulengedwa kwa Main Switchboard mawonekedwe ndi wapadera Mtsogoleri. Dispatcher Switchboard mawonekedwe ndi pansi ntchito ndi zinasokoneza makompyuta. Ngati ndi koyamba, simudzapeza mawonekedwe Switchboard ndi chimakulimbikitsani kulenga. Pop-zenera mfiti lili mabatani angapo kumene mukhoza kusankha "Change". Kotero inu mukhoza kupita ku khwekhwe aya ntchito keypad maonekedwe ndi ena mitundu zilipo m'munsi.

Mwachitsanzo, kuwonjezera mabatani awiri - "Button 1" ndi "Button 2" - pa Main Switchboard mawonekedwe. mabatani awa Lumikizanani mawonekedwe Authors1 ndi mabuku amene uli pansi. Ndi kusankha "New", ife adzatsegula ndi kukambirana bokosi pamene ife akusonyeza dzina Napempha kwa batani ndi kanthu kuti tiyenera kuchita ( "Open mawonekedwe kusintha"). M'munda lachitatu, kulowa mawonekedwe ndi zomwe tikufuna akulumikiza kuwonjezera mabatani.

Kutseka zoikamo zenera, ife tikupeza kuti Switchboard wathu mawonekedwe anaonekera mu navigation zenera. Posankha izo mu navigation pane, windo ndi kuwona kuti muli kapangidwe kalembedwe losavuta, ndi mabatani awiri. Kuwonekera pa mabatani adzachititsa Nawonso achichepere ndi kutsegula mawonekedwe kuti batani kumayambitsa.

matebulo kugawa

Mu tebulo kugawa pambuyo ntchito angapezeke kuwonjezera tebulo atsopano otchedwa Switchboard katundu. Izo zimasunga malo onse obwera ndi kupanga Switchboard mawonekedwe. Ifeyo pali m'modzi yekha Switchboard mawonekedwe ndi mabatani ziwiri, aikidwa zolemba atatu okha:

• mbiri mabatani ali mawonekedwe,
• zochita nawo,
• mbiri ya kwambiri mawonekedwe Switchboard.

Kulengedwa mode

Analenga Switchboard mawonekedwe akhoza kumva ndi Zokongoletsa izo mu Design view okhutira. Ntchito padziko mukhoza kuwonjezera zina zambiri amazilamulira zothandiza.

Main Switchboard mawonekedwe komanso ali ndi luso yolumikizana ndi akalumikidzidwa zina zofanana. Iyi ndi mbali lipindulitsa pa ndandanda kusintha pakati pa mitundu mu Nawonso achichepere lalikulu kwambiri kumene kuli chipinda zosiyanasiyana zigawo ndi siyana.