Understanding Jet Operators and Expressions

Table of Contents

This Book

Special Edition Using Microsoft® Office Access 2003

Search

About the Author

Acknowledgments

We Want to Hear from You!

Reader Services

Introduction

Pt. I. Getting Acquainted with Access 2003

Pt. II. Learning the Fundamentals of Jet Databases

Pt. III. Transforming Data with Queries and PivotTables

Ch. 9. Designing Queries for Jet Databases

Ch. 10. Understanding Jet Operators and Expressions

Writing Expressions for Query Criteria and Data Validation

Understanding the Elements of Expressions

Intrinsic and Named Constants

Creating Jet Expressions

Troubleshooting

In the Real World—The Algebra of Access Expressions

Ch. 11. Creating Multitable and Crosstab Queries

Ch. 12. Working with PivotTable and PivotChart Views

Ch. 13. Creating and Updating Jet Tables with Action Queries

Pt. IV. Designing Forms and Reports

Pt. V. Upgrading to SQL Server Databases

Pt. VI. Publishing Data to Intranets and the Internet

Pt. VII. Programming and Converting Access Applications

Chapter 10. Understanding Jet Operators and Expressions

In this chapter

Writing Expressions for Query Criteria and Data Validation
Understanding the Elements of Expressions
Operators
Literals
Identifiers
Functions
Intrinsic and Named Constants
Creating Jet Expressions
Troubleshooting
In the Real World—The Algebra of Access Expressions

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Part III: Transforming Data with Queries... > Understanding Jet Operators and Expr...

Chapter 10. Understanding Jet Operators and Expressions