(NOTE: Each chapter concludes with Summary, Q&A, and a Workshop.
I. ACCESS PROGRAMMING 101.
Hour 1. What's New in Access 2002.
New Side Panes for Easier Navigation. Customizing Menus and Toolbars. Spell-Checking Data. Editing Options. Speech Command and Control. Collaborating Online. Network Places. Remove Author Information. Introducing ActiveX Data Objects. Programming Objects. Adding Data to Web Pages. Access Projects.
Hour 2. Exploring VBA.
Understanding How Access VBA Works. Learning Access VBA Keywords. Access Operators and Operands. Data: What a Program Knows. Putting It All Together. Prelude to Advanced Topics.
Hour 3. Storing Your Program's Data.
How Memory Is Used. Declaring Variables. Data Assignment and Evaluation. Be Explicit. Using Pop-up Hints. Using the Locals Window. Using the Watches Window. Running Code in the Immediate Window. Employing the Call Stack.
Hour 4. Controlling Program Flow and Performing Calculations.
What Goes into an Equation. Understanding Operator Count. Using Arithmetic Operators. Performing Comparisons. The Truth of Logical Operators. Concatenate It. Who Has Precedence Here? Special Operators.
II. WRITING CODE TO MANAGE YOUR ACCESS DATA.
Hour 5. Learning to Write Conditional Code.
A Programmer's Traffic Cop. Tidying Up Nested Conditional Statements. Want to Go for a Spin? Take It Once Around the Block. Iterating Through Data. Iterating Collections of Data. Short-circuiting Code. Using the Switch Function.
Hour 6. Managing Your Database.
Access 2002 Is Backward Compatible with Access 2000. Creating a Database. Managing a Table with Code. Iteratively Inputting User Data. Using Conditional Code to Find Data.
Hour 7. Using Advanced Data Types to Manage Data.
Understanding OLE Automation. Using the ADODB Object. Using the ADOX Object.
III. USING ACCESS RESOURCES TO GET THE JOB DONE.
Hour 8. Solving Problems a Piece at a Time.
The Mechanics of Writing Subroutines. The Mechanics of Writing Functions. Programming Rules of Thumb. Tying It All Together.
Hour 9. Using Macros As Learning Aids.
Creating a Macro 101. Using CopyObject. Using DeleteObject. The Keys to the City. Importing Data. Using Macro Resources in Code. To Macro or Not to Macro.
Hour 10. Employing Access Predefined Solutions.
Using String-Handling Functions. Formatting Data. Using Date and Time Functions. Managing File I/O. Dynamic User Input Functions. Using Function, Method, Property, and Statement References.
IV. DEFINING DATA TYPES AND USING ARRAYS AND COLLECTIONS.
Hour 11. Making the Complex Simple: Creating Your Own Data Types.
Understanding Aggregation. Using the Type Declaration. What Kind of Data Can Go into My Type? Declaring Instances of User Types. Defining Enume