During May, AccountingWEB and IT Zone members confronted their fear of databases, following promptings from Simon Hurst to stop using spreadsheets for inappropriate tasks.
Along with long-time AccountingWEB member Neil Eglintine, Hurst has been spearheading the database crusade since 2001. But the profession has generally stuck its fingers in its ears, started humming to itself very loudly and buried its head in Excel.
In an Excel seminar at the Digita user conference at the end of April 2005, Hurst returned to the topic: "One of my pet hates is when people use spreadsheets when they should be using databases. If you're storing lots of data or doing data input with lots of transactions, use Microsoft Access instead," he said.
Accountants tend to overuse Excel because they're familiar with it,...