He aratohu Tere mo te kaweake i nga Ripanga Tau 2003 ki Excel

He Tutorial Taahiranga-ma-Tae mo te Uru 2003

He mea tika tonu te huri i nga raraunga i roto i te kounga Raraunga Access 2003 ki tetahi atu momo, penei he pukamahi Excel. Ka hiahia pea koe ki te whakamahi i etahi o nga mahinga tuuturu ahurei a Excel ranei, ki te tuwha i nga raraunga ki tetahi kaore e mohiotia ana ki te Uru. Ahakoa te take, he tino tika te tukanga whakawhiti.

Tutorial ki te kaweake Uru 2003 Ripanga ki Excel

Whakamahia ai e tënei akoranga te papaunga pätengi raraunga o Northwind , na me tino hiahia koe ki te whakarite. I muri i to tautuhi pai koe, whai i enei taahiraa ki te kaweake i te ripanga Kaihoko ki te pukamahi Excel .

  1. Whakatūwherahia te pātengi raraunga o Northwind .
  2. Ina puta mai te Northwind Switchboard, pāwhiritia te pātene Matapihi Raraunga Whakaaturanga kia uru ki te matapihi pātengi raraunga matua.
  3. Mena kaore koe i te tirohanga Ripanga, kati i nga waahanga Ripanga i raro i te Mahinga Ahanoa i te taha maui o te matapihi Raraunga.
  4. Pāwhiri-rua i te ripanga Kaihoko i te matapihi Raraunga hei whakatuwhera i te ripanga.
  5. Mai i te tahua Kōnae , kōwhiria te kōwhiringa Whakaputa .
  6. Me kite koe i tetahi pouaka korero e huaina ana ko te "Kaweake Ripanga" Kaihokohoko Ki te ... "Tautuhia te whakatakotoranga kaweake ma te whiriwhiri i te Microsoft Excel 97-2002 mai i te tahua" Tiaki hei momo ".
    1. Ina tirotiro koe i tenei tahua, tirohia nga momo waahanga i roto i te tahua "Whakaorangia hei momo". Ka taea e koe te whakamahi i tenei tukanga ano hei kaweake i nga ripanga Uru ki te tini o nga momo, tae atu ki etahi atu paparanga raraunga rite Paradox me dBASE. Ka taea e te Access te whakarato i te kaha nui ma te tuku ki a koe ki te kaweake i nga raraunga ki tetahi punaha raraunga ODBC-whaimana ranei he kōnae kuputuhi marama.
  7. Tautuhia he ingoa ingoa tika i roto i te pouaka "Ingoa Kōnae".
  8. Patohia te Paerewa Whakakorea katoa hei whakaoti i te tukanga kaweake.

Kia oti te whakaoti i tenei tukanga, whakatuwheratia te ripanga ripanga a Excel hei waitohu he pai te kaweake o te raraunga. Ko te mea katoa kei reira!

Tuhipoka : Ko enei tohutohu e whai ana ki te Access 2003 me nga putanga o mua.