Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Want to improve the integrity of your data? Place constraints in the database, as well as in your application. NoSQL, the catchall phrase for non-relational databases, is all the rage among Web ...

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