Microsoft Access VBA for Non Programmers - YOU Can Do This! (Udemy.com)
Microsoft Access VBA can be learned quickly even if you've never done programming! Make complex jobs easy with VBA!
Created by: Bruce Myron
Produced in 2021
What you will learn
- Be able to create and test vba subroutines and functions
- Be comfortable with moving to and from the vba editor
- Take control of the keyboard within forms
- Control interaction between forms and pass data back and forth
- Tie sorting to clicking on controls within forms
- Create and debug pull down filters on forms
- Create the capability to instantly search for records
- Use recordsets within forms to locate specific records
- Convert queries into SQL and place them inside vBA code
- Create complex reports using embedded queries and recordsets
- Secure forms by turning off resize and close capabilities
- Hide the menu and navigation pane and bring them back
Quality Score
Overall Score : 94 / 100
Course Description
Some StudentReviews:
Microsoft Access VBA for Non Programmers-Learn VBA. Thanks to the course my knowledge of VBA has increased to a workplace skill level. I am further confident in reading and writing code. Without a programmers background, I have been successfully able to follow the lectures and replicate the database structures as outlined. An excellent resource in code writing and application for database development. - Fleur Pepper"This is the best class I've taken on Udemy. There isn't a wasted minute in these videos. Thanks, Bruce!" - William Vicars"I used to think I was an expert at Access until I took this course. Bruce has a way of presenting material that makes you learn it on the first view. He goes into all nooks and crannies of the subject presented. I highly recommend this course for beginners and experts alike.." - Rafal Krolik"Bruce has created a really extensive course about Access. This course is built in bite size bits and every section teaches you an additional function in Access. The best thing about this course is that it is very low key and is really designed to help out the non-programmer. VBA might be very intimidating but this course shows you everything. The pace is good and every part is being explained in an excellent manner. I highly recommend this course especially if you want to learn and while learning create a wonderful tool that truly is useful." - Nicky WongBuild a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!
Create VBA Subroutines for Forms and Control the KeyboardExtensive Training on Handling ErrorsControl Record Sorting and Searching for Specific RecordsLearn How to Move and Pass Data Between FormsCreate Interactive Pull Down Filters for Form DataBuild a Complex Report Entirely with VBAIntroduction to SQL and How to Use SQL in VBATurn the Ribbon and Nav Pane On and OffPrevent Form Closure or ResizingLearn How to Close Access with VBAPowerful Skills That Increase Your Value in the MarketplaceLearning 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!
Content and Overview All you need to do the course is some basic experience with Access components: tables, queries, forms and reports. This course does not require any programming experience or knowledge of macros.
Even though there are 80+ lectures and over 7.
5 hours of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows. You will find that each chapter builds on the previous one as you build a complete system, step by step. By the time you have finished the course you will have done so much with VBA and it will be so familiar that you will be ready to tackle your own project immediately, putting your new learned skills into practical use and impressing your boss and coworkers.
The course is complete with working files and finished code samples for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.
Clicking the Take This Course button could be the best step you could take towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!
Required SoftwareYou should have Office 2010 or later. The course was created using Office 2010.
Who this course is for:
This course is meant for those who have a basic familiarity with Microsoft Access, but have never used macros or done any VBA programming.
Instructor Details
- 4.7 Rating
288 Reviews
Bruce Myron
Hello, my name is Bruce Myron. 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.
More courses by Bruce Myron
Excel to Access: Intro to Microsoft Access for Excel Users (2021)
4.8 (299 Reviews)
Provider: Udemy
Time: 10h
$11.99
Microsoft Access VBA, Design and Advanced Methods Workshop 1 (2021)
4.7 (144 Reviews)
- Provider: Udemy
- Time: 3h
$11.99
Microsoft Access VBA: Automating Import of Excel Files (2021)
4.8 (112 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
Access to Excel- Instant Excel Reports & Excel Pivot Tables (2021)
4.8 (100 Reviews)
- Provider: Udemy
- Time: 2h
$11.99
Microsoft Access Networking 2: Maximum Security (2021)
4.9 (68 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
8h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
