Microsoft Access VBA for Non Programmers - YOU Can Do This!

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic!

Some Student Reviews:

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 Wong

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!

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 Software

You 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.
  • 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 Show more Show less Curated for the Udemy Business collection Requirements No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription. Description Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic! Some Student Reviews: 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 Wong 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! 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 8 0+ 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 Software You 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. Show more Show less Featured review Frank Freese 85 courses 35 reviews Rating: 5.0 out of 5 a year ago Bruce will take you through Access VBA like I have never seen before. I would suggest that you work the exercises with him to get the most out of this course. This is simply the BEST Access VBA class I have ever taken. Don't let the name of this course appear to be a cake walk. You are going to work and work some more but the benefits are worth it! Thanks Bruce - a fantastic job, great lessons, amazing examples. I am looking forward to the other classes you have! Show more Show less Course content 13 sections • 99 lectures • 8h 21m total length Expand all sections Introduction 3 lectures • 6min Course Overview Preview 03:08 Setup Tasks 02:59 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Start Learning VBA and Handling Errors 9 lectures • 42min View Database Table and Forms - Review the Goal Preview 01:51 Create Your First VBA Subroutine! Preview 07:41 Fix a Syntax Error and Take Over the Keyboard Preview 03:24 Use an IF Statement and DoCmd 04:28 Use ElseIf and a Select Statement 06:13 Runtime Errors, Error Traps and Program Stops 09:59 Break Into Programs and Infinite Loops 03:48 What Have You Learned in Section 2? 5 questions Section 2 Conclusion and Review 04:06 Section 2 Notes 2 pages Create Record Sorting Subroutines 6 lectures • 24min On Open Event, Me Keyword and Orderby 05:54 NOTE on Label Events Not Appearing 00:37 Subroutines for Form Controls, VBA Editing Shortcuts 05:25 Modify Subroutines to Sort DESC, More Error Handling 10:24 What Have You Learned in Section 3? 4 questions Section 3 Conclusion and Review 01:30 Section 3 Notes 2 pages Use Instant Search to Learn More About the Keyboard, Recordsets and Variables 8 lectures • 48min Expanding the Keydown Subroutine 06:35 Using Public Variables 06:13 Building the Search Criteria 06:36 Field Names and Reserved Words 08:40 Using a Recordset and Bookmarks 05:37 Enhancing Our Instant Search 11:06 What Have You Learned In Section 4? 6 questions Section 4 Conclusion and Review 03:12 Section 4 Notes 4 pages Interact With Other Forms and Pass Information 12 lectures • 1hr 4min Open Another Form with a Button Click 06:17 Send Data to the Other Form 04:15 Modify a Form to Utilize Data Sent to it. 06:06 Intro to SQL and Using SQL in the Recordsource 07:09 Locate Same Record When Returning from the Form 05:27 Modify the Form to Remember the Sort 06:34 Create a Prompt to Save Changes 04:50 Activate the Add Customer Button 04:30 Testing for a Blank Record 09:54 Activate the Delete Button 06:02 What Have You Learned in Section 5? 11 questions Section 5 Conclusion and Review 02:31 Section 5 Notes 5 pages Add Multiple Interactive Pulldown Filters 9 lectures • 52min Setup Rowsource for Dropdown Filters 08:29 Enable Editing In the Dropdown Filters 07:49 Set Dropdown Rowsources on the Fly 08:25 Create a Subroutine to Build All the Filters 07:35 Use the AfterUpdate Event to Rebuild the Filter 03:29 Setup the Clear Filter Buttons 04:43 Save the Filters when Closing the Form 08:30 What Have You Learned in Section 6? 6 questions Section 6 Conclusion and Review 03:02 Section 6 Notes 5 pages Build a Report Containing Complex Calculations 11 lectures • 1hr 4min Inspect the Tables and Review the Goal 03:00 Creating a Summary Table with a Query 06:44 Building Our First Function and Saving Queries to VBA 06:16 Add a Delete Query and Create a Test Macro 04:30 Restructure Tables and Add a Second Query to our VBA Function 06:24 Figure Out How to Get the Days Between Orders 06:06 Doing the Steps With A Recordset 10:06 Calculate the Average Days Between Orders 07:04 Plug the Average Days into the Report Table 10:39 What Have You Learned In Section 7? 10 questions Section 7 Conclusion and Review 02:45 Section 7 Notes 5 pages Turn Off The Menu, Ribbon and Navigation Pane 8 lectures • 31min View the Example of Removing the Nav Pane and Ribbon 01:39 Create the HideMenu subroutine 07:16 Call the HideMenu Subroutine from our Form 04:15 Make the Subroutine Toggle the Menus 04:54 Create a Startup Subroutine and an Autoexec Macro 04:38 Prevent Closing the Form and Activate the Exit Button 05:54 What Have You Learned in Section 8? 8 questions Section 8 Conclusion and Review 02:02 Section 8 Notes 3 pages How to Create and Modify Table Structures In VBA 7 lectures • 25min Overview and Goal 01:57 Create Delete Subroutine and Make First Changes to SummRpt Function 02:57 Backup the SummRpt Function and Make the First Changes 02:55 Pull a Query from VBA Back to Design, Change It and Update VBA 04:45 Use TableDefs to Add a Field to a Table 04:50 Use TableDefs to Create a Table and Add FIelds to it. 04:21 Make Final Changes and Test the Modified Function 02:50 Section 11: USING VBA with SUBFORMS 14 lectures • 1hr 9min Overview of the Tables in the Subforms Database 03:14 Overview of the Forms in the Subforms Database 02:18 Add OrderList as a Subform to the Customer Form. 06:38 Using an On Exit Subroutine to Capture the Order Number You Were On 04:47 Pass the Order Number to the Go To Order Button 04:37 Open the Orders Form and Move to the Specified Order 05:22 Create Code to Return to the Customer Form 05:32 Setup the OrdProdList Subform 04:51 Create a Total in the Subform 04:24 Update the Subtotal and Order Total 04:20 Add a New Product to the Order 05:00 Create the Add Order Subroutine and Post a New Order 09:51 Get the New Order Number and Open the Order Form 04:49 Review, Conclusion and Future Enhancements Preview 02:59 3 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678101ded8680702',m:'c731329f18df831103da7d99f8cf6da0f1e6ffc8-1627841260-1800-AWmlrBkEcK8h58mk1YP/ixNlkouLEMthWIfVAn0Br6wdq8FhC7cHnwyDC993+M+++ODdOFX5y+aFhyfXqpYBZ3Y00ZRSQauTRfn6dq5bZhN0OTp+V0dot+mXo9OdwbYLSOVkS1hUKgbLru42Eceer5E/Tqa0K+5e+jXPqBpdRrtQqFK3yFK3Jbbrlfi8F9Z1tkKvd3HOzwk2Q7v2F/dCrgk=',s:[0xf94be3b248,0x1b84dcddaa],}})();
  • 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 Show more Show less Curated for the Udemy Business collection Requirements No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription. Description Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic! Some Student Reviews: 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 Wong 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! 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 8 0+ 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 Software You 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. Show more Show less Featured review Frank Freese 85 courses 35 reviews Rating: 5.0 out of 5 a year ago Bruce will take you through Access VBA like I have never seen before. I would suggest that you work the exercises with him to get the most out of this course. This is simply the BEST Access VBA class I have ever taken. Don't let the name of this course appear to be a cake walk. You are going to work and work some more but the benefits are worth it! Thanks Bruce - a fantastic job, great lessons, amazing examples. I am looking forward to the other classes you have! Show more Show less Course content 13 sections • 99 lectures • 8h 21m total length Expand all sections Introduction 3 lectures • 6min Course Overview Preview 03:08 Setup Tasks 02:59 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Start Learning VBA and Handling Errors 9 lectures • 42min View Database Table and Forms - Review the Goal Preview 01:51 Create Your First VBA Subroutine! Preview 07:41 Fix a Syntax Error and Take Over the Keyboard Preview 03:24 Use an IF Statement and DoCmd 04:28 Use ElseIf and a Select Statement 06:13 Runtime Errors, Error Traps and Program Stops 09:59 Break Into Programs and Infinite Loops 03:48 What Have You Learned in Section 2? 5 questions Section 2 Conclusion and Review 04:06 Section 2 Notes 2 pages Create Record Sorting Subroutines 6 lectures • 24min On Open Event, Me Keyword and Orderby 05:54 NOTE on Label Events Not Appearing 00:37 Subroutines for Form Controls, VBA Editing Shortcuts 05:25 Modify Subroutines to Sort DESC, More Error Handling 10:24 What Have You Learned in Section 3? 4 questions Section 3 Conclusion and Review 01:30 Section 3 Notes 2 pages Use Instant Search to Learn More About the Keyboard, Recordsets and Variables 8 lectures • 48min Expanding the Keydown Subroutine 06:35 Using Public Variables 06:13 Building the Search Criteria 06:36 Field Names and Reserved Words 08:40 Using a Recordset and Bookmarks 05:37 Enhancing Our Instant Search 11:06 What Have You Learned In Section 4? 6 questions Section 4 Conclusion and Review 03:12 Section 4 Notes 4 pages Interact With Other Forms and Pass Information 12 lectures • 1hr 4min Open Another Form with a Button Click 06:17 Send Data to the Other Form 04:15 Modify a Form to Utilize Data Sent to it. 06:06 Intro to SQL and Using SQL in the Recordsource 07:09 Locate Same Record When Returning from the Form 05:27 Modify the Form to Remember the Sort 06:34 Create a Prompt to Save Changes 04:50 Activate the Add Customer Button 04:30 Testing for a Blank Record 09:54 Activate the Delete Button 06:02 What Have You Learned in Section 5? 11 questions Section 5 Conclusion and Review 02:31 Section 5 Notes 5 pages Add Multiple Interactive Pulldown Filters 9 lectures • 52min Setup Rowsource for Dropdown Filters 08:29 Enable Editing In the Dropdown Filters 07:49 Set Dropdown Rowsources on the Fly 08:25 Create a Subroutine to Build All the Filters 07:35 Use the AfterUpdate Event to Rebuild the Filter 03:29 Setup the Clear Filter Buttons 04:43 Save the Filters when Closing the Form 08:30 What Have You Learned in Section 6? 6 questions Section 6 Conclusion and Review 03:02 Section 6 Notes 5 pages Build a Report Containing Complex Calculations 11 lectures • 1hr 4min Inspect the Tables and Review the Goal 03:00 Creating a Summary Table with a Query 06:44 Building Our First Function and Saving Queries to VBA 06:16 Add a Delete Query and Create a Test Macro 04:30 Restructure Tables and Add a Second Query to our VBA Function 06:24 Figure Out How to Get the Days Between Orders 06:06 Doing the Steps With A Recordset 10:06 Calculate the Average Days Between Orders 07:04 Plug the Average Days into the Report Table 10:39 What Have You Learned In Section 7? 10 questions Section 7 Conclusion and Review 02:45 Section 7 Notes 5 pages Turn Off The Menu, Ribbon and Navigation Pane 8 lectures • 31min View the Example of Removing the Nav Pane and Ribbon 01:39 Create the HideMenu subroutine 07:16 Call the HideMenu Subroutine from our Form 04:15 Make the Subroutine Toggle the Menus 04:54 Create a Startup Subroutine and an Autoexec Macro 04:38 Prevent Closing the Form and Activate the Exit Button 05:54 What Have You Learned in Section 8? 8 questions Section 8 Conclusion and Review 02:02 Section 8 Notes 3 pages How to Create and Modify Table Structures In VBA 7 lectures • 25min Overview and Goal 01:57 Create Delete Subroutine and Make First Changes to SummRpt Function 02:57 Backup the SummRpt Function and Make the First Changes 02:55 Pull a Query from VBA Back to Design, Change It and Update VBA 04:45 Use TableDefs to Add a Field to a Table 04:50 Use TableDefs to Create a Table and Add FIelds to it. 04:21 Make Final Changes and Test the Modified Function 02:50 Section 11: USING VBA with SUBFORMS 14 lectures • 1hr 9min Overview of the Tables in the Subforms Database 03:14 Overview of the Forms in the Subforms Database 02:18 Add OrderList as a Subform to the Customer Form. 06:38 Using an On Exit Subroutine to Capture the Order Number You Were On 04:47 Pass the Order Number to the Go To Order Button 04:37 Open the Orders Form and Move to the Specified Order 05:22 Create Code to Return to the Customer Form 05:32 Setup the OrdProdList Subform 04:51 Create a Total in the Subform 04:24 Update the Subtotal and Order Total 04:20 Add a New Product to the Order 05:00 Create the Add Order Subroutine and Post a New Order 09:51 Get the New Order Number and Open the Order Form 04:49 Review, Conclusion and Future Enhancements Preview 02:59 3 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678101ded8680702',m:'c731329f18df831103da7d99f8cf6da0f1e6ffc8-1627841260-1800-AWmlrBkEcK8h58mk1YP/ixNlkouLEMthWIfVAn0Br6wdq8FhC7cHnwyDC993+M+++ODdOFX5y+aFhyfXqpYBZ3Y00ZRSQauTRfn6dq5bZhN0OTp+V0dot+mXo9OdwbYLSOVkS1hUKgbLru42Eceer5E/Tqa0K+5e+jXPqBpdRrtQqFK3yFK3Jbbrlfi8F9Z1tkKvd3HOzwk2Q7v2F/dCrgk=',s:[0xf94be3b248,0x1b84dcddaa],}})();
  • 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 Show more Show less Curated for the Udemy Business collection Requirements No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription. Description Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic! Some Student Reviews: 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 Wong 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! 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 8 0+ 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 Software You 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. Show more Show less Featured review Frank Freese 85 courses 35 reviews Rating: 5.0 out of 5 a year ago Bruce will take you through Access VBA like I have never seen before. I would suggest that you work the exercises with him to get the most out of this course. This is simply the BEST Access VBA class I have ever taken. Don't let the name of this course appear to be a cake walk. You are going to work and work some more but the benefits are worth it! Thanks Bruce - a fantastic job, great lessons, amazing examples. I am looking forward to the other classes you have! Show more Show less Course content 13 sections • 99 lectures • 8h 21m total length Expand all sections Introduction 3 lectures • 6min Course Overview Preview 03:08 Setup Tasks 02:59 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Start Learning VBA and Handling Errors 9 lectures • 42min View Database Table and Forms - Review the Goal Preview 01:51 Create Your First VBA Subroutine! Preview 07:41 Fix a Syntax Error and Take Over the Keyboard Preview 03:24 Use an IF Statement and DoCmd 04:28 Use ElseIf and a Select Statement 06:13 Runtime Errors, Error Traps and Program Stops 09:59 Break Into Programs and Infinite Loops 03:48 What Have You Learned in Section 2? 5 questions Section 2 Conclusion and Review 04:06 Section 2 Notes 2 pages Create Record Sorting Subroutines 6 lectures • 24min On Open Event, Me Keyword and Orderby 05:54 NOTE on Label Events Not Appearing 00:37 Subroutines for Form Controls, VBA Editing Shortcuts 05:25 Modify Subroutines to Sort DESC, More Error Handling 10:24 What Have You Learned in Section 3? 4 questions Section 3 Conclusion and Review 01:30 Section 3 Notes 2 pages Use Instant Search to Learn More About the Keyboard, Recordsets and Variables 8 lectures • 48min Expanding the Keydown Subroutine 06:35 Using Public Variables 06:13 Building the Search Criteria 06:36 Field Names and Reserved Words 08:40 Using a Recordset and Bookmarks 05:37 Enhancing Our Instant Search 11:06 What Have You Learned In Section 4? 6 questions Section 4 Conclusion and Review 03:12 Section 4 Notes 4 pages Interact With Other Forms and Pass Information 12 lectures • 1hr 4min Open Another Form with a Button Click 06:17 Send Data to the Other Form 04:15 Modify a Form to Utilize Data Sent to it. 06:06 Intro to SQL and Using SQL in the Recordsource 07:09 Locate Same Record When Returning from the Form 05:27 Modify the Form to Remember the Sort 06:34 Create a Prompt to Save Changes 04:50 Activate the Add Customer Button 04:30 Testing for a Blank Record 09:54 Activate the Delete Button 06:02 What Have You Learned in Section 5? 11 questions Section 5 Conclusion and Review 02:31 Section 5 Notes 5 pages Add Multiple Interactive Pulldown Filters 9 lectures • 52min Setup Rowsource for Dropdown Filters 08:29 Enable Editing In the Dropdown Filters 07:49 Set Dropdown Rowsources on the Fly 08:25 Create a Subroutine to Build All the Filters 07:35 Use the AfterUpdate Event to Rebuild the Filter 03:29 Setup the Clear Filter Buttons 04:43 Save the Filters when Closing the Form 08:30 What Have You Learned in Section 6? 6 questions Section 6 Conclusion and Review 03:02 Section 6 Notes 5 pages Build a Report Containing Complex Calculations 11 lectures • 1hr 4min Inspect the Tables and Review the Goal 03:00 Creating a Summary Table with a Query 06:44 Building Our First Function and Saving Queries to VBA 06:16 Add a Delete Query and Create a Test Macro 04:30 Restructure Tables and Add a Second Query to our VBA Function 06:24 Figure Out How to Get the Days Between Orders 06:06 Doing the Steps With A Recordset 10:06 Calculate the Average Days Between Orders 07:04 Plug the Average Days into the Report Table 10:39 What Have You Learned In Section 7? 10 questions Section 7 Conclusion and Review 02:45 Section 7 Notes 5 pages Turn Off The Menu, Ribbon and Navigation Pane 8 lectures • 31min View the Example of Removing the Nav Pane and Ribbon 01:39 Create the HideMenu subroutine 07:16 Call the HideMenu Subroutine from our Form 04:15 Make the Subroutine Toggle the Menus 04:54 Create a Startup Subroutine and an Autoexec Macro 04:38 Prevent Closing the Form and Activate the Exit Button 05:54 What Have You Learned in Section 8? 8 questions Section 8 Conclusion and Review 02:02 Section 8 Notes 3 pages How to Create and Modify Table Structures In VBA 7 lectures • 25min Overview and Goal 01:57 Create Delete Subroutine and Make First Changes to SummRpt Function 02:57 Backup the SummRpt Function and Make the First Changes 02:55 Pull a Query from VBA Back to Design, Change It and Update VBA 04:45 Use TableDefs to Add a Field to a Table 04:50 Use TableDefs to Create a Table and Add FIelds to it. 04:21 Make Final Changes and Test the Modified Function 02:50 Section 11: USING VBA with SUBFORMS 14 lectures • 1hr 9min Overview of the Tables in the Subforms Database 03:14 Overview of the Forms in the Subforms Database 02:18 Add OrderList as a Subform to the Customer Form. 06:38 Using an On Exit Subroutine to Capture the Order Number You Were On 04:47 Pass the Order Number to the Go To Order Button 04:37 Open the Orders Form and Move to the Specified Order 05:22 Create Code to Return to the Customer Form 05:32 Setup the OrdProdList Subform 04:51 Create a Total in the Subform 04:24 Update the Subtotal and Order Total 04:20 Add a New Product to the Order 05:00 Create the Add Order Subroutine and Post a New Order 09:51 Get the New Order Number and Open the Order Form 04:49 Review, Conclusion and Future Enhancements Preview 02:59 3 more sections Instructor Bruce Myron Productivity Specialist 4.6 Instructor Rating 23,165 Reviews 112,526 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. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'678101ded8680702',m:'c731329f18df831103da7d99f8cf6da0f1e6ffc8-1627841260-1800-AWmlrBkEcK8h58mk1YP/ixNlkouLEMthWIfVAn0Br6wdq8FhC7cHnwyDC993+M+++ODdOFX5y+aFhyfXqpYBZ3Y00ZRSQauTRfn6dq5bZhN0OTp+V0dot+mXo9OdwbYLSOVkS1hUKgbLru42Eceer5E/Tqa0K+5e+jXPqBpdRrtQqFK3yFK3Jbbrlfi8F9Z1tkKvd3HOzwk2Q7v2F/dCrgk=',s:[0xf94be3b248,0x1b84dcddaa],}})();
  • 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 Show more Show less Curated for the Udemy Business collection Requirements No programming knowledge is necessary! Just a very basic familiarity with Access Tables, Queries, Forms and Reports. The videos show every step and you will also always have finished examples to compare to. The course was created in Access 2010, but the downloadable databases provided with each section are in Access 2000 format, so can be used with any version of Access from 2000 through 2016, or with a current Office 365 subscription. Description Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic! Some Student Reviews: 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 Wong 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! 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 8 0+ 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 Software You 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. Show more Show less Featured review Frank Freese 85 courses 35 reviews Rating: 5.0 out of 5 a year ago Bruce will take you through Access VBA like I have never seen before. I would suggest that you work the exercises with him to get the most out of this course. This is simply the BEST Access VBA class I have ever taken. Don't let the name of this course appear to be a cake walk. You are going to work and work some more but the benefits are worth it! Thanks Bruce - a fantastic job, great lessons, amazing examples. I am looking forward to the other classes you have! Show more Show less Course content 13 sections • 99 lectures • 8h 21m total length Expand all sections Introduction 3 lectures • 6min Course Overview Preview 03:08 Setup Tasks 02:59 Important NOTE on DOWNLOADABLE RESOURCES 00:19 Start Learning VBA and Handling Errors 9 lectures • 42min View Database Table and Forms - Review the Goal Preview 01:51 Create Your First VBA Subroutine! Preview 07:41 Fix a Syntax Error and Take Over the Keyboard Preview 03:24 Use an IF Statement and DoCmd 04:28 Use ElseIf and a Select Statement 06:13 Runtime Errors, Error Traps and Program Stops 09:59 Break Into Programs and Infinite Loops 03:48 What Have You Learned in Section 2? 5 questions Section 2 Conclusion and Review 04:06 Section 2 Notes 2 pages Create Record Sorting Subroutines 6 lectures • 24min On Open Event, Me Keyword and Orderby 05:54 NOTE on Label Events Not Appearing 00:37 Subroutines for Form Controls, VBA Editing Shortcuts 05:25 Modify Subroutines to Sort DESC, More Error Handling 10:24 What Have You Learned in Section 3? 4 questions Section 3 Conclusion and Review 01:30 Section 3 Notes 2 pages Use Instant Search to Learn More About the Keyboard, Recordsets and Variables 8 lectures • 48min Expanding the Keydown Subroutine 06:35 Using Public Variables 06:13 Building the Search Criteria 06:36 Field Names and Reserved Words 08:40 Using a Recordset and Bookmarks 05:37 Enhancing Our Instant Search 11:06 What Have You Learned In Section 4? 6 questions Section 4 Conclusion and Review 03:12 Section 4 Notes 4 pages Interact With Other Forms and Pass Information 12 lectures • 1hr 4min Open Another Form with a Button Click 06:17 Send Data to the Other Form 04:15 Modify a Form to Utilize Data Sent to it. 06:06 Intro to SQL and Using SQL in the Recordsource 07:09 Locate Same Record When Returning from the Form 05:27 Modify the Form to Remember the Sort 06:34 Create a Prompt to Save Changes 04:50 Activate the Add Customer Button 04:30 Testing for a Blank Record 09:54 Activate the Delete Button 06:02 What Have You Learned in Section 5? 11 questions Section 5 Conclusion and Review 02:31 Section 5 Notes 5 pages Add Multiple Interactive Pulldown Filters 9 lectures • 52min Setup Rowsource for Dropdown Filters 08:29 Enable Editing In the Dropdown Filters 07:49 Set Dropdown Rowsources on the Fly 08:25 Create a Subroutine to Build All the Filters 07:35 Use the AfterUpdate Event to Rebuild the Filter 03:29 Setup the Clear Filter Buttons 04:43 Save the Filters when Closing the Form 08:30 What Have You Learned in Section 6? 6 questions Section 6 Conclusion and Review 03:02 Section 6 Notes 5 pages Build a Report Containing Complex Calculations 11 lectures • 1hr 4min Inspect the Tables and Review the Goal 03:00 Creating a Summary Table with a Query 06:44 Building Our First Function and Saving Queries to VBA 06:16 Add a Delete Query and Create a Test Macro 04:30 Restructure Tables and Add a Second Query to our VBA Function 06:24 Figure Out How to Get the Days Between Orders 06:06 Doing the Steps With A Recordset 10:06 Calculate the Average Days Between Orders 07:04 Plug the Average Days into the Report Table 10:39 What Have You Learned In Section 7? 10 questions Section 7 Conclusion and Review 02:45 Section 7 Notes 5 pages Turn Off The Menu, Ribbon and Navigation Pane 8 lectures • 31min View the Example of Removing the Nav Pane and Ribbon 01:39 Create the HideMenu subroutine 07:16 Call the HideMenu Subroutine from our Form 04:15 Make the Subroutine Toggle the Menus 04:54 Create a Startup Subroutine and an Autoexec Macro 04:38 Prevent Closing the Form and Activate the Exit Button 05:54 What Have You Learned in Section 8? 8 questions Secti