ããaccesså³Microsoft Office Accessã
ããMicrosoft Office Accessæ¯ç±å¾®è½¯åå¸çå
³èå¼æ°æ®åºç®¡çç³»ç»ãå®ç»åäº Microsoft Jet Database Engine å å¾å½¢ç¨æ·çé¢ä¸¤é¡¹ç¹ç¹ï¼æ¯ Microsoft Office çç³»ç»ç¨å¼ä¹ä¸ã
ããç®ä»ç¼è¾
ããMicrosoft Office Accessæ¯å¾®è½¯ææ°æ®åºå¼æçå¾å½¢ç¨æ·çé¢å软件å¼åå·¥å
·ç»åå¨ä¸èµ·çä¸ä¸ªæ°æ®åºç®¡ç
ããMicrosoft Office Access(2å¼ )
ããç³»ç»ãå®æ¯å¾®è½¯OFFICEçä¸ä¸ªæå, å¨å
æ¬ä¸ä¸çåæ´é«çæ¬çofficeçæ¬éé¢è¢«åç¬åºå®ã2012å¹´12æ4æ¥,ææ°ç微软Office Access 2013å¨å¾®è½¯Office 2013éåå¸,微软Office Access 2010 æ¯åä¸ä¸ªçæ¬ã
ããMS ACCESS以å®èªå·±çæ ¼å¼å°æ°æ®åå¨å¨åºäºAccess Jetçæ°æ®åºå¼æéãå®è¿å¯ä»¥ç´æ¥å¯¼å
¥æè
é¾æ¥æ°æ®(è¿äºæ°æ®åå¨å¨å
¶ä»åºç¨ç¨åºåæ°æ®åº)ã
ãã软件å¼å人ååæ°æ®æ¶æå¸å¯ä»¥ä½¿ç¨Microsoft Accesså¼ååºç¨è½¯ä»¶,âé«çº§ç¨æ·âå¯ä»¥ä½¿ç¨å®æ¥æ建软件åºç¨ç¨åºãåå
¶ä»åå
¬åºç¨ç¨åºä¸æ ·ï¼ACCESSæ¯æVisual Basicå®è¯è¨,å®æ¯ä¸ä¸ªé¢å对象çç¼ç¨è¯è¨,å¯ä»¥å¼ç¨åç§å¯¹è±¡ï¼å
æ¬DAO(æ°æ®è®¿é®å¯¹è±¡),ActiveXæ°æ®å¯¹è±¡,以å许å¤å
¶ä»çActiveXç»ä»¶ãå¯è§å¯¹è±¡ç¨äºæ¾ç¤ºè¡¨åæ¥è¡¨ï¼ä»ä»¬çæ¹æ³åå±æ§æ¯å¨VBAç¼ç¨ç¯å¢ä¸ï¼VBA代ç 模åå¯ä»¥å£°æåè°ç¨Windowsæä½ç³»ç»å½æ°ã
ããç¨é
ããMicrosoft Accesså¨å¾å¤å°æ¹å¾å°å¹¿æ³ä½¿ç¨ï¼ä¾å¦å°åä¼ä¸ï¼å¤§å
¬å¸çé¨é¨ã
ããAccessçç¨éä½ç°å¨ä¸¤ä¸ªæ¹é¢ï¼
ããä¸ãç¨æ¥è¿è¡æ°æ®åæï¼ accessæ强大çæ°æ®å¤çãç»è®¡åæè½åï¼å©ç¨accessçæ¥è¯¢åè½ï¼å¯ä»¥æ¹ä¾¿å°è¿è¡åç±»æ±æ»ãå¹³åçç»è®¡ã并å¯çµæ´»è®¾ç½®ç»è®¡çæ¡ä»¶ãæ¯å¦å¨ç»è®¡åæä¸ä¸æ¡è®°å½ãåå ä¸æ¡è®°å½å以ä¸çæ°æ®æ¶é度快ä¸æä½æ¹ä¾¿ï¼è¿ä¸ç¹æ¯Excelæ æ³ä¸ä¹ç¸æ¯çã è¿ä¸ç¹ä½ç°å¨ï¼ä¼ç¨accessï¼[1]æé«äºå·¥ä½æçåå·¥ä½è½åã
ããäºãç¨æ¥å¼åè½¯ä»¶ï¼ accessç¨æ¥å¼å软件ï¼æ¯å¦ç产管çãéå®ç®¡çãåºå管ççåç±»ä¼ä¸ç®¡ç软件ï¼å
¶æ大çä¼ç¹æ¯ï¼æå¦ï¼é计ç®æºä¸ä¸ç人åï¼ä¹è½å¦ä¼ãä½ææ¬å°æ»¡è¶³äºé£äºä»äºä¼ä¸ç®¡çå·¥ä½ç人åç管çéè¦ï¼éè¿è½¯ä»¶æ¥è§èåäºãä¸å±çè¡ä¸ºï¼æ¨è¡å
¶ç®¡çææ³ãï¼VBã.netã Cè¯è¨çå¼åå·¥å
·å¯¹äºé计ç®æºä¸ä¸äººåæ¥è¯´å¤ªé¾äºï¼èaccessåå¾å®¹æï¼ã è¿ä¸ç¹ä½ç°å¨ï¼å®ç°äºç®¡ç人åï¼é计ç®æºä¸ä¸æ¯ä¸ï¼å¼ååºè½¯ä»¶çâ梦æ³âï¼ä»è转å为âæ管ç+ä¼ç¼ç¨âçå¤åå人æã[1]
ããå¦å¤ï¼å¨å¼åä¸äºå°åç½ç«WEBåºç¨ç¨åºæ¶ï¼ç¨æ¥åå¨æ°æ®ãä¾å¦ASP+Accessãè¿äºåºç¨ç¨åºé½å©ç¨ASPææ¯å¨InternetInformation Servicesè¿è¡ï¼æ¯è¾å¤æçWEBåºç¨ç¨åºå使ç¨PHP/MySQLæè
ASP/Microsoft SQL Serverï¼
ããACCESSçç¨éæ´å¤ï¼ä½ç°å¨å¾å¤æ¹é¢ï¼
ããè¡¨æ ¼æ¨¡æ¿ã åªéé®å
¥éè¦è·è¸ªçå
容ï¼Access 便ä¼ä½¿ç¨è¡¨æ ¼æ¨¡æ¿æä¾è½å¤å®æç¸å
³ä»»å¡çåºç¨ç¨åºã Access å¯å¤çå段ãå
³ç³»åè§åçå¤æ计ç®ï¼ä»¥ä¾¿æ¨è½å¤éä¸ç²¾åå¤ç项ç®ã æ¨å°æ¥æä¸ä¸ªå
¨æ°çåºç¨ç¨åºï¼å
¶ä¸å
å«è½å¤ç«å³å¯å¨å¹¶è¿è¡çèªç¶ UIã
ããå建åè¿è¡æ§æ°æ®åºã å°½æ
享ç¨å¯¹æ¨çç°ææ¡é¢æ°æ®åº (ACCDB/MDB) çæ¯æã
ããç¹æ§
ããAccessæ¯ä¸æ¬¾æ°æ®åºåºç¨çå¼åå·¥å
·è½¯ä»¶ï¼å
¶å¼å对象主è¦æ¯Microsoft JETæ°æ®åºåMicrosoft SQLServeræ°æ®åºãç±äºå¨Office 97å以åççæ¬ä¸ï¼Microsoft JET 3.51å以åçæ¬çæ°æ®åºå¼ææ¯éAccessä¸èµ·å®è£
ååå¸çï¼JETæ°æ®åºä¸Accesså°±æäºå¤©ççè¡ç¼å
³ç³»ï¼å¹¶ä¸Access对JETæ°æ®åºåäºå¾å¤å°æ©å
ï¼å¦ï¼å¨Accessçç¯å¢ä¸ï¼å¯ä»¥å¨æ¥è¯¢ä¸ä½¿ç¨èªå·±ç¼åçVBAå½æ°ï¼Accessççªä½ãæ¥è¡¨ãå®å模åæ¯ä½ä¸ºä¸ç§ç¹æ®æ°æ®åå¨å¨JETæ°æ®åºæ件(.mdb)ä¸ï¼åªæå¨Accessç¯å¢ä¸æè½ä½¿ç¨è¿äºå¯¹è±¡ãéçï¼Microsoft Windowsæä½ç³»ç»çæ¬çä¸æå级åæ¹è¯ï¼å¨Windows XP以åçæ¬ä¸ï¼Microsoftå°JETæ°æ®åºå¼æéæå¨Windwosæä½ç³»ç»ä¸ä½ä¸ºç³»ç»ç»ä»¶çä¸é¨åä¸èµ·åå¸(主è¦åå æ¯Windowsä¸è¿æå¾å¤ç»ä»¶éè¦ä½¿ç¨JETå¼æï¼æ´»å¨ç®å½ç)ãä»æ¤JETæ°æ®åºå¼æä»Accessä¸å离åºæ¥ï¼èAccessä¹å°±æ为äºä¸ä¸ªä¸é¨çæ°æ®åºåºç¨å¼åå·¥å
·ã
ããç±äºJETæ°æ®åºå¼æçå离ï¼å¾å¤åºç¨ç¨åºéç¨äºJETæ°æ®åºä½ä¸ºå
¶åºç¨çæ°æ®åºï¼JETæ°æ®åºç¬¦åå
³ç³»æ°æ®åºç论ï¼æçå®æ´çæ°æ®å®ä¹ãæ°æ®å¤çãæ°æ®å®å
¨ç®¡çä½ç³»ãå¨Microsoft Windowsæä½ç³»ç»ä¸ï¼éçMicrosoftå¨ActiveXææ¯ä¸çåå±ï¼Windowsä¸ä¸æå级æ¢ä»£çæ°æ®è®¿é®ç»ä»¶ï¼è¿äºç»ä»¶å
æ¬ODBCãOLEDBãDAOãADOãADOï¼JETæ°æ®åºå¼æåè¿äºç»ä»¶ä¸èµ·å·²ç»æäºå
è´¹çæ°æ®åºç®¡çç³»ç»ã
?ãã?
温馨提示:内容为网友见解,仅供参考