Modules and Macros in Access

Advanced

Every good database designer needs a tool belt with lots of tricks, and Macros are the 5-star tool you need to automate repetitive tasks. You will be introduced to writing Macros using the Visual Basic Editor and learn how to use Temporary variables and constants, as well as how to work securely. The class will give you lots of code snippets you can copy and use in any database. Plus, it’s super cool!

  • Different types of Macros
  • Embedded Macros
  • Macro Triggers
  • Reading VBA Code
  • Creating Variables
  • Temporary Variables
  • Loops and If Statements
  • Personal Shortcuts
  • Macro Security

Class Length: 4 hours. Can include up to 15 attendees in one session.