期刊文献+

Access与Excel软件在住院药房药品盘点中的应用 被引量:4

Application of Access and Excel Software in Drug Stocktaking of Inpatient Pharmacy
原文传递
导出
摘要 目的:为改进医院住院药房药品盘点工作提供参考。方法:依托"军卫一号"医院信息系统库存管理系统,从中提取数据并应用Access与Excel软件设计和建立药品盘点表,采用货位编号盘点法进行盘点。结果与结论:该方法减少了以往运用手工计算修正备用服务器数据的环节,避免了手工操作可能导致的误差,使盘点更加方便、快捷,在确保数据处理准确无误的前提下将每次盘点时间减少了近1.5h。 OBJECTIVE: To provide reference for the improvement of drugs stocktaking in the inpatient pharmacy. METHODS: Based on "Army No. 1" inventory management system, the data were retrieved and adjusted using Access and Excel, and the drugs stocktaking table of the inpatient pharmacy was designed, and arrangement order of drugs was used to check the stock of drugs. RESULTS & CONCLUSIONS: The established drug stocktaking method reduces the traditional process of handwork, avoids the probable mistake of handwork, and facilitates a more convenient and faster stocktaking. The time of drug stocktaking reduces by 1.5 h under the accurate data processing.
出处 《中国药房》 CAS CSCD 北大核心 2011年第37期3506-3508,共3页 China Pharmacy
关键词 住院药房 药品盘点表 ACCESS EXCEL Inpatient pharmacy Drug stocktaking tablet Access Excel
作者简介 药师。研究方向:医院药学。电话:020—36654674。E—mail:yjklihui@163.com
  • 相关文献

参考文献5

二级参考文献10

共引文献25

同被引文献16

引证文献4

二级引证文献15

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部