Many developers who get into Access skip over the step of using macros to automate applications. But there are some tasks that must be performed using macros rather than code.
The Access team at Microsoft have worked hard to whittle down the need to use macros. The tasks that macros are still needed for are as follows:
You use Autokeys macros create key combinations. A common example is using ^P to print (where ^ is used for the Ctrl key). Third-party vendors and developers who are creating “Office-compatible” applications use Autokeys to include necessary key combinations.
You can use Access as a DDE server for other Windows applications. When another application wants ...