Access数据宏在中药组方配伍中的应用

Access Data Macro in Compatibility of Traditional Chinese Medicine Prescriptions

针对中药组方时药对间可能存在相反或相畏关系的问题,本文介绍在Access数据库中利用数据宏实现自动甄别的方法,以达到对相关药物使用的提示作用。数据宏类似于大型数据库中的DML触发器,是对Access数据库特别是表对象功能的极大补充,弥补了表对象在过程型数据完整性功能实现上的不足。本文的实现方法也为在Access数据库中相似问题的解决提供了参考。

For the incompatible problems and mutual restraints in traditional Chinese medicine prescriptions, this paper intro- duces an automatic judgment method using data macro in Access database, in order to cue the doctor when prescribing a receipt. Data macro is similar to DML trigger in the large database, which is a great supplement to the Access database, especially to the table object function. It makes up for the shortage of the table object in process data integrity function implementation. This paper also provides a reference for solving the similar problems in Access database.