UCL CROMIS-2 Database

CROMIS-2 is a medical research project run by University College London. The CROMIS-2 team needed a database to allow them to effectively manage the administration of the project.

brief

University College London were investigating micro bleeds in people taking anti-coagulant drugs. They were looking for a way to track patients’ MRI scans, along with follow-ups, which are on a six monthly basis.  As the follow ups are particularly important, the database needed to track these accurately for each patient, capturing relevant data. This would allow the CROMIS-2 team to gain a clear understanding of how the patients’ health was changing, something crucial to the success of the project.

To assist with the research, the database needed to present graphs of the main project statistics. Multiple sets of data needed to be presented, such as the number of patients recruited each month, along with follow-ups completed and those still to do.

In order to efficiently input data relating to patients, GPs and hospitals, we built user-friendly forms to make the process quick and easy. This was particularly useful for those who previously would have needed assistance in completing forms.

The system was designed to make the process of follow-ups as simple as possible, allowing the team to collect the important data needed for the research.

technical notes

The database was created in Microsoft Access, as there was no need for multi-user capability. The ability to export data to a spreadsheet for further analysis was particularly useful.

Email reminders of follow-up appointments can be sent directly from Access, which has proved very convenient.

Strategic Mentors Gaught Conlon