Developers have screamed for this capability for several versions of Access. Find out how to use table macros to automate common database tasks at a table level. We will look at the before & after data macro events as well as named macros. Here are some of the examples that you will see… keeping track of who last updated a record, writing to a history table after a delete or change, maintain a de-normalized total on a parent table. Access 2010 has put a new face on the macro designer and added new functionality like parameter support, IntelliSense and copy and paste.
Paul Schnitzler is a full time Access & SQL Server developer serving a wide variety of businesses. He has over 10 years of experience with Access and SQL Server.