
ä»ç®ã§å§ããããã°ã©ãã³ã°è¬åº§ãè¶ åå¿è åãã#01 倿°
ã倿°ãã£ãŠäœïŒååãä»ããŠå
¥ããã ãïŒ
æ©éãããã°ã©ãã³ã°ã®å匷ãå§ããŠè¡ããŸãããïŒ
é£ããçšèªããç¹å¥ãªãœãããèŠããŸããã
å¿ èŠãªã®ã¯ä»ç®ãšãã³ã®ã€ã¡ãŒãžã ãã§ãã
ã³ã³ãã¥ãŒã¿ãŒã¯ãšã£ãŠãã·ã³ãã«
ãããã°ã©ãã³ã°ã£ãŠé£ããã...ããšæããŸãããããã®é£ããããã°ã©ãã³ã°ã£ãŠäœãªãã§ãããïŒ
ã³ã³ãã¥ãŒã¿ãŒã«ããããã£ãŠãã£ãŠæç€ºãåºãããšã§ãã
ãããŠãã³ã³ãã¥ãŒã¿ãŒã£ãŠçµæ§åçŽã§ããã£ãŠããããšã¯å®ã¯3ã€ãããªããã§ãã
ããŒã¿ãèŠããã(ã€ã³ãããïŒ
倿ãããç¹°ãè¿ããèšç®ãããªã©ãïŒå å·¥ïŒ
人éãåããããã«ãããïŒåºåã»ã¢ãŠããããïŒ

ä»ååŠã¶ã倿°ãã¯ãæåã®ãããŒã¿ãèŠãããã§ãã
ã³ã³ãã¥ãŒã¿ã«ããã®ããŒã¿ãèŠããŠããŠããšæç€ºããæ¹æ³ã¯ãä»ã«ã宿°ãšã颿°ãšãè²ã
ãããã©ãäžçªåºæ¬ãšãªãã®ã倿°ã§ãã
ã€ãŸãã倿°ãããããã°ãããã°ã©ãã³ã°ã®åºæ¬æŠå¿µã®çŽ3åã®1ãçè§£ããããšã«ãªããã§ãããäœæ ãé£ãããšæãã人ãå€ããã§ãããã
å®ã¯ç°¡åãªé£é¢ãã€ã³ãã倿°ãïŒ
ç§ã®ç ä¿®ã§ãåããŠããã°ã©ãã³ã°ãçµéšããäºåè·ããã¹ã¯ã¯ãŒã«ãŒã®æ¹ãã¡ãããããªãã€ãŸããããšïŒããã
倿°ïŒ
å®ã¯ç§ãæ
å ±ç³»ã®å°éåŠæ ¡ã§RPAãHTML/CSS/JavaScriptãExcel Power QueryãæããŠãŸãããã€ãŸããããã°ã©ãã³ã°ã®ãããç®æãçåŸãã¡ã«ãæããŠãããã§ããã
ãã®äººãã¡ã§ã
ãäžå¿äœ¿ããŠããã©ãçè§£åºæ¥ãŠããŸããðŠã
ãšããçåŸãå€ãã£ãã§ãã
倿°ã¯ãããžã¿ã«åãé²ãããªãã
Microsoft ExcelãGoogle ã¹ãã¬ããã·ãŒãã§ããããã
ããŒã³ãŒãã»ããŒã³ãŒãã®ããŒã¿ããŒã¹ã ãããã
RPAã ãããã
å¿
ãéããªããã°ãªããªãé¢éãªãã§ãã
ããã§åŒã£ããããš
ãéäžãŸã§å匷é 匵ã£ããã©ãæ«æããŸããðã
ãšããäºã«ãªã£ãŠããŸããã§ããã
ã§ãã§ããïŒ
倿°ã£ãŠããããªã«é£ããç©ã§ã¯ç¡ããã§ãã
倿°ãé£ããçç±ãåããã°çè§£åºæ¥ãïŒ
ããã§ãç§ã¯èããŸããïŒ
äœã§çããããªã«é£ããã£ãŠèšããã ããã£ãŠïŒ
äºã€æãåœãããŸããã
ãŸããã倿°ããšããèšèã
ãæ°ããšããæŒ¢åãå
¥ã£ãŠããããã§ããªããšãªãæ°åŠã£ãœãð°ãé£ãããã®ð±ããšããå°è±¡ããããŸãããïŒ
ãªãããç§ã®çåŸããã¯ã»ãŒæç³»ã®æ¹ããããŠç§ãæ°åŠãèŠæãªæç³»åºèº«ïŒ
ãæ°ãã«ãå€ããä»ããŠãããªããŠãæãèŠåŽãã代æ°ã ã®ãçŽ æ°ã ã®ãšåãã絶察é£ããã€ãïŒïŒãšããæã蟌ã¿ããç°¡åãªç©ãé£ããæãããŠããæ°ãããŸãã
ããã°ã©ãã³ã°çšèªã«ã¯ã倿°ã®ä»ã«ã
宿°ã颿°ãåŒæ°âŠãæ°ãä»ãèšèãå€ããŠâŠã
ãªãããããããé£ããæ°ãããŠããŸããããã
å®éãå
ã
ã¯é£ããã£ãã®ã ãšæããŸãã
æãã³ã³ãã¥ãŒã¿ãŒã¯é£ããèšç®ãããããã«äœãããŸããããã®é ã®ããã°ã©ãã³ã°ã¯0ãš1ã®çµã¿åããããããããšããšãããã¯ãæ°ãæ±ãæŠå¿µã ã£ããã§ãã
ãšãããä»ïŒããã°ã©ãã³ã°ã¯ã ãã ãç°¡åã«ãªã£ãŠããŸãð
æ°ã ãã§ã¯ç¡ãããæåãããŒã¿å
šè¬ãæ±ããããã«ãªã£ãããã§ãã
ãšããããšã¯ã
倿°ãšããååã¯ãä»ã¯ãå€ããæ°ã§ã¯ãªãããå€ããæ°ãæåãã«ãªã£ããã§ãïŒ
ããããå®éã«å€æ°ãšã¯ã©ãããç©ãã説æããŸãã
ãã®ãšããç®ã§ã¯ã倿°ããšèŠããŠããŠãã
é ã®äžã§ã¯ãå€ããæ°ãæåãããŒã¿ã > ãå€-æ°æåããŒã¿ããã€ã¡ãŒãžããŠãã ãããã°ããšé£æåºŠäžãããŸãïŒ
ãããŠãããäžã€é£ãããšæããçç±ãã
ã³ãŒããšå€æ°ãäžç·ã«å匷ããããïŒïŒ
ã³ãŒããšã¯ãã³ã³ãã¥ãŒã¿ã«ãäœãããŠã»ãããããé çªã«äŒããããã®æç« ïŒæç€ºæžïŒã§ãããã®ãã¢ã«ãã¡ããããèšå·ã®ããåãããªãçŸ åã§ããpythonãšãVBAãšãè²ã ãªããã°ã©ãã³ã°èšèªã§æç« ã®æžãæ¹ãéããŸããããã§ãŸãè¿·ããã§ãããã
å®ã¯ãç§ãæåã«èŠããã®ã¯ãããã°ã©ãã³ã°èšèªã§ã¯ç¡ããã§ãã
FileMakerãšãããããŒã³ãŒãã®ããŒã¿ããŒã¹ïŒMicrosoft Accessããã³ããŒã³ã¿ãããªã€ã¡ãŒãžïŒã§ãã³ãŒããšå€æ°ãªã©ããã°ã©ãã³ã°ã®ä»çµã¿ãåããŠåŠç¿ãããã§ãã
ã ãããæç³»å®¶æ¿ç§åºèº«ã®ç§ã§ããããã°ã©ãã³ã°ãæããã»ã©çè§£ããããšãåºæ¥ãããã«ãªã£ãã®ã§ã¯ãªãããšæã£ãŠããŸãã
ãªã®ã§ããã®åŠç¿ã§ã¯ãäžå¿åèãŸã§ã«ã³ãŒããèŒããŠã¯ããããã©ã
ä»ç®ã§åŠç¿ããŠãã ããïŒïŒ
ãããå眮ããé·ããªã£ããã©ã倿°ïŒè¡ããŸããïŒïŒ
ã倿°ããšæžãããŠãããããå€ããæ°ãæåãããŒã¿ã > ãå€-æ°æåããŒã¿ããã€ã¡ãŒãžããããšãå¿ããªãã§ãã ãããïŒïŒ
倿°ã£ãŠäœç©ïŒ
å ¥ãç©ã«ååãä»ããç©ã§ãã
ãïŒããã ãïŒïŒ
ãããããã ãã§ãã
ç°¡åãããŠã³ã£ããããŸãããïŒïŒ
ãããããã§ã¯ãä»ç®ã§ã€ã¡ãŒãžããŠã¿ãŸãããã
å¶æ¥äºåã®è±åããã¯ãããé»è©±ãããã£ãŠããã客æ§ãšãã®ã客æ§ã®æ
åœè
ã®ååãä»ç®ã§ããœã³ã³ã«è²Œã£ãŠããŸãã
æ¥ã®ç°åã®ææã«ãã客æ§ãæ
åœè
ãå€ãã£ãã®ã§ãä»ç®ã®ååãæžãæããŸããã
ãã®ä»ç®ã¯ãæ åœè ã®ååãå€ãã > æåãå€ãã > å€ããæåãããªãã¡ã倿°ïŒå€-æ°æåããŒã¿ïŒã§ãã
ãšãããè±åãããã¡ãã£ãšå°ã£ãããšã«ãªããŸããã
ä»ç®ã«äœãæžããŠããããåããããã«ããŠããªãã£ããã§ãïŒ

ããã¯ãæ
åœè
åããæžããŠããä»ç®ã
ããã¯ãã客æ§ã®ååããæžããŠããä»ç®ã
ãããªé¢šã«ãä»ç®ã«äœãæžããŠãããã¡ãããšåãããååãä»ããŠãããªããã°ãªããªãã§ããã
è±åããã®ããœã³ã³ã®ä»ç®ã¯ãããªé¢šã«ãªããŸããã
ååã©ãã«ããïŒããæžããŠããå 容
------------------------------------------------
æ åœè åãããïŒããäœè€
ã客æ§ã®ååãïŒããç°äžæ§
ååã©ãã«ïŒå€æ°åïŒïŒäžã«äœãå ¥ã£ãŠãããã瀺ãåå
æžããŠããå 容ïŒå€ïŒïŒå®éã®ããŒã¿
ããã°ã©ãã³ã°çã«èšããšã倿°ïŒä»ç®ïŒãã«ãååããä»ããã
ãååããä»ããã倿°ãã«ãããŒã¿ïŒç°äžããïŒããå ¥ããã
ããŒã¿ã¯æžãæãOK!
ã§ãã
ããå°ãå°éçã«èšããšãååãã€ããäºããåœåïŒããããïŒããšãããŸããã倿°ã®åœåã«ãŒã«ãå®ããŸãããããªããŠèšãæ¹ãããŸãããã®å ¥éç·šã§ããªãããç§ã«ãåºæ¥ããïŒãšæã£ãããäžçŽç·šã§ãã£ããåŠç¿ããŠãã ããããïŒäžçŽç·šå·çäžïŒ
ãã®å ¥ãç©ã«ååãä»ãããããå°ãåºããŠã€ã¡ãŒãžããŠã¿ãŸãããã
äŸãã°ã売äžãããŒã¿ããŸãšãããšã¯ã»ã«ãã¡ã€ã«ãäœã£ããšãããã®ãšã¯ã»ã«ãã¡ã€ã«ã«ã©ãããããŒã¿ãå
¥ã£ãŠããããåããããã«ååãä»ããŠä¿åããŸããã
ãããä¿åãããã©ã«ãã«ããäœãå
¥ã£ãŠãããåãããã©ã«ãåãä»ããŠããŸãããã
ãã®ãããŒã¿ããã¡ã€ã«ãä¿åãããšããããšãã
ã³ã³ãã¥ãŒã¿ãŒãããŒã¿ãèŠãããšããäºã§ãã
ãã®ãšãã«å¿
ãäžèº«ãåãããããªååãä»ããŸãããã
ã³ã³ãã¥ãŒã¿ãŒãããŒã¿ãèŠãããã€ãŸãããªããããŒã¿ãä¿åããã
ãã®æã«äžèº«ãåããããã«ååãä»ããã
ãã®åºæ¬ãèŠããŠãããšã倿°ãããã®åŸåŠç¿ãã颿°ãé åãšããç©ããçè§£ãããããªããšæããŸãã
ãŸãã¯ã倿°ãšããå ¥ãç©ã«ãäžã«äœãå ¥ãããåããååãä»ããïŒãšããããšãæèããŠãã ããã
å ¥ãç©ã«ååãä»ããŠãäžèº«ãå ¥ãæ¿ããããšã¯åãã£ããã©ããã£ãšè©³ããïŒã£ãŠæããŸãããã
ãã®å ¥éç·šã¯webããŒãžãšé£åããŠäœã£ãŠããŸãã
ð ã倿°ãã£ãŠäœïŒä»ç®ã§å§ããããã°ã©ãã³ã° #01
ãã¡ãã«ãå
¥éã¬ãã«ã®å€æ°ã®è§£èª¬ãšãåèãŸã§ã«ãã³ãŒãã ãšã©ã衚çŸãããããããŠãã¡ãã£ãšè§Šã£ãŠã€ã¡ãŒãžãåºæ¥ãç©ãèŒããŠããŸãã
æ¯éã芧ã«ãªã£ãŠãã ãããã
仿¥ã®ãŸãšã
倿°ãšã¯ãååã©ãã«ä»ãã®ä»ç®ãã®ã€ã¡ãŒãžãããŒã¿ãäžæçã«èŠããŠããå Žæ
倿°ã®å 容ã¯ãã€ã§ãæžãæããããïŒå€ã倿Žã§ããïŒ
倿°åã«ã¯ãäœãå ¥ã£ãŠããããããååããã€ããããšã倧äº
次åã¯ã倿ãããããåãããã«æ¥åžžã®å Žé¢ãã解説ããŸããã
ãã®èšäºã¯ãä»ç®ã§å§ããããã°ã©ãã³ã°ãã·ãªãŒãºã®ç¬¬1åã§ããITæªçµéšã®æ¹ãããã°ã©ãã³ã°ã«æ«æããçµéšã®ããæ¹ã«åããŠãåºæ¬æŠå¿µãæ¥åžžã®ã€ã¡ãŒãžã§äžå¯§ã«è§£èª¬ããŠãããŸããããã°ã©ãã³ã°ãèŠããå座æèŠã§æŽ»çšããŠããã ãããšå¬ããã§ãã
Last Updated: 2026/04/20