Microsoft Access 2007

Microsoft Access is alive and kicking and is available in it’s latest incarnation “Access 2007″.
It is unclear just how many companies have switched to it or Office 2007 in general, but I suspect the take up is slow.

Personally I am not keen on Access 2007 because it seems too much of a radical change from what we have been used to in the past. No doubt the introduction of the ribbon type toolbar is the way forward for MS Office products, but it can be frustrating to use.

It is not clear where the save button is for instance. Where is the undo command? Others have told me they don’t like the new security model or lack of one. I probably need to explore Access 2007 more and get used to it all though.

HOW ARE YOU USING ACCESS IN YOUR BUSINESS?

I find it amazing that some companies are still using or supporting application written in Access 2.0. If budgets allow you should aim to upgrade to a newer version as Access 2.0 was never the most reliable of versions.

USE THE RIGHT TOOL FOR THE RIGHT JOB

If you need to perform calculations and do forecasting, use Excel not Access. If your database needs to cater for more than 5 or so users or even if it will be handling large volumes of information, consider using something such as SQL Server. Don’t try to make Access do too many things and stuff it with form after form. Keep your Access databases light and simple.

PLAN OUT WHAT YOU WANT YOUR SYSTEM TO DO

If you get it right or near enough from the beginning then it will pay dividends for you in the long run.

Tags: , , , ,