From the course: Access Essential Training (Office 365/Microsoft)
Join today to access over 24,900 courses taught by industry experts.
Take a quick peek at the Visual Basic language - Microsoft Access Tutorial
From the course: Access Essential Training (Office 365/Microsoft)
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 SQL code for you behind the scenes, there's several places where you may add an interactive event, and Access is really writing Visual Basic. We can see an example of that on the customer orders form. This form was created by the wizard and it placed this button on the form. If I go into design view and select the button, open up the property sheet and take a look at the on click event, you'll see it's listed as event procedure, instead of embedded macro like the button that we created. Click the build button to the right, and that opens up an entirely separate coding application called Visual Basic for Applications. Here is the code that's executed when you click the button, it opens up the second form and applies a filter to the…
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.