您的位置:首页  > 论文页面

利用Excel VBA构建小型数据库系统

发表时间:2008-06-30  浏览量:18392  下载量:8588
全部作者: 陈雨旦,王伟,郑竞宏
作者单位: 中国矿业大学(北京)机电与信息工程学院;清华大学电机工程与应用电子技术系
摘 要: 在现代各行业的软件开发中,数据库技术应用越来越广泛。传统数据库开发周期长,技术要求高,使诸多非专业人员望而却步。本文提出了一种设计方案,利用Excel及其自带的开发语言VBA来构建小型数据库系统。用Excel VBA开发系统,不仅开发周期短,而且凡是能用Excel操作实现的都能用其宏录制器录制相应代码实现,从而使开发难度大大降低。最后设计并实现了一个电能质量监控仪表的后台数据处理系统,并给出了关键部分的代码及设计思路。
关 键 词: 计算机应用;Excel VBA;数据库;电能质量
Title: Construct small database systems with Excel VBA
Author: CHEN Yudan, WANG Wei, ZHENG Jinghong
Organization: School of Mechanical Electronic & Information Engineering, China University of Mining & Technology;Department of Electrical Engineering, Tsinghua University
Abstract: The database technology is popularly used along with the software developments in every field. The traditional developing process of database often takes a long time, needs a high level of technology and makes the laypeople face a great difficulty. This paper presents a new design method, which can construct small database systems with Excel and VBA. This kind of design takes less time, and reduces the level of difficulty by transcribing the corresponding codes with the Micro Record to complete the same tasks that can be realized with Excel. At last, the paper designs and then realizes a rear database-dealing system for the monitoring of power quality, offering some key codes and methods of design.
Key words: computer application; Excel VBA; database; power quality
发表期数: 2008年10月第12期
引用格式: 陈雨旦,王伟,郑竞宏. 利用Excel VBA构建小型数据库系统[J]. 中国科技论文在线精品论文,2008,1(12):1396-1401.
 
2 评论数 0
暂无评论
友情链接