Database system developments clinical trial data

Abstract

          Research Management and Development Division is the primary unit responsible for coordinating and managing clinical research projects at Mahidol University. The number of projects in each budget year is large and the trend is increasing. By managing clinical research data, formerly using Microsoft Excel, which encountered problems such as recording, searching and tracking results duplication and delay etc. Therefore, the author wants to develop a system for managing clinical research databases. To make data operations more efficient by using Microsoft Access program which is used to develop the management system. The data scope is all research work process, including reviewed agreement, clinical trial research registration, disbursement, report progress and project closure. By testing the data record and data search between Microsoft Access and Microsoft Excel, it was found that Microsoft Access recorded the data in total time more efficiently 43.71% and data search more than 86.29%. In each step of the clinical research process, comparing the statistical differences as follows: The process of reviewed agreement (Data record) and clinical trial research registration (Data record and data search) were not significantly different. The others are statistically significant differences. The Microsoft Access program is more effective than the percentage as follows; reviewed agreement (data search 42.86%), disbursement (data record 55.33%, data search 99.52%), report progress (data record 88.22%, data search 93.81%) and project closure (data record 65.2%, data search 88.57%). The benefits from the development of clinical research data management using Microsoft Access is based on the research objectives that require fast, accurate and efficient clinical research data storage system. Further development in the field of set access rights, capacity in storage and backup planning to get more efficient database management system.