äºçº§å¯ä»¥ä»VFPï¼cè¯è¨ï¼javaï¼c++ï¼vbï¼accessï¼
ä»»éä¸ç§ï¼èè¿å³å¯ï¼æ 论èåªä¸é¢é½è¦èäºçº§å
Œ
±åºç¡ç¥è¯ã
å
Œ
±åºç¡ç¥è¯
åºæ¬è¦æ±
1.ææ¡ç®æ³çåºæ¬æ¦å¿µã
2.ææ¡åºæ¬æ°æ®ç»æåå
¶æä½ã
3.ææ¡åºæ¬æåºåæ¥æ¾ç®æ³ã
4.ææ¡éæ¥æ±ç²¾çç»æåç¨åºè®¾è®¡æ¹æ³ã
5.ææ¡è½¯ä»¶å·¥ç¨çåºæ¬æ¹æ³ï¼å
·æåæ¥åºç¨ç¸å
³ææ¯è¿è¡è½¯ä»¶å¼åçè½åã
6.ææ¡æ°æ®åºçåºæ¬ç¥è¯ï¼äºè§£å
³ç³»æ°æ®åºç设计ã
èè¯å
容
ä¸ãåºæ¬æ°æ®ç»æä¸ç®æ³
1.ç®æ³çåºæ¬æ¦å¿µï¼ç®æ³å¤æ度çæ¦å¿µåæä¹ï¼æ¶é´å¤æ度ä¸ç©ºé´å¤æ度ï¼ã
2.æ°æ®ç»æçå®ä¹ï¼æ°æ®çé»è¾ç»æä¸åå¨ç»æï¼æ°æ®ç»æçå¾å½¢è¡¨ç¤ºï¼çº¿æ§ç»æä¸é线æ§ç»æçæ¦å¿µã
3.线æ§è¡¨çå®ä¹ï¼çº¿æ§è¡¨ç顺åºåå¨ç»æåå
¶æå
¥ä¸å é¤è¿ç®ã
4.æ åéåçå®ä¹ï¼æ åéåç顺åºåå¨ç»æåå
¶åºæ¬è¿ç®ã
5.线æ§åé¾è¡¨ãååé¾è¡¨ä¸å¾ªç¯é¾è¡¨çç»æåå
¶åºæ¬è¿ç®ã
6.æ çåºæ¬æ¦å¿µï¼äºåæ çå®ä¹åå
¶åå¨ç»æï¼äºåæ çååºãä¸åºåååºéåã
7.顺åºæ¥æ¾ä¸äºåæ³æ¥æ¾ç®æ³ï¼åºæ¬æåºç®æ³ï¼äº¤æ¢ç±»æåºï¼éæ©ç±»æåºï¼æå
¥ç±»æåºï¼ã
äºãç¨åºè®¾è®¡åºç¡
1.ç¨åºè®¾è®¡æ¹æ³ä¸é£æ ¼
2.ç»æåç¨åºè®¾è®¡ã
3.é¢å对象çç¨åºè®¾è®¡æ¹æ³ï¼å¯¹è±¡ï¼æ¹æ³ï¼å±æ§å继æ¿ä¸å¤ææ§ã
ä¸ã软件工ç¨åºç¡
1.软件工ç¨åºæ¬æ¦å¿µï¼è½¯ä»¶çå½å¨ææ¦å¿µï¼è½¯ä»¶å·¥å
·ä¸è½¯ä»¶å¼åç¯å¢ã
2.ç»æååææ¹æ³ï¼æ°æ®æµå¾ï¼æ°æ®åå
¸ï¼è½¯ä»¶éæ±è§æ ¼è¯´æ书ã
3.ç»æå设计æ¹æ³ï¼æ»ä½è®¾è®¡ä¸è¯¦ç»è®¾è®¡ã
4.软件æµè¯çæ¹æ³ï¼ç½çæµè¯ä¸é»çæµè¯ï¼æµè¯ç¨ä¾è®¾è®¡ï¼è½¯ä»¶æµè¯çå®æ½ï¼åå
æµè¯ãéææµè¯åç³»ç»æµè¯ã
5.ç¨åºçè°è¯ï¼éæè°è¯ä¸å¨æè°è¯ã
åãæ°æ®åºè®¾è®¡åºç¡
1.æ°æ®åºçåºæ¬æ¦å¿µï¼æ°æ®åºï¼æ°æ®åºç®¡çç³»ç»ï¼æ°æ®åºç³»ç»ã
2.æ°æ®æ¨¡åï¼å®ä½è系模ååEâRå¾ï¼ä»EâRå¾å¯¼åºå
³ç³»æ°æ®æ¨¡åã
3.å
³ç³»ä»£æ°è¿ç®ï¼å
æ¬éåè¿ç®åéæ©ãæå½±ãè¿æ¥è¿ç®ï¼æ°æ®åºè§èåç 论ã
4.æ°æ®åºè®¾è®¡æ¹æ³åæ¥éª¤ï¼éæ±åæãæ¦å¿µè®¾è®¡ãé»è¾è®¾è®¡åç©ç设计çç¸å
³çç¥ã
èè¯æ¹å¼
1.å
Œ
±åºç¡ç¥è¯çèè¯æ¹å¼ä¸ºç¬è¯ï¼ä¸Cè¯è¨ç¨åºè®¾è®¡ï¼C++è¯è¨ç¨åºè®¾è®¡ãJavaè¯è¨ç¨åºè®¾è®¡ãVisual Basicè¯è¨ç¨åºè®¾è®¡ãVisual FoxProæ°æ®åºç¨åºè®¾è®¡æAccessæ°æ®åºç¨åºè®¾è®¡ï¼çç¬è¯é¨åå为ä¸å¼ è¯å·ï¼å
Œ
±åºç¡ç¥è¯é¨åå å
¨å·ç30åã
2.å
Œ
±åºç¡ç¥è¯æl0ééæ©é¢å5é填空é¢ã
Cè¯è¨ç¨åºè®¾è®¡
åºæ¬è¦æ±
1.çæTURBO Céæç¯å¢ã
2.çç»ææ¡ç»æåç¨åºè®¾è®¡çæ¹æ³ï¼å
·æè¯å¥½çç¨åºè®¾è®¡é£æ ¼ã
3.ææ¡ç¨åºè®¾è®¡ä¸ç®åçæ°æ®ç»æåç®æ³ã
4.TURBO Cçéæç¯å¢ä¸ï¼è½å¤ç¼åç®åçCç¨åºï¼å¹¶å
·æåºæ¬ççº éåè°è¯ç¨åºçè½åã
èè¯å
容
ä¸ãCè¯è¨çç»æ
1.ç¨åºçææï¼MAINå½æ°åå
¶ä»å½æ°ã
2.头æ件ï¼æ°æ®è¯´æï¼å½æ°çå¼å§åç»ææ å¿ã
3.æºç¨åºç书åæ ¼å¼ã
4.Cè¯è¨çé£æ ¼ã
äºãæ°æ®ç±»ååå
¶è¿ç®
1.Cçæ°æ®ç±»åï¼åºæ¬ç±»åï¼æé ç±»åï¼æéç±»åï¼ç©ºç±»åï¼åå
¶å®ä¹æ¹æ³ã
2.Cè¿ç®ç¬¦çç§ç±»ãè¿ç®ä¼å
级åç»åæ§ã
3.ä¸åç±»åæ°æ®é´ç转æ¢ä¸è¿ç®ã
4.C表达å¼ç±»åï¼èµå¼è¡¨è¾¾å¼ï¼ç®æ¯è¡¨è¾¾å¼ï¼å
³ç³»è¡¨è¾¾å¼ï¼é»è¾è¡¨è¾¾å¼ï¼æ¡ä»¶è¡¨è¾¾å¼ï¼éå·è¡¨è¾¾å¼ï¼åæ±å¼è§åã
ä¸ãåºæ¬è¯å¥
1.表达å¼è¯å¥ï¼ç©ºè¯å¥ï¼å¤åè¯å¥ã
2.æ°æ®çè¾å
¥ä¸è¾åºï¼è¾å
¥è¾åºå½æ°çè°ç¨ã
3.å¤åè¯å¥ã
4.GOTOè¯å¥åè¯å¥æ å·ç使ç¨ã
åãéæ©ç»æç¨åºè®¾è®¡
1.ç¨IFè¯å¥å®ç°éæ©ç»æã
2.ç¨SWITCHè¯å¥å®ç°å¤åæ¯éæ©ç»æã
3.éæ©ç»æçåµå¥ã
äºã循ç¯ç»æç¨åºè®¾è®¡
1.FOR循ç¯ç»æã
2.WHILEåDO WHILE循ç¯ç»æã
3.CONTINUEè¯å¥åBREAKè¯å¥ã
4.循ç¯çåµå¥ã
å
ãæ°ç»çå®ä¹åå¼ç¨
1.ä¸ç»´æ°ç»åå¤ç»´æ°ç»çå®ä¹ãåå§ååå¼ç¨
2.å符串ä¸å符æ°ç»ã
ä¸ãå½æ°
1.åºå½æ°çæ£ç¡®è°ç¨ã
2.å½æ°çå®ä¹æ¹æ³ã
3.å½æ°çç±»ååè¿åå¼ã
4.å½¢å¼åæ°ä¸å®å¨åæ°ï¼åæ°å¼çä¼ éã
5.å½æ°çæ£ç¡®è°ç¨ï¼åµå¥è°ç¨ï¼éå½è°ç¨ã
6.å±é¨åéåå
¨å±åéã
7.åéçåå¨ç±»å«ï¼èªå¨ï¼éæï¼å¯åå¨ï¼å¤é¨ï¼ï¼åéçä½ç¨ååçåæã
8.å
é¨å½æ°ä¸å¤é¨å½æ°ã
å
«ãç¼è¯é¢å¤ç
1.å®å®ä¹ï¼ä¸å¸¦åæ°çå®å®ä¹ï¼å¸¦åæ°çå®å®ä¹ã
2.âæ件å
å«âå¤çã
ä¹ãæé
1.æéä¸æéåéçæ¦å¿µï¼æéä¸å°åè¿ç®ç¬¦ã
2.åéãæ°ç»ãå符串ãå½æ°ãç»æä½çæé以åæååéãæ°ç»ãå符串ãå½æ°ãç»æä½çæéåéãéè¿æéå¼ç¨ä»¥ä¸åç±»åæ°æ®ã
3.ç¨æéä½å½æ°åæ°ã
4.è¿åæéå¼çæéå½æ°ã
5.æéæ°ç»ï¼æåæéçæéï¼MAINå½æ°çå½ä»¤è¡åæ°ã
åãç»æä½ï¼å³âç»æâï¼ä¸å
±ç¨ä½ï¼å³âèåâï¼
1.ç»æä½åå
±ç¨ä½ç±»åæ°æ®çå®ä¹æ¹æ³åå¼ç¨æ¹æ³ã
2.ç¨æéåç»æä½ææé¾è¡¨ï¼ååé¾è¡¨ç建ç«ãè¾åºãå é¤ä¸æå
¥ã
åä¸ãä½è¿ç®
1.ä½è¿ç®ç¬¦çå«ä¹å使ç¨ã
2.ç®åçä½è¿ç®ã
åäºãæ件æä½
åªè¦æ±ç¼å²æ件系ç»ï¼å³é«çº§ç£çI/Oç³»ç»ï¼ï¼å¯¹éæ åç¼å²æ件系ç»ï¼å³ä½çº§ç£çI/Oç³»ç»ï¼ä¸è¦æ±ã
1.æ件类åæéï¼FILEç±»åæéï¼ã
2.æ件çæå¼ä¸å
³éï¼FOPENï¼FCLOSEï¼ã
3.æ件ç读åï¼FPUTCï¼FGETCï¼FPUTSï¼FGETSï¼FREADï¼FWRITEï¼FPRINTFï¼FSCANFå½æ°ï¼ï¼æ件çå®ä½ï¼REWINDï¼FSEEKå½æ°ï¼ã
èè¯æ¹å¼
1.ç¬è¯ï¼120åéï¼æ»¡å100åï¼å
¶ä¸å«å
Œ
±åºç¡ç¥è¯é¨åç30åã
2.ä¸æºï¼60åéï¼æ»¡å100åã
ä¸æºæä½å
æ¬ï¼
ï¼1ï¼å¡«ç©ºã
ï¼2ï¼æ¹éã
ï¼3ï¼ç¼ç¨ã
VBä»ç»
ä¸ãVisual Basicç¨åºå¼åç¯å¢
1ãVisual Basicçç¹ç¹åçæ¬ã
2ãVisual Basicçå¯å¨ä¸éåºã
3ã主çªå£ï¼
(1)æ é¢åèåã
(2)å·¥å
·æ ã
4ãå
¶ä»çªå£ï¼
(1)çªä½è®¾è®¡å¨åå·¥ç¨èµæºç®¡çå¨ã
(2)å±æ§çªå£åå·¥å
·ç®±çªå£ã
äºã对象åå
¶æä½
1ã对象ï¼
(1)Visual Basicç对象ã
(2)对象å±æ§è®¾ç½®ã
2ãçªä½ï¼
(1)çªä½çç»æä¸å±æ§ã
(2)çªä½äºä»¶ã
3ãæ§ä»¶ï¼
(1)æ åæ§ä»¶ã
(2)æ§ä»¶çå½ååæ§ä»¶å¼ã
4ãæ§ä»¶çç»æ³ååºæ¬æä½ã
5ãäºä»¶é©±å¨ã
ä¸ãæ°æ®ç±»ååå
¶è¿ç®
1ãæ°æ®ç±»åï¼
(1)åºæ¬æ°æ®ç±»åã
(2)ç¨æ·å®ä¹çæ°æ®ç±»åã
(3)æ举类åã
2ã常éååéï¼
(1)å±é¨åéä¸å
¨å±åéã
(2)åä½ç±»ååéã
(3)缺ç声æã
3ã常ç¨å
é¨å½æ°ã
4ãè¿ç®ç¬¦ä¸è¡¨è¾¾å¼ï¼
(1)ç®æ¯è¿ç®ç¬¦ã
(2)å
³ç³»è¿ç®ç¬¦ä¸é»è¾è¿ç®ç¬¦ã
(3)表达å¼çæ§è¡é¡ºåºã
åãæ°æ®è¾å
¥ãè¾åº
1ãæ°æ®è¾åºï¼
(1)Printæ¹æ³ã
(2)ä¸Printæ¹æ³æå
³çå½æ°ï¼TabãSpcãSpace $ï¼ã
(3)æ ¼å¼è¾åºï¼Fomat$ï¼ã
2ãInputBoxå½æ°ã
3ãMsgBoxå½æ°åMsgBoxè¯å¥ã
4ãåå½¢ã
5ãæå°æºè¾åºï¼
(1)ç´æ¥è¾åºã
(2)çªä½è¾åºã
äºã常ç¨æ åæ§ä»¶
1ãææ¬æ§ä»¶ï¼
(1)æ ç¾ã
(2)ææ¬æ¡ã
2ãå¾å½¢æ§ä»¶ï¼
(1)å¾çæ¡ï¼å¾åæ¡çå±æ§ï¼äºä»¶åæ¹æ³ã
(2)å¾å½¢æ件çè£
å
¥ã
(3)ç´çº¿åå½¢ç¶ã
3ãæé®æ§ä»¶ã
4ãéæ©æ§ä»¶ï¼å¤éæ¡ååéæé®ã
5ãéæ©æ§ä»¶ï¼å表æ¡åç»åæ¡ã
6ãæ»å¨æ¡ã
7ã计æ¶å¨ã
8ãæ¡æ¶ã
9ãç¦ç¹ä¸Tab顺åºã
å
ãæ§å¶ç»æ
1ãéæ©ç»æï¼
(1)åè¡ç»ææ¡ä»¶è¯å¥ã
(2)åç»ææ¡ä»¶è¯å¥ã
(3)IIfå½æ°ã
2ãå¤åæ¯ç»æã
3ãFor循ç¯æ§å¶ç»æã
4ãå½å¾ªç¯æ§å¶ç»æã
5ãDo循ç¯æ§å¶ç»æã
6ãå¤é循ç¯ã
7ï¼GoToåæ§å¶ï¼
(1) GoToè¯å¥ã
(2) On-GoToè¯å¥ã
ä¸ãæ°ç»
1ãæ°ç»çæ¦å¿µï¼
(1)æ°ç»çå®ä¹ã
(2)éææ°ç»ä¸å¨ææ°ç»ã
2ãæ°ç»çåºæ¬æä½ï¼
(1)æ°ç»å
ç´ çè¾å
¥ãè¾åºåå¤å¶ã
(2)For Each...Nextè¯å¥ã
(3)æ°ç»çåå§åã
3ãæ§ä»¶æ°ç»ã
C++è¯è¨ç¨åºè®¾è®¡
åºæ¬è¦æ±
1. ææ¡C++è¯è¨çåºæ¬è¯æ³è§åã
2. çç»ææ¡æå
³ç±»ä¸å¯¹è±¡çç¸å
³ç¥è¯ã
3. è½å¤éç¨é¢å对象çç¼ç¨æè·¯åæ¹æ³ç¼ååºç¨ç¨åºã
4. è½çç»ä½¿ç¨Visual C++6.0éæå¼åç¯å¢ç¼ååè°åº¦ç¨åºã
èè¯å
容
ä¸ã C++è¯è¨æ¦è¿°
1. äºè§£C++è¯è¨çåºæ¬ç¬¦å·ã
2. äºè§C++è¯è¨çè¯æ±ï¼ä¿çåãæ è¯ç¬¦ã常éãè¿ç®ç¬¦ãæ ç¹ç¬¦å·çï¼ã
3. ææ¡C++ç¨åºçåºæ¬æ¡æ¶ï¼ç»æç¨åºè®¾è®¡æ¡æ¶ãé¢å对象ç¨åºè®¾è®¡æ¡æ¶çï¼ã
4. è½å¤ä½¿ç¨Visual C++ 6.0éæå¼åç¯å¢ç¼è¾ãç¼è¯ãè¿è¡ä¸è°åº¦ç¨åºã
äºã æ°æ®ç±»åã表达å¼ååºæ¬è¿ç®
1. ææ¡C++æ°æ®ç±»åï¼åºæ¬ç±»åï¼æéç±»åï¼åå
¶å®ä¹æ¤Äbr> 2. äºè§£C++ç常éå®ä¹ï¼æ´å常éï¼å符常éï¼é»è¾å¸¸éï¼å®å常éï¼å°å常éï¼ç¬¦å·å¸¸éï¼ã
3. ææ¡åéçå®ä¹ä¸ä½¿ç¨æ¹æ³ï¼åéçå®ä¹ååå§åï¼å
¨å±åéï¼å±é¨åéï¼ã
4. ææ¡C++è¿ç®ç¬¦çç§ç±»ãè¿ç®ä¼å
级åç»åæ§ã
5. çç»ææ¡C++表达å¼ç±»ååæ±å¼è§åï¼èµå¼è¿ç®ï¼ç®æ¯è¿ç®ç¬¦åç®æ¯è¡¨è¾¾å¼ï¼å
³ç³»è¿ç®ç¬¦åå
³ç³»è¡¨è¾¾å¼ï¼é»è¾è¿ç®ç¬¦åé»è¾è¡¨è¾¾å¼ï¼æ¡ä»¶è¿ç®ï¼æéè¿ç®ï¼éå·è¡¨è¾¾å¼ï¼ã
ä¸ã C++çåºæ¬è¯å¥
1. ææ¡C++çåºæ¬è¯å¥ï¼ä¾å¦èµå¼è¯å¥ã表达å¼è¯å¥ãå¤åè¯å¥ãè¾å
¥ãè¾åºè¯å¥åç©ºæ ¼è¯å¥çã
2. ç¨ifè¯å¥å®ç°åæ¯ç»æã
3. ç¨switchè¯å¥å®ç°å¤åæ¯éæ©ç»æã
4. ç¨forè¯å¥å®ç°å¾ªç¯ç»æã
5. ç¨whileè¯å¥å®ç°å¾ªç¯ç»æã
6. ç¨doâ¦whileè¯å¥å®ç°å¾ªç¯ç»æã
7. 转åè¯å¥ï¼gotoï¼continue,breakåreturnï¼ã
8. ææ¡åæ¯è¯å¥å循ç¯è¯å¥çåç§åµå¥ä½¿ç¨ã
åã æ°ç»ãæéä¸å¼ç¨
1. ææ¡ä¸ç»´æ°ç»çå®ä¹ãåå§åå访é®ï¼äºè§£å¤ç»´æ°ç»çå®ä¹ãåå§åå访é®ã
2. äºè§£å符串ä¸å符æ°ç»ã
3. çç»ææ¡å¸¸ç¨å符串å½æ°ï¼strlen,strcpy,streat,strcmp,strstrçï¼ã
4. æéä¸æéåéçæ¦å¿µï¼æéä¸å°åè¿ç®ç¬¦ï¼æéä¸æ°ç»ã
5. å¼ç¨çåºæ¬æ¦å¿µï¼å¼ç¨çå®ä¹ä¸ä½¿ç¨ã
Javaè¯è¨ç¨åºè®¾è®¡
åºæ¬è¦æ±
1. ææ¡Javaè¯è¨çç¹ç¹ï¼å®ç°æºå¶åä½ç³»ç»æã
2. ææ¡Javaè¯è¨ä¸é¢å对象çç¹æ§ã
3. ææ¡Javaè¯è¨æä¾çæ°æ®ç±»ååç»æã
4. ææ¡Javaè¯è¨ç¼ç¨çåºæ¬ææ¯ã
5. ä¼ç¼åJavaç¨æ·çé¢ç¨åºã
6. ä¼ç¼åJavaç®ååºç¨ç¨åºã
7. ä¼ç¼åJavaå°åºç¨ç¨åºï¼Appletï¼ã
8. äºè§£Javaçåºç¨ã
èè¯å
容
ä¸ãJavaè¯è¨çç¹ç¹åå®ç°æºå¶
äºãJavaä½ç³»ç»æ
1. JDKç®å½ç»æã
2. JavaçAPIç»æã
3. å¼åç¯å¢è®¾ç½®ã
4. Javaç¨åºç»æã
ä¸ãJavaè¯è¨ä¸é¢å对象çç¹æ§
1. é¢å对象ç¼ç¨çåºæ¬æ¦å¿µåç¹å¾ã
2. ç±»çåºæ¬ç»æå使ç¨ã
3. 对象ççæã使ç¨åå é¤ã
4. æ¥å£ä¸å
ã
5. Javaç±»åºç常ç¨ç±»åæ¥å£ã
åãJavaç®åæ°æ®ç±»ååè¿ç®
1. åéå常éã
2. åºæ¬æ°æ®ç±»åå转æ¢ã
3. Javaç±»åºä¸å¯¹ç®åæ°æ®ç±»åçç±»å
è£
ã
4. è¿ç®ç¬¦å表达å¼è¿ç®ã
5. æ°ç»åå符串ã
äºãJavaè¯è¨çåºæ¬è¯å¥
1. 表达å¼è¯å¥ã
2. æ¡ä»¶è¯å¥ã
3. 循ç¯è¯å¥ã
4. 注éè¯å¥ã
5. å¼å¸¸å¤çã
å
ãJavaç¼ç¨ææ¯åºç¡
1. 线ç¨çæ¦å¿µå使ç¨ã
2. åæ¥ä¸å
±äº«ã
3. 串è¡åæ¦å¿µåç®çã
4. 串è¡åæ¹æ³ã
5. 串è¡åç举ä¾ã
6. åºäºææ¬çåºç¨ã
7. æ件åæ件I/Oã
8. æ±éï¼collectionsï¼æ¥å£ã
ä¸ãç¼åç¨æ·çé¢ç¨åº
1. å¾å½¢ç¨æ·çé¢ã
2. AWTåºç®ä»ã
3. Swingç®ä»ã
4. AWTä¸Swingæ¯è¾ã
å
«ãç¼åå°åºç¨ç¨åºï¼Appletï¼
1. å°åºç¨ç¨åºæ¦å¿µã
2. å®å
¨æºå¶ã
3. Appletæ§è¡è¿ç¨ã
4. Appletçå¾å½¢ç»å¶ã
5. Appletççªå£ã
6. Appletçå·¥ä½ç¯å¢ã
7. Java ApplicationåAppletã
ä¹ãJavaçåºç¨
åãJ2DKçä¸è½½åæä½
èè¯æ¹å¼
1. ç¬è¯ï¼90åéï¼æ»¡å100åï¼å
¶ä¸å«å
Œ
±åºç¡ç¥è¯é¨åç30åã
2. ä¸æºæä½ï¼90åéï¼æ»¡å100åã
ä¸æºé¢ç®ç±»åè¦æ±ï¼
ï¼1ï¼ åºæ¬æä½ã
ï¼2ï¼ ç®ååºç¨ã
3 综ååºç¨
Accessæ°æ®åºç¨åºè®¾è®¡
åºæ¬è¦æ±
1ã å
·ææ°æ®åºç³»ç»çåºç¡ç¥è¯ã
2ã åºæ¬äºè§£é¢å对象çæ¦å¿µã
3ã ææ¡å
³ç³»æ°æ®åºçåºæ¬åçã
4ã ææ¡æ°æ®åºç¨åºè®¾è®¡æ¹æ³ã
5ã è½ä½¿ç¨Access建ç«ä¸ä¸ªå°åæ°æ®åºåºç¨ç³»ç»ã
èè¯å
容
ä¸ãæ°æ®åºåºç¡ç¥è¯
1ã åºæ¬æ¦å¿µï¼
æ°æ®åºï¼æ°æ®æ¨¡åï¼æ°æ®åºç®¡çç³»ç»ï¼ç±»å对象ï¼äºä»¶ã
2ã å
³ç³»æ¨¡åï¼å®ä½çå®æ´æ§ï¼åç
§çå®æ´æ§ï¼ç¨æ·å®ä¹çå®æ´æ§ï¼å
³ç³»æ¨¡å¼ï¼å
³ç³»ï¼å
ç»ï¼å±æ§ï¼å段ï¼åï¼å¼ï¼ä¸»å
³é®åçã
3ã å
³ç³»è¿ç®åºæ¬æ¦å¿µï¼
éæ©è¿ç®ï¼æå½±è¿ç®ï¼è¿æ¥è¿ç®ã
4ã SQLåºæ¬å½ä»¤ï¼æ¥è¯¢å½ä»¤ï¼æä½å½ä»¤ã
5ã Accessç³»ç»ç®ä»ï¼
ï¼1ï¼Accessç³»ç»çåºæ¬ç¹ç¹ã
ï¼2ï¼åºæ¬å¯¹è±¡ï¼è¡¨ï¼æ¥è¯¢ï¼çªä½ï¼æ¥è¡¨ï¼é¡µï¼å®ï¼æ¨¡åã
äºãæ°æ®åºå表çåºæ¬æä½
1ã å建æ°æ®åºï¼
ï¼1ï¼å建空æ°æ®åºã
ï¼2ï¼ä½¿ç¨å导å建æ°æ®åºã
2ã 表ç建ç«ï¼
ï¼1ï¼ å»ºç«è¡¨ç»æï¼ä½¿ç¨å导ï¼ä½¿ç¨è¡¨è®¾è®¡å¨ï¼ä½¿ç¨æ°æ®è¡¨ã
ï¼2ï¼ è®¾ç½®å段å±æ§ã
ï¼3ï¼ è¾å
¥æ°æ®ï¼ç´æ¥è¾å
¥æ°æ®ï¼è·åå¤é¨æ°æ®ã
3ã 表é´å
³ç³»ç建ç«ä¸ä¿®æ¹ï¼
ï¼1ï¼ è¡¨é´å
³ç³»çæ¦å¿µï¼ä¸å¯¹ä¸ï¼ä¸å¯¹å¤ã
ï¼2ï¼ è®¾ç½®åç
§å®æ´æ§ã
ï¼3ï¼ å»ºç«è¡¨é´å
³ç³»ã
4ã 表çç»´æ¤ï¼
ï¼1ï¼ ä¿®æ¹è¡¨ç»æï¼æ·»å å段ï¼ä¿®æ¹å®æ®µï¼å é¤å段ï¼éæ°è®¾ç½®ä¸»å
³é®åã
ï¼2ï¼ ç¼è¾è¡¨å
容ï¼æ·»å è®°å½ï¼ä¸ªæ§è®°å½ï¼å é¤è®°å½ï¼å¤å¶è®°å½ã
ï¼3ï¼ è°æ´è¡¨å¤è§ã
5ã 表çå
¶ä»æä½ï¼
ï¼1ï¼ æ¥æ¾æ°æ®ã
ï¼2ï¼ æ¿æ¢æ°æ®ã
ï¼3ï¼ æåºè®°å½ã
ï¼4ï¼ çéè®°å½ã
ä¸ãæ¥è¯¢çåºæ¬æä½
1ãæ¥è¯¢åç±»
ï¼1ï¼ éæ©æ¥è¯¢ã
ï¼2ï¼ åæ°æ¥è¯¢ã
ï¼3ï¼ äº¤å表æ¥è¯¢ã
ï¼4ï¼ æä½æ¥è¯¢ã
ï¼5ï¼ SQLæ¥è¯¢ã
2ãæ¥è¯¢åå
ï¼1ï¼ è¿ç®ç¬¦ã
ï¼2ï¼ å½æ°ã
ï¼3ï¼ è¡¨è¾¾å¼ã
3ãå建æ¥è¯¢
ï¼1ï¼ æä½å·²å建çæ¥è¯¢
ï¼2ï¼ ç¼è¾æ¥è¯¢ä¸çå段ã
ï¼3ï¼ ç¼è¾æ¥è¯¢ä¸çæ°æ®æºã
ï¼4ï¼ æåºæ¥è¯¢çç»æã
åãçªä½çåºæ¬æä½
1ã çªä½åç±»ï¼
ï¼1ï¼ çºµæ å¼çªä½
ï¼2ï¼ è¡¨æ ¼å¼çªä½
ï¼3ï¼ ä¸»/åçªä½
ï¼4ï¼ æ°æ®è¡¨çªä½
ï¼5ï¼ å¾è¡¨çªä½
ï¼6ï¼ æ°æ®éè§è¡¨çªä½
2ã å建çªä½ï¼
ï¼1ï¼ ä½¿ç¨å导å建çªä½ã
ï¼2ï¼ ä½¿ç¨è®¾è®¡å¨å建çªä½ï¼æ§ä»¶çå«ä¹åç§ç±»ï¼å¨çªä½ä¸æ·»å åä¿®æ¹æ§ä»¶ï¼è®¾ç½®æ§ä»¶ç常è§å±æ§ã
äºãæ¥è¡¨çåºæ¬æä½
1ãæ¥è¡¨åç±»ï¼
ï¼1ï¼ çºµæ å¼æ¥è¡¨ã
ï¼2ï¼ è¡¨æ ¼å¼æ¥è¡¨ã
ï¼3ï¼ å¾è¡¨æ¥è¡¨ã
ï¼4ï¼ æ ç¾æ¥è¡¨ã
2ã使ç¨å导å建æ¥è¡¨ã
3ã使ç¨è®¾è®¡å¨ç¼è¾æ¥è¡¨ã
4ãå¨æ¥è¡¨ä¸è®¡ç®åæ±æ»ã
å
ã页çåºæ¬æä½
1ãæ°æ®è®¿é®é¡µçæ¦å¿µã
2ãå建æ°æ®è®¿é®é¡µï¼
ï¼1ï¼ èªå¨å建æ°æ®è®¿é®é¡µã
ï¼2ï¼ ä½¿ç¨å导æ°æ®è®¿é®é¡µã
ä¸ãå®
1ãå®çåºæ¬æ¦å¿µã
2ãå®çåºæ¬æä½ï¼
ï¼1ï¼ å建å®ï¼å建ä¸ä¸ªå®ï¼å建å®ç»ã
ï¼2ï¼ è¿è¡å®ã
ï¼3ï¼ å¨å®ä¸ä½¿ç¨æ¡ä»¶ã
ï¼4ï¼ è®¾ç½®å®æä½åæ°ã
ï¼5ï¼ å¸¸ç¨çå®æä½ã
å
«ã模å
1ã模åçåºæ¬æ¦å¿µï¼
ï¼1ï¼ ç±»æ¨¡åã
ï¼2ï¼ æ å模åã
ï¼3ï¼ å°å®è½¬æ¢ä¸ºæ¨¡åã
2ãå建模åï¼
ï¼1ï¼ å建VBA模åï¼å¨æ¨¡åä¸å å
¥è¿ç¨ï¼å¨æ¨¡åä¸æ§è¡å®ã
ï¼2ï¼ ç¼åäºä»¶è¿ç¨ï¼é®çäºä»¶ï¼é¼ æ äºä»¶ï¼çªå£äºä»¶ï¼æä½äºä»¶åå
¶ä»äºä»¶ã
3ãè°ç¨ååæ°ä¼ éã
4ãVBAç¨åºè®¾è®¡åºç¡ï¼
ï¼1ï¼ é¢å对象ç¨åºè®¾è®¡çåºæ¬æ¦å¿µã
ï¼2ï¼ VBAç¼ç¨ç¯å¢ï¼è¿å
¥VBEï¼BEçé¢ã
ï¼3ï¼ VBAç¼ç¨åºç¡ï¼å¸¸éï¼åéï¼è¡¨è¾¾å¼ã
ï¼4ï¼ VBAç¨åºæµç¨æ§å¶ï¼é¡ºåºæ§å¶ï¼éæ©æ§å¶ï¼å¾ªç¯æ§å¶ã
ï¼5ï¼ VBAç¨åºçè°è¯ï¼è®¾ç½®æç¹ï¼åæ¥è·è¸ªï¼è®¾ç½®çè§ç¹ã
èè¯æ¹å¼
1ãç¬è¯ï¼90åéï¼æ»¡å100åï¼å
¶ä¸å«å
Œ
±åºç¡ç¥è¯é¨åç30åã
2ãä¸æºæä½ï¼90åéï¼æ»¡å100åã
ä¸æºæä½å
æ¬ï¼
ï¼1ï¼ åºæ¬æä½ã
ï¼2ï¼ ç®ååºç¨ã
ï¼3ï¼ ç»¼ååºç¨
2005年计ç®æºç级èè¯äºçº§Visual FoxProï¼VFPï¼èè¯å¤§çº²
åºæ¬è¦æ±
1.å
·ææ°æ®åºç³»ç»çåºç¡ç¥è¯ã
2.åºæ¬äºè§£é¢å对象çæ¦å¿µã
3.ææ¡å
³ç³»æ°æ®åºçåºæ¬åçã
4.ææ¡æ°æ®åºç¨åºè®¾è®¡æ¹æ³ã
5.è½å¤ä½¿ç¨Visual FoxPro建ç«ä¸ä¸ªå°åçæ°æ®åºåºç¨ç³»ç»ã
èè¯å
容
ä¸ãVisual Foxproçåºç¡ç¥è¯
1.åºæ¬æ¦å¿µï¼æ°æ®åºï¼æ°æ®æ¨¡åï¼æ°æ®åºç®¡çç³»ç»ãç±»å对象ãäºä»¶ãæ¹æ³ã
2.å
³ç³»æ°æ®åºï¼
(1)å
³ç³»æ°æ®åºï¼å
³ç³»æ¨¡åãå
³ç³»æ¨¡å¼ãå
³ç³»ãå
ç»ãå±æ§ãåã主å
³é®ååå¤é¨å
³é®åã
(2)å
³ç³»è¿ç®ï¼æå½±ãéæ©ãèæ¥ã
(3)æ°æ®åºçä¸è´æ§åå®æ´æ§ï¼å®ä½å®æ´æ§ãåå®æ´æ§ãåç
§å®æ´æ§ã
3.Visual FoxProç³»ç»ç¹ç¹ä¸å·¥ä½æ¹å¼ï¼
(1)Windowsçæ¬çæ°æ®åºç¹ç¹ã
(2)æ°æ®ç±»åå主è¦æ件类åã
(3)åç§è®¾è®¡å¨åå导ã
(4)å·¥ä½æ¹å¼ï¼äº¤äºæ¹å¼ï¼å½ä»¤æ¹å¼ãå¯è§åæä½ï¼åç¨åºè¿è¡æ¹å¼ã
4.Visual Foxproçåºæ¬æ°æ®å
ç´ ï¼
(1)常éãåéã表达å¼ã
(2)常ç¨å½æ°ï¼å符å¤çå½æ°ãæ°å¼è¿ç®å½æ°ãæ¥ææ¶é´å½æ°ãæ°æ®ç±»å转æ¢å½æ°ãæµè¯å½æ°ã
äºãVisual FoxProæ°æ®åºçåºæ¬æä½
1.æ°æ®åºå表ç建ç«ãä¿®æ¹ä¸æææ§æ£éªï¼
(1)表ç»æç建ç«ä¸ä¿®æ¹ã
(2)表记å½çæµè§ãå¢å ãå é¤ä¸ä¿®æ¹ã
(3)å建æ°æ®åºï¼åæ°æ®åºæ·»å æä»æ°æ®åºå é¤è¡¨ã
(4)设å®å段级è§ååè®°å½çº§è§åã
(5)表çç´¢å¼ï¼ä¸»ç´¢å¼ãåéç´¢å¼ãæ®éç´¢å¼ãå¯ä¸ç´¢å¼ã
2.å¤è¡¨æä½ï¼
(1)éæ©å·¥ä½åºã
(2)建ç«è¡¨ä¹é´çå
³èï¼ä¸å¯¹ä¸å
³èãä¸å¯¹å¤å
³èã
(3)设置åç
§çå®æ´æ§ã
(4)表çèæ¥JOINï¼
å
é¨èæ¥
å¤é¨è¿æ¥ï¼å·¦èæ¥ãå³èæ¥ãå®å
¨èæ¥ã
(5)建ç«è¡¨é´ä¸´æ¶å
³ç³»ã
3.建ç«è§å¾ä¸æ°æ®æ¥è¯¢ï¼
(1)æ¥è¯¢æ件ç建ç«ãæ§è¡ä¸ä¿®æ¹ã
(2)è§å¾æ件ç建ç«ãæ¥çä¸ä¿®æ¹ã
(3)建ç«å¤è¡¨æ¥è¯¢ã
ä¸ãå
³ç³»åæ°æ®åºæ åè¯è¨SQL
1ãSQLçæ°æ®å®ä¹åè½ï¼
(1)CREATETABLEï¼SQLã
(2)ALTERTABLEï¼SQLã
2.SQLçæ°æ®ä¿®æ¹åè½ï¼
(1)ç®åæ¥è¯¢ã
(2)åµå¥æ¥è¯¢ã
(3)èæ¥æ¥è¯¢ã
(4)åç»ä¸è®¡ç®æ¥è¯¢ã
(5)éåç并è¿ç®ã
åã项ç®ç®¡çå¨ã设计å¨åå导ç使ç¨
1.使ç¨é¡¹ç®ç®¡çå¨ï¼
(1)使ç¨âæ°æ®âé项å¡ã
(2)使ç¨âææ¡£âé项å¡ã
2.使ç¨è¡¨å设计å¨ï¼
(1)å¨è¡¨åä¸å å
¥åä¿®æ¹æ§ä»¶å¯¹è±¡ã
(2)设å®æ°æ®ç¯å¢ã
3.使ç¨èå设计å¨ï¼
(1)建ç«ä¸»é项ã
(2)设计åèåã
(3)设å®èåé项ç¨åºä»£ç ã
4.使ç¨æ¥è¡¨è®¾è®¡å¨ï¼
(1)çæå¿«é表ã
(2)ä¿®æ¹æ¥è¡¨å¸å±ã
(3)设计åç»æ¥è¡¨ã
(4)设计å¤æ æ¥è¡¨ã
5.使ç¨åºç¨ç¨åºå导ã
äºãVisual FoxProç¨åºè®¾è®¡
1ãå½ä»¤æ件建ç«ä¸è¿è¡ï¼
(1)ç¨åºæ件建ç«ã
(2)ç®åç交äºæ¹å¼è¾å
¥è¾åºå½ä»¤ã
(3)åºç¨ç¨åºçè°è¯ä¸æ§è¡ã
2.ç»æåç¨åºè®¾è®¡ï¼
(1)顺åºç»æç¨åºè®¾è®¡ã
(2)åæ¯ç»æç¨åºè®¾è®¡ã
(3)循ç¯ç»æç¨åºè®¾è®¡ã
3.è¿ç¨ä¸è¿ç¨è°ç¨ï¼
(1)åç¨åºè®¾è®¡ä¸è°ç¨ã
(2)è¿ç¨ä¸è¿ç¨æ件ã
(3)å±é¨åéåå
¨å±åéãè¿ç¨è°ç¨ä¸çåæ°ä¼ éã
èè¯æ¹å¼
1.ç¬è¯ï¼90åéã
2.ä¸æºèè¯ï¼90åéã
ä¸æºæä½å
æ¬ï¼
(1)åºæ¬æä½ã
(2)ç®ååºç¨ã
(3)综ååºç¨ã
å
¶ä¸ VFPï¼ACCESSé½å¾ç®åï¼vfpæ¯è¿å
³çæé«ç
å¸æå¯¹ä½ ææ帮å©
温馨提示:答案为网友推荐,仅供参考