O'Reilly logo

Pro Access 2010 Development by Mark Collins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Using Data Macros

Data macros are arguably the best new feature in Access 2010. In the previous chapter, I showed you how to use foreign key and other constraints to ensure data integrity. Data macros will allow you to take this to a whole new level. Constraints keep the user from doing bad things, while data macros can do good things to keep the data in sync. For example, when a Loan is created, data macros can be used to automatically update the InventoryItem to show it has been checked out. Similarly, when the Loan is updated to show it has been checked back in, the InventoryItem is updated as well.

In earlier versions of Access, this type of logic had to be implemented with VBA code as part of the UI implementation. You'll see as ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required