The latest news and information affecting you and your environment
newssection09 Jan 2012
Spreadsheets and Databases
I still come across people who use spreadsheets, when what they really need is a Database. So, what"s the difference and why do you need a database?
I still come across people who use spreadsheets, when what they really need is a Database. So, whatís the difference and why do you need a database?
Many people start their databases as a spreadsheet but, as it becomes larger and more complex, the spreadsheet becomes more and more difficult to work with. There are many advantages to using a database.
A database can contain a virtually unlimited number of records while most spreadsheets have a limited number of records or rows, and you end up with multiple spreadsheets and itís difficult to find the information you need.
Data input can be controlled much better in a database through the use of field rules. This means fewer input errors - especially when new employees or temporary help is employed.
Data input can be easier, faster, and more versatile through the use of lookup lists and lookup tables Ė for example address details can be brought forward into an invoice without retyping.
Multiple report formats can easily be created for the same data without physically re-sorting or re-ordering any data. Reporting capabilities are much more powerful and formats can generally be more complex.
Sorting and filtering of data for viewing, editing, and reporting is much easier and more powerful than with a spreadsheet.
So, if you want someone who is able to write an database solution for you, or you know someone would benefit, please have a look at http://www.bplus.co.uk/AlphaSoftware and letís have a chat.
This article was published at 00:00 Mon 09 January 2012.