Me pēhea te ki te waihanga i tētahi pātengi raraunga i roto i Access. Mahi ki te pātengi raraunga Access

E rave rahi o te iwi rohe e mohiotia nei i tetahi whakaoho wa ka whakatika i te MS Office 2007 he atanga whakarerekētia, a te mea e kore e whakamakuku tona kaiwhakawhanake! "Guru" i tangi te meka i ko "rorirori, me te tipua" te huinga tari hou, engari no te mea he pakari tohu ia i te matenga, me te katoa kaiwhakamahi te warewaretanga.

Kahore! Mai tetahi mea tupu, i runga i te anga ke, rawa hohoro ka reira mārama e meinga te whakamahi o te putanga hou "Office" Kua nui māmā me te ake watea.

A, no te mea (rite tūmanakohia) huringa, nga hiahiatanga mo i i hanga i roto i te "Tari 2007" e kore noa pai te oho ki tona oranga hou, engari riro ano hoki te whanaketanga arorau o tona. Ko Ko te aha hei te putanga 2010 kua tino rongonui i roto i ngā kaiwhakamahi ngaio.

Huringa i roto i te putanga hou o te Access

Tino i hanga huringa nui, me te tono rongonui mō te hanga pātengi. Na roto i te wae Sparklines hou, ka taea e koe te waihanga me te whakatika nui o ngā mōhiohio. A whakawhetai ki te taputapu ripiripi i ha faingamālie nohopuku me te ngāwari navigation noa i roto i pātengi raraunga nui. Na te whakawhetai katoa ki te kounga tiketike, me te whakaaro filtration pūnaha faata'i.

I tua atu, i te ngā i tapiritia pai kōmitimiti ki Excel, tika i nei e taea e koe te kawemai nui o ngā mōhiohio. Heoi, fifili atu pinepine kaiwhakamahi tauhou e pā ana ki te pehea, ki te hanga i tētahi pātengi raraunga i roto i Access.

He aha te tenei

Hei tika whakaturia ake turanga, me matau tuatahi koe ratou ngako. Pātengi Raraunga huaina hanganga tino whakaritea hangaia ki te rokiroki me te whakarite i ngā mōhiohio. Kia roto i te reira i ngā rawa rerekē, engari ratou wae arorau ko te tepu.

Ratou rerekētanga matua i ngā hanganga rite i roto i te kaiwhakatika ripanga ko e kōtuitui ratou. Te whakaputa i te rerekētanga o tetahi huānga, ka kōkiri i aunoa koe te whakakapinga o tuatihia ki ngā hanganga e hāngai ana katoa. Mämä noa iho, Me kore koe ki te manukanuka ā whakatika nga tepu mōhiohio nui.

He aha koe e taea te mahi ki te awhina o MS Access?

Kaua e amo i te tono, ko te ahua o "hokohoko atu arorau» Excel. Ko nui whānui te taea o te hōtaka i roto i te pātai. I roto i ngā, i tetahi hanga o pātengi raraunga MS Access titau whakaaro tupato te hanganga mōhiohio o te tuhinga motuhake, tirohia te tapatahi o te raraunga taketake, ka whakamahi i tēnei mōhiohio ki te whakatau i te uiui, ngā puka me ngā pūrongo.

tauira o te hanga i te

Na me pehea ki te hanga i tētahi pātengi raraunga i roto i Access, a ka taea e te whakamahi i te "Ruānuku" hanga e mea ohie mō ngā kaiwhakamahi tauhou, he kahore rerekē te tukanga o ngā whīwhiwhi. Otiia kihai matou i pai tūtohu ki te haere taua ara, mai kia matau nga tukanga katoa ki te kia hua.

rere Tuatahi te tono. ka puta kōrero i runga i te mata ki te waihanga i tētahi tuhinga hou. I roto i te reira e tīpako koe "Database New". I roto i te "ingoa Kōnae" whakaurua te whai pūtake ana i te reira. A ape i ingoa auau, me te horihori o te kahore: rite ki te hua o tetahi hapa ake ta'etokangá ranei, ka taea e koe ngaro ngāwari ngā mōhiohio nui.

"Waihanga" i muri i aki i tenei pātene te. Tonu i muri e, ka puta te aroturuki te pouaka kōrero ki te waihanga i tētahi ripanga pārongo hou, a ka hanga e koe i ai tou kaupapa.

Me pēhea te ki te whiriwhiri aratau?

