摘要
介绍了利用Excel VBA设计和开发低值易耗品经费管理信息系统。该系统实现了低值易耗品计划审批信息和实际付款信息的输入、查询、修改,以及低值易耗品经费的信息统计、查询、浏览、汇总和预警等功能。目前,该系统已在工作中成功应用,为管理层提供了及时准确的信息,为进一步提高低值易耗品信息化管理水平提供了有力的保障。
Introduces the Funds Management Information System of Low Value and Easy Consumption Experimentation Articles that developed by using Excel VBA.The system includes such functions as information input,inquiries,modification of examination and approval of low value and easy consumption experimentation articles plans and the actual payment,and information statistics,inquiries,browsing,summarizing,warning.At present,the system is successfully used in the funds management.It provides key information in an accurate and timely fashion for managers,and offers further strong guarantee for improving the information management levels of low value and easy consumption experimentation articles.
出处
《广东石油化工学院学报》
2011年第1期55-58,共4页
Journal of Guangdong University of Petrochemical Technology
基金
湛江市科技攻关项目(2008C09025)
湛江师范学院社科科研项目(W0719)
关键词
低值易耗品
实验室经费
EXCEL
VBA
管理信息系统
Low Value and Easy Consumption Experimentation Articles
laboratory funds management
Excel VBA
Management Information Systems