酒类销售系统

1酒类销售管理系统摘要酒类营销与其它快速消费品相比，因为进入门槛低、产品同质化严重、表面上的利润丰厚、渠道广泛、消费量具大而导致了大量资金和企业的介入，最后使得酒类营销纷繁复杂。在全国经济全面回升的影响下，我国的酒类市场也渐趋兴旺。在酒类市场蓬勃发展的趋势下，酒类品种及其丰富，各类客户在需求数量、需求品种上表现出极大差别，对销售管理的效率提出了更高的要求。而现阶段我国中小酒业销售商的销售管理工作还停留在传统手工作业上。面临这么严峻的挑战，建立一个销售管理信息系统，缩减企业的运作成本，将销售工作统一化、规范化、现代化，才能在激烈的酒类销售行业竞争中取得一席之地。本设计题目是：酒类销售管理系统。此系统用的是MicrosoftOfficeaccess2003。可以详尽、可靠地进行商品进货信息、商品销售信息、商品退货信息、客户基本信息等信息的综合查询和统计。使酒类销售企业可以摆脱每次手工书写统计的问题，实现管理计算机化，使用者通过鼠标、键盘的简单操作就能实现完整的功能，从而提高工作效率，并且节省大量人力资源。关键词：酒类销售系统；信息管理系统；MicrosoftOfficeaccess2003AbstractComparedwithotherfastconsumergoods,alcoholbeverageindustryhasrelativelowerentrybarrier,producthomogeneityserious,higherprofitinappearance,moreapproachesaswellaslargerconsumermarket.Duetolargeamountofentriesofenterprisesandinvestmentsentries,thealcoholindustryhasbecomecomplex.Withthewarmingupofthenationaleconomy,thealcoholbeverageindustryisbecomingprosperous.Theproductsshowmorediversity;thedemandsonquantityandspecificclassesdifferentiategreatlyamongdifferentconsumers.2Therefore,higherefficiencyofthesalesmanagementisindemand.However,mostsmallandmediumenterprisesinthisindustrystillemploythetraditionalapproaches.Facingthesechallenges,itisessentialtoestablishansalesmanagement(Mgt)ITsystemtocutdowntheoperationalcostandmodernizethemanagementinordertooccupycertainmarketshareinthisindustry.Thedesignentitled:HongDaliquorsalesmanagementsystem.PleaseuseMicrosoftOfficeaccess2003odesignthesystem.Thefinalsystemenablesgeneralsearchesandconsolidationsovertheinformationonprocurement,sales,andreturnsofproductsaswellasclients.Thissystemallowsenterprisestomanagethesalesactivitiesbycomputerswhichimprovestheefficiencyandsavesmanyhumanresources.Keywords:HongDaliquorsalesmanagementsystem;informationmanagementsystem;MicrosoftOfficeaccess20033目录1.绪论...................................................................................................................................41.1选题背景...............................................................................................................41.2选题意义...............................................................................................................41.3资料来源...............................................................................................................51.4系统特点...............................................................................................................52.系统分析...........................................................................................................................52.1初步调查...............................................................................................................52.2可行性分析...........................................................................................................62.3详细调查...............................................................................................................73.系统设计.........................................................................................................................153.1系统设计目标.....................................................................................................153.2系统功能结构图.................................................................................................153.3数据库设计...............................................................................................................173.4编码设计...................................................................................................................234、系统实施...........................................................................................................................244.1开发工具选择...........................................................................................................244.2软硬件环境设计.......................................................................................................244.3系统测试...................................................................................................................255.系统使用与维护说明..........................................................................................................255.1系统安装与配置.......................................................................................................255.2系统使用说明..........................................................................................................265.3系统维护...................................................................................................................315.4设计中使用的关键技术...........................................................................................326.参考文献.....................................................................................................................334酒类销售管理系统1.绪论1.1选题背景作为拥有数千年酒文化历史的中国，酒民数量高达5亿多人，酒类产品生产和消费都位居世界第一。酒渗透于整个中华五千年的文明史中，从文化娱乐到饮食烹饪、人际交往等各方面在中国人生活中都占有重要的位置。2013年我国酒类市场在全球经济回暖的情况下，产量取得大幅增长。饮料酒产量：3847.36万千升，同比增长8.66%，啤酒2939.28万千升，同比增长6.16%；白酒339.89万千升，同比增长17.88%；黄酒51.88万千升，同比增长12.31%；葡萄酒55.57万千升，同比增长66.98%；酒精460.74万千升，同比增长13.18%。酒业在产量增长的同时，经济效益均有较大幅度的下滑。在日趋激烈的市场竞争中，酒业销售公司只有在竞争中运用新的营销理念和技巧，才能在激烈的酒类行业竞争中取得一席之地