Access 2007 Programming by Example with VBA, XML, and ASP

Chapter 15Creating and Running Queries with DAO/ADO

Having worked with Microsoft Access for a while, you already know that to retrieve relevant information from your database and perform data-oriented tasks you need to write queries. Queries are SQL statements that are saved in the database and can be run at any time. Microsoft Office Access 2007 supports several types of queries.

The simplest queries allow you to select a set of records from a table. However, when you need to extract information from more than one table at a time, you must write a more complex query by using an SQL JOIN statement. Other queries perform specific actions on existing data, such as making a new table, appending rows to a table, updating the values in a table, or ...