基于触发器的Access数据库数据宏功能研究  

Research on Data Macro Function of Access Database Based on Trigger

作　　者：郭静[1] GUO Jing(Shaanxi Institute of Technology,Xi'an 710300 China)

机构地区：[1]陕西国防工业职业技术学院,陕西西安710300

出　　处：《自动化技术与应用》2021年第8期167-170,183,共5页Techniques of Automation and Applications

摘　　要：本文深入探究了基于触发器的Access数据库数据宏功能,并以实例实现了功能。结果表明,就Access数据库数据宏功能应用而言,关键在于科学充分掌握记录集的实际意义;就相关条件,于表内重新寻找更新记录,构成以更新记录为名称的临时记录表,其具有可读写性;使用过程中需注重数据宏功能,以确保数据宏操作代码编写的合理性与准确性。This paper probes into the data macro function of Access database based on trigger,and realizes the function with an example.The result shows that the key to the application of data macro function of Access database is to fully grasp the practical significance of record set scientifically.In terms of the relevant conditions,the updated records are re-searched in the table to form a temporary record table with the name of the updated record,which is read-write;It is necessary to pay attention to the function of data macro in the process of using to ensure the rationality and accuracy of the code of data macro operation.

关 键 词：触发器 ACCESS数据库 数据宏 

分 类 号：TP311.13[自动化与计算机技术—计算机软件与理论]