O'Reilly logo

Pro Access 2010 Development by Mark Collins

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

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