O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Visual Basic for Access 2010

Video Description

Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. To begin learning today, simply click on the movie links.

Table of Contents

  1. Introduction
    1. What the Course Is About 00:06:35
    2. Why Code VBA in Access 00:06:18
  2. Objects
    1. What an Object Is 00:04:58
    2. Object Properties 00:05:42
    3. Object Methods 00:04:54
    4. Form Methods 00:06:18
    5. Referencing Data in Code 00:06:14
    6. What IS Is 00:05:48
    7. Application Object 00:05:10
    8. Window Object 00:03:46
  3. Events and Event Procedures
    1. Events and Event Procedures Introduction 00:06:31
    2. Reading Data 00:06:50
    3. Form Events 00:04:29
    4. Object Events 00:05:31
    5. Events Causing Events 00:04:54
    6. Sample Event Procedure 00:06:22
  4. Form and Record Navigation
    1. Record Navigation Buttons 00:05:01
    2. DoCmd Object 00:05:11
    3. Record Navigation Events 00:06:01
    4. Adding New Records 00:03:58
    5. Form Operation Events 00:04:19
    6. Report Operation Events 00:04:33
    7. Sample Navigation 00:04:15
  5. Collections and User-Defined Data Types
    1. Creating Composite Data Types 00:05:23
    2. Declaring Variables of Composite Types 00:04:23
    3. Accessing Data in Composite Types 00:04:39
    4. Nested Types 00:05:38
    5. Dynamic Arrays 00:05:29
    6. Collections 00:04:59
    7. Creating a Collection 00:05:27
    8. Searching a Collection 00:04:32
    9. Sample Collection 00:05:59
  6. VBA and Form Objects
    1. Checkbox 00:04:22
    2. Option Buttons 00:04:59
    3. VBA Code for Option Groups 00:05:38
    4. List Box Single Selection 00:04:36
    5. List Box Multiple Selection 00:05:18
    6. Filling List Box 00:04:49
    7. Sample Data Fill 00:04:50
  7. Embedded SQL
    1. What Embedded SQL Is 00:04:44
    2. SELECT Statement 00:05:45
    3. WHERE Clause 00:05:13
    4. Computed Fields 00:04:45
    5. SQL Summation Functions 00:05:24
    6. SQL Row Limitation Functions 00:05:07
    7. Sample Query 00:04:30
    8. Sorting Results 00:04:29
    9. Grouping Results 00:06:06
    10. Sample Gathering 00:02:36
    11. Joins 00:06:15
    12. Sample Join 00:04:09
    13. Action Queries 00:06:46
  8. Recordsets
    1. What a Recordset Is 00:05:01
    2. Creating a Recordset 00:05:55
    3. Opening Recordsets 00:05:51
    4. Recordset Navigation 00:04:53
    5. Finding Records 00:05:33
    6. Reading and Updating Records 00:05:21
    7. Adding and Deleting Records 00:06:19
    8. Snapshot Recordsets 00:05:45
    9. Sample Recordset 00:06:27
    10. Sample Recordset Use 00:03:08
    11. Sample Recordset Find 00:05:33
  9. Classes
    1. What a Class Is 00:07:01
    2. Defining a Class and Data 00:05:06
    3. Class Properties 00:06:27
    4. Class Methods 00:05:27
    5. Initialize Method 00:03:44
    6. Sample Class Design 00:04:27
    7. Sample Class Code 00:04:33
  10. Databases
    1. Database Object 00:06:46
    2. Connection Object 00:07:05
    3. Using Remote Databases 00:06:32
    4. Referencing Remote Databases 00:05:58
    5. Using Data from a Remote Database 00:04:22
  11. Conclusion
    1. Course Wrap Up 00:05:45
    2. Planning for Events 00:05:59
    3. Navigation Forms 00:06:00
  12. Credits
    1. About the Author 00:05:28