Database design – Back to basics

Over my 15 years of developing with Microsoft Access, I have found myself adding functionality onto existing databases that I have inherited so to speak and sooner or later found that my clients database was not grounded from sensible database design and so the scalability is severely stunted and has little room for expansion and being useful to the users. I always find myself going back to basics and mentally sitting those first classes at college to mull over the relational database and normalisation of the data you want to store and ultimately the information you wish to extract from it.

This shows that it is vital to spend time with the client, understand their needs implicitly in order to root in a solid database design allowing scalability as one day they may well expand , require an upscale to SQL server, where this will pay dividends.