DEMO: This is a sample video of this course.
In order to play this video, you will need to install Adobe Flash player for your browser.
The paid version of this course contains videos of following chapters:
Course Length: 4 Hours 33 Minutes 52 Seconds
Course Outline
Module 1: Introduction to Programming
Overview of a Microsoft Access application
Writing procedures
Working with variables
Controlling program flow
Calling procedures
Getting help
Module 2: Responding to User Actions
Overview of the class application
Adding event procedures
Working with events
Using objects, properties, and methods
Using the DoCmd object
Module 3: Validating Data
Overview of data validation
Validating data without using code
Validating data by using code
Module 4: Using Functions and Understanding Scope
Using functions
Understanding scope
Module 5: Using Debugging Tools
Stepping through code
Viewing variables
Module 6: Handling Run-Time Errors
Types of errors
Run-time errors
Adding error handlers
Module 7: Looping Through Code
Overview of looping structures
Do loops
For loops
Interrupting the execution of a loop
Module 8: Working with Records
Overview of record sets
Retrieving data
Structured Query Language (SQL)
Manipulating data
Module 9: Completing Your Application
Reviewing your application
Enhancing the user interface
Packaging for delivery
Course Completion
Upon completing this course, students will be able to:
Use the programming capabilities of Microsoft Visual Basic for Applications in Microsoft Access applications to write custom functions and event-driven procedures.
Validate data.
Find and trap errors.
Gain access to and manipulate data in tables using ActiveX® Data Objects (ADO) and Structured Query Language (SQL).
Prerequisites
Before beginning this course, students should be able to:
Design a relational database.
Use Microsoft Access to:
Create a database with multiple tables, forms, and reports.
Create queries.
Recommended:
Six months of experience using Microsoft Access