è¥è¦å¿«éæ¥æ¾åæåºè®°å½ï¼å°±éè¦ç´¢å¼å个å段æå段çç»åã对äºæä¸å¼ 表æ¥è¯´ï¼å»ºç«ç´¢å¼çæä½å°±æ¯è¦æå®ä¸ä¸ªæè
å¤ä¸ªå段ï¼ä»¥ä¾¿äºæè¿ä¸ªæè
è¿äºå段ä¸çå¼æ¥æ£ç´¢æ°æ®ï¼æè
æåºæ°æ®ãå¨ä¸æAccess 2000ä¸è½å»ºç«çç´¢å¼å¦ä¸æè¿°ã
1.å建åå段索å¼
âåå段索å¼âçæææ¯ä¸å¼ 表ä¸åªæä¸ä¸ªç¨äºç´¢å¼çå段ï¼ä½¿ç¨ä¸åæ¥éª¤è¿è¡æä½å¯ä»¥å»ºç«å®ï¼
æ¥éª¤ä¸ãå¨â设计âè§å¾ä¸æå¼è¡¨ã
æ¥éª¤äºãå¨â设计âè§å¾çå段å表ä¸åå»è¦å建索å¼çå段ï¼éå®å®ã
æ¥éª¤ä¸ãå¨â常è§âé项å¡ä¸åå»âç´¢å¼âå±æ§æ¡å
é¨ï¼ç¶åä»ä¸æå表ä¸éæ©âæï¼æéå¤ï¼âæâæï¼æ éå¤ï¼â项ï¼åè§å¾33ã
å¨å¾33æ示çâç´¢å¼âä¸æå表ä¸ï¼åå»âæ(æ éå¤)âé项ï¼å¯ä»¥ç¡®ä¿è¯¥å段ä¸çè®°å½æ²¡æéå¤å¼ãè¿æ¯å¸¸ç¨çé项ã
æ¥ä¸æ¥å
³é该è§å¾åï¼ç´¢å¼å°±å»ºç«å¥½äºãæ¤åï¼æ¨å°±å¯ä»¥å°æ¤å段ä¸çå¼æååºæè
éåºçæ¹å¼è¿è¡æåºï¼å¹¶è®©åè¡è®°å½å¼éæ°æååæ¥æ¾ç¤ºãå³è¿ç§éæ°æåºçç»ææ¯ä½¿å¾åè¡è®°å½æç´¢å¼çå®ä¹å¨è¡¨ä¸éæ°æåï¼ä»èæå©äºæµè§æ°æ®è®°å½ã
注æï¼ç¨äºç´¢å¼çå段ï¼é常æ¯ä¸äºå¯ä»¥ç¨äºæåºæ°æ®è®°å½ï¼å¦ï¼æ°åãè±æåè¯ï¼ä¹è½ç¨äºä¸æï¼ä½ä¸å¸¸ç¨ã
å¾33 åå»è¿ä¸ªä¸ææé®
2.å建å¤å段索å¼
为äºå建å¤å段索å¼ï¼å¯ä»¥ä½¿ç¨ä¸åæ¥éª¤è¿è¡æä½ï¼
æ¥éª¤ä¸ãå¨â设计âè§å¾ä¸æå¼è¡¨ã
æ¥éª¤äºãåå»â设计âè§å¾å·¥å
·æ ä¸çâç´¢å¼âæé®ï¼åè§å¾34ã
å¾34 åå»è¿ä¸ªæé®
æ¥éª¤ä¸ãè¥è¡¨ä¸å½å没æç´¢å¼å主é®çè¯ï¼å¯å¨å¾35æ示çâç´¢å¼â对è¯æ¡ä¸ï¼åå»âç´¢å¼å称âæ ä¸ç第ä¸ä¸ªç©ºè¡ï¼ç¶åé®å
¥ç´¢å¼å称ãå¦åï¼å¯å¨è¯¥æ ç第äºè¡ä¸è¾å
¥å®ï¼ä»¥ä¾¿å»ºç«ç¬¬äºä¸ªç´¢å¼ã
å¾35 å¨è¿éè¾å
¥å称
âç´¢å¼å称âä»
æ¯ç´¢å¼çæ è¯ï¼å¯ä»¥ä½¿ç¨ç´¢å¼å段çå称æ¥å½åï¼æ使ç¨å
·ææç§å«ä¹çå符串ãå¦ï¼æ¬ä¾å°å»ºç«âååéé¢âç´¢å¼ï¼ä»¥ä¾¿äºä»¥åæååéé¢ç大å°æåºæ¥æµè§æ°æ®è®°å½ï¼æ以ç»åºäºå¾35ä¸æ示çç´¢å¼å称ã
æ¥éª¤åãå¨âå段å称âæ ä¸ï¼åå»ä¸ææé®ï¼ç¶åä»ä¸æå表ä¸éå®æ©ç¨äºç´¢å¼çå段ï¼åè§å¾36ã
å¾36 ä»ä¸æå表ä¸éæ©è¿ä¸ªå段
å¾37 åå»è¿ä¸ªä¸ææé®
æ¥éª¤äºãå°å
æ 移è³å³æçâæåºæ¬¡åºâæ ä¸ï¼åå»ä¸ææé®åä»ä¸æå表ä¸éæ©æåºæ¹å¼ï¼åè§å¾37ã
æ¥éª¤å
ãè¥è¦ä½¿ç¨å¤ä¸ªç´¢å¼ï¼èä¸éæ°å®ä¹â主é®âçè¯ï¼åå»âç´¢å¼â对è¯æ¡çå·¦ä¸é¨çâ主索å¼âä¸ææé®ï¼ç¶åä»å¾38æ示çä¸æå表ä¸éæ©â主索å¼âã
å¾38 åå»è¿ä¸ªä¸ææé®
æ¥éª¤ä¸ãå°å
æ 移è³âå段å称âæ ä¸çä¸ä¸è¡ä¸ï¼åå»è¯¥è¡æå¨åå
æ ¼ï¼ç¶åéè¿å¾38æ示çä¸æå表éå®ç¬¬äºä¸ªç´¢å¼å段ï¼å¦âåä½å°åâã
è¿ä¸æ¥æä½å°æå®ç¬¬äºä¸ªç´¢å¼ï¼è该è¡çâç´¢å¼å称âæ ä¸ä»å°æ¯ç©ºç½ãæ¨å¯ä»¥éå¤è¯¥æä½ï¼ç´å°éæ©äºåºå
å«å¨ç´¢å¼ä¸çææå段ï¼æå¤å¯è¾¾å°10个å段ãå
³éâç´¢å¼â对è¯æ¡åï¼ç¨äºè¯¥è¡¨çç´¢å¼å°±å»ºç«å¥½äºãæ¤åï¼æ¨è¿å¯å¨ä»»ä½æ¶åï¼æç
§ä¸é¢çæä½è¿å
¥âç´¢å¼â对è¯æ¡ä¸æ¥è§çåç¼è¾ç´¢å¼ãè¥è¦å é¤æä¸ä¸ªç´¢å¼çè¯ï¼åªéè¦å¨è¿ä¸ªå¯¹è¯æ¡çå表ä¸å°å®å é¤æå³å¯ï¼è¿ç§å é¤ä¸ä¼æ¾ç¤ºå°è¡¨ä¸çç»æä¸æ°æ®è®°å½ï¼æ¨å°½ç®¡æ¾å¿çæä½å§ï¼
åèèµæï¼http://database.51cto.com/art/200512/12960.htm