CHAPTER 6

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 ...

Get Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.