MS Access. MS Access pātengi raraunga. MS Access 2007

MS Access - kiritaki-tūmau tūhonohono pūnaha whakahaere pātengi raraunga (RDBMS) i Microsoft. tikanga Pānga e te hāngai ai ki runga ki nga papa. whakaaro tatou i tenei pūnaha i roto i te kōrero atu.

He aha te mea he pātengi raraunga tūhonohono?

He pātengi raraunga tūhonohono ngā o te huinga o nga papa, i waenganui nei ki te hanga whanaunga kōrero ranei. Pātengi Raraunga - he anga e taea ai e koe te hanga me te whakamahi pātengi raraunga MS Access.

Whakaaroa nga painga me ngā kino o te DBMS.

Painga o DBMS Microsorf Uru

• atanga Simple me te pūmanawa. Haere ki te mahi ki e taea tenei pātengi raraunga e, ki kahore he pūkenga motuhake. I tua atu, i te āwhina tauhou o ngā pukapuka tohutoro maha, ipurangi me ngā akoranga tuimotu.
• Ko pai te mōhiotia, me te tino rongonui i roto i te PC papamahi pātengi raraunga MS Access. Te tikanga o tēnei e taea e koe te rapu tonu te tauturu i te hoa, kua oti te whakamahi i tenei pātengi raraunga mō te tohutohu, me te mahi tahi ki tetahi pātengi raraunga i runga i te whatunga.
• taea Tata ta'efakangatangata ki te kaweake raraunga: raraunga i tepu e taea te whakawhiti tetahi pāwhiri o te kiore ki a Excel, Word, kaweake ki XML, te whakaputa ki PDF, e kore ki te whakahua i te meka e ki kahore raruraru neke ahanoa kua tīpakohia ki tetahi atu pātengi raraunga.
• utu iti. Ki te hoko koe i MS Access rite te wahi o te mōkihi Microsoft Office tonu, he mea whakarite ki ētahi atu pātengi raraunga utua, ka kia tino ataahua te utu.
• He kōwhiringa whānui o kaihoahoa mo hanga puka, pūrongo, me uiui, ka taea e koe te whakamahi i ki tātari i te raraunga, me te whakaatu ia ratou i roto i te ara watea.
• Whai wāhitanga ki te kawemai raraunga, ki te whai koe i raraunga ripa mā te whakamahi i te kupu pūtukatuka MS Word ranei MS Excel ripanga pūtukatuka, whakamahi koe i te ruānuku ka whakawhiti ratou ki to koutou pātengi raraunga ngāwari. Kawemai, i roto i te tua, e taea te mahi i te tuhinga kuputuhi ohie i te tuhinga XML, me te kōnae pātengi raraunga hanga i roto i te tahi atu pātengi (pērā i dBASE, Paradox).
• Te āhei ki te waihanga i tētahi kupuhipa hoki koutou pātengi raraunga.
• Hanga-i roto i te reo taumata-tiketike VBA.
• Ko te kaha ki te tuhi tonotono.
• ētita SQL.

Ka taea e hoki hötaka tīpako tetahi painga nui: matua Access jet 4 tāmau i roto i ngā pūnaha whakahaere Microsoft, tīmata ki-e hāngai ana Windows 98. tikanga o tēnei e te tono mā te whakamahi i te pātengi raraunga i hanga i roto i Access, ka taea e ngāwari koe te kawe i runga i tetahi rorohiko ki runga ki Windows. Ka mahi te reira, kahore he ki te tāuta i te DBMS iho. I roto i te take tino, Me anake ki te tāuta Wāhaere - putanga, e taea e tino noa ki te tiki i te paetukutuku Microsoft.

Ka rite ki a koutou e taea te kite, he wātea te rangatiratanga o te DBMS MS Access. Ko taea nga painga katoa e tami huakore rawa nui. Kia titiro tatou ki a ratou.

Huakore o DBMS Microsoft Access

• E pā ana MS Access ki te pātengi raraunga kōnae-tūmau. tikanga o tēnei e tukatuka raraunga katoa te tika i runga i te kaiwhakamahi kiritaki rorohiko. Ko te wāhanga tūmau o te tango te raraunga, me te whakawhiti ratou i runga i te tono. arata'i tenei ki te meka e i runga i te whatunga rohe haereere rerenga raraunga nui, a ki te maha nui o ngā kaiwhakamahi mahi ki te pātengi raraunga, kia waiho ai popoketanga whatunga. Ko te hoahoanga kōnae-tūmau matarohia e tura'ii te tonu hua iti ka he maha nui o ngā kaiwhakamahi. I roto i te MS Access te wāhanga faatiti'aifarohia 2010 putanga o tenei pātai.
• Ko te kore o taputapu tiaki raraunga pono. I roto i te meka, whakamahia he kupuhipa anake te i runga i te pūtake o te raraunga, me te kupuhipa o te kaiwhakamahi. Hoki te mātanga mātanga kore tū tetahi uaua ki te tango i tenei tiaki.
• Ko taea aratau Multiplayer anake i roto i te whatunga hanga noa ranei i roto i te tūmau kōnae whatunga.
• Hei whakawhanake i tētahi atanga ritenga e hiahiatia ana te ki te kukume hötaka.
• Editor SQL ka uiui te he i tahito ra, he reira ērā ki te whakamahi.
• E kore te mea noa tenei pātengi raraunga.
• MS Access herea i raro i ngā pūnaha whakahaere Windows. Hei tamata ki te whakamahi i te raraunga i hanga i roto i te pātengi raraunga ki ētahi atu pūnaha whakahaere (hei tauira, LINUX), i tino uaua. Noa whakawhiti te raraunga ki tētahi atu pātengi raraunga.

