Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2011 Mark Collins
About this chapter
Cite this chapter
Collins, M. (2011). Using Data Macros. In: Pro Access 2010 Development. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3579-8_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3579-8_3
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3578-1
Online ISBN: 978-1-4302-3579-8
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)