From the course: Access: VBA
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Introduction to Access macros and data macros
From the course: Access: VBA
Introduction to Access macros and data macros
- [Instructor] There are several different ways that you can automate Microsoft Access by creating different types of macros and VBA code. In this movie, I will provide a quick comparison for the three methods that are most often used. I've already described the one, VBA, and we'll describe the other two, which we'll cover in this chapter. First, macros let you select actions from a predefined list. In Microsoft Access, macros are considered separate from Visual Basic for Applications. So your VBA code in, for example, Microsoft Excel, is usually called a macro. However, in Access, macro means a specific type of database object. Data macros let you build actions when table data meets specific criteria. For example, if you have a customer from California, you can have a data action that sends you an email indicating that they signed up. There might be special information, or discounts, or perhaps, government programs for customers from California. And finally, VBA lets you do just…
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.