Kia titiro tatou ki nga pai me ngā raruraru o MS Access, ka hoatu te tauira o te putanga 2007 etahi tohutohu tere i runga i te taea o tenei pātengi raraunga.

Te hanga tepu

Kahore he mea māmā atu i ki te waihanga i tētahi ripanga hou mā te whakamahi i MS Access 2007:

1. "Fakatupú," haere ki te ripa i muri i te whakatuwheratanga i te pātengi raraunga.
2. Pāwhiritia i runga i te icon "Ripanga", ko reira te tuatahi i runga i te maui.
3. I mua i tatou i te kanohi ataata o te tepu ki te ingoa paerewa "Ripanga 1" me te mara incrementing-aunoa "Code".
4. Ka taea e koe te timata ki raraunga tāuru ki te tīwae tuarua. I muri tomo te aho, me pēhi e koe te tomo matua. Kei te whakaingoatia aunoa i te tīwae ki "Āpure 1," ka tangohia "Code" mara te uara o ngā waeine ka hei raraunga tāuru wātea i roto i te rārangi i muri.
5. Hei whakaingoa i tētahi tīwae, tika pāwhiri runga taua mea ki te kiore rua. Ko reira e minaminatia ki te tautuhi i te ingoa tīwae ki kahore he mokowā!
6. tepu Kaihanga i Access 2007, tino atamai. Ko reira utu ki a koutou i roto i te rarangi tuatahi o te tepu hou ki te tomo i te uara mara o te momo "Rā", pera i roto i te rārangi e whai ake i roto i te tīwae kotahi aunoa e kia karangatia koe ki te whakamahi i te maramataka.
7. Hei whakaoti i te hanganga o te tepu me ora i te reira mā te pāwhiri i runga i te ata e tika ana ranei pahekotanga pātuhi CTRL + S.

He maha ngā kaiwhakamahi atu watea ki te haere ki te tikanga o "Designer" mo ake mahi pūmanawa i runga i nga mara o te tepu, no te mea i roto i tenei aratau, ka taea e koe te whakapūtā te momo o mara, here i runga i ngā uara. I roto i tenei aratau, ka taea e koe te haere i tetahi wa ki te mahi ki te tepu, pēhi noa te pātene hāngai i runga i te rōpū.

Te hanga i te uiui

Fakakaukau ki he founga ki te hanga i uiui i roto i te MS Access. I roto i te 2007 ka hanga he uiui ohie i roto i te tirohanga Hoahoa:

1. I te "Tahua" pihanga, pāwhiri i runga i te "Waihanga" pātene "Designer Uiui" ripa.
2. Here ka kite tonu koe i te tepu matapihi kōwhiringa. Pāwhiritia i runga i ia tepu i nei me tīpakohia te raraunga. Kia mahara te reira e te kōwhiringa ka taea ki te kawe i roto i anake koe, ki te taea te arorau hono tepu neke atu i te kotahi ki ia atu e tetahi mara.
3. Ki te mea kua tīpakohia e koe neke atu i te kotahi tepu, me hanga e koe he here i waenganui i a ratou, te whakawhānui i te raina ki te kiore i tetahi mara i roto i te tepu kotahi ki te mara e hono ana ki te tahi atu.
4. Na pāwhiri rua-te mara i ia tepu e hiahia ana koe ki te kite i te hua.
5. I roto i te pae tahua i runga i te ripa "Hoahoa", pāwhiri i runga i te tohu nei nui. I mua i puta koe i roto i ripa hanga i te hua o tou kōwhiringa.

Ko te tātai whānui mō te hanga pātai tenei. Hoki atu pātai matatini, kite Āwhina mo te hōtaka, te whakamahi i taonga motuhake ranei.

I te tahi taime e hiahia ana ara he kaiwhakamahi tauhou ki te tapaea atu o koutou raraunga i roto i te hōputu atu whai hua atu i te tepu ohie. Katahi ia mai ki te āwhina o MS Access taputapu - "Puka".

Ruānuku puka

I runga i te tauira Access 2007, whakaaro pehea ki te whakamahi i te Ruānuku Puka:

1. I te "Waihanga" ripa, i raro i "Puka" haere ki "Ruānuku Puka" i roto i te "Ētahi puka".
2. Kōwhiri i te rārangi taka-iho, he tepu uiui ranei mo e hiahia ana koe ki te waihanga i tētahi puka ataata.
3. Whakamahia ">" me ">>" o te whakawhiti poraka "mara wātea" ngā rā o tīwae i roto i te poraka "tīpakohia mara" e tetahi katoa ranei i kotahi, aua. Pāwhiritia i runga i te pātene "Next".
4. Tīpakohia te ahua o te puka mā te whakamahi i te pana.
5. Next, tīpako i te kāhua puka, a ka taea e koe pēhi i te pātene "Mutu". Tenei ko to koutou tepu uiui ranei raraunga i roto i te hōputu ngā.

Hei waihanga atu āhua matatini me te whakamahi i te hanganga e tika ana.

Ka whakaaro enei tohutohu, ka taea e tatou e faaoti e MS Access - ko te whai wāhitanga pai mo te utu iti tenei. atanga hoa, te nuinga o tāmau Engineers tautoko me kaimahi - hanga tenei katoa reira māmā ki te hoahoa i te pātengi raraunga , me te mahi tahi me taua mea.