An integrated construction project cost information system using MS Access™ and MS Project™

The integration of time and cost management of construction projects has been recognized as the most effective way for close management. However, it has not been effectively used due to the presence of a large quantity of data with many complex interrelationships. Advanced software using current state-of-the-art could be developed to solve this problem. Nevertheless, construction organizations, especially those of small to medium size, cannot afford to procure such software due to the high cost involved in development and training. Probably, the maximum capability of small to medium size contractors is to purchase general applications - spreadsheet, database, etc. - and general time planning software. Thus, a computer solution for an existing problem using general software will have a higher potential for application. In this context, research was undertaken to establish the feasibility of the use of MS Access™ and MS Project™ to provide an integrated time and cost management information system encompassing estimating, scheduling, cost control, resource monitoring and costing, and financial control. First, through a literature review, documentary search in contractor organizations and interviews of professionals, the requirements of such a system were identified. Second, detail procedures were established by use of standard system design procedures. Third, a data modelling was developed and a relational database was established with data transfer mechanism between database and time planning software. The research proved that an effective integrated project cost management system could be developed using MS Project™ and MS Access™ as an economical solution for small to medium construction organizations.