Access-hanga. Waihanga i te puka mo te urunga raraunga

Access Ko te kaha tono Windows, pūnaha whakahaere pātengi raraunga (DBMS ). Ko tōna whakaaro - ki te whakarato i ngā mōhiohio ki te kaiwhakamahi i roto i te puka watea, ngā mahi aunoatanga, e maha nei toutou. tauturu hoki te hōtaka i roto i te tiki, me te rokiroki raraunga. kawea tenei katoa i roto i Access-hanga. Te hanga puka - mahi ohie, hangaia ki te āwhina i te kaiwhakamahi nui taea.

I roto i te puka Access rite te matapihi toa, he reira watea ki tiro me te whakatuwhera i te tūemi e hiahiatia ana. Mai te puka - ko te ahanoa e taea ngā kaiwhakamahi ki te tāpiri i, whakatika me te whakaatu raraunga rongoa i roto i Access, tona ahua e whai wāhi nui.

Ki te te pātengi raraunga, ko te Uru tono puāwaitanga whakamahia e ngā kaiwhakamahi maha, he puka pai-hangaia - te tika raraunga matua me te kakama o te mahi ki a ratou.

Te hanga puka

whakarato pātengi raraunga Access te kaiwhakamahi ki te tikanga watea mō te mahi ki te raraunga. Tenei Access-puka motuhake, e tino whakahaere urunga, whakatika raraunga, mātakitaki ratou. Ko ratou he ahanoa motuhake i roto i te pātengi raraunga, me te whai i te täoro nui o ngā mana ki i reira he aunoatanga o pūrongo, rongoa i roto i ngā ripanga pātengi raraunga. He mara kuputuhi, pouaka taki, pātene irirangi, rārangi maturuturu-iho, a na i runga i enei.

He maha ngā huarahi ki te hanga i ngā puka i roto i te Access:

• hanga puka e hāngai ana i runga i ngā papa me te pātai;
• hanga puka pātea;
• piko āhua;
• puka ki ngā tāurunga maha;
• puka Access-kaimahi.

Waihanga i te puka mā te whakamahi i te Ruānuku Puka, kaihoahoa motuhake.

Ko ratou tino whai hua ki te, hei tauira, me mahi tāurunga raraunga ki puka motuhake. Hoki tenei momo o te puka, āta mahi te rite i runga i te puka i te mara tomokanga raraunga.

Puka hāngai i runga i te tepu ngā

Te hanga puka i roto i te Access i runga i te tepu ngā Ko te tino māmā. Ki te mahi i tenei, kite "Te hanga i te" hiahia ki te pāwhiri i te pātene "Puka". Te huru matua i roto i tenei take ko te hanga tuatahi o tepu raraunga, me tona kōwhiringa i roto i te rohe navigation. whakaatu te puka kotahi anake record, me te raraunga ripanga e pā ana.

Hei whakaatu ngā pūkete maha i roto i te puka tepu kia i roto i te taua pātene "Waihanga" ki te tīpako "torutoru huānga". Na ka taea ki te whakaatu i roto i te puka mara kuputuhi, he maha o ngā pūkete raraunga ki mara tepu katoa tatou.

I runga i te pūtake o te ngā puka hanga tepu i roto i Access taea hoki ki a koe te whakawhanake i tētahi puka wehea. Tenei tirohanga, e tahi ki te kanohi raraunga ko te mana kōwhiringa raraunga i roto i te whakarara i roto i te puka ripanga. Hei waihanga i tētahi puka ritua, he mea e tika ana i roto i te pātene "Waihanga" ki te tīpako "Puka Split".

kitea ara kotahi puka taua whakahōputu ki ngā mana maha. Nuinga o ngā wā enei āhuatanga ko nga mara kuputuhi raina-kotahi, e kua whakaaturia i roto i te uara raraunga rongoa i roto i mara te tepu. Engari o mua-whakahōputu, ka taea e mahi koe i te puka kau.

Tirohia tahora

