Don't be frightened: Learn to live with databases

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.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Places to start with Access ...

Anonymous | | Permalink

I'm primirily an IT person but with an interest in Finance. I can recommend Access as a great way of learning about databases but like most Office applications there are probably more features than you need which can be a bit daunting when you first use the program.

There are a lot of books on the market which explain relational database theory - I'd recommend at least doing a little Googling to find out about primary keys, fields and normalisation it will really pay dividends if you are seriously contemplating spending the time to learn Access.

The only thing I would say against Access is that I would not use it for an enterprise scale application and it does not have the robustness of its big cousins SQL Server and Oracle (scalability, performance, recovery etc). But it's great if you want a small to medium-sized database for your workgroup.

Richard Willis's picture

What about the workers?!

Richard Willis | | Permalink

I am pretty good at Excel and can get by in Access. The reason why most of our in-house ad-hoc work is done in Excel is that I am one of only two people in the place that wouldn't run up the road screaming at the mention of Access.

The problem with Access is that unless one has time to do the full front end bit, people unfamiliar with it will either be unable to use it or will mess it up. As most people in a commercial environment are at least comfortable with Excel, one can knock up spreadsheets which they can and will use intuitively without too much additional coaching required. Protecting the bits that they may feel inclined to mess up is simple, and if they want or need to extract bits for their own use, they can.

Not the whole story, though!

neileg | | Permalink

I'm hardly going to disagree with the editorial above, am I?

Bu I have to say that the dedication to Ecxcel goes further than that. I am horrified at the number of reports that I have seen written in Excel by accountants. What about Word, for goodness sake!