TABLE OF CONTENTS
Chapter 1 AN INTRODUCTION TO ACCESS 2010
Microsoft Access 2010 Limitations
Working with Older Database Formats
Enhanced Data Formatting and Presentation
Creating a New Access 2010 Database
Chapter 3 INTRODUCTION TO ACCESS VBA
Introduction to Event Procedures
Introduction to VBA Statements
Accessing Objects and Their Properties
Getting User Input with Text Boxes
Variables and Beginning Data Types
VBA Arithmetic and Order of Operations
Introduction to Looping Structures
Chapter 6 COMMON FORMATTING AND CONVERSION FUNCTIONS
Chapter Program: Secret Message
Chapter 7 CODE REUSE AND DATA STRUCTURES
Introduction to User-Defined Procedures
Declaring Variables of User-Defined Type
Chapter 8 DEBUGGING, INPUT VALIDATION, FILE PROCESSING, AND ERROR HANDLING
Opening a Sequential Data File
Reading Sequential Data from a File
Writing Sequential Data to a File
Error Trapping for File Access
Chapter Program: Trivial Challenge
Chapter 9 MICROSOFT ACCESS SQL
Chapter 10 DATABASE PROGRAMMING WITH ADO
Introduction to Database Locks
Chapter Program: Choose My Adventure
Chapter 11 OBJECT-ORIENTED PROGRAMMING WITH ACCESS VBA
Adding Members to a Collection
Removing Members from a Collection
Accessing a Member in a Collection
Introduction to Object-Oriented Programming
Chapter Program: Monster Dating Service
Chapter 12 MACROS AND PERFORMANCE TUNING
Macro Troubleshooting and Error Handling
Access Database Performance Considerations
Appendix A COMMON CHARACTER CODES
Appendix B KEYBOARD SHORTCUTS FOR THE CODE WINDOW
Appendix D VISUAL BASIC ENVIRONMENT OPTIONS