tepu translation-ki-te whakamahi Rite i roto i te tirohanga Puka. I roto i tenei aratau, e taea te puta ke anake te pūkete raraunga tūturu o ngā ripanga pātengi raraunga, ki te neke i waenganui i te pūkete. e kore e hōputu i roto i tenei aratau whakaaetia, me te hanga o ngā puka o Microsoft Access titau mana hōputu me te puka ano. tenei katoa e taea te mahi, ki te whakawhiti koe ki te aratau Tahora aratau hoahoa ranei.

Ko rerekē i te aratau hoahoa iti wāhitanga mo te hoahoa o ngā puka aratau Tahora. Heoi, ko reira tino watea mo te whakahōputu tere, ki te hanga huringa iti ki te mana: tīaroaro poutū whakapae ranei o ratou, te tāpiri mara kuputuhi atu, te huri i te puka o te kāhua me na runga i. I roto i te aratau Tahora, e kore koutou e taea e te huri i te putanga raraunga i roto i te mana, i te aratau hoahoa whakarato ha faingamālie taua.

Tautuhi ana i te puka i roto i te tirohanga Hoahoa he matatini ake me hohonu. I tua atu, anake i roto i te aratau hoahoa he wātea he maha o ngā āhuatanga o te hoahoa whakairoiro, me te mana: tapawhā, raina, pātene, pouaka paheko, pātene irirangi, me te ake. I roto i tenei aratau, ka taea e koe te huri i te pūtake raraunga mo te puka taea te whakatika. Ano, e taea te monokia tenei aratau aratau tahora.

Tāpiri i te pātene ki te puka

Hei tauira, e hiahia ana koe ki te tāpiri i te pātene ki te puka ki i e whai reira ki te kati. I roto i te aratau hoahoa he wātea ana ki te tahora katoa o ngā āhuatanga mana, i roto i te mea he pātene. Ki te tāpiri koe i te reira ki te tahora o te puka, te pātengi raraunga, ka waihanga aunoa i te kī ariki, e ka puta ki te pouaka kaiwhakamahi.

Matapihi waihanga pātene whakahere he kōwhiringa o te maha ngā kāwai, e roto i ngā rārangi o ngā mahi. I roto i tenei take, me te whiriwhiri koe i te kāwai "mahi ki te puka." Mai i tenei rārangi mahi kāwai ki te tīpako "Katia te puka."

He tika te whai ki whakamōhio te kaiwhakamahi i tenei pātene te kawenga mo te kati o te pokepokea ai. Ka taea e koe te waiho i te kuputuhi i runga i te pātene, a ka taea e korero ki a koutou i te reira ki te icon (pikitia).

Next, e muhumuhu te ruānuku te kaiwhakamahi ki te hoatu i te ingoa ki te pātene, ka taea e koe te pāwhiri "Mutu" - na te tiki pātene rite i runga i te puka, e ka tukua ki te kati i te reira.

Ki te inaianei pāwhiri koe i runga i te pātene Waihanga, e ue'i koe ki te whakaora i te pātengi raraunga i hanga i roto i te puka o huringa, a ka kati i te reira. I roto i te tirohanga Hoahoa, ko te pātene kore e mahi tenei. Te reira i anake mahi i roto i te aratau o waihanga.

Ko reira tika hoki ki te mea e taea te hanga e te puka ratou te whakamahi i te ruānuku motuhake. I roto i te hanga o te pokepokea ariki, e titauhia anake kia tautuhia ki ona tautuhinga. Next, te hanga i tētahi puka ngāwari hōputu i to ratou ariki te ngarahu pai mā te whakawhiti ki te Tahora aratau me te i roto i te aratau hoahoa.

subforms

Pukaroto - he huānga he te ngä o te tahi atu, te matua Access-āhua. Te hanga puka tāpaetanga - ko te whanaketanga o te hanganga aroākapa o te papa e rua, e whakaata ana i te oraraa o whanaunga i waenganui i ngā puka.

Ko te hononga i waenganui i a ratou e taea e tohu he wātea i waenganui i ngā ripanga pātengi raraunga te momo rerekē o te kōrero, "kotahi-ki-maha", "he tokomaha-ki-he tokomaha". E mea pinepine enei whanaunga whakaaro whanaungatanga motu ki te aroaro o te matua (turanga) puka me te āpiti (pononga).

