Microsoft Access VBA For Non Programmers: Learn VBA Now

No Rating(0)
See all reviews

This course is designed for those interested to learn about Microsoft Access VBA.

Watch Free For 30 Days

start free access

-or-

buy single class $199
  • On Demand Video Lessons
  • Course Certificate
  • 24/7 Support

About This CourseBeginner

Learn how to create what I call a Recordset Walk Thru with a Double Loop. These little programs can save you lots of time and grief!

Learn how to open a form anywhere in your Access Visual Basic (VBA) code and send and receive values from it!
Learn all the Access VBA programming concepts, tools, and functions that you will need while you build a fully functional system!

Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!

  • Create VBA Subroutines for Forms and Control the Keyboard
  • Extensive Training on Handling Errors
  • Control Record Sorting and Searching for Specific Records
  • Learn How to Move and Pass Data Between Forms
  • Create Interactive Pull Down Filters for Form Data
  • Build a Complex Report Entirely with VBA
  • Introduction to SQL and How to Use SQL in VBA
  • Turn the Ribbon and Nav Pane On and Off
  • Prevent Form Closure or Resizing
  • Learn How to Close Access with VBA

Powerful Skills That Increase Your Value in the Marketplace

Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!

There is a HUGE need in the marketplace for people who can create systems like this in Access. This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks! This could be your shortest path to increasing your income!

Our Promise to You
By the end of this course, you will have the knowledge about Microsoft Access VBA.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and develop your skills in Microsoft Access VBA!

Course Curriculum

Course Sections

Course Overview

Setup Tasks

Direct Download Links For Database Files

Microsoft Access VBA For Non Programmers – Course Materials

View Database Table And Forms – Review The Goal

Create Your First VBA Subroutine!

Fix A Syntax Error And Take Over The Keyboard

Use An IF Statement And DoCmd

Use ElseIf And A Select Statement

Runtime Errors, Error Traps And Program Stops

Break Into Programs And Infinite Loops

Section 2 Conclusion And Review

On Open Event, Me Keyword And OrderBy

Subroutines For Form Controls, VBA Editing Shortcuts

Modify Subroutines To Sort DESC, More Error Handling

Section 3 Conclusion And Review

Expanding The Keydown Subroutine

Using Public Variables

Building The Search Criteria

Field Names And Reserved Words

Using A Recordset And Bookmarks

Enhancing Our Instant Search

Section 4 Conclusion And Review

Open Another Form With A Button Click

Send Data To The Other Form

Modify A Form To Utilize Data Sent To It

Intro To SQL And Using SQL In The Recordsource

Locate Same Record When Returning From The Form

Modify The Form To Remember The Sort

Create A Prompt To Save Changes

Activate The Add Customer Button

Testing For A Blank Record

Activate The Delete Button

Section 5 Conclusion And Review

Setup Rowsource For Dropdown Filters

Enable Editing In the Dropdown Filters

Set Dropdown Rowsources On The Fly

Create A Subroutine To Build All The Filters

Use The AfterUpdate Event To Rebuild The Filter

Setup The Clear Filter Buttons

Save The Filters When Closing The Form

Section 6 Conclusion And Review

Inspect The Tables And Review The Goal

Creating A Summary Table With A Query

Building Our First Function And Saving Queries To VBA

Add A Delete Query And Create A Test Macro

Restructure Tables And Add A Second Query To Our VBA Function

Figure Out How To Get The Days Between Orders

Doing The Steps With A Recordset

Calculate The Average Days Between Orders

Plug The Average Days Into The Report Table

Section 7 Conclusion And Review

View The Example Of Removing The Nav Pane And Ribbon

Create The HideMenu Subroutine

Call The HideMenu Subroutine From Our Form

Make The Subroutine Toggle The Menus

Create A Startup Subroutine And An Autoexec Macro

Prevent Closing The Form And Activate The Exit Button

Section 8 Conclusion And Review

Overview And Goal

Create Delete Subroutine And Make First Changes To SummRpt Function

Backup The SummRpt Function And Make The First Changes

Pull A Query From VBA Back To Design, Change It And Update VBA

Use TableDefs To Add A Field To A Table

Use TableDefs To Create A Table And Add Fields To It

Make Final Changes And Test The Modified Function

Download The Subforms Database

Overview Of The Tables In The Subforms Database

Overview Of The Forms In The Subforms Database

Add OrderList As A Subform To The Customer Form

Using An On Exit Subroutine To Capture The Order Number You Were On

Pass The Order Number To The Go To Order Button

Open The Orders Form And Move To The Specified Order

Create Code To Return To The Customer Form

Setup The OrdProdList Subform

Create A Total In The Subform

Update The Subtotal And Order Total

Add A New Product To The Order

Create The Add Order Subroutine And Post A New Order

Get The New Order Number And Open The Order Form

Review, Conclusion And Future Enhancements

Download The POPUPS Database

Import Customer List Form And Rename It As CustPopup

Prepare The CustPopup Form For Use As A Popup Form

Modify The Customer Form Code To Open The Popup

Make The Popup Move To The Current Customer On Open

Use The TAG Property To Send The OrdCust Value Back From The Popup Form

Add A Customer From Inside The Popup Form

Double Loop Database Download

A CLASSIC Situation That MUST Be Handled Correctly

Database Overview And Why You Want One Table

The Code Behind The Recalc Button

Doing Total Queries And Making The Subroutine A Function

Reviews

No Reviews found for this course.

About The Instructor

Bruce

Hello, my name is Bruce. I am a self-employed Access programmer and general computer consultant to small and medium-sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business. "Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce I live in Portland, Oregon and have many long-term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do. I have also spent time as a full-time trainer providing group classes on the Microsoft Office programs. In my opinion, the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible. Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed. My goal is to show my students how to create systems that business will value and that will create long-term income.