Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 3 hours on-demand video
  • 3 articles
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Access VBA

Microsoft Access VBA, Design and Advanced Methods Workshop 2

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!
Rating: 4.7 out of 54.7 (187 ratings)
3,503 students
Created by Bruce Myron
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Perform several advanced Microsoft Access VBA techniques that will enable them to create more robust database systems
Curated for the Udemy for Business collection

Requirements

  • Students should have had some exposure to Microsoft Access VBA.

Description

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific design challenge from a student and then go over the details of how I would handle it.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

This course will not remain this price forever! It's time to take action!

Click the "Take This Course" button at the top right now!

...every hour you delay is costing you money...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Who this course is for:

  • A person who has some exposure to Microsoft Access VBA, but wants to learn more advanced methods.

Course content

8 sections • 29 lectures • 3h 2m total length

  • Preview03:39
  • Important NOTE on DOWNLOADABLE RESOURCES
    00:19

  • Preview07:37
  • Setting Subform Colors with Access VBA
    07:21
  • Finish Placing Codes and Final Testing
    05:19

  • Preview02:16
  • Create the Query that Makes the SalesByQuarter Table
    06:46
  • Start Building the GetLastYear Query
    09:20
  • Add the Sales Difference to the GetLastYear Query
    04:25

  • Create Running and Page Totals
    10:06

  • NOTE on modification to the way Access works when appending records
    00:12
  • Set the Starting CustID and Append Customer Data
    05:33

  • Overview of the BackToRecord Database
    02:28
  • Open on Customer Form and Record Values on Exit
    10:15
  • Modify the Customer Open Subroutine to Use the values in the table
    08:43

  • Overview of the Call List Design Challenge
    11:47
  • Add VBA Code to the Edit Button
    11:14
  • A Function to Test for No Records and Add VBA Code to the Add Button
    11:15
  • Create a Subroutine to Sort the Call List Records
    05:01
  • Add Code to the Delete Button
    09:26
  • Start Building Code for the Change To Combo Box
    06:45
  • Build the LostFocus Sub and Start the AfterUpdate Sub
    05:45
  • Figure Out How to Handle Change To Renumbering
    03:39
  • Create the Decrease Sequence Subroutine
    06:45
  • Create the Increase Sequence Subroutine
    07:25
  • Testing for Errors
    08:45
  • Final Testing and Debugging
    08:08

  • Conclusion and Overview of What We Covered
    02:07
  • BONUS Lecture! Learn Even More!
    00:15

Instructor

Bruce Myron
Productivity Specialist
Bruce Myron
  • 4.6 Instructor Rating
  • 21,332 Reviews
  • 107,671 Students
  • 19 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.