He aha te mea he Pukaroto

Ka taea te faataa subforms te hanga i roto i Access e te tauira: Ka taea e tenei puka e he puka o kaihoko whakahaua te toa ipurangi.

roto ngā mōhiohio kiritaki i roto i te tepu kotahi, a ka penapena mōhiohio e pā ana ki ona whakahau i roto i te tahi atu i roto i te hononga ki te māori o te hoahoa pātengi raraunga. tutaki tetahi kaihoko e rave rahi whakahau, na te hononga i waenganui i te kiritaki me te whakahau tepu whakaata te hononga "kotahi-ki-he tokomaha". I roto i tenei take, te āhua e tohu raraunga o te kaihoko, ka riro i te auraki. Ka te atu e tohu ana raraunga whakahau kia tapiritia ki te matua, a ka kia kaimahi.

Whakanohoia i roto i tetahi tahora wāhi o te faaiteiteraa puka matua, me te kaimahi anake e pā ana raraunga. Hei tauira, ki te ko te kaihoko kiritaki ahurei te tepu, me i roto i te kaupapa ki a ia whakahau tepu e toru ngā tāurunga e pā ana, ka Pukaroto whakaaturanga e toru ngā pūkete katoa o tona whakahau.

Ruānuku puka

Waihanga i te hanganga aroākapa o te puka i roto i Access, koutou taea i roto i ngā huarahi rerekē. Hei tauira, te whakatinana i te tauari o te hanga puka me te matua, me te tuarua, ka taea e koe huihui ki te whakamahi i te Ruānuku Puka.

Te hanga i te puka matua i roto i Access, kei roto kaimahi, te whakamahi i te ruānuku e kore e waiho ohie. e kore e hanga e ia anake te puka ratou, engari ano ki te herea ratou ki te huru e tika ana. Ki te kōrero te taua Pukaroto hanga tauari tāpiri reira ki te matua tīariari, ka taea rānei e koe te whakamahi i te ruānuku, toia noa me te maturuturu te tepu ngā i runga i te tahora matua, me te kia awhenga reira ranei.

Waihanga i te tāpaetanga puka

Waihanga subforms hāngai te i runga i rua nga tepu e pā ana (Kaitito, me Pukapuka). ka whakamahi matou i te ruānuku puka. Ko te taahiraa matamua e whakatuwhera te rangatira ia, kei te mahi kapa e i roto i te pātengi raraunga Access (hanganga o puka). I roto i te Access 2007, mo te tauira, e taea te kitea i te reira i roto i te taka-iho rārangi tūemi "Ētahi puka".

matapihi Ruānuku e oroko ui koe ki te tīpako i te tepu hoki e hiahia ana koe ki te waihanga i ngā puka me mara (kōwhiringa mā te pāwhiri-rua), e hiahia ana i te kaiwhakamahi ki te kite. I muri i te tepu tuatahi i roto i te matapihi taua, ka hiahia koe ki te whiriwhiri i tetahi, hono nei te ki te tuatahi. ka kitea Ruānuku te hononga, me te mea e kore e taea te mahi ia i te reira, na te hanga i te puka kaimahi ko reira taea noa ki. I roto i tenei take, ka hanga i hanga te pononga i runga i te pūtake o te tepu Books.

I roto i te taahiraa i muri mai o te ruānuku ui koe ki te tīpako i te ahua o ngā raraunga. E ti'a ia tatou ki te whiriwhiri i te "Subforms" a ka pēhi ano te pātene "Next".

Ka tukua te taahiraa i muri ki a tatou te whiriwhiri i te ahua o ngā puka whakapumautia: rīpene e hāngai ana-ripanga tahora ranei. Me mea e ahau he taonga hoki Kāhua taua rīpene.

I roto i te taahiraa whakamutunga e hiahia ana tatou ki te whakarite panekōrero, ka pāwhiri "Mutu" - noho kaimahi ki te uru i te puka. Waihanga ana ngā puka oti.

