List of Tables

Chapter 2: Exploring the New Look of Access 2007

Table 2–1: Macro Settings

Chapter 4: Creating Your Database and Tables

Table 4–1: Access Data Types

Table 4–2: Field Properties on the General Tab

Table 4–3: Field Definitions for the Companies Table

Table 4–4: Comparison Symbols Used in Validation Rules

Table 4–5: LIKE Wildcard Characters

Table 4–6: Input Mask Definition Characters

Table 4–7: Field Definitions for the Products Table

Table 4–8: Table Properties for Defining a Subdatasheet

Table 4–9: Field Definitions for the Company Contacts Table

Table 4–10: Field Definitions for the Contact Products Table

Table 4–11: Field Definitions for the Contact Events Table

Chapter 5: Modifying Your Table Design

Table 5–1: Contacts

Table 5–2: tblContacts

Table 5–3: Limitations on Converting One Data Type to Another

Table 5–4: Lookup Properties

Chapter 6: Importing and Linking Data

Table 6–1: dBASE-to-Access Data Type Conversions

Table 6–2: Paradox-to-Access Data Type Conversions

Table 6–3: SQL-to-Access Data Type Conversions

Table 6–4: Visual FoxPro-to-Access Data Type Conversions

Chapter 7: Creating and Working with Simple Queries

Table 7–1: Criteria Operators for Queries

Table 7–2: Operators Used in Arithmetic Expressions

Table 7–3: Interval Settings for DateDiff Function

Table 7–4: Arithmetic Operator Precedence

Table 7–5: Date and Time Functions

Table 7–6: Keyboard Shortcuts for Scrolling in a Datasheet

Table 7–7: Keyboard Shortcuts for Selecting Data in a Datasheet

Table 7–8: Keyboard Shortcuts for Entering Data in a Datasheet

Chapter 8: Building Complex Queries

Table 8–1: Total Functions

Table 8–2: How ztblDates Expands Reservation Rows

Table 8–3: PivotTable Tools on the Ribbon

Chapter 10: Using Forms

Table 10–1: Keyboard Shortcuts for Fields and Records

Table 10–2: Keyboard Shortcuts for a List Box or a Combo Box

Chapter 11: Building a Form

Table 11–1: Controls Group Buttons

Table 11–2: Font Group Buttons

Table 11–3: Border Formatting Commands for Controls

Chapter 12: Customizing a Form

Table 12–1: Format Property Settings for Number and Currency Data Types

Table 12–2: Formatting Characters for Number and Currency Data Types

Table 12–3: Formatting Characters for the Text Data Type

Table 12–4: Format Property Settings for the Date/Time Data Type

Table 12–5: Formatting Characters for the Date/Time Data Type

Table 12–6: Format Property Settings for the Yes/No Data Type

Table 12–7: Settings for the Enabled and Locked Properties

Table 12–8: Other Control Properties

Table 12–9: Form Properties for Controlling Editing and Filtering

Table 12–10: Settings for the Border Style Property

Table 12–11: Other Form Properties

Chapter 13: Advanced Form Design

Table 13–1: Useful Tab Control Formatting Properties

Chapter 16: Advanced Report Design

Table 16–1: Fields in the qryXmplRptReservationsByDay Query

Table 16–2: Properties for a Section

Table 16–3: Properties for a Report

Chapter 17: Understanding Event Processing

Table 17–1: Opening and Closing Forms and Reports

Table 17–2: Changing Data

Table 17–3: Detecting Focus Changes

Table 17–4: Detecting Filters Applied to Forms and Reports

Table 17–5: Trapping Keyboard and Mouse Events

Table 17–6: Detecting Changes in PivotTables and PivotCharts

Table 17–7: Printing

Table 17–8: Trapping Errors

Table 17–9: Detecting Timer Expiration

Chapter 18: Automating Your Application with Macros

Table 18–4: Option Settings for the MsgBox Function

Table 18–1: Macro Actions That Are Not Trusted

Table 18–2: Actions, Arguments, and Settings in SyncWeddingAndCity

Table 18–3: Actions, Arguments, and Settings in the TestCity Macro

Table 18–5: Return Values for the MsgBox Function

Table 18–6: Actions, Arguments, and Settings in the AskEdit Macro

Table 18–7: Actions, Arguments, and Settings in the SetStateAndZip Macro

Chapter 19: Understanding Visual Basic Fundamentals

Table 19–1: Visual Basic Data Types

Table 19–2: OpenRecordset Parameter Settings

Table 19–3: RecordSetObject.Open Parameter Settings

Table 19–4: Visual Basic Equivalents for Macro Actions

Table 19–5: Explanation of Code in Example to Load Random Data

Table 19–6: Explanation of Code in Example to Examine Error Codes

Chapter 21: Publishing Data on the Web

Table 21–1: Common HTML Tags

Table 21–2: Common HTML Object Members

Table 21–3: Some Members of Commonly Used Tags

Table 21–4: Options for Exporting Access Objects to HTML

Table 21–5: HTML Template Tokens Recognized by Access

Chapter 23: Using XML

Table 23–1: USysRibbons Table Fields

Chapter 24: The Finishing Touches

Table 24–1: RibbonX Attributes

Table 24–2: RibbonX Controls

Table 24–3: Explanation of XML in the rbnCSD Ribbon

Table 24–4: IRibbonUI Methods

Table 24–5: AutoKeys Macro Key Codes

Chapter 25: Distributing Your Application

Table 25–1: Access Shortcut Command-Line Options