Sams Teach Yourself Microsoft Access 2002 in 21 Days

Chapter 11. Manipulating Queries

Back in Day 4, “The Data Foundation—the Table,” you saw some of the power of select queries. Later, in Day 14, “Special Query Uses,” you’ll learn how easy it is to manipulate your data and the database itself using action queries. Today, you’ll see how to use expressions in queries, the meaning of joins, and some other highly useful, but often overlooked query abilities.

Today You Will Learn

Each of the features or techniques in this lesson is fairly short in length, so this day tends to jump around quite a bit from one seemingly unrelated topic to another. While it’s true that these subjects have little in common other than their use in queries, they do form a body of knowledge utterly vital to any serious Access ...