Spreadsheets

next

- Excel To Go or Pocket Excel
- Easy and great for calculations
- But problems with security, error checking, synchronization and relational data.

Databases

next

- Everything is a database – quite right too!

- Software like HanDBase makes it easy to get started

-eg surgical logbook

- Today's session is to make sure you do the right thing

Bespoke databases

- Allow advanced user interface
- Expensive and require computer expertise

Scenario 1

next

Store the following information

- name
- date of birth
- ID
- sex
- consultant
- ward
- bed no.

Database field types

Scenario 2

next

- same information as before, but also...

- see patients by name, by ward and by consultant

- weight, height, BMI

- diagnosis

Scenario 3

- same information as before, but also...

- blood results over several days for each patient