Australian National Diabetes Information Audit & Benchmarking (ANDIAB) 2011 Final Report

1.2 The Software

Describes the software used to read and analyse data used in the report

Page last updated: December 2011

An application of Teleform© scannable/faxable software was integrated with a Microsoft Access 97© database running under a Windows NT© operating system13, 14. The Teleform© Designer module allows paper forms to be designed and printed (or faxed out). Once completed, forms can be scanned (or faxed back). The Teleform© Reader module assesses each form and either accepts the form (transferring data to an intermediate Access© data file), or suspends the form for verification of one or more data items that the Reader software cannot confidently identify. The Teleform© Verifier module allows an on screen version of the scanned (or faxed) image to be viewed, and corrections made where necessary. Once such corrections are made and accepted, data from these forms are also transferred to the intermediate file. Data in this file are then appended to the permanent database file. Current Operating System and Software Versions are Windows XP, Access 2003 & Teleform V10.4.1

The software has been written to allow individual practitioners or sites (eg a Diabetes Centre) to be registered, and for unique forms to be generated for completion by that practitioner (or site). Two single page scannable forms were designed for data collection using the Teleform© software [Adult and Paediatric/Adolescent]. Completed data once returned are then allocated to that practitioner. A suite of reports has been developed and attached to menu buttons on a user-friendly interface to enable data reporting. These include data verification reports, patient data reports, pooled practice reports and comparative audit reports (see below pp 8-10).

ANDIAB Software is a Microsoft Access© application available in Access 97 or Access 2000 formats. It includes an extract program, which produces a de-identified ANDIAB extract of data for all individuals seen in the previous 12 months. The data extract file is readily incorporated into the Central database for collation and analysis along with scanned form data.

Data were stored and analysed in the Central ANDIAB Database, a Microsoft Access© database held in password protected files on computers stored in a locked room. In 2009, twelve Centres provided data in electronic format from in-house databases via email and all other sites used the scannable form. No sites provided extracts from ANDIAB Software in 2009.

As in previous years, the Central Data Analysis Site [Benchmarking Centre] at the Bankstown-Lidcombe Diabetes Centre in Sydney pooled, verified, analysed and reported the data.

The Commonwealth funded ANDIAB Project 2009-2010 provided funds for ANDIAB 2009 [plus an ANDIAB2 collection in 2010] and for the ANDIAB database application to be completely overhauled. This happened progressively and resulted in several enhancements in the way reports are generated, giving us the ability to provide participants with complete electronic as well as hard copy reports – [the former having not been previously possible]. Further enhancements have been implemented in 2011 using ANDIAB Project 2011-2012 funding.

Document download

This publication is available as a downloadable document.

Australian National Diabetes Information Audit & Benchmarking (ANDIAB) 2011 Final Report(PDF 559 KB)