This advanced level course is designed for the Access user who is familiar with creating and modifying tables, forms, queries and reports. In order to automate Access, you'll create custom toolbars, custom menus, and macros. Students will create multiple macros in macro groups and use conditional macros. Basic actions and arguments for macros will be addressed and numerous samples will be created including using unbound forms to run macros. Participants will learn to attach macros to buttons and events, test for errors and create macros to execute on startup. Macros will also be created for global keyboard shortcuts.
Please note that this course is not a VBA programming course, but instead uses Macro objects in Access.
On Request Only - Contact DPADuration: One-Day Course
Platform: Windows Only
Fee: Call for information
We recommend one to eight people for this course.
Microsoft Access is a relational database management system which combines the relational Microsoft Jet Database Engine with a graphical user interface. Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container. You can create a macro which is an action or set of actions that you can use to automate tasks. to perform a specific action. Microsoft Access lets you also create a macro group which is a collection of related macros that are stored together under a single macro name to perform a series of actions. The collection is often referred to simply as a macro.
Users: IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create robust databases that can be searched, sorted, analysed, reported, updated and shared with other users.