kia whakawhiti te hanganga i hanga i roto i te hoahoa tahora ranei tirohanga. ka hiahia te reira ki te whakahōputu te mara hua, tāpiri atu ngā mana ranei.

Te hanga i te puka Papawhakawhiti i roto i Access

Ko te aroaro o te tokomaha nui o ngā ripanga i roto i te pātengi raraunga, me te te puka e pā ana ki te raraunga i roto i enei papa, nui fakafaingata'a'ia'i te aronuinga pātengi raraunga whānui. Ki te whakahaere i nekehanga i waenganui i nga puka turanga, hanga i te puka Main Papawhakawhiti pera-ka karanga. Ko te huānga noa, e taea te whakatika i roto i ona whakaaro anake i roto i te hanganga tenei. Ka taea e tatou te mea e, te hanga i te puka Papawhakawhiti Main, kua kawea koe i roto i te hanga o ngā puka pātengi raraunga i roto i Access, i te mea tona kaitiaki mata te whārangi kāinga ranei.

Whakamahia te pātene kei te rota māmā runga reira ki te neke i waenganui i ngā āhuatanga, rite e pā ana ia pātene kei ki te puka motuhake. Pāwhiritia i runga i te pātene ai te pātengi raraunga ki te mahi i te whakawhitinga ki te tepu pātene e pā ana.

Te mahi ki te

I roto i Access, te hanganga o te puka Main Papawhakawhiti e te motuhake pūmana. Dispatcher he puka Papawhakawhiti raro mahi ki pātengi. Ki te ko reira te wa tuatahi, e kore e kitea e koe puka Papawhakawhiti me faauru ki a koe te hanga i tētahi. Kei ruānuku matapihi pakū-ake te maha pātene i e taea e koe te tīpako i te "Huri". Na ka taea e koe te haere ki te puka papapātuhi kōrero tatūnga mahi me ētahi atu puka turanga wātea.

Hei tauira, tāpiri e rua pātene - "Pātene 1" me te "Pātene 2" - i runga i te puka Main Papawhakawhiti. Ēnei pātene Whakapā puka Authors1 me Books, i te mea kaimahi. Mā te tīpako "New", ka whakatuwhera matou he pouaka kōrero i reira tohu tatou i te ingoa e hiahiatia ana o te pātene, me te mahi e hiahia ana tatou ki te mahi i ( "Open puka ki te huri i"). I roto i te toru o nga mara, tomo te puka ki i hiahia tatou ki te hono ki te tāpiri pātene.

Te katia te matapihi tautuhinga, kitea tatou e puta i to tatou puka Papawhakawhiti i roto i te matapihi whakatere. Te tohu i te reira i roto i te pihanga whakaterenga, whakatuwhera te matapihi, me te kite e kei reira he kāhua hoahoa ohie, me rua pātene. Pāwhiri i runga i te pātene ka meinga te pātengi raraunga ki te whakatuwhera i te puka i hono te pātene kei te.

tepu Wehewehenga

I roto i te tepu arai i muri i te mahi e taea te kitea ki te tāpiri i te tepu hou i huaina Tūemi Papawhakawhiti. pupuru ana te reira i te tautuhinga katoa e pā ana ki te hanga i te puka Papawhakawhiti. I roto i to tatou take i reira ko te kotahi anake puka Papawhakawhiti ki e rua pātene, na kua whakanohoia reira e toru anake ngā tāurunga:

• pūkete o te pātene roto i runga i te puka,
• nga mahi e pā ana ki a ratou,
• he lekooti o te puka Papawhakawhiti te nuinga.

aratau hoahoa

Ka taea te faingataa puka Papawhakawhiti hanga e hōputu reira i roto i Hoahoa ihirangi tirohanga. Mā te whakamahi i te reira i runga i te mata koe e taea e te tāpiri i maha atu mana whai hua.

puka Papawhakawhiti Main hoki kua te kaha ki te hono ki ētahi atu āhua rite. Ko te āhuatanga whai hua mō te tabularaa i ngā whakawhitinga i waenganui i ngā puka i roto i te pātengi raraunga rawa nui te wahi i reira he wahi mo te momo o wāhanga, me ngā kāwai tenei.