Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 16 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Access VBA to Automate Access by Building a Solid Foundation with Access VBA
Working with Access and VBA
Microsoft Access has a lot of moving parts. Tables to store your data, Queries to retrieve data, Forms to work with data and Reports to report on your data. Each of these Access Objects are important all by themselves, but, the real power of Microsoft Access comes when you bring all these objects together.
Automate with Access VBA
Join me in this course on Microsoft Access VBA and learn how to create an intuitive, accessible Access application by automating yours and your users experience working with data in Access.
Access VBA, or Visual Basic for Applications, will provide the means to streamline your efforts in working with Access. Through VBA you will learn to automate routine Access tasks as well as tasks that would normally take a large portion of your day to complete.
Course Structure
I have structures this course for those that are brand new to developing within VBA. Starting with the basics of working within the VBE (Visual Basic Editor) Window, your coding development environment, all the way through more advanced topics such as working with VBA variables and creating loops to repeat tasks, blocks of code.
Enroll Now
Enroll now and participate in the course by taking advantage of not only the step by step video demonstrations, test your understanding with section quizzes, but also download the exercise file that I will be using throughout the videos and follow along.
Allow me to be your guide on the amazing journey of learning to program with the Microsoft Access with VBA.
Course Content
- 8 section(s)
- 42 lecture(s)
- Section 1 Getting Started with Microsoft Access VBA
- Section 2 Working with Access VBA SUB Procedures and Functions
- Section 3 Understanding and Working with Access Objects with VBA
- Section 4 Foundational VBA Programming Concepts
- Section 5 Working with the Access Recordset Object
- Section 6 Debugging Access VBA Code
- Section 7 Access VBA - Project #1 Working with Access VBA SUB Procedures
- Section 8 Congratulations and Bonus
What You’ll Learn
- Automate routine Microsoft Access process with Access VBA
- Develop intuitive, accessible Access Applications
- Writing VBA Code from Scratch
- Build a Solid Foundation with Access VBA
Skills covered in this course
Reviews
-
TT M
I gained a very clear understanding of the basic usage of Access VBA.
-
JJoão Jacinto
Muito bem organizado e aulas bem interligadas. Aproveita fazer erros no código para ensinar mais além. Muito bom para iniciar VBA
-
PPrajeeth K
The course till now is wonderful. I am a Planning Engineer with limited exposure to coding and I want to code for building better data management tools. I find the course easy to grasp for novices like me as well.
-
CChristopher McKinnon
This seems like it was lifted whole from the full Access course. The info was good but except for the Button VBA, most of what he showed did not seem to have a practice use for creating functionality for most users in VBA. I liked what I learned, but I would have liked to see how it could be applied in a more practical manner. I have some ideas for that but they stem from other experiences I have had as opposed to information the course offered.
