Visual Basic for Microsoft Access Tutorial

Supercharge your Microsoft Access by using Visual Basic. A practical tutorial that teaches real world skills
4.2 (101 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
13,944 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 79
  • Length 6.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2012 English

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this course.

In this software training course from InfiniteSkills, 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introducing VBA For Access
Working Files - Download These First
Preview
Article
Can I Really Become A Programmer
Preview
02:52
Using The Working Files
Preview
01:59
Initial Setup Of The Sample Databases Provided
Preview
02:44
Section 2: Moving From A Database To An Application
What Is VBA
03:20
Where Is The VBA
04:38
The VBA Editor Quick Tour
02:34
The Editor - Explorer And Properties Windows
02:50
The Editor - The Debug Window
02:45
Macros Or VBA - Convert Your Macro To Code
03:19
Section 3: Programming In VBA
Getting Started With A Standard Module
02:11
Creating A Procedure
02:55
Adding Comments To Your Code
02:10
VBA Data Types
02:38
Declaring Parameters For Use In Procedures
04:30
How To Declare Variables And Constants
05:09
Creating And Assigning Array Values
04:21
The Scope And Lifetime Of Variables
03:33
Standard Naming Conventions For Variables
03:24
Handling Multiple Line Commands
03:44
The Very Useful Keyword - ME
02:45
Section 4: Repeating VBA Code
Do Loop
04:34
While Wend
01:54
For Next
04:47
If Else End If
07:02
The Very Flexible Select Case Statement
05:17
Section 5: Working With Access Objects
The Access Object Model
07:23
Changing The Value Of Object Properties
04:14
Access Special Object DoCmd
03:52
Class Modules And Class Procedures
04:35
Enable And Disable Controls
05:41
Hide Or Show Form Controls
05:47
Lock Unlock Controls
02:52
Form Events To Trigger Procedures
05:48
Setting Color Properties
07:19
Defining Your Own Custom Colours
08:09
Defining Font Properties Through Your Code
05:46
With End With To Shorten Code Writing
02:47
Assigning Values To Data Fields On A Form
06:44
Opening A Form
05:29
Open Form And Display Filtered Dataset
06:40
Closing Any Open Form
06:00
Section 6: Data Manipulation
A Very Quick SQL Tour
03:53
Running An Action Query As Code
04:50
Stop Warnings On Action Queries When Run In VBA
04:12
Building And Storing SQL In Variables
05:39
Changing The Sql That Populates A List Or Combo Box
04:28
Create A New Table
03:56
Deleting (And Closing) A Table
04:47
Adding Data To Tables Through Code
07:38
The Recordset Explained
07:29
How To Reference Fields In A Recordset
02:13
Navigating Through The Rows Of A Recordset
02:41
Closing Off A Recordset And ADODB Connection
02:14
The Recordset In Action
13:05
DCOUNT (Great Function)
06:09
Section 7: Interacting With The User
Getting Started With The MSGBOX
07:13
Customizing The MSGBOX
06:12
Reacting To The User Response In A MSGBOX
06:04
Creating A Dialog Box
04:29
Using A Dialog To Give Choices To Users
07:46
Combo Box Dynamic List Building
06:01
Excluding Values From The Combo Box List
03:07
Using The Combo Box Selected Value
04:42
Detecting The Right Mouse Click
07:20
Section 8: Combo And ListBox Specials
Combo Box And ListBox Properties
04:04
Accessing And Setting Combo And Field List Properties
09:12
Accessing Combo Box Fields From A Different Form
10:45
List Box Search Application
04:26
Section 9: Functions
What Is A Function
02:21
Creating A Custom Function
04:17
A Proper ProperCase Function
06:53
Section 10: Testing, Error Handling And Debugging
The Three Types Of Errors
04:48
Handling Logical Errors With Debug Print
05:39
Handling Logical Errors With Breakpoints
05:46
Creating Your Own Runtime Error Handler
06:07
Specific Error Messages For Specific Errors
06:51
Section 11: And Finally
Locking The VBA From Prying Eyes
02:57
So What's Next
03:13

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course