1.ã¯ããã«
ãã¯ãããžãŒãé²æ©ããããŒã¿ç®¡çæ¹æ³ãå€æ§åããçŸä»£ãå€ãããååšããåºã掻çšãããŠããMicrosoft AccessãšããããŒã¿ããŒã¹ã·ã¹ãã ã«ã€ããŠããæ代é ãããšããèšèããã°ãã°é£ã³äº€ã£ãŠããŸãã
1.1.æ¬èšäºã®ç®ç
æ¬èšäºã®ç®çã¯ããã®Microsoft Accessãæ代é ããšãããçç±ããããŠãã®ççžã詳ãã解説ããçŸåšã«ãããAccessã®åœ¹å²ãšäŸ¡å€ãæããã«ããããšã§ããAccessãæ代é ãã§ãããšãã説ã¯æ¬åœãªã®ãããããšã誀解ãªã®ããæ¬èšäºãèªãããšã§ããã®çããèŠããŠããããšã§ãããã
1.2.äœæ Accessæ代é ã説ãåºãŠããã®ã
ã§ã¯ããªãAccessãæ代é ããšãã説ãåºãŠããã®ã§ãããããããã¯æ°ããªããŒã¿ããŒã¹ã·ã¹ãã ã®ç»å Žãæè¡ã®é²åã倧ããé¢ä¿ããŠããŸããã€ã³ã¿ãŒãããã®çºå±ã«äŒŽããããŒã¿ããŒã¹ç®¡çã®ã¹ã¿ã€ã«ããŸãå€åããäŒæ¥ã®ããŒã¿ç®¡çéèŠã¯ãŸããŸãè€éåããŠããã®ã§ãããã®ç¶æ³ã«å¯ŸããAccessã¯å€ãã·ã¹ãã ãšæããããæ代é ããšãã説ãæµ®äžããŠããã®ã§ãã
ããããAccessãçŸåšã§ãæ¥åã§æŽ»çšãããŠããäºå®ããããŸããåŸã£ãŠãAccessãæ¬åœã«æ代é ããšèšããã®ãããããšãããã¯èª€è§£ãªã®ããæããã«ããããã«ãæ§ã ãªèŠ³ç¹ããAccessã«ã€ããŠæ·±å ãããŠãããŸãã
2.Accessãšã¯äœã
Microsoft Accessã¯éåžžã¯AccessãšåŒã°ããMicrosoftã1992幎ã«æåã«å ¬éããããŒã¿ããŒã¹ãããžã¡ã³ãã·ã¹ãã ïŒDBMSïŒã§ããAccessã¯ãåå¥ã®ãã¹ã¯ãããã¢ããªã±ãŒã·ã§ã³ããæ¥ååããœãªã¥ãŒã·ã§ã³ãŸã§ãããŒã¿ããŒã¹ã®äœæãšç®¡çãç®çãšããããŒã«ãšããŠå¹ åºãæ¡çšãããŠããŸããã
2.1.Accessã®å®çŸ©
Accessã¯ãé¢ä¿ããŒã¿ããŒã¹ç®¡çã·ã¹ãã (RDBMS)ã®äžçš®ã§ãããŒã¿ãæ ŒçŽãæ€çŽ¢ãæäœããæ©èœãåããŠããŸãããã®ã·ã¹ãã ã¯ãGUIãšSQLãçµã¿åããããŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ãç¹åŸŽãšããŠããããŠã£ã³ããŠãºç°å¢ã§ã®ããŒã¿ããŒã¹äœæãç·šéãæäœãç°¡åã«ã§ããŸãã
2.2.Accessã®ç¹åŸŽãšå©ç¹
Accessã¯ããã€ãã®éèŠãªç¹åŸŽãæããŠããŸãããŸããéåžžã«çŽæçãªãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ãæã£ãŠããããšã§ããããã«ããããŠãŒã¶ãŒã¯ããŒã¿ããŒã¹ãç°¡åã«æäœããããšãã§ããããŒã¿åæã®äœæ¥ãè¿ éã«é²è¡ããŸãããã®é«ãå©äŸ¿æ§ã¯Accessã®æ倧ã®å©ç¹ã®äžã€ã§ãããå€ãã®ãŠãŒã¶ãŒã«ãã£ãŠè©äŸ¡ãããŠããŸãã
ãŸããAccessã¯ãMicrosoft Officeãšã®é«ãäºææ§ãæã£ãŠããŸããWordãExcelãšã®é£æºã«ãããããŒã¿ã®åã蟌ã¿ãåºåãç°¡åã«è¡ããŸããããã«ãããããžãã¹ã®çŸå Žã§ãå¹ åºã掻çšãããŠããŸãã
2.3.Accessã§åºæ¥ãäº
Accessã䜿ã£ãŠãäœãã§ããã®ã§ããããïŒAccessã¯ã以äžã®ãããªæ©èœãæäŸããŸãã
1. ããŒã¿ããŒã¹ã®äœæãšç®¡çïŒAccessã¯ãåºæ¬çã«ããŒã¿ããŒã¹ã®äœæãšç®¡çã容æã«ããããã®ããŒã«ã§ããããŒãã«ããã©ãŒã ãã¯ãšãªãã¬ããŒããªã©ã䜿ã£ãŠæ å ±ãæŽçããããŒã¿ã®äœæãæŽæ°ãæ€çŽ¢ãè¡ãããšãã§ããŸãã
2. ããŒã¿åæïŒAccessã®ã¯ãšãªæ©èœã䜿çšãããšãããŒã¿ããŒã¹ã®äžããç¹å®ã®æ å ±ãæœåºããããããŒã¿ãããŸããŸãªè§åºŠããåæããããšãã§ããŸããããã¯éåžžã«åŒ·åãªæ©èœã§ãæ£ç¢ºãªããŒã¿åæãå¯èœã«ããŸãã
3. Microsoft Office ãšã®çµ±å:Accessã¯æ¢ã«è¿°ã¹ãããã«ãMicrosoft Officeã·ãªãŒãºãšã®çµ±åæ§ãé«ãã§ãããã®ãããExcelãWordããAccessã«ããŒã¿ãåã蟌ãã ãããã®éãå¯èœã§ããããã«ãããOfficeã§äœæããããŒã¿ãããŒã¿ããŒã¹ãšããŠæŽ»çšããããšãã§ããŸãã
3.Accessæ代é ã説ã®çç±
Accessãæ代é ããšèšãããçç±ã«ã¯ãããŸããŸãªèŠå ã圱é¿ããŠããŸãããäž»ãªèŠçŽ ã¯äžèšã®éãã§ãã
3.1.ãã¯ãããžãŒã®é²æ©ãšAccess
çŸä»£ç€ŸäŒã®ãã¯ãããžãŒã¯ç®ãŸããããçºå±ãç¶ããŠããŸãããã®äžã§ãããŒã¿ããŒã¹ç®¡çã·ã¹ãã ããŸãäŸå€ã§ã¯ãããŸãããåæã®Accessã¯ãã®é ã®æè¡ãåæ ããããŒãœãã«ã³ã³ãã¥ãŒã¿ã«ä¿åãããããŒã¿ããŒã¹ã容æã«ç®¡çããããšãå¯èœã§ãããããããæ代ãé²ãã«ã€ããã¯ã©ãŠãããŒã¹ã®ããŒã¿ããŒã¹ã·ã¹ãã ãå°é ãã倧éã®ããŒã¿ããªã¢ã«ã¿ã€ã ã§æ±ãããšãæ±ããããããã«ãªããŸãããAccessã¯ãã®èœåããã£ãŠããªãã£ããããæ°ãããã¯ãããžãŒã«åãæ®ãããŠããŸã£ããšãã解éããããŸãã
3.2.æ°ããªããŒã¿ããŒã¹ã·ã¹ãã ã®åºçŸ
è¿å¹Žã®ããžãã¹ç°å¢ã§ã¯ããªã¢ã«ã¿ã€ã ã§å€§éã®ããŒã¿ãåŠçããèœåãæ±ããããŠããŸãããã®ããã«æ°ããªããŒã¿ããŒã¹ã·ã¹ãã ã次ã ã«èªçããŠããããã®å€ããã¯ã©ãŠãããŒã¹ã§ã®éçšãäž»æµãšãªã£ãŠããŸãããããæ°æè¡ã¯ãAccessãåŸæãšããŠãããªã³ãã¬ãã¹ç°å¢ã§ã®æäœæ§ãšã¯ç°ãªãå©ç¹ãæã£ãŠããŸããäŸãã°ããªã¢ãŒãã¯ãŒã¯ã®æ®åã«äŒŽããã©ãããã§ãã¢ã¯ã»ã¹ã§ããã¯ã©ãŠãããŒã¿ããŒã¹ãéå®ãããããã«ãªã£ãã®ããAccessãæ代é ããšèšãããäžå ã§ãã
3.3.Accessã«å¯Ÿããäžéšã®èª€è§£
æåŸã«è§ŠããŠããããã®ã¯ãAccessã«å¯Ÿããäžéšã®èª€è§£ã§ããAccessã察å¿ã§ããªãã»ã©ã®å€§èŠæš¡ããŒã¿ããŒã¹ããè€éãªã¯ãšãªã«å¯Ÿå¿ã§ããªããšãã誀解ãåºãŸã£ãŠããŸããããããããã¯äžéšã®å Žåã«ã®ã¿åœãŠã¯ãŸããå šãŠã®ã·ãã¥ãšãŒã·ã§ã³ã§Accessã圹ç«ããªãããã§ã¯ãããŸãããæé©ãªããŒã«ã¯èŠä»¶ãç¶æ³ã«ãã£ãŠå€ãããããäžæŠã«Accessãæ代é ããšã¯èšããŸããããã ãããã®èª€è§£ãåºãŸã£ãŠããããšãäºå®ã§ãããã¯Accessæ代é ã説ã®æºæ³ã®äžã€ãšãªã£ãŠããŸãã
4.Accessæ代é ã説ã®ççž
Accessã«ã€ããŠã®æ代é ã説ãåãããäžæ¹ã§ãå®éã«ã¯ãŸã ãŸã å€ãã®å Žé¢ã§Accessã®èœåã掻çšãããŠããŸãã
4.1.äŸç¶ãšããŠæŽ»èºããAccessã®ã·ãŒã³
ç¹ã«ãè€éãªããŒã¿åŠçãåæãå¿ èŠãšããªãå°èŠæš¡ãªãªãã£ã¹ã¯ãŒã¯ã§ã¯ãAccessã®æã€äœ¿ããããããŠãŒã¶ããªãã£ãè©äŸ¡ãããäŸç¶ãšããŠæŽ»èºããŠããŸããAccessã¯ãããŒã¿ããŒã¹ãšããŠã®åºæ¬æäœã ãã§ãªãããã©ãŒã ã®äœæãã¬ããŒãæ©èœãVBAã«ããèªååãªã©ãå¹ åºãããŒã¿ç®¡çãäžå çã«è¡ãããšãå¯èœã§ããããã ãããããèšå€§ãªããŒã¿ãæ±ãããã°ããŒã¿ãªã©ã®ã·ãŒã³ã§ã¯åãçºæ®ãã«ãããããããŸããããæ軜ã«ããŒã¿ã管çãããã·ãã¥ãšãŒã·ã§ã³ã§ã¯äžå®ã®éèŠã確ä¿ããŠããã®ã§ãã
4.2.ä»ã®æ°ããªææ³ãšæ¯èŒããAccessã®äœçœ®ä»ã
æè¿ã§ã¯ãNoSQLããŒã¿ããŒã¹ãã¯ã©ãŠãããŒã¹ã®ããŒã¿ããŒã¹ãªã©ãæ°ããªããŒã¿ããŒã¹æè¡ãå°é ããŠããŠããŸããããããAccessã®äœçœ®ä»ããæºãããªãçç±ã®äžã€ã¯ããã®åŠç¿æ²ç·ã®ç·©ãããã§ããæ°ããªããŒã¿ããŒã¹æè¡ã¯é«åºŠãªæè¡ãçšããããã«ãäžå®ã®åŠç¿ã³ã¹ããå¿ èŠã§ãã
ããããAccessã¯ãã®å±ããRDBMSã®ç¹æ§ã掻ããã衚圢åŒã§ããŒã¿ã管çããããšãäž»ãªæäœãªã®ã§ãåå¿è ã§ãç解ããããã§ãããŸããããœã³ã³äžå°ããã°å§ããããæ軜ããé åã§ããŠãŒã¶ãŒã«å¯ŸããããŒãã«ã®äœããæ±ããããç°å¢ã§ã¯éå®ãããŸãã
ãã®ãããæ¯èŒççæéã§ã·ã¹ãã ãæ§ç¯ã»éçšããããåå¿è ãåŠç¿ããéã®ææãšããŠãAccessã¯ãã®ååšäŸ¡å€ãä¿ã¡ç¶ããŠãããšèšããŸãã
5.Accessã®ä»åŸãšå©çšã®ã¡ãªãããã¡ãªãã
ããã§ã¯ãAccessã®å°æ¥æ§ã«ã€ããŠæãäžãããã®æŽ»çšæ³ãã¡ãªããããã¡ãªããã詳ããåæããŠãããŸãã
5.1.Access掻çšã®æå¹æ§
Accessã¯ãä»ããªãå€ãã®å Žé¢ã§ãã®æå¹æ§ãçºæ®ããŠããŸããç¹ã«ãããŒã¿ã®ãããŒãžã¡ã³ããåæãå¿ èŠãšãªãäžå°äŒæ¥ãå人äºæ¥äž»ã«ãšã£ãŠã¯äŸ¿å©ãªããŒã«ã§ãããšèšããã§ããããããã¯ãAccessãæ¯èŒç容æã«äœ¿ãå§ããããšãã§ããäžå®ã®ããŒã¿éãŸã§ã¯ååã«ãã®åŠçèœåãçºæ®ããããã§ãã
5.2.Accessã®é²åãšå¯èœæ§
ãŸããAccessèªäœãé²åãç¶ããŠãããä»åŸæŽã«ãã®æŽ»çšã®å¹ ãåºããå¯èœæ§ãç§ããŠããŸããäŸãã°ãã¯ã©ãŠãé£æºæ©èœã®è¿œå ã«ããããããã¬ãã·ãã«ãªããŒã¿ç®¡çãå ±æãå¯èœã«ãªããšæåŸ ãããŠããŸãããã¡ãããããŒã¿ãµã€ãºãåŠçé床ãè€éãªåæãæ±ããããå Žåã«ã¯å°çšã®DBMSã倧èŠæš¡ãªERPã·ã¹ãã ãžç§»è¡ããå¿ èŠããããŸãããã¢ããããŒããç©ã¿éããããšã§Accessã®éçãå°ããã€åºãã£ãŠããã®ã§ãã
5.3.Accessã®ã¡ãªããã»ãã¡ãªãã
ããŠãAccessã®ã¡ãªãããšãã¡ãªããã«ã€ããŠèŠãŠãããŸããããäž»ãªã¡ãªãããšããŠã¯ãåè¿°ããããã«åŠç¿ã³ã¹ããæ¯èŒçã«äœãç¹ãç¬èªã®ããŒã¿ããŒã¹ã容æã«èšèšã§ããç¹ããŸãå°èŠæš¡ãªããŒã¿ããŒã¹ã«å¯Ÿããé«ãåŠçèœåãæããããŸãã
äžæ¹ã§ããã¡ãªãããšããŠã¯ãããŒã¿éãèšå€§ã«ãªã£ãå Žåãè€æ°ãŠãŒã¶ãåæã«å©çšããå Žåã®ããã©ãŒãã³ã¹ãåé¡ãšãªãããšããããŸãããŸããSQLã§ã§ããè€éãªåŠçãåæãå°éã®DBMSã»ã©ã«ã¯å®çŸã§ããªããšããç¹ãèæ ®ããå¿ èŠããããŸãããããããããã®åé¡ç¹ãã䜿çšç®çãç¶æ³ã«å¿ããŠé©åã«ããŒã«ãéžæããããšã§ãåé¿ããããšãå¯èœãšãªããŸãã
ããããã¡ãªãããšãã¡ãªãããèžãŸããªãããèªåã®ç¶æ³ã«æé©ãªããŒã¿ããŒã¹ããŒã«ãéžæã§ããããšãéèŠã§ãã
6.ãŸãšã
ãã®èšäºãéããŠãæã ã¯æ°ã ã®èŠç¹ããMicrosoft Accessã®ååšãšãã®é©çšç¯å²ã«ã€ããŠãæ·±ãèå¯ããŸããã
6.1. æ¬èšäºã®å 容ã®å確èª
åãã«ãMicrosoft Accessãšã¯äœãªã®ãããã®ç¹åŸŽãå©çšã·ãŒã³ã«ã€ããŠè§ŠããŸããããã®äžã§ãææè³ã«ããããšã®ãããAccessæ代é ã説ãã®çºçèæ¯ã«è§Šãããã¯ãããžãŒã®é²æ©ãæ°ããªããŒã¿ããŒã¹ã·ã¹ãã ã®åºçŸããããŠåœè©²èª¬ã«å¯Ÿãã誀解ã«ã€ããŠèå¯ããŸããã
ãã®åŸã説ã®ççžãè¿œæ±ããéçšã§ãä»æ¥ã§ãçŸåœ¹ã§æŽ»èºããAccessã®å©çšã·ãŒã³ããä»ã®æ°ããããŒã¿ããŒã¹ç®¡çæ段ãšæ¯èŒããäžã§ã®å ¶ã®äœçœ®ä»ããæ€èšããŸããã
æåŸã«ãä»åŸã®Accessã®å©çšã«åããæå¹æ§ãå¯èœæ§ããããŠã¡ãªããã»ãã¡ãªããã«ã€ããŠè§Šããèªè ã®çæ§ã«å ·äœçãªç解ãæ·±ããŠããã ããŸããã
6.2. Accessæ代é ã説ãžã®çµè«
Accessãæ代é ãã§ãããåŠãã«ã€ããŠã®çµè«ã¯ã䜿çšããç®çãããŒãºããããŠæçµçãªå©çšç°å¢ã«ãããšããã®ãç§ãã¡ã®èŠè§£ã§ããAccessã¯äŸç¶ãšããŠãã®äŸ¡å€ãç¶æããäžå°èŠæš¡ã®ããŒã¿ããŒã¹ç®¡çã«ãããŠæåãªéžæè¢ã§ããããšã¯ééããããŸããããããã倧èŠæš¡ãªããŒã¿åŠçããæ°ããªãã¯ãããžãŒãšã®èŠªåæ§ãæ±ããå Žåã«ã¯ãä»ã®æ°ããããŒã¿ããŒã¹ã·ã¹ãã ã®éžæãèæ ®ãã¹ãã§ãããã
èšãæããã°ãAccessèªäœãæ代é ãã§ããããã§ã¯ãªããã©ã®ããŒã«ãã©ã®ç¶æ³ã§äœ¿ãã¹ãããç解ããããšãå¿ èŠã§ãããšããããšã§ãããã®ãããAccessæ代é ã説ã«ã€ããŠã¯ãå¿ ãããäžæŠã«ã¯èªããããªããšããçµè«ã«éããŸããã
ãããããæè¡ã®é²æ©ãšå ±ã«ãããŒã«ã®éžæè¢ã¯å¢ããŠããã§ãããããããéèŠãªã®ã¯ããã®äžããæé©ãªãã®ãéžã³ãå©çšããããã®ç解ãšç¥èãæ·±ããèªèº«ã®ããŒãºã«åã£ãéžæãããããšã§ãã