Flexibility and ease of use have made the spreadsheet the popular but unfortunate choice for makeshift databases; we can do better For a long stretch of early personal computing history, three ...

A reader asked what program I’d recommend for creating a “database” of her CD collection that could be broken down by song title, artist, genre, performance date, etc. A “database” is a “table” of ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

I was just thinking about this: fundamentally, what is the difference between a spreadsheet file with many sheets (technically, isn't it a relational database?) and an SQL DB?<BR><BR>There has to be ...

Much of the early success of consumer electronics giant Apple Inc. was due to the demand of businesses for the Apple II home computer to run the VisiCalc spreadsheet software application. VisiCalc and ...

I'm working with a Mac-centric non-profit that has accumulated a list of 12k contacts in an excel spreadsheet. They would like to convert it to a database. I'm looking for suggestions to do so. The ...

If you are part of a business, sooner or later you want to be able to collaborate on a database with a colleague or customer. In the past, the easiest way to share a small database was to create a ...

Many companies use spreadsheets to store information, but they also have other valuable functions. Companies use spreadsheets to model and manipulate data sets, create graphical visualizations, and ...