O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required