Cover -- TABLE OF CONTENTS -- Chapter 1 AN INTRODUCTION TO ACCESS 2010 -- What Is Microsoft Access? -- Access Vs. Excel -- Microsoft Access 2010 Limitations -- System Requirements -- Working with Older Database Formats -- What's New in Access 2010 -- User Interface Changes -- New Database File Extensions -- New Templates -- Improved Object Design Tools -- New Data Types and Controls -- Enhanced Data Formatting and Presentation -- Improved 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 2010 Database -- Tables and Fields -- Table Relationships -- Forms -- Common Controls -- Hungarian Notation -- Queries -- Summary -- 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 -- 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 -- 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.

Chapter 6 COMMON FORMATTING AND CONVERSION FUNTIONS -- 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 -- 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 -- Chapter 8 DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING -- Debugging -- Stepping Through Code -- Breakpoints -- Immediate Window -- Locals Window -- Watches 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 -- 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 -- 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 -- Chapter 11 OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA -- Working with Collections -- Adding Members to a Collection -- Removing Members from a Collection -- Accessing a Member in a Collection -- For Each Loops -- Introduction to Object-Oriented Programming -- Creating Custom Objects -- Working with Class Modules -- Property Procedures -- Method Procedures -- Putting It All Together -- Chapter Program: Monster Dating Service -- Summary -- Chapter 12 MACROS AND PERFORMANCE TUNING -- Macros -- Macro Builder -- Data 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.