Special Edition Using Microsoft® Access 2000

Chapter 9. Understanding Query Operators and Expressions

In this chapter

• Understanding the Elements in Expressions

• Operators

• Arithmetic Operators

• Assignment and Comparison Operators

• Logical Operators

• Identifiers

• Functions

• Numeric, Logical, Date/Time, and String Data-Type Conversion Functions

• Intrinsic and Named Constants

• Expressions for Creating Default Values

• Expressions for Validating Data

• Expressions for Query Criteria

• In the Real World—The Algebra of Access Expressions

Writing Expressions for Query Criteria and Data Validation

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, "Designing Access Queries," touched on ...