Ruānuku Uiui Microsoft i Excel

Ma tenei tauira koe e ako me pehea te kawemai i nga raraunga mai i te patengi raraunga Microsoft Access ma te whakamahi i te Ruānuku Uiui Microsoft. Ma te whakamahi i a Microsoft Query, ka taea e koe te kowhiri i nga pou e hiahiatia ana ka kawemai ki Excel anake.

1. I te ripa Arā Atu Anō Raraunga (raraunga) pawhiria Mai i etahi atu Rauemi (Mai i etahi atu puna) ka kowhiri Mai i te Uiui a Microsoft (Na Microsoft Query). Ka puta he pouaka korero Kōwhiria te Puna Raraunga (Tīpakohia te puna raraunga).
2. Tīpakohia MS Access Database* ka tirohia te pouaka i te taha o te whiringa Whakamahia te Ruānuku Uiui ki te waihanga/whakatika uiui (Whakamahia te Ruānuku Uiui).
3. press OK.
4. Tīpakohia he pātengi raraunga ka pāwhiri OK.He maha nga ripanga kei roto i tenei pātengi raraunga. Ka taea e koe te kowhiri i te ripanga me nga pou hei whakauru ki te patai.
5. Miramirahia he ripanga kiritaki ka paato i te paatene me te tohu ">".
6. press Panuku (Aro atu).
7. Hei kawemai i te huingararaunga kua tohua anake, tātarihia. Ki te mahi i tenei, tohua Te tāone I roto i te rarangi Tīwae hei tātari (Ngā tīwae hei kōwhiri). I te taha matau, i te rarangi taka-iho tuatahi, tohua rite tonu (he rite), a i te tuarua ko te ingoa o te pa – New York.
8. press Panuku (Aro atu).

Ka taea e koe te whakariterite i nga raraunga ki te hiahia koe, engari kaore matou e mahi.

9. press Panuku (Aro atu).
10. press Mutu (Kua oti) ki te tuku raraunga ki a Microsoft Excel.
11. Tīpakohia te momo whakaaturanga korero e hiahia ana koe ki te whakatakoto i nga raraunga ka paato OK.

Hua:

Tuhipoka: Ina huri te patengi raraunga Access, ka taea e koe te paato tāmata (Whakahou) ki te tango i nga huringa ki Excel.