O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

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 18. Advanced Access Query Techniques

IN THIS CHAPTER

  • Using calculated fields

  • Creating queries that calculate totals

  • Using different types of queries that total

  • Creating crosstab queries

  • Using query wizards

  • Understanding action queries

  • Learning how action queries work

  • Creating new tables with a make-table query

  • Creating update, delete and append queries

  • Troubleshooting action queries

  • Working with SQL queries

In this chapter, you work with more complex queries in greater detail than you did in earlier chapters. So far, you have worked with types of select queries and parameters. Earlier parts of this book explained relatively simple select queries, in which you select specific records from one or more tables based on some criteria. You also learn about action queries, which enable you to change the field values in your records automatically and add or delete records.

Note

This chapter uses the database named Chapter18.accdb. If you have not already copied it onto your machine from the CD, you need to do so now. This database is a direct ODBC import from an Oracle database. All the field names from the Oracle database are expressed in uppercase characters. See Chapter 17 for details about importing data into Access applications.

Using Calculated Fields

Queries are not limited to fields from tables; you can also use calculated fields (created by performing some calculation). A calculated field can be created in many different ways, including the following:

  • Concatenating two Text type fields ...

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