Õª Òª
 Ëæ×ÅÏÖ´ú¹¤ÒµµÄ·¢Õ¹£¬¼ÆËã»úÐÅÏ¢¹ÜÀíϵͳԽÀ´Ô½Êܵ½ÆóÒµÖØÊÓ¡£±¾ÎÄÖ÷Òª·ÖÎöÁË¿â´æ¹ÜÀíϵͳµÄһЩ»ù±¾¹¦ÄܺÍ×é³ÉÇé¿ö£¬°üÀ¨ÏµÍ³µÄÐèÇó·ÖÎö¡¢ÏµÍ³½á¹¹£¬¹¦ÄÜÄ£¿é»®·ÖÒÔ¼°Êý¾Ý¿âģʽ·ÖÎöµÈ£¬Öصã¶ÔÓ¦ÓóÌÐòµÄʵ¼Ê¿ª·¢ÊµÏÖ×÷Á˽éÉÜ¡£´ïµ½ÁËÊý¾ÝµÄÒ»ÖÂÐԺͰ²È«ÐÔ£¬ÇÒÓ¦ÓóÌÐò¹¦ÄÜÍ걸£¬·ûºÏÁË¿â´æ¹ÜÀíϵͳ×÷ΪµäÐ͵ÄÐÅÏ¢¹ÜÀíϵͳ(MIS)µÄÒªÇó¡£Í¬Ê±¼òµ¥½éÉÜÁËVisual Basic±à³Ì»·¾³ºÍAccessÊý¾Ý¿â¹ÜÀíϵͳµÄ¹¦ÄÜÌص㣬¿â´æ¹ÜÀíϵͳÊÇÆóÒµÎïÁ÷¹ÜÀíÖв»¿É»òȱµÄÒ»²¿·Ö¡£

¹Ø¼ü´Ê£º¿â´æ¹ÜÀí£¬Êý¾Ý¿â£¬ÐÅÏ¢¹ÜÀí£¬VB

Abstract
With the development of modern industry, the information management system of the computer is being paid attention to by enterprises. This text has analysed some basic functions of the administrative system of the stock and makes up the situation mainly, including the systematic demand is analysed, systematic structure, the function module divides and the data base mode is analysed etc., have realized doing the introduction to the actual development of the application program especially. Having reached the consistency and security of the data, and the application program function is complete, have accorded with the administrative system of the stock as the request for the typical information management system (MIS). Introduced the function characteristics of Visual Basic programming environment and Access data base management system briefly at the same time, the administrative system of the stock is an indispensable part in enterprise's material flow management.

Keywords: stock management, database, information management, VB

Ä¿    ¼
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª

µÚÒ»Õ  Ð÷ÂÛÇø ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  2
1.1¹ÜÀíÐÅϢϵͳµÄ¸ÅÊö   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  2
1.2Êý¾Ý¿âÓ¦ÓÃϵͳ¿ª·¢¼ò½é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  3
1.3¿â´æ¹ÜÀíϵͳ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   4
1.3.1¹úÄÚÍâͬÀà¹ÜÀíÈí¼þµÄÑо¿ÏÖ×´Óë·¢Õ¹Ç÷ÊÆ  ¡­¡­¡­¡­¡­¡­   7
1.3.2¿â´æ¹ÜÀíϵͳÑо¿±³¾°ÓëÒâÒå ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  9

µÚ¶þÕ Êý¾Ý¿âÀíÂÛ»ù´¡ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  10
2.1Êý¾Ý¿âϵͳÉè¼Æ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  10
2.2SQLÓïÑÔ½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 15
2.2.1SQL»ù´¡  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 18
2.2.2SQLÓï¾ä  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  20

µÚÈýÕ  Ó¦ÓÃϵͳ¿ª·¢¹¤¾ß  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  22
3.1 Visual Basic¼ò½é¼°ÊµÏÖÔ­Àí ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  22
3.2 Êý¾Ý¿â×é¼þ½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   27
3.3 SQLÓïÑÔÔÚVBÖеÄÓ¦Óà ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  31
3.4Access2000¼òÊö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  32

µÚËÄÕ   ¿â´æ¹ÜÀíϵͳÉè¼Æ·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   35
4.1ÐèÇó·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  35
4.2Ä£¿é»®·Ö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  36
4.3Êý¾Ý¿âÉè¼Æ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  36
µÚÎåÕ   Ó¦ÓóÌÐòÉè¼Æ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 38
5.1³ÌÐò½á¹¹ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 39
5.2³ÌÐòÔ´´úÂë ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 40

µÚÁùÕ Éè¼Æ×Ü½á ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 42

л ´Ç  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 43

²Î¿¼ÎÄÏ× ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 44
 
µÚÒ»Õ Ð÷ÂÛ

¿â´æ¹ÜÀíϵͳÊÇÒ»¸öÆóÊÂÒµµ¥Î»²»¿ÉȱÉÙµÄÒ»²¿·Ö,ËüµÄÄÚÈݶÔÓÚÆóÒµµÄ¾ö²ßÕߺ͹ÜÀíÕßÀ´Ëµ¶¼ÊÇÖÁ¹ØÖØÒªµÄ£¬Òò´Ë£¬¿â´æ¹ÜÀíϵͳӦ¸ÃÄܹ»ÎªÓû§Ìṩ³ä×ãµÄÐÅÏ¢ºÍ¿ì½ÝµÄ²éѯÊֶΣ¬µ«Ò»Ö±ÒÔÀ´ÈËÃÇʹÓô«Í³µÄÈ˹¤·½Ê½¹ÜÀí¿â´æ£¬ÕâÖÖ¹ÜÀí·½Ê½´æÔÚ×ÅÐí¶àȱµã£¬ÖîÈçЧÂʵͣ¬±£ÃÜÐÔ²îµÈ£¬¶øÇÒʱ¼äÒ»³¤£¬½«²úÉú´óÁ¿µÄÎļþºÍÊý¾Ý£¬Õâ¶ÔÓÚ²éÕÒ¡¢¸üкÍά»¤¶¼´øÀ´Á˲»ÉÙµÄÀ§ÄÑ¡£
Ëæ×Å¿Æѧ¼¼ÊõµÄ²»¶ÏÌá¸ß£¬¼ÆËã»ú¿Æѧ²»¶Ï·¢Õ¹£¬ÆäÇ¿´óµÄ¹¦ÄÜÒѾ­±»ÈËÃÇÉî¿ÌÈÏʶ£¬ËüÒѾ­½øÈëÁËÈËÀàÉç»áµÄ¸÷¸öÁìÓò²¢·¢»Ó×ÅÔ½À´Ô½ÖØÒªµÄ×÷Óá£
×÷Ϊ¼ÆËã»úÓ¦ÓõÄÒ»²¿·Ö£¬Ê¹ÓüÆËã»ú¶Ô²úÆ·¿â´æÐÅÏ¢½øÐйÜÀí£¬¾ßÓÐ×ÅÈ˹¤¹ÜÀíÎÞ·¨±ÈÄâµÄÓŵ㣬Ëü¼ìË÷ѸËÙ¡¢²éÕÒ·½±ã¡¢¿É¿¿ÐԸߡ¢´æ´¢Á¿´ó¡¢±£ÃÜÐԺá¢ÊÙÃü³¤¡¢³É±¾µÍµÈ£¬¿É¼õÉÙ¸ü¶àµÄÈËÁ¦ÎïÁ¦£¬ÕâЩ¶¼Äܹ»¼«´óµØÌá¸ß»õÆ·¿â´æµÄ¹ÜÀíЧÂÊ£¬Ò²ÊÇÆóÒµ¿â´æ¹ÜÀí¿Æѧ»¯¡¢Õý¹æ»¯£¬ÓëÊÀ½ç½Ó¹ìµÄÖØÒªÌõ¼þ¡£Òò´Ë£¬¿ª·¢Ò»¸ö¿â´æ¹ÜÀíϵͳÊǺÜÓбØÒªµÄ£¬¾ßÓÐÆäÌØÓеļ¼ÊõÒâÒåºÍ¹ÜÀíÒâÒå¡£