Databases introduce a number of unique security requirements for their users and administrators. On one hand, databases are designed to promote open and flexible access to data. On the other ... Read More

Users new to the world of databases are often confused by a special value particular to our field – the NULL value. This value can be found in a field ... Read More

By their very nature, our databases contain a lot of data. In previous features, we've explored methods of extracting the specific data we're looking for using the Structured Query ... Read More

The Structured Query Language offers database users a powerful and flexible data retrieval mechanism -- the SELECT statement. In this article, we'll take a look at the general form ... Read More

Microsoft's website is now offering free "test drives" of Office 2007, including the new version of Microsoft Access. These programs allow you to explore the full functionality of the ... Read More

In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.

As you may already know, databases use tables to organize information. Each table consists of a number of rows, each of which corresponds to a single database record. So, ... Read More

You've finally buckled down and decided that it's time to purchase a database solution for your home or business. What type of database do you need? It's actually a simple ... Read More

Most large-scale databases use the Structured Query Language (SQL) to facilitate user and administrator interactions. This language offers a flexible interface for databases of all shapes and sizes.

Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, ... Read More

By this point in time, you've probably heard a good deal about data mining -- the database industry's latest buzzword. What's this trend all about? To use a simple analogy, ... Read More

If you're looking for Microsoft Access training, you may wish to consult this official roadmap from Microsoft Training. It outlines all of the available Microsoft training courses and links ... Read More

So, you'd like to learn more about Microsoft Access and you don't know where to begin. I've selected five of my favorite introductory-level Access books for your perusal.

In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up.

Did you know that you can use a self-join to simplify nested SQL queries where the inner and outer queries reference the same table? Here's a simple example.