Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Workshop 7: Access VBA, Design and Advanced Methods

Name: Workshop 7: Access VBA, Design and Advanced Methods
Rating: 4.8 (115 reviews)

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created byBruce Myron

Last updated 6/2024

English

English [Auto],

What you'll learn

Perform several advanced Microsoft Access techniques that will enable them to create more robust database systems

Course content

7 sections • 16 lectures • 1h 54m total length

Introduction2:43
Explore Access VBA techniques, including substring combo boxes, default forms and controls, calendars on new records, quick backups, and highlighting the current record on continuous forms.
Important NOTE on DOWNLOADABLE RESOURCES0:19

Overview and Review of Standard Combo Box8:38
Learn to build a substring-searching combo box in Access VBA, enabling instant search across a customer table and keyboard navigation to quickly locate records.
Create a Sub to Change the Combo Row Source10:29
create a subroutine to dynamically update a combo box row source as you type, using a search value and wildcard criteria to filter by first name, last name, and address.
Modify Keydown to use our new subroutine6:09
Modify the keydown event to call a new subroutine that updates a combo box row source from the search value, handling escape and backspace to reset and refresh the dropdown.
Modify the ESC and Backspace Keys9:47
Demonstrates handling escape and backspace in an Access VBA form: clear search, reset row source, update the combo box, and keep the cursor at the end for smooth filtering.

Auto Show a Calendar on blank Date Fields4:02
Auto show a calendar for blank date fields in Access forms with VBA. Use got focus, null checks, and send keys (alt down arrow) to trigger the calendar.
Test Query Parameter Values as they are entered.4:55
Learn to create and validate parameter queries in Access, using start date, end date, low value, and high value prompts. Set parameters in design and handle input to improve reliability.
Create a Quick Database Backup button14:33
Create a quick database backup button in Access VBA that uses a shell command with xcopy to copy the current database to a backup folder, handling quotes and spaces.

Build the Wrapper Form and Listbox8:54
Build a wrapper form with a two-column list box and a continuous form to filter product sales by selections. Use product code and name with simple multi-select.
Create VBA to Get the Product List7:05
Create a VBA subroutine for a list box after update to build filter from selected items. Use a variant for item data and verify the filter with a message box.
Apply the Filter to the Form6:52
Apply a filter to the form using a multi-select list box, set the subform's filter with the filter string, and add a clear button to reset selections.

Requirements

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

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 workshop that you will not find an ANY of my other courses!

I also include a specific database 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.

Workshop 7: Access VBA, Design and Advanced Methods

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 3min

Create a Substring Search Combo Box4 lectures • 35min

Creating Default Forms and Controls2 lectures • 17min

QUICK TIPS3 lectures • 24min

Highlight the Current Record in a Continuous Form1 lecture • 12min

DESIGN CHALLENGE: Create a Multi Select Listbox to Filter a Continuous Form3 lectures • 23min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: