Skip to Main Content
Special Edition Using Microsoft® Office Access 2003
book

Special Edition Using Microsoft® Office Access 2003

by Roger Fennings
September 2003
Intermediate to advanced content levelIntermediate to advanced
1536 pages
42h 35m
English
Que
Content preview from Special Edition Using Microsoft® Office Access 2003

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

Writing Expressions for Query Criteria and Data Validation

Chapter 6, “Entering, Editing, and Validating Jet 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 Jet Databases,” touched on expressions again when you devised selection criteria for the query that you created. Expressions play an important role in all ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Faithe Wempen
Pro Access 2007

Pro Access 2007

Martin WP Reid

Publisher Resources

ISBN: 0789729520Purchase book