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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.