taea te tepu te tāuta i roto i maha ara rerekē, engari e tohutohu tatou "Designer", mai te mea te reira māmā ki te whakahaere i te tukanga katoa, me te pai matau te hanganga ā-katoa o te tuhinga.

Whakamahia whakawhitinga "Momo-Designer" ki te haere ki a ia. Muri te whakahaerea reira hiahiatia ingoa ripanga motuhake. Mai hiahia ai ratou ake i te kotahi, tūtohu ano tatou ki te whakamahi i te tahi mau ingoa e whai kiko ana.

Na, mau, te tukanga iho. Me pēhea te ki te waihanga i tētahi pātengi raraunga i roto i Access? Ko te mahi tuatahi, ko te ki te tīpako me te whakakiia i nga ingoa o nga mara, tautuhi momo raraunga, me te whakaturia te mara matua tika. ka anake ka taea e koe te tīmata whakakī i raraunga i roto i te ripanga.

Ki te mahi i tenei, te whakamahi i te whakahau "tepu aratau tirohanga." Kia whai whakaaro! Ki te te mara "waehere ahanoa" i roto i to koutou take ko reira tika ki "Counter", ka whakakiia i roto i te mara motuhake e kore te mea e tika ana. A, no te mea kua oti koe te mahi i runga i te whakataki o ngā mōhiohio, e taea te kati i te reira. Ki te hiahia te pātengi raraunga ngā te tepu tuarua, huihuia ana e ia he rōpū o "Creation o te tepu hoahoa."

tauira o turanga

e kia katoa o te runga ake te reta mate kahore hoatu koutou nga taipitopito o te "wheako mara", e haere mai i roto i te pātengi raraunga Access pepa. Ka taea e koe te matapaki i te mau hi'oraa i roto i tenei rohe tata mure ore, engari ka arotahi tatou i runga i te puka, e taea tino whakahaere te rere o te tukanga akoranga.

whakaahua poto te hanganga o te tuhinga i runga i te marautanga. He aha e hiahia ana ahau ki te whakauru? Me tae atu ēnei i te mara e whai ake nei: waehere makehe, tau rōpū, me te kaiako kaupapa. Me mōhio: te mara "Kaupapa" me "kaiako" Me e pā ana ki tepu atu, i nei e utu te hōtaka te mōhiohio e tika ana.

Pehea te mahi i te reira?

Tuatahi, te mahi mahi katoa i roto i runga i te tohutohu i runga ake. Haere ki te "Hoahoa", tīmata koe ki te whakaki i roto i te mara. I roto i te raina ki te waehere pato raraunga motuhake kia tohua reira rite "counter, te mara matua".

Ko te "Rōpū" me ngā rārangi rite o te momo parae e kīia ki rite "kuputuhi." Otiia i roto i nga mara "Kaupapa" me "kaiako" kia whiriwhiri "Ruānuku Tirohia". Kaua e manukanuka: te taenga atu ano tīpako koutou i tenei uara, ka whakaatu i te hōtaka koe he pouaka kōrero. I muri i tana tohutohu, ka taea e koe te hanga i tētahi hononga ki ētahi atu tepu. Ka rite ki matau koutou, kia whakapumautia i roto i mua.

Kia pāwhiri koe i runga i te pātene "Mutu", whakaaturia he whakatūpato i roto i mua o koutou e hiahia ana koe ki te waihanga i tētahi hononga ki te whakaora i te tepu. Whakaū tenei mahi.

Te hanga hononga i waenga i ngā ripanga

Kua kua korero matou e pā ana ki te meka e mahi ana ki te pātengi raraunga Access titau te oraraa o ngā hononga tika i waenganui i ripakaute maha. Na me pehea ki te hanga a ratou?

Ki te mahi i tenei, whakatuwhera te tuhinga e hiahiatia ana, a ka haere i runga i te ara, "Mahi ki Pātengi - Kaupapa Raraunga". Hei whakatau a whakaturia te āhua o te hononga, me pāwhiri rua-koe te pātene kiore maui i roto i te pouaka kōrero "Huri Association." I muri i taua kia pāwhiri koe i runga i te pātene "OK". Ka rite ki te hua, whakaturia koe te kōwhiringa taunoa, "tetahi ki tokomaha".

Na ka titiro matou ki te pātai o te pehea, ki te hanga i tētahi pātengi raraunga i roto i Access. Te ti'aturi nei matou e, kia whai hua ki a koutou i te mōhiohio.