From the course: Access 2019: Macros
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Data macros and table events
- [Instructor] Data macros are an entirely different kind of macro. They're connected to data tables, and are triggered when something changes in the table. They're most commonly used to essentially watch what gets entered into a table, and then respond to that entry event by creating a log, noting the change that happened, and recording the time and date when the change was made. Let's create a simple logging system to help keep track of changes that are made to H-plus Sport's orders table. First, we're going to need a table to store the change log in. I'll go up here to the create tab and we'll start a new table in design view. The first field is going to be log ID. I'm press tab to come over here to the data type field and I'm going to choose A for autonumber and come down to the next line. The second field will be the order ID and this is where we'll store the order ID that's being changed back in the orders table. We'll choose the number data type for this. Next we're going to…
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.