10. Understanding Access Query Operators and Expressions

image Chapter 5, “Working with Access Databases and Tables,” described how to use expressions to define values in calculated fields, which are new in Access 2010. Chapter 6, “Entering, Editing, and Validating Access Table Data,” briefly introduced you to operators and the expressions that use them when you added validation rules to table fields. Chapter 9, “Designing Queries for Access Databases,” touched on expressions again when you devised selection criteria for the query that you created. Expressions play an important role in all the chapters that follow.

Much of this chapter is devoted to ...

Get Microsoft® Access® 2010 In Depth now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.