From the course: Access 2019: Tips, Tricks, and Techniques
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
VBA function basics
From the course: Access 2019: Tips, Tricks, and Techniques
VBA function basics
- [Instructor] Access shift with many built-in functions that you can use to modify the data that's stored in your data tables. Occasionally, however, the won't be enough to calculate exactly what you need. Or perhaps you want to save a complex calculation to use over and over again. In these cases, you'll want to create your own custom functions in Visual Basic. We can start that process by coming up to the Create tab, and coming over to the Macros & Code section, on the far right, and clicking on Module. That'll open up a brand new program called Microsoft Visual Basic for Applications. And this is where we get the acronym VBA. I wanna make sure that we have three different windows opened, here on our screen. We've got the Project Explorer, here on the upper left, the Properties Window, on the lower left, and the Immediate Window, across the bottom. If you're missing any of these windows, just come up here to View, and you can toggle them on with the Immediate Window option, Project…
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.