Design and software development of a power quality monitoring database

The major drawback in collecting power quality data is the management and integration of the resulting databases. The objective of the project is to develop a power quality data management and analysis software which is designed to store data, analyze large quantities of power quality related disturbances and to print the report of that data. The database will store site characteristics and event information, provide the means of to automate both the loading of new data and generate summary and reports. The design of the database is outlined including the inputs to and outputs from the database as well as the data processing required by using Microsoft®Access for this application. The use of Visual Basic macros within Access is presented.