From the course: Microsoft Access Essential Training (Office 2024/LTSC)
Join today to access over 24,700 courses taught by industry experts.
Take a quick peek at the Visual Basic language
From the course: Microsoft Access Essential Training (Office 2024/LTSC)
Take a quick peek at the Visual Basic language
- [Instructor] Macros provide a user-friendly way to experiment with some basic automation procedures, but Access supports a much more powerful scripting language called Visual Basic. Just like when you create a query using the designer and Access writes the SQL code for you behind the scenes, there are several places where you may add an interactive event, and Access is really writing Visual Basic code for you. We can see an example of that if we look at the button that the Form Wizard created for us on the customer's orders form. Let's switch this form into Design View and take a look at it. I'm going to scroll over here on the design of my form and click that button. In the Property Sheet for the toggle button on the event tab, find the On Click event. Here you'll see it's listed as Event Procedure instead of Embedded Macro like the button that we created. Click the Build button on the far right and that opens up an entirely new environment. This is called Visual Basic for…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.