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

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

New software could make databases much easier for laypeople to work with. The program's home screen looks like a spreadsheet, but it lets users build their own database queries and reports by ...

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

Wouldn't that make a great exam question? "Spreadsheets are evil. Discuss." What would your answer be? My answer would be that spreadsheets are evil 95% of the time (and I have a spreadsheet that ...

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

Data. Your business can't run without it. As a small-business owner, you need to track everything – from your inventory levels to the personal information of employees. Many entrepreneurs start off ...

Spreadsheets are great tools. Spreadsheet programs have been around for over 25 years and many contractors have built some pretty respectable spreadsheets over the years for their estimating.

Excel and Access are two software applications which belong to the Microsoft Office suite. You can create a data file in a spreadsheet format using Access and then later open the file and work on it ...

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...