Access VBA: The Beginner's Blueprint to Programming Access (Udemy.com)

To Learn Visual Basic for Applications & Do More with Your Databases, Program Them with the Tools Found in This Course!

Created by: IsBel .

Produced in 2021

icon
What you will learn

  • UNDERSTAND why you would want to use VBA in Access Databases
  • KNOW the differences between Macros and VBA
  • CREATE a simple Macro in Access
  • NAVIGATE comfortably in the Visual Basic Editor
  • LEARN the essentials of writing Access VBA code
  • PROGRAM command buttons
  • CREATE decision structures
  • CREATE user interaction dialog boxes, like message boxes and input boxes
  • DEBUG your VBA code
  • LEARN how to handle errors
  • USE built in String, Date, and Format functions

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

In This Course You Get:
Free Downloadable Databases - makes it easy to follow along & practice after class."Test Your Skills" - exercises to get you engaged & reinforce what you have learned.
Code - in the Resources section of the lectures where applicable.
Access VBA Glossary - talk the talkChoose Access VBA when...
Simple tables, forms, or reports just won't do. ..
When Macros aren't quite enough. ..
And when creating your own applications from scratch is overkill.
Are you experienced with Access, but not with VBA programming?
This course introduces VBA programming concepts with easy to follow examples, and lessons.-----------------------------------------------------------------------------------First, you will learn the difference between Macros and VBA, and create a simple Macro.
Then you will get familiar with the Visual Basic Editor, your home for programming Access, and basic concepts of Visual Basic for Applications.
During this course you will learn VBA concepts that you can apply to your job, and add functionality to your Access databases:
Get comfortable with the Visual Basic Editor (VBE)Learn the essentials of writing VBA codeLearn about the powerful DoCmd objectCreate branching decision structuresCreate user interactions forms, like message boxes, and input boxesDAO recordsetsDebug your code, and handle errors-----------------------------------------------------------------------------------What to know before you enroll:
You will have unlimited, lifetime access to the course!
You will have instant, and free access to any updates I add to the course.
Don't forget, you are covered by a 30 day money back guarantee.-----------------------------------------------------------------------------------Get started programming VBA for your Access databases today.
Who this course is for:
The Beginning Access VBA ProgrammerProgrammers of other languages that would like a good tutorialAnyone who is responsible for working with Access databasesAnyone wanting to know more about Access VBA

icon
Instructor Details

IsBel .



Would You Like to Get the Tips, Tools, and Exercises You Need
for the Technical, Business, and Software Skills You Want?
IsBel Will Show You How.


ABOUT
Since 1999 IsBel has been training you - the Admin, the Parent going back to work, the Teacher, the Small Business Owner, the Electrician, and Law Officer. Those moving into a new career, and those wanting to move up in their current career. Government Officials, Job-seekers, Part-time workers, and Full-time students have all taken courses, both in person, and online from IsBel.
Technical courses in everyday language are offered in her Udemy portfolio.
IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.
IsaBel grew up around teachers, so education was always important to her.
All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.
She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

COURSESONUDEMY

icon
More courses by IsBel .

Microsoft Access SQL: SQL for Non-Programmers

$11.99

Microsoft Access: Beyond the Basics of Access Bundle

$11.99

SQL Made Simple: SQL Server Queries for Non-Programmers

$11.99

icon
More excel courses

Excel Skills for Business: Essentials

Free

Excel Skills for Business: Intermediate I

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

$11.99

Excel with Top Microsoft Excel Hacks

$11.99

Microsoft Excel  Complete Excel Guide (Excel 2007  2021)

$11.99

icon
Reviews

4.6

108 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Sofia Longart on 11/27/2020

This course has taught me things that I didn't now before and they way the examples and explanations are provided really help me understand how I should program my VBA codes better.

By Jae Choi on 11/9/2020

I love this course. The instructor is amazing, articulate, easy to understand, and easy to follow. The course content is exactly what I was looking for!

By Sylvio Rocha on 8/18/2020

Comunicao clara e objetiva! curso muito bem estruturado e bem construdo! Os exemplos e material de apoio sero de grande ajuda!

By Edward Williams on 7/24/2020

I wish there were more exercises per section.

By Richard TEich on 7/24/2020

She explains things in a wonderfully clear way.

By Chris Fogel on 6/22/2020

This is good, but lets get on to the VBA programming

By Jammie Williams on 6/14/2020

So I chose to learn computers as a hobby. My original major in college 15 years ago was electrical engineering where I was just starting to enter into the arena of programming before joining the military and changing my major. Thanks to the computer classes I took in classes 15 years ago, I was always somewhat more capable of learning and doing different things on a computer than the average user. So I decided to set my sights on becoming a technical expert. My goal is to start learning coding and programming starting with some of the most basic languages. In my mind, Access is a database which uses basic SQL Language and VBA to complete other tasks. Other server based databases use SQL as well. I figured I'd use Access as a way for me to gain some familiarity with database and information management before branching into Server based data management and SQL, PYTHON, and other coding languages. With that being said, my understanding of access was basic to advanced. I knew how to create and link tables, create queries, update queries, delete queries, forms, and reports. I know the basic functions of access as well using the function wizard. What I didn't know what VBA and SQL. This class starts out familiarizing you with the VBA interface and teaching the structure of it before showing how to make it work. It starts you slow, then progressively builds on what it teaches you. The class is amazing. If person understands how to do the basic user functions in access such as creating and linking tables using relationships, and can create all types of queries, and has a general understanding of creating forms along with basic functions, then they can do this class. It will help you to automate your forms and database to make the interface and user functions far more user-friendly.

By Juan Lopez on 5/23/2020

Sort of, what was discussed in this segment of the training, I already knew but definitely a good refresher

By James Tucker on 5/22/2020

Excellent presentation and presented at a proper speed. Very professional and very informative

By Pedro Villegas on 5/21/2020

The instructor is excellent, but the material should be organized in such a way as to introduce terms when they are needed, not abstractly at the beginning of the course. I had to wait to module 30+ to begin to understand the topic. Abstract concepts are not digested but only within the to the material being learned.

By Richard Atkins on 5/14/2020

I highly recommend this course for anyone who is seeking to start Access VBA programming.
The course material is very organized and is taught at a comfortable pace. I am just starting in VBA, and this has provided a solid foundation for me to move forward.
Also, in addition to IsaBel's voice having remarkable clarity, she uses it in a style that is professional, yet personally engaging.
In fact, other teachers should consider writing out their Udemy lectures and hiring her to deliver them. She is that good.

By Milton friedman on 5/8/2020

Easy to understand and concise.