Yadda ake yin binciken SQL a Excel

SQL sanannen harshe ne wanda ake amfani dashi lokacin aiki tare da bayanai (Database). Kodayake don aiki tare da bayanan bayanai a cikin Microsoft Office Kunshin Aikace-aikacen akwai wani aikace-aikacen kwamfuta daban, amma shirin Excel Shafu zai iya aiki tare da bayanan, yin buƙatun SQL. Bari mu gano yadda ta hanyoyi da yawa zaka iya samar da irin wannan bukatar.

Darasi: "Smart 'Tables a Fim

Hanyar 2: Amfani da ƙarin kayan aikin fice

Akwai kuma hanyar don ƙirƙirar tambarin SQL zuwa asalin bayanan da aka zaɓa ta amfani da kayan aikin da aka gina.

1. Gudanar da kyakkyawan shirin. Bayan haka, mun ƙaura zuwa shafin "data" shafin.



2. A cikin "Samun bayanai na waje" Toolbar, wanda yake a kan kintinkiri, danna kan "daga sauran hanyoyin" gumaka "gumaka" gumaka "gumaka" icon. Jerin ƙarin zaɓuɓɓukan aiki suna buɗe. Zaɓi abu "daga Manya Data ta Data".



3. Ana ƙaddamar da maye rikodin bayanai. A cikin jerin hanyoyin hanyoyin bayanai, zaɓi "ODBC DSN". Bayan haka, danna maɓallin "na gaba".



4. Window taga taga yana buɗewa wanda kake son zabar nau'in tushe. Zaɓi sunan "Active Cibiyar Data". Sannan danna maballin "Gaba".



5. Smallaramar taga ta buɗe, wanda ya kamata ku canza zuwa ga directory din bayanai a cikin MDB ko ACDB kuma zaɓi fayil ɗin bayanan da ake so. Ana yin kewayawa tsakanin logic disks a cikin "diski". Akwai canji zuwa yankin tsakiyar taga suna da kira "Catalogs". A cikin ɓangaren hagu na taga yana nuna fayiloli da ke cikin directory na yanzu idan suna da mdb ko na Acdb. A wannan fannin da kuke buƙatar zaɓar sunan fayil ɗin, sannan danna maɓallin "Ok".



6. Wadannan, an ƙaddamar da taga zaɓar teburin tebur a cikin bayanan da aka kayyade. A cikin yankin tsakiyar, zaɓi sunan tebur da ake so (idan akwai da yawa daga cikinsu), sannan danna maɓallin "na gaba".



7. Bayan haka, taga haɗin bayanan bayanai yana buɗewa. Wannan ya ƙunshi ainihin bayani game da haɗin da muka kafa. A wannan taga, ya isa danna maɓallin "gama".



8. An yi hoton Freel Fiel ya ƙaddamar da taga. Ana iya kayyade shi a cikin abin da kuke son gabatar da bayanai:
   • Tebur;
   • Bayar da rahoton tebur mai cinyewa;
   • Zane mai taƙaituwa.

   Zaɓi zaɓin da ake so. Lower a ƙasa, kuna buƙatar ayyana inda yakamata a sanya bayanan: a kan sabon takarda ko akan takardar na yanzu. A cikin yanayin na karshen, da yiwuwar zabar masu daidaitawa kuma ana bayar da su. Ta hanyar tsoho, ana sanya bayanan a kan takardar na yanzu. An sanya kusurwar hagu na wanda aka shigo da abin da aka shigo dashi a cikin tantanin A1.

   Bayan duk shigo da shigo da shigo da shi, danna maɓallin "Ok".



9. Kamar yadda muke gani, teburin daga cikin bayanan an motsa zuwa takardar. Sannan muna matsawa zuwa shafin "bayanai" kuma danna maɓallin "Haɗin", wanda aka sanya a kan tef a toshe kayan aiki tare da sunan.



10. Bayan haka, an fara wannan taga. A ciki muke ganin sunan bayanan da aka saba danganta da mu. Idan bayanan da aka haɗa yana ɗan ɗan lokaci, to zaɓi zaɓi da ake so da kuma haskaka shi. Bayan haka, danna maɓallin "kaddarorin ..." maɓallin a gefen dama na taga.



11. Tagoran hanyoyin haɗin yanar gizon. Mun shiga ciki cikin shafin "Ma'anar" shafin. A cikin "rubutun rubutu", wanda yake a kasan taga na yanzu, wanda ya rubuta sql bisa ga tsarin wannan harshe, wanda muka yi magana lokacin da muke la'akari da maɓallin "Ok".



12. Bayan haka, komawa zuwa ga haɗin kai tsaye zuwa ga littafin. Ya rage kawai don danna maɓallin "sabuntawa" a ciki. Kira ga bayanan da ke cikin tambaya na faruwa, bayan abin da cibiyar bayanai ta dawo sakamakon aiki na farko, a cikin tebur a baya ya canja wurin da mu.

Hanyar 3: Haɗa zuwa SQL Server SQL Server

Bugu da kari, ta hanyar kayan aiki na Grema, akwai haɗi tare da SQL Server kuma aika buƙatun a gare shi. Gina tambayar baya banbanta da sigar da ta gabata, amma da farko, kuna buƙatar shigar da haɗin kanta. Bari mu ga yadda ake yin shi.

1. Gudun shirin Excel kuma je zuwa shafin data. Bayan haka, danna maɓallin "daga sauran maɓallin" daga wasu hanyoyin ", wanda aka sanya a kan tef a cikin" Samun bayanan waje "kayan aiki na waje" kayan aiki ". A wannan karon, daga jerin jerin, zaɓi zaɓi "Daga uwar garken SQL Server".



2. Yana buɗe taga haɗin zuwa uwar garken bayanai. A cikin Server sunan filin, saka sunan windows wanda kuke aiwatar da haɗi. A cikin rukunin "Account", kuna buƙatar yanke hukunci daidai yadda ake haɗa: ta amfani da Tabbatar da Windows ko kuma shigar da sunan mai amfani da kalmar wucewa. Na nuna canzawa bisa ga shawarar da aka yanke. Idan ka zaɓi zaɓi na biyu, to, ƙari, filayen da suka dace dole ne su shiga sunan mai amfani da kalmar wucewa. Bayan duk saitunan ana ɗaukar, danna maɓallin "Gaba". Bayan aiwatar da wannan aikin, yana haɗi zuwa uwar garken da aka ƙayyade. An ci gaba da ayyuka kan Kungiyar HUKUNCIN HUKUNCIN HUKUNCIN SAUKI YANZU YANZU DAGA CIKIN SAUKI.

Kamar yadda kake gani, a cikin Eccele Sql, ana iya shirya bukatar azaman kayan aikin ginannun gine-gine kuma tare da ƙara na ɓangare na uku. Kowane mai amfani zai iya zaɓar zaɓi wanda ya fi dacewa a gare shi kuma ya fi dacewa don magance aikin saiti na musamman. Kodayake, yuwuwar ƙara-kan, gabaɗaya, har yanzu suna da ɗan ci gaba fiye da kayan aikin Expeded. Babban rashi na xtlols shi ne cewa lokacin amfani da ƙara-in da aka iyakance zuwa makonni biyu kawai.