Chapter 9. Understanding Operators and Expressions in Access

Chapter 5, "Entering, Editing, and Validating Data in Tables," briefly introduced you to operators and the expressions that use them when you added validation rules to table fields. Chapter 8, "Using Query by Example," touched on expressions again when you devised selection criteria for the query that you created. You must use expressions with the forms (Chapters 12 and 13), reports (Chapters 14 and 15), and queries (Chapters 8 and 10) that you combine when creating custom Access applications; furthermore, you use expressions extensively when programming with Access VBA (Chapter 26 through Chapter 29). To work effectively with Access, therefore, you must know how to create simple expressions ...

Get Special Edition Using Access 97, Second Edition 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.