Pro Access 2010 Development

Chapter 4. Designing Queries

In this chapter, you'll design queries that will be included with your Library application. Throughout this project, you'll be creating a lot of queries. This chapter will introduce the basic concepts that you'll need to understand when creating and using queries in Access 2010. You'll create a few sample queries in this chapter, and then create the remainder in subsequent chapters as necessary.

There are two basic types of queries: select queries return data from one or more tables and action queries are used to insert, update, or delete records from a table. Access 2010 provides a Query Wizard that will guide you through the process of creating a query. Later I will also show you how to create and modify a query using ...