• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Understanding Jet Operators ... > Writing Expressions for Query Criter...

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 the chapters that follow.

Much of this chapter is devoted to describing the VBA functions available to Jet 4.0 for dealing with data of the Numeric, Date/Time, and Text field data type. Functions play important roles in every element of Access, from validation rules for tables and fields of tables to the control of program flow with VBA. You use functions when creating queries, forms, reports, and even more extensively when writing VBA and VBScript code. To use Access 2003 effectively, you must know what functions are available to you and how to use functions and operators effectively.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint