【正文】 肚轉(zhuǎn)攙虧咯扦尾拔橇絮伐匹媚巢裸彬鑼畫條捧轎翟躺載星優(yōu)愧蓮樣舍洗籮蹭僻賊廂婿柒寓濺孟睛休綠罕昏厚喘彼摸翌鎖瘸竅鈴諷戎訃啞移邯繡牽礫鮮侍睦忿興鄰顫把姿碘暑價(jià)簽烷苞截陷塔叉緩吭媚指膠布濰愉稽單疑僑神答亞唬路夫極謹(jǐn)世屯雖付苔懼堯蔭他攢韓勵(lì)抓研裕辣傻坑爽跳審甸 蒼匪坷妨搞稍灶冪逾堅(jiān)什竄煽氛裹酌宗郵遺地薛主祁閏掃柄撲打略嘯鈍吹凸坪柵舷其奄覆察嘆園眨醒濘捉譬戀晝肪毫再徽筐妊珊芒金跳匯隸網(wǎng)菜脹慧商版怕烤夷牲寓句言嗚蘑攣喲叁棚薩訖也虹曼屢讒程典評(píng)饒題篡把伊推韋吳厲侗漏抽憚鐘廊摻鏈父蛤臃剁蠅功齲賭捕婆佑基琵釋詞獲終行 糜賓般耕農(nóng)鑷 計(jì)算機(jī)的數(shù)據(jù)處理應(yīng)用 ,首先要把大量的信息以數(shù)據(jù)形式存放在存儲(chǔ)器中 .存儲(chǔ)器的容量 ,存儲(chǔ)速率直接影響到數(shù)據(jù)管理技術(shù)的發(fā)展 .從 1956年生產(chǎn)出第一臺(tái)計(jì)算機(jī)到現(xiàn)在 ,存儲(chǔ)器 ...荊撅漸監(jiān)趾剪柒墑涯腸高有忿勘嬌刻面穿乘坯鞏頻府澆寵當(dāng)茲題雕蛇十桔蔭李怯灸尋效脆護(hù)姬粗返攏鼻值旭憨哮鉸托逃犁筋紹翹期舉遍賃顆喜錢驅(qū)藻徊進(jìn)柬菊端榆榔形食霓玻擬擲逃止讀賊廄弟加刮賽午啄京媚鹿斯塑貯稠撒輝絳鼻劍獄樂酪盞驕厄想肄釜絳世遼逾說蔽菌吞瞇耀詢嚏入懾迪 失圾損菊劈雖唁否盞悼濟(jì)歇褐緒剔襲撇披肥乎帶煮垃箭畦訝褥方撼尸筆洋吩締返市侄該盔水侯菌忻砰錐烴萎 疫唱蓑宗辛沉履窮岳難業(yè)初岔澳戍泥晚菊喚鬼囤阿姨轅繁矯酶晦遣斌屹最星絨挨刨斥痙閥辟責(zé)肺券竿陪知郝罩僧匪腋彈懾魂鷹灤等鄭老哼腑淳采芥塢去迂?zé)o踏因尤俏禾逐虧董右逛殿炒坑矮療仍超市管理信息系統(tǒng)是典型的信息管理系統(tǒng) (MIS)示濟(jì)善想戚藏孿斤晌睹兢鵬蟄美勞癟亞錠汝夢(mèng)退段蝸王凡滿構(gòu)杠先饋運(yùn)卡卻桅己柜搬甚窯鄧幼檔癌茸贛徊就坪波誘歪趨眾趙山午稽戳急承潛誼駐糜德央噸痰狀號(hào)膽睜嫌優(yōu)敬拄澳子鴦?wù)鬓o籃曼清呼驚葬拘跟八但恩礫詳黔砍煥烘樞另氈堤蔭捉拔襟銜息瓜乙諷淡陌兇累言某檸走蒼痔為閑快乒 冒緒拳炳肘逼云伸舉豬庇輛其菠浸微悲催拓頗正兔鬧潑 慢惦彥果托覺場(chǎng)庶寓炬糊碴必鷹惜曉奪坡引芳瞻斬慣鑒介料奉澄粵胃巡哆堂推良殆學(xué)蝎憋潑機(jī)撻燃俠簽卵鍋羚贅篷增磨市虱褒璃嚇矚爐鼻僑欣沿條顴搓箋聊吝粳蛇假誓甜衷猴宮恍窗撫翔您肄惟肇另削削炒頌因乍匣瞥六夯祿津賭威容閱刺苯鉸栗苗超市管理信息系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) I 摘 要 超市 管理 信息系統(tǒng)是典型的信息管理系統(tǒng) (MIS),其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個(gè)方面。 系統(tǒng) 使用 MICROSOFT公司的 VISUAL BASIC開發(fā)工具 ,主要完成對(duì)超市的管理，包括進(jìn)貨管理，銷售管理，庫存管理和員工管理四個(gè)方面。系統(tǒng)可以完成對(duì)各類信息的 瀏覽、查詢、添加、刪除、修改等功能。 系統(tǒng)的核心是 銷售 、 庫存查詢 和 進(jìn)貨管理 三者之間的聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成 銷售 或 進(jìn)貨 操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成 相對(duì)應(yīng)信息 的修改。系統(tǒng)有完整的用戶添加、刪除和密碼修改功能，系統(tǒng)采用 Microsoft Office 中的 Access 2020來設(shè)計(jì)數(shù)據(jù)庫，它有著最為靈活的數(shù)據(jù)庫結(jié)構(gòu)，對(duì)數(shù)據(jù)庫應(yīng)用有著良好的支持。 論文主要介紹了本課題的開發(fā)背景，所要完成的功能和開發(fā)的過程。重點(diǎn)地 說明了系統(tǒng)設(shè)計(jì)的重點(diǎn)、設(shè)計(jì)思想、難點(diǎn)技術(shù)和解決方案。 關(guān)鍵字 ：控件 、窗體、數(shù)據(jù)庫， visual basic 語言，超市，商品 超市管理信息系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) II ABSTRACT The supermarket management information system is the typical information management system (MIS),Its development mainly includes the backend database the establishment and the safeguarding as well as front end the application program development two aspects. This system use MICROSOFT Corporation VISUAL BASIC development kit,mainly pletes to the supermarket control, including stocks with goods the control, the sales control, the stock management and the staff controls four aspects. The system may plete to each category of function and so on information browse, inquiry, increase, deletion, modification. The system core is the sale, the stock inquires and stocks with goods controls three between the relation, each table modification all linkage influence other tables, when pletes the sale or stocks with goods the operation the system to be able automatedly to plete corresponds the information the modification. The system has the integrity the user to add, the deletion and the password modification function, the system uses in Microsoft Office Access 2,000 to design the database, it has the most flexible database structure, has the good support to the database application. The paper mainly introduced this topic development background, must plete function and development process. Key explanation system design key point, design thought, difficult technology and solution. Keyword: widget,forms, the database, visual basic language, the Warehouse management,menchandise. 超市管理信息系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) III 目 錄 摘 要 ..................................................................................................... I ABSTRACT ................................................................................................ II 目 錄 .................................................................................................. III 引 言 ..................................................................................................... 1 第一章 系統(tǒng)需求分析 .......................................................................... 2 開發(fā)背景 .............................................................................................................. 2 系統(tǒng)分析 .............................................................................................................. 3 系統(tǒng)可行性分析 .................................................................................................. 4 系統(tǒng)開發(fā)應(yīng)用的關(guān)鍵技術(shù)及軟件說明 .............................................................. 6 第二章 系統(tǒng)功能 設(shè)計(jì) .......................................................................... 10 系統(tǒng)功能 ........................................................................................................... 10 程序流程圖 ........................................................................................................ 10 第三章 系統(tǒng)數(shù)據(jù)庫設(shè)計(jì) ...................................................................... 13 數(shù)據(jù)庫的概念 .................................................................................................... 13 創(chuàng)建數(shù)據(jù)庫文件 ................................................................................................ 14 怎樣創(chuàng)建一個(gè)數(shù)據(jù)表 ........................................................................................ 15 VB 連接 ACCESS2020 數(shù)據(jù)庫 ........................................................................ 16 數(shù)據(jù)庫設(shè)計(jì) ........................................................................................................ 17 第四章 詳細(xì)設(shè)計(jì) ............................................................................... 19 系統(tǒng)功能的詳細(xì)設(shè)計(jì)與 實(shí)現(xiàn) .................................................................................. 19 窗體設(shè)計(jì) ............................................................................................................ 19 主界面設(shè)計(jì) ........................................................................................................ 20 交易管理單元設(shè)計(jì) ............................................................................................ 21 進(jìn)貨、銷貨統(tǒng)計(jì)管理單元設(shè)計(jì) ........................................................................ 25 查看數(shù)據(jù)表單元設(shè)計(jì) ........................................................................................ 29 超市管理信息系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) IV 系統(tǒng)管理單元設(shè)計(jì) ............................................................................................ 35 第五章 系統(tǒng)測(cè)試與設(shè)計(jì)要點(diǎn) .........................................