ACKNOWLEDGMENTS -- ABOUT THE AUTHOR -- CONTENTS -- CHAPTER 1 AN INVITATION TO ACCESS 2007 -- What Is Microsoft Access? -- Microsoft Access 2007 Limitations -- Microsoft Office Suites -- System Requirements -- Working with Older Database Formats -- What's New in Access 2007 -- User Interface -- Templates -- Datasheet View -- Layout View -- Calendar -- Rich Text -- Split Forms -- Multivalued Fields -- Data Types -- File Format -- Help -- Summary -- CHAPTER 2 ACCESS ESSENTIALS -- Database Normalization -- 1[sup(st)] Normal Form -- 2[sup(nd)] Normal Form -- 3[sup(rd)] Normal Form -- Creating a New Access 2007 Database -- Tables and Fields -- Table Relationships -- Forms -- Common Controls -- Hungarian Notation -- Queries -- Summary -- Programming Challenges -- CHAPTER 3 INTRODUCTION TO ACCESS VBA -- The Event-Driven Paradigm -- Object-Based Programming -- The VBA IDE -- Introduction to Event Procedures -- Introduction to VBA Statements -- Accessing Objects and Their Properties -- The Forms Collection -- The Me Keyword -- Assignment Statements -- Command and Label Objects -- Getting User Input with Text Boxes -- Variables and Beginning Data Types -- Variable Naming Conventions -- Variable Scope -- Option Statements -- VBA Arithmetic and Order of Operations -- Chapter Program: Fruit Stand -- Summary -- Programming Challenges -- CHAPTER 4 CONDITIONS -- If Blocks -- Nested If Blocks -- Compound If Blocks -- Select Case Structures -- Dialog Boxes -- Message Box -- Input Box -- Common Controls Continued -- Option Group -- Option Buttons -- Check Boxes -- Toggle Buttons -- Chapter Program: Hangman -- Summary -- Programming Challenges -- CHAPTER 5 LOOPING STRUCTURES -- Introduction to Looping Structures -- Do While -- Do Until -- Loop While -- Loop Until -- For -- List and Combo Boxes -- Adding Items -- Removing Items -- Managing Columns -- Random Numbers.

Chapter Program: Math Quiz -- Summary -- Programming Challenges -- CHAPTER 6 COMMON FORMATTING AND CONVERSION FUNCTIONS -- String-Based Functions -- UCase -- LCase -- Len -- StrComp -- Right -- Left -- Mid -- InStr -- Date and Time Functions -- Date -- Day -- WeekDay -- Month -- Year -- Time -- Second -- Minute -- Hour -- Now -- Conversion Functions -- Val -- Str -- Chr -- Asc -- Formatting -- Formatting Strings -- Formatting Numbers -- Formatting Date and Time -- Chapter Program: Secret Message -- Summary -- Programming Challenges -- CHAPTER 7 CODE REUSE AND DATA STRUCTURES -- Code Reuse -- Introduction to User-Defined Procedures -- Subprocedures -- Function Procedures -- Arguments and Parameters -- Standard Modules -- Arrays -- Single-Dimension Arrays -- Two-Dimensional Arrays -- Dynamic Arrays -- Passing Arrays as Arguments -- User-Defined Types -- Type and End Type Statements -- Declaring Variables of User-Defined Type -- Managing Elements -- Chapter Program: Dice -- Summary -- Programming Challenges -- CHAPTER 8 DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING -- Debugging -- Stepping Through Code -- Breakpoints -- Immediate Window -- Locals Window -- Watch Window -- Input Validation -- IsNumeric -- Checking a Range of Values -- Error Handling -- The Err Object -- The Debug Object -- File Processing -- About Sequential File Access -- Opening a Sequential Data File -- Reading Sequential Data from a File -- Writing Sequential Data to a File -- Closing Data Files -- Error Trapping for File Access -- Chapter Program: Trivial Challenge -- Summary -- Programming Challenges -- CHAPTER 9 MICROSOFT ACCESS SQL -- Introduction to Access SQL -- Data Manipulation Language -- Simple SELECT Statements -- Conditions -- Computed Fields -- Built-In Functions -- Sorting -- Grouping -- Joins -- INSERT INTO Statement -- UPDATE Statement.

DELETE Statement -- Data Definition Language -- Creating Tables -- Altering Tables -- DROP Statement -- Summary -- Programming Challenges -- CHAPTER 10 DATABASE PROGRAMMING WITH ADO -- ADO Overview -- Connecting to a Database -- Working with Recordsets -- Introduction to Database Locks -- Introduction to Cursors -- Retrieving and Browsing Data -- Updating Records -- Adding Records -- Deleting Records -- Chapter Program: Choose My Adventure -- Summary -- Programming Challenges -- CHAPTER 11 OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA -- Introduction to Object-Oriented Programming -- Creating Custom Objects -- Working with Class Modules -- Property Procedures -- Method Procedures -- Creating and Working with New Instances -- Working with Collections -- Adding Members to a Collection -- Removing Members from a Collection -- Accessing a Member in a Collection -- For Each Loops -- Chapter Program: Monster Dating Service -- Summary -- Programming Challenges -- CHAPTER 12 MACROS AND PERFORMANCE TUNING -- Macros -- Stand-Alone Macros -- Macro Troubleshooting and Error Handling -- Converting Macros to VBA -- Access Database Performance Considerations -- Forms -- VBA Code -- Queries and Indexes -- Performance Analyzer -- Summary -- Programming Challenges -- APPENDIX A: COMMON CHARACTER CODES -- APPENDIX B: KEYBOARD SHORTCUTS FOR THE CODE WINDOW -- APPENDIX C: TRAPPABLE ERRORS -- APPENDIX D: VISUAL BASIC ENVIRONMENT OPTIONS -- APPENDIX E: RESERVED WORDS AND SYMBOLS -- INDEX -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- Y -- Z.