利用微软Office建立医院自制制剂检验数据管理系统

Establishment of Data Management System for Hospital Preparation Test Using Microsoft Office

目的:规范医院自制制剂检验工作管理,确保制剂质量。方法:运用VBA编程,有机集成微软Office自动化办公套件中Access数据库、Word文字处理等组件,设计符合制剂检验特点的数据管理系统。结果:检验工作所涉及的各种原始记录和报告等打印文件页面美观,格式统一;制剂的检验数据通过计算机记录在数据库中,方便了制剂质量信息的掌握和计算数据的处理。结论:该系统的建立提高了制剂检验工作效率和工作质量,有利于医院自制制剂工作的制度化、规范化建设。

OBJECTIVE： To standardize the management on test of hospital preparations to ensure the quality of preparations. METHODS： The Access database and Word application of in Microsoft Office automatic groupware were integrated organically using VBA programming, and the data management system suitable for hospital preparation test was designed. RESULTS： The print files of various primary records and reports related to testing work exhibited beautiful page and uniformed format. Testing data of preparations were included into data base by computer recording, which facilitated data inquiry and data processing related to quality of hospital preparations. CONCLUSION： Due to this system, both the efficiency and quality of hospital preparation test work have been enhanced, which contributes to institutionalization and standardization of hospital preparation work.