Visual Basic for Microsoft Access Tutorial
4.8 (122 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.
14,007 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Visual Basic for Microsoft Access Tutorial to your Wishlist.

Add to Wishlist

Visual Basic for Microsoft Access Tutorial

Supercharge your Microsoft Access by using Visual Basic. A practical tutorial that teaches real world skills
4.8 (122 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.
14,007 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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.

Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 79 Lectures Collapse All 79 Lectures 06:20:29
+
Moving From A Database To An Application
6 Lectures 19:26

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
+
Programming In VBA
11 Lectures 37:20
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
+
Repeating VBA Code
5 Lectures 23:34
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
+
Working With Access Objects
16 Lectures 01:29:06
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
+
Data Manipulation
14 Lectures 01:13:14
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
+
Interacting With The User
9 Lectures 52:54
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
+
Combo And ListBox Specials
4 Lectures 28:27
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
+
Functions
3 Lectures 13:31
What Is A Function
02:21

Creating A Custom Function
04:17

A Proper ProperCase Function
06:53
+
Testing, Error Handling And Debugging
5 Lectures 29:11
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
1 More Section
About the Instructor
Infinite Skills
4.4 Average rating
38,494 Reviews
691,411 Students
331 Courses
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.