Choosing Between Spreadsheets and Databases
Small businesses frequently use spreadsheets when a database would be more appropriate. This is often due to widespread familiarity with spreadsheets and the short learning curve required to begin using them productively. Time and again there is a lack of in-house knowledge about databases and their potential benefits.
This chapter aims to help you decide whether a database would benefit your small business by explaining the limitations of spreadsheets, how they can lead to difficulties, and how databases can overcome some of these problems. It aims to bring these issues to your attention and warn you about how they could worsen as your data increases in volume and complexity. There are situations ...