基于VBA数据库报表自动生成系统的设计

In recent time, databases are utilized to support while developing software and then detect its running situation through get data from these databases. It is beneficial for software quality to deal with data quickly and to generate reports automatically. VBA is the tool to get the data, draw charts based on users’ requirement. The whole system mentioned in this paper is to detect CPU running and save data to database, and the system designed in this paper is a part of the system, which to get data and draw charts automatically. This paper is to explain how to accomplish the functions in Excel by VBA.