PART 1 AUTOMATING DATABASE TASKS

1: Get Started Quickly with Wizards

·        Using Wizards for Application Development

·        Creating a Database Using the Database Wizard

·        Adding an Object to Your Application

·        Adding a Command Button to a Form

2: Customize an Application with Visual Basic

·        Customizing a Command Button

·        Modifying a Command Button Created Using the Wizard

·        Making a Form Read-Only by Default

·        Creating a Command Button Without a Wizard

·        Creating Event Procedures for Form Events

·        Displaying a Message to the User

3: Find and Filter Records in a Form

·        Creating a Combo Box to Find Records

·        Filtering Data

4: Respond to Data Entry Events

·        Understanding Form and Control Events

·        Performing Actions as the User Moves in a Form

·        Performing Actions as the User Changes Data

·        Responding to Keyboard Events

·        Validating Data

PART 2 PROGRAMMING IN VISUAL BASIC

5: Write Your Own Functions

·        Understanding Modules and Procedures

·        Creating General Procedures in a Standard Module

·        Using General Procedures on a Form

·        Creating General Functions in a Form Module

6: Monitor and Debug Your Code

·        Stepping Through Code Line by Line

·        Finding and Fixing Bugs in Your Code

7: Respond to Errors and Unexpected Conditions

·        Replacing Standard Error Messages

·        Responding to a Combo Box Error

·        Creating Error-Handling Routines

PART 3 CREATING A CUSTOM APPLICATION

8: Gather Information in a Dialog Box

·        Creating an Application from Scratch

·        Creating a Dialog Box to Go to a Specific Record

·        Filtering Data in a Report

9: Navigate Through Your Application

·        Making Forms Work Together

·        Displaying Related Records in a Pop-Up Form

·        Opening a Form to Add Related Records

10: Display Custom Menus and Toolbars

·        Using Menus and Toolbars in Your User Interface

·        Creating a Custom Menu Bar

·        Customizing Toolbars

11: Put Final Touches on an Application

·        Controlling How Your Application Starts

·        Customizing Your Application’s Appearance

·        Preparing to Distribute Your Application to Users

PART 4 WORKING WITH DATA AND OBJECTS

12: Explore Objects and Collections

·        Introducing the Issues Application

·        Understanding Objects and Collections

·        Referring to Objects and Collections

·        Using the For Each Statement with a Collection

·        Using a Multiple-Selection List Box

·        Working Directly with Database Objects

·        Finding and Changing Data in a Recordset

·        Creating and Running an Action Query