O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

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 9. Creating and Working with Simple Queries

In the last five chapters, you learned how to create tables, modify them, and link or import tables from other data sources. Although you can certainly build forms and reports that get their data directly from your tables, most of the time you will want to sort or filter your data or display data from more than one table. For these tasks, you need queries.

When you define and run a select query, which selects information from the tables and queries in your database, Microsoft Access 2010 creates a recordset of the selected data. In most cases, you can work with a recordset in the same way that you work ...

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