Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Learning Visual Basic For Microsoft Access

    Subscriber Reviews • Browse Similar Topics

    Overview

    In this software training course from expert author and trainer Guy Vaccaro, you will learn how to use Visual Basic with Microsoft Access. Knowing how to use Visual Basic with Microsoft Access gives you greater control of your Access forms and design. You will start with an introduction to VBA and the VBA editor, how to navigate and use the tools available to you to write VBA code. You will explore variables and constants, functions, sub routines, arrays and other VBA constructs. This video based training will teach you to use VBA for data manipulation, create and use recordsets, controlling objects, create and use dialog and message boxes, debugging, and creating error messages. Finally, you will learn to protect your VBA programs. By the completion of this training video, you will be comfortable with using Visual Basic for Access to exert greater control over your Microsoft Access forms and databases. Working Files are included to allow you to work alongside the author in this video tutorial.

    Subscriber Reviews

    Average Rating: 5 out of 5 rating Based on 1 Rating

    "Learning Visual Basic for Microsoft Access" - by TonyB on 16-NOV-2012
    Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
    What I would have given for this video series years ago! I watched this over a 3 day period and really learned some of the basics of what I was already doing - only now, I actually understand what I was doing! VERY WELL DONE!
    Report as Inappropriate

    Table of Contents

    Chapter/Selection

    Time

    01. Introducing VBA For Access

    Can I Really Become A Programmer

    Play Video

    00:02:52

    About The Author

    Play Video

    00:01:30

    Using The Working Files

    Play Video

    00:01:59

    Initial Setup Of The Sample Databases Provided

    Play Video

    00:02:44

    02. Moving From A Database To An Application

    What Is VBA

    Play Video

    00:03:20

    Where Is The VBA

    Play Video

    00:04:38

    The VBA Editor Quick Tour

    Play Video

    00:02:33

    The Editor - Explorer And Properties Windows

    Play Video

    00:02:50

    The Editor - The Debug Window

    Play Video

    00:02:45

    Macros Or VBA - Convert Your Macro To Code

    Play Video

    00:03:19

    03. Programming In VBA

    Getting Started With A Standard Module

    Play Video

    00:02:11

    Creating A Procedure

    Play Video

    00:02:55

    Adding Comments To Your Code

    Play Video

    00:02:10

    VBA Data Types

    Play Video

    00:02:38

    Declaring Parameters For Use In Procedures

    Play Video

    00:04:30

    How To Declare Variables And Constants

    Play Video

    00:05:09

    Creating And Assigning Array Values

    Play Video

    00:04:21

    The Scope And Lifetime Of Variables

    Play Video

    00:03:33

    Standard Naming Conventions For Variables

    Play Video

    00:03:24

    Handling Multiple Line Commands

    Play Video

    00:03:44

    The Very Useful Keyword - ME

    Play Video

    00:02:45

    04. Repeating VBA Code

    Do Loop

    Preview

    00:04:34

    While Wend

    Preview

    00:01:54

    For Next

    Preview

    00:04:47

    If Else End If

    Preview

    00:07:02

    The Very Flexible Select Case Statement

    Preview

    00:05:16

    05. Working With Access Objects

    The Access Object Model

    Preview

    00:07:23

    Changing The Value Of Object Properties

    Preview

    00:04:14

    Access Special Object DoCmd

    Preview

    00:03:52

    Class Modules And Class Procedures

    Preview

    00:04:35

    Enable And Disable Controls

    Preview

    00:05:41

    Hide Or Show Form Controls

    Preview

    00:05:47

    Lock Unlock Controls

    Preview

    00:02:52

    Form Events To Trigger Procedures

    Preview

    00:05:48

    Setting Color Properties

    Preview

    00:07:19

    Defining Your Own Custom Colours

    Preview

    00:08:09

    Defining Font Properties Through Your Code

    Preview

    00:05:46

    With End With To Shorten Code Writing

    Preview

    00:02:47

    Assigning Values To Data Fields On A Form

    Preview

    00:06:44

    Opening A Form

    Preview

    00:05:28

    Open Form And Display Filtered Dataset

    Preview

    00:06:40

    Closing Any Open Form

    Preview

    00:06:00

    06. Data Manipulation

    A Very Quick SQL Tour

    Preview

    00:03:53

    Running An Action Query As Code

    Preview

    00:04:50

    Stop Warnings On Action Queries When Run In VBA

    Preview

    00:04:12

    Building And Storing SQL In Variables

    Preview

    00:05:39

    Changing The Sql That Populates A List Or Combo Box

    Preview

    00:04:28

    Create A New Table

    Preview

    00:03:56

    Deleting (And Closing) A Table

    Preview

    00:04:47

    Adding Data To Tables Through Code

    Preview

    00:07:38

    The Recordset Explained

    Preview

    00:07:29

    How To Reference Fields In A Recordset

    Preview

    00:02:13

    Navigating Through The Rows Of A Recordset

    Preview

    00:02:41

    Closing Off A Recordset And ADODB Connection

    Preview

    00:02:14

    The Recordset In Action

    Preview

    00:13:05

    DCOUNT (Great Function)

    Preview

    00:06:09

    07. Interacting With The User

    Getting Started With The MSGBOX

    Preview

    00:07:13

    Customizing The MSGBOX

    Preview

    00:06:11

    Reacting To The User Response In A MSGBOX

    Preview

    00:06:04

    Creating A Dialog Box

    Preview

    00:04:29

    Using A Dialog To Give Choices To Users

    Preview

    00:07:46

    Combo Box Dynamic List Building

    Preview

    00:06:01

    Excluding Values From The Combo Box List

    Preview

    00:03:07

    Using The Combo Box Selected Value

    Preview

    00:04:42

    Detecting The Right Mouse Click

    Preview

    00:07:20

    08. Combo And ListBox Specials

    Combo Box And ListBox Properties

    Preview

    00:04:04

    Accessing And Setting Combo And Field List Properties

    Preview

    00:09:12

    Accessing Combo Box Fields From A Different Form

    Preview

    00:10:45

    List Box Search Application

    Preview

    00:04:26

    09. Functions

    What Is A Function

    Preview

    00:02:21

    Creating A Custom Function

    Preview

    00:04:17

    A Proper ProperCase Function

    Preview

    00:06:53

    10. Testing, Error Handling And Debugging

    The Three Types Of Errors

    Preview

    00:04:48

    Handling Logical Errors With Debug Print

    Preview

    00:05:39

    Handling Logical Errors With Breakpoints

    Preview

    00:05:46

    Creating Your Own Runtime Error Handler

    Preview

    00:06:07

    Specific Error Messages For Specific Errors

    Preview

    00:06:51

    11. And Finally

    Locking The VBA From Prying Eyes

    Preview

    00:02:57

    So What's Next

    Preview

    00:03:13

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    These files have been provided by the publisher.

    • Working_Files.zip