Contents -- Introduction -- Chapter 1 ACCESS ESSENTIALS -- Getting Started with Access 2003 -- System Requirements -- Migrating to Access 2003 -- Your First Access Database -- Creating an Access Database -- Tables and Fields -- Relationships -- Forms -- Common Controls -- Hungarian Notation -- Bound Controls -- Startup Forms and Dashboards -- Queries -- Getting Help with Access 2003 -- Chapter Summary -- Chapter 2 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 -- Chapter Summary -- Chapter 3 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 -- Chapter Summary -- Chapter 4 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 -- Chapter Summary -- Chapter 5 FUNCTION CONTINUED -- 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 -- Chapter Summary -- Chapter 6 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 -- Chapter Summary -- Chapter 7 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 -- Chapter Summary -- Chapter 8 MICROSOFT JET SQL -- Introduction to Jet 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 -- Chapter Summary -- Chapter 9 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 -- Chapter Summary.

Chapter 10 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 -- Chapter Summary -- Chapter 11 MICROSOFT OFFICE OBJECTS -- Introduction to Microsoft Office Objects -- Assistant Object -- Balloon Object -- Command Bars -- CommandBarControl Object -- CommandBarButton Object -- FileDialog Object -- Chapter Program: Animated Math -- Chapter Summary -- Chapter 12 INTRODUCTION TO DATA ACCESS PAGES AND ACCESS SECURITY -- Introduction to Data Access Pages -- Creating Data Access Pages -- Adding Group Levels -- Publishing Data Access Pages -- Introduction to Access Security -- Activating Logon Procedures -- Enabling User-Level Security -- Connecting to a Workgroup -- Securing Access from Data Access Pages -- Chapter Summary -- Appendix A: COMMON CHARACTER CODES -- Appendix B: KEYBOARD SHORTCUTS FOR THE CODE WINDOW -- Appendix C: TRAPPABLE ERRORS -- INDEX -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X -- Y -- Z.