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.

Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...

Data imported from other spreadsheets or databases is already separated into fields, using something called a field delimiter—a comma, tab, space, or custom character—to separate one field from ...

A few best practices can go a long way toward protecting your Access data from careless or overly curious users. Here are some simple ways to add a few layers of security to a database. A few best ...