Accessã§å·¥æ°ç®¡çãäœã£ãŠã¿ãææ
ãŠã§ãå šçæä»£ã«ãªãããŸãã¹ããŒãããã€ã¹å šçã«ãªããPCã®åºçªã¯å°ãªããªãã€ã€ããäžã§ããæªã çãæ®ã£ãŠãMicrosoft Accessãæ¥åçšã¢ããªãããŒã³ãŒãã§äœæããææ®µãšããŠããã ããŸã ãŸã éèŠããããšããäºã®è£è¿ããããããŸããã
ããŠããããªAccessã§1ã10ãŸã§ãåŠã¶ãããªææããšããäºã§ãäžéãã¢ããªãäœãäžã§ã®ã€ãããå ãããã®ããªãªãŒã¹ããããšã«ããŸãããã«ã¹ã¿ãã€ãºããŠäœ¿ããããã«ãªã£ãŠããŸãã
ç®æ¬¡
ä»å䜿çšãããã¡ã€ã«ç
- å·¥æ°ç®¡ç - 管çè åŽããã°ã©ã
- å·¥æ°ç®¡ç - ãŠãŒã¶åŽããã°ã©ã
- ãããžã§ã¯ãã³ãŒãäžèЧ - Excelãã¡ã€ã«
- 倿 管çããŒã¿çªåçšãã¡ã€ã« - Excelãã¡ã€ã«
ããŒã¿ã¯ç©ºã®ç¶æ ã§ãããããããŒã¿ã®æŽåãå¿ èŠã§ãããŸããæ¬ããã°ã©ã ã¯Microsoft Access 2016 (64bit)ã§äœãããŠããŸãããåç §èšå®ãšããŠMicrosoft Outlook 2016 Object Libraryãå ¥ã£ãŠãçºãå¥éOutlookãã€ã³ã¹ããŒã«ãããŠããå¿ èŠããããŸãã
ã»ããã¢ãã
ããŒã¿ã®æºå
ãããžã§ã¯ãã³ãŒãäžèЧ
ãŠãŒã¶ãå·¥æ°ç»é²ãããéã«å©çšãããããžã§ã¯ãã®ã³ãŒãã®äžèЧãšãªããŸããèµ·åæã«èªåçã«ãªã³ã¯ããŒãã«ãšããŠæ¥ç¶ãããããã«ãªã£ãŠããããããã¡ã€ã«ãµãŒããªã©ã«ãã®ãã¡ã€ã«ãé 眮ãã远å ãªã©ãããå Žåã«ã¯çŽæ¥ãã®ãã¡ã€ã«ã«èšè¿°ã远å ããã°ããŠãŒã¶åŽã§ã®éžæè¢ã«åºãŠããããã«ãªããŸãã
èšè¿°ããå 容ã¯ä»¥äžã®éãã§ã
- IDã¯é£çªã§ã1ãã¯ãããŠéè€ããªãæ°å€ãèšè¿°ããŸã
- pjcodeã¯æååã§ãããã¡ããéè€ããªãæååïŒæåãšæ°å€ïŒã§ã³ãŒãçªå·ãèšè¿°ããŸãã
- pjtitleã¯ãããžã§ã¯ãåãå ¥ããŸãã
- busyoã¯çŸåšå©çšããŠããªãé ç®ã§ãããéšçœ²ã³ãŒãïŒæ°å€ïŒãå ¥ããããã«å©çšããŸãïŒéšçœ²ããšã«ã³ãŒããåããããã«å©çšïŒ
- bunruiã¯çŸåšå©çšããŠããªãé ç®ã§ãããçŽæ¥ã»éæ¥ã®ã©ã¡ãããå ¥ããŠãå·¥æ°ç®¡çã®è£å©ã«å©çšããŸãã
å³ïŒãŠãŒã¶åŽã§ã³ãŒãéžæçšã®ãªã¹ãã«ãªããŸã
倿 管çããŒã¿çªåçš
ãã®ãã¡ã€ã«ã¯ãæåºãããå·¥æ°ããŒã¿ãšå€æ ã·ã¹ãã åŽããåãåºããããŒã¿ãšãçªåïŒå·¥æ°æéã«å·®ç°ãç¡ããïŒæªç»é²ã®ããŒã¿ã¯ãªããïŒïŒããçºã®ãã³ãã¬ãŒãã§ãã
瀟å¡çªå·ããã³æ¥ä»ã«ãŠç¹å®ããäž¡è ã®å·¥æ°æéãšåŽåæéãšã®å·®ããã§ãã¯ããŸãããã³ãã¬ãŒãåŽã«èšèŒããå 容ã¯ä»¥äžã®éãã§ãã
- 瀟å¡ã³ãŒã - æ°å€åã瀟å¡çªå·ãèšå ¥ããŸãã
- 瀟å¡å - æåååã瀟å¡ã®åç§°ãèšèŒããŸãã
- éšçœ² - éšçœ²åãèšèŒããŸãã
- åœ¹è· - 圹è·åãèšèŒããŸãã
- æ¥ä» - 西æŠã§ã®åŽåæ¥ãåºæ¬çã«ã¯30,31æ¥ãŸã§ã®ãã¹ãŠã®æ¥ä»ãèšèŒããŸããïŒäŒæ¥ã§ãã£ãŠãå¿ èŠã§ãïŒ
- æ¥ã¿ã€ã - 0=å¹³æ¥ã1=æå®äŒæ¥ïŒåææ¥ïŒã2=æ³å®äŒæ¥ïŒæ¥ææ¥ãç¥æ¥ïŒãäŒæ¥ã®å€å®ã«å©çšããŠããŸãã
- ã€ãã³ã - äž»ã«ç¥æ¥åãäŒæ¥å€å®ã«å©çšããŠããŸãã
- å®åŽåæé - å®éã«åŽåã«è²»ãããæéïŒåäœã¯åïŒã0ã®å Žåã¯äŒæ¥ã
- æå®åŽåæé - ãã®äŒæ¥ã«æŒãã1æ¥ã®å¿ èŠãªåŽåæéïŒåäœã¯åïŒ
- äŒæ1:äŒæå - å¹³æ¥ã«æŒããŠäŒæãåã£ãŠããå Žåã®å€å®ïŒrestliståç §ïŒ
ç·è²ã§ããŒã¯ããé ç®ã¯å¿ é å ¥åé ç®ã«ãªããŸãã
å³ïŒçªåã®çºã®ãã³ãã¬ãŒãã§ã
ãã¹ã¿ããŒã¿ã®æŽå
ãã®é ç®ã¯äž»ã«ç®¡çè åŽã§æåºãããå·¥æ°ãå ã«åæãçªåã®ããã«çšãããããã¹ã¿ãŒããŒã¿ã§ããadmin.accdbå ã«ããããŒãã«ã«æ ŒçŽããŸããããªãã³ããããã¹ã¿ããŒã¿ç·šéãããUIäžã§ç®¡çããäºãå¯èœã§ãã
å³ïŒUIäžããç»é²ã»ç·šéã»åé€ãå¯èœã§ãã
useridããŒãã«
å·¥æ°ç®¡ç察象ã®ç€Ÿå¡ã«é¢ããæ å ±ãæ ŒçŽããããŒãã«ã§ãã瀟å¡çªå·ãå ã«ä»ã®ããŒãã«ã§éæ¥çã«å©çšããŸããäž»ã«
- 瀟å¡çªå·
- 瀟å¡å
- ã¡ã¢ã
- éçŽ - æ°å€åã§rankããŒãã«ã«ããæ°å€ãæå®ããïŒããããããŠã³ã§éžæå¯èœïŒ
- 瀟å¡åºå - æ°å€åã§emptypeããŒãã«ã«ããæ°å€ãæå®ããïŒããããããŠã³ã§éžæå¯èœïŒ
ãç»é²ããŸãããŠãŒã¶äžèЧã¿ãããç»é²ããŸãã
rankããŒãã«
瀟å¡ã®éçŽã«é¢ããæ å ±ãæ ŒçŽããããŒãã«ã§ããéçŽã«å¿ããŠ1æéåœããã®å·¥æ°å䟡ãç»é²ããŸããäž»ã«å·¥è³ã®è§£æã«å©çšããŸãã
- éçŽ - æ°å€åãéè€ç»é²ã¯åºæ¥ãŸãã
- éçŽå - ãã®éçŽã®è·å¶åç§°ã
- å䟡 - æ°å€åã1æé(60åïŒåœããã®åŽåå䟡ãå ¥åããŸãã
è·å¶éçŽã¿ãããç»é²ããŸãã
restlistããŒãã«
äŒæ¥å€å®ã®çºã®ããŒãã«ã§ãã
äž»ã«å€æ ããŒã¿ãšã®çªåã®çºã«å©çšããŸããå¹³æ¥ã«æŒããŠåŽåæéã0äžã€ãrestlistããŒãã«ã«ããäŒæåãåã£ãå ŽåãäŒæ¥ãã©ã°ãå²ãåœãŠãå€å®ã«å©çšããäŒæ¥ãã©ã°ãTrueã®å Žåã¯æéã®çªåãããŸãããæçµŠäŒæïŒååã»ååŸïŒã®ãããªåäŒå¶åºŠé©çšã®å Žåã¯ãäŒæ¥ãã©ã°ã¯ãªãã«ãªãããã«äºãããŒã¿ã»ãããå ¥ããŠãããŸãã
- ID - ãªãŒããã³ããŒåãé£çªã§å©çšããããã®ãã®ã§ãã
- äŒæå - 倿 ããŒã¿åŽã®äŒæ1:äŒæåãšã®å€å®ã«å©çšããŸãã
- äŒæ¥ãã©ã° - Trueã®å Žåããã®æ¥ã¯äŒæãšã¿ãªããå·¥æ°æéãšã®çªåäœæ¥å¯Ÿè±¡å€ã«ãªããŸãã
emptypeããŒãã«
ãã¹ã¿ãŒããŒã¿ç·šéäžã§ã®ç€Ÿå¡åºåã®çºã®ããŒãã«ã§ããäºãããã€ãã®ããŒã¿ã»ãããå ¥ã£ãŠããŸãã
ãã®ããŒãã«ã ãã¯ãã¹ã¿ãŒããŒã¿ç·šéã®UIã«ã¯ç·šéé ç®ãçšæããŠããŸãããçŽæ¥ããŒãã«ããç»é²ãç·šéãå¿ èŠã§ãïŒé »ç¹ã«ç»é²ã倿Žãããé ç®ã§ã¯ãªãçºïŒã
äž»ã«ã倿 ããŒã¿ãšã®çªåã§å©çšãããæ¬ããã°ã©ã ã§ã¯ãID:2ã®æŽŸé£ç€Ÿå¡ã«ã€ããŠã ãã¯çªå察象ããå€ãçºã«å©çšããŠããŸãã
- ID - 瀟å¡åºåã®åºç€ãšãªãæ°å€åã®IDã§ãã
- emptype_name - 瀟å¡åºåã®åç§°ãå ¥åããŸãã
å©çšæé
ãã®é ç®ã§ã¯ãŠãŒã¶åŽã§ã®å·¥æ°ç»é²ã»æåºã管çè åŽã§ã®åã蟌ã¿ã»çªåäœæ¥ã»åæãŸã§ã®äžé£ã®äœæ¥ã®æµããšåæ©èœã«ã€ããŠã®èª¬æã«ãªããŸããããã§ã¯ãclient.accdbã¢ããªã«ã€ããŠã®èª¬æã«ãªããŸãã
ãŠãŒã¶åŽããã°ã©ã
ã»ããã£ã³ã°
ååèµ·åæã«ç»é²ãå¿ èŠã§ããVBAã³ãŒããå ¥ã£ãŠãçºãã³ãŒãã®æå¹åãæ±ããããå ŽåããããŸãïŒãããã¯ãã¯ãã®èšå®ãã倿Žå¯èœããŸããä¿¡é Œã§ããå ŽæãšããŠè¿œå ããäºã§åºãŠããªããªããŸãïŒã
- PJã³ãŒããªã¹ã - åé ã§æºåããŠãããPJã³ãŒããªã¹ãã®Excelãã¡ã€ã«ãžã®ãã¹ãæå®ããŸãã
- ä¿åå - å·¥æ°ããŒã¿ãä¿åããå ã®ãã©ã«ããžã®ãã¹ãæå®ããŸãã
- 瀟å¡çªå· - èªèº«ã®ç€Ÿå¡çªå·ãå ¥åããŸãã
- 瀟å¡å - èªèº«ã®ç€Ÿå¡åãå ¥åããŸãã
PJã³ãŒããªã¹ããä¿åå ã¯ãå šå¡å ±éã®å Žæãäºã管çè åŽã§æ±ºããŠããããã¡ããæå®ããããã«éç¥ããŸããããä¿åãã¯ãªãã¯ãããšãèªåçã«PJã³ãŒããªã¹ããšãªã³ã¯ããŒãã«ïŒxlsxtableïŒã貌ãããæ¬¡å以éã¯èµ·åæã«è²ŒãããŸãã
å³ïŒãã®äœæ¥ã¯å¿ é é ç®ã§ã
å·¥æ°ç»é²
ãŠãŒã¶ãæ¥ã å·¥æ°ãç»é²ããç»é¢ã§ããç»é²äœæ¥ã¯ã·ã³ãã«ã§ç°¡åã§ããæé ã¯ä»¥äžã®éã
- å³äžã®æ°èŠã¬ã³ãŒã远å ãã¿ã³ãã¯ãªãã¯
- æ¥ä»æ¬ããç»é²ããæ¥ä»ãã«ã¬ã³ããŒããéžã³ãŸã
- äžèЧããPJã³ãŒããããããããŠã³ããéžã³ãŸããèªåçã«PJã¿ã€ãã«ã¯å ¥ããŸãã
- å·¥æ°ã¯hh:mmã®åœ¢åŒã§æéãå ¥åããŸãã
- ç»é²å 容ã¯ããšããã§ãçŽæ¥å¯Ÿè±¡ã®æ¥ä»ãå·Šãµã€ãã®æ¥ä»ããã«ããéžãã§çŽæ¥èšæ£ãå¯èœã§ãã
åäžæ¥ä»ã§ã®ç»é²ã¯åºæ¥ãŸããããŸãã1æ¥å ã«æŒãããããžã§ã¯ãã³ãŒãã¯è€æ°ç»é²ã¯å¯èœã§ãã
å³ïŒã³ãŒããéžã³å·¥æ°ãå ¥ããŠããã ãã®ã¹ã¿ã€ã«
å·¥æ°æåº
ç»é²ããå·¥æ°ã¯æå®ãããä¿åå Žæãžãšæåºãå¿ èŠã«ãªããŸããæ¯æææ«ã«æªç»é²ã®å·¥æ°ããã¹ãŠç»é²ããæåºäœæ¥ã以äžã®æé ã§è¡ããŸãã
- ãªãã³ã®ã¡ãã¥ãŒãã倿 åºåãã¯ãªãã¯
- 幎ã西æŠã§æå®
- æãæå®
- åºåãã¯ãªãã¯ãã
æå®ã®ãã©ã«ãã«ä»¥äžã®å³ã®äŸã§èšãã°ã202105ã®ãã©ã«ããäœæãããŠããããžç€Ÿå¡çªå·ã§ã®xlsxãã¡ã€ã«ãçæãããå·¥æ°ããšã¯ã¹ããŒããããŸãã管çè ã¯ãã®å¹Žæã®ãã©ã«ããæå®ããäºã§ã€ã³ããŒãããããšã«ãªããŸãã
å³ïŒå¹Žãšæãæå®ããŠåºåããã ã
å³ïŒãšã¯ã¹ããŒããããããŒã¿ã®äžèº«
管çè åŽããã°ã©ã
管çè åŽã¯ãŠãŒã¶åŽãšç°ãªã倿°ã®æ©èœãååšããŸããã»ããã£ã³ã°é ç®ã«ã€ããŠã¯ãŠãŒã¶åŽãšåæ§ã§ããã®ã§ãããã§ã¯èšèŒãçç¥ããŸãããŸãããã¹ã¿ãŒããŒã¿ç·šéã«ã€ããŠãåè¿°ããŠããçºããã§ã¯æºåæžã¿ãšããŠé²ããŸããããã§ã¯ãadmin.accdbã«ã€ããŠãã®äœ¿ãæ¹ãšæµãã説æããŸãã
ããŒã¿åã蟌ã¿
ãŠãŒã¶ãæåºããå·¥æ°ããŒã¿ããã©ã«ãåäœã§ã€ã³ããŒãããŸããåäžå¹Žæã®ããŒã¿ã¯äžæŠããªãŒãããŠããååã蟌ã¿ãè¡ãã®ã§æŽãæ¿ãã§ããŒã¿ã¯ã€ã³ããŒããããŸãã以äžã®æé ã§åã蟌ã¿ãŸãã
- ãªãã³ããããŒã¿åã蟌ã¿ãã¯ãªãã¯
- ã€ã³ããŒããããããŒã¿ã®å ¥ã£ãŠããã©ã«ããæå®ããŸãïŒäŸïŒ202105ïŒ
- ãã©ã«ãå ã®xlsxãã¡ã€ã«ãé£ç¶ããŠã€ã³ããŒããããŸãã
- ãªãã³ããã¡ã€ã³è¡šç€ºãã¯ãªãã¯ããäºã§ã€ã³ããŒããããããŒã¿ãé²èЧå¯èœã§ãã
äºãuseridããŒãã«ã«ç»é²ã®ãªã瀟å¡çªå·ã®ããŒã¿ã¯ã€ã³ããŒããããŸããã®ã§æ³šæãå¿ èŠã§ãã
ãŸã4.ã§è¡šç€ºãããå·¥æ°äžèЧã¯èŠªããŒãã«ã幎æãããã«ã€ã³ããŒãããŒãã«ãã¶ãäžãã圢ã§é£çµãããŠããŸããåã蟌ãã ããŒã¿ãæŽã«åè§£ããŠãåæçšã«ããŒã¿ãããã¯ã°ã©ãŠã³ãã§äœ¿ããããã«æŽåããŠããŸãã
å³ïŒã€ã³ããŒããããããŒã¿ã®äžèЧ
TSãã°åã蟌ã¿
倿 管çããŒã¿ãšçªåãã§ãã¯ããçºã®ããŒã¿ã®ã€ã³ããŒããè¡ãæ©èœã§ããäºãçšæããŠãããåè¿°ã®å€æ 管çããŒã¿ïŒæå®æã®ãã®ïŒãã€ã³ããŒãããã€ã³ããŒãæžã¿ã®å·¥æ°ããŒã¿ãšã®å·®ç°ãæç¡ã確èªããŸãã以äžã®æé ã§ã€ã³ããŒããè¡ããŸãã
- ãªãã³ãããTSãã°åã蟌ã¿ããã¯ãªãã¯ãã
- çšæããŠããã倿 ããŒã¿ã®xlsxãã¡ã€ã«ãæå®ãã
- tsdataããŒãã«ãžããŒã¿ã¯æŽãæ¿ãã§ã€ã³ããŒããããŸãïŒæ¥ä»ã¯ãã¡ã€ã«ããèªåå€å®ããŸãïŒ
- ãªãã³ãããTSçªåçµæè¡šç€ºããã¯ãªãã¯ãã
- NGå€å®ãšããŠãçªåçµæã§æéå·®ç°ããããã®ãå·¥æ°æªç»é²ã®ãã®ã倿 åŽæªç»é²ã®ãã®ãªã©ãå€å®çµæãšããŠè¡šç€ºãããŸãã
- éç¥ã®éä¿¡ãã¿ã³ãã¯ãªãã¯ããäºã§ããããã®ããŒã¿ã«ã€ããŠäžæ¬ã§å¯Ÿè±¡è ã«ãŸãšããŠã¡ãŒã«ã§ä¿®æ£ã»ç»é²ãä¿ãäºãå¯èœã§ãïŒOutlookãå¿ èŠã§ãïŒ
å³ïŒçªåçµæNGã®ãã®ã衚瀺ããã
æšç§»åæ
ãŠãŒã¶ããã®å·¥æ°ããŒã¿ãåã蟌ããšåçš®åæãå¯èœã«ãªããŸãã皌åæééèšãå人æ¯éèšãå·¥æ°TOP10ãå·¥è³TOP10ãçŸåšãµããŒãããŠããŸãã以äžã®æé ã§ããããæ€çŽ¢ãããããšãã£ãŒã衚瀺ãããããã«ãªããŸãã
- ãªãã³ãããæšç§»åæããã¯ãªãã¯ãã
- 4ã€ã®ã¿ããããã®ã§ãåæãããå 容ã®ã¿ããéã
- éå§æ¥ä»ããã³çµäºæ¥ä»ãã«ã¬ã³ããŒããéžæãã
- å人æ¯éèšã®ã¿ããããããŠã³ãã瀟å¡åãéžæããŸãã
- æ€çŽ¢ãã¯ãªãã¯ãããšããŒã¿ãçµã蟌ãŸããŠéèšãããŠãã£ãŒãã«åæ ããŸãã
å³ïŒPJã³ãŒãå¥ã瀟å¡å¥ã§ã°ã«ãŒãåãããŠéèšãããŸã
ããŒã¿éèš
ãŠãŒã¶ããã®å·¥æ°ããŒã¿ãåã蟌ãã åŸã«ãããã®ããŒã¿ããPJã³ãŒãå¥ãå人å¥ã«å·¥æ°æéããã³å·¥è³ã«ã€ããŠéèšããããŒã¿ã衚瀺ã»Excel圢åŒã§ãšã¯ã¹ããŒãããäºãå¯èœã«ãªã£ãŠããŸãã以äžã®æé ã§æ€çŽ¢ãæããŠããåºåãè¡ããŸãã
- ãªãã³ãããããŒã¿éèšããã¯ãªãã¯ãã
- 2ã€ã®ã¿ããããã®ã§ãéèšãããå 容ã®ã¿ããéã
- éå§æ¥ä»ããã³çµäºæ¥ä»ãã«ã¬ã³ããŒããéžæãã
- æ€çŽ¢ãã¯ãªãã¯ãããšããŒã¿ãçµã蟌ãŸããŠéèšãããŠããŒã¿ãªã¹ãã衚瀺ãããŸãã
- åºåãã¯ãªãã¯ãããšãä¿åå Žæãæå®ããŠãExcel圢åŒã§çŸåšã®ããŒã¿ãªã¹ãããšã¯ã¹ããŒãããŸãã
å³ïŒç°¡åã«å šããŒã¿ããçµã蟌ã¿ãšéèšãå¯èœ
ãªãã³ã®ã³ãŒã
æ¬ããã°ã©ã ã®ç¬èªãªãã³ã¯ãã·ã¹ãã ãªããžã§ã¯ãã§ãããUSysRibbonsãããŒãã«ã«ç»é²ãããŠããŸãã衚瀺ã®ããããã¯ãã¡ãã®ãµã€ããåèã«ã·ã¹ãã ãªããžã§ã¯ãã衚瀺ãããšé²èЧãå¯èœã§ãããéåžžã¯åŒããªãã§ãã ããã
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="ribbonman"> <commands> <command idMso="PartTemplateGallery" enabled="false" /> </commands> <ribbon startFromScratch="false"> <tabs> <tab id="CustomTab" label="ã³ãã³ã"> <group id="control1" label="ã¡ã€ã³ç»é¢"> <button id="Button1" imageMso="ShowTimeZones" size="large" label="ã¡ã€ã³è¡šç€º
" screentip="å·¥æ°ç»é²ç»é¢ã®è¡šç€º" onAction="ã¡ã€ã³è¡šç€º" /> <button id="Button2" imageMso="MeetingsWorkspace" size="large" label="ã»ããã£ã³ã°
" screentip="èšå®ç»é¢ã®è¡šç€º" onAction="ã»ããã£ã³ã°" /> <button id="Button3" imageMso="BlogPublish" size="large" label="倿 åºå
" screentip="ããŒã¿ãåºå" onAction="åºå衚瀺" /> </group> </tab> </tabs> </ribbon> </customUI> |
- åãªãã³ã®ã³ãã³ãã§ããonActionã¯ãã¹ãŠãã¯ããæå®ããŠããŸãã
- ãŸããèµ·åæã«ã¯Autoexecãã¯ããèªåçã«äœåããstartupexec()ãå®è¡ãããä»çµã¿ã«ãªã£ãŠããŸãã
- ãªãã³å¶åŸ¡çšã®ã¢ãžã¥ãŒã«ã¯ãã¹ãŠribboncmdã«æ ŒçŽãããŠããŸãããªãã³ããŒãæã«ribbonmanã³ãã³ããå®è¡ãããŸãã
- ãªãã³ã䜿ãçºã«åç §èšå®ã«ãŠãMicrosoft Office 16.0 Object Libraryããå ããŠããŸãã