Home > Microsoft Office Training:
Microsoft Access Training - Macros
Microsoft Office 2000-2003
Application Overview:
Microsoft Access
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.
Upgrade to Microsoft Office 2007 Training
Microsoft Office 2000-2003 Training
Microsoft Access
Macros
Course Information
Duration: One-Day Course
Platform: Windows Only
Fee: $325 CDN (+GST)
This class is limited to eight people.
Course Overview
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.
Course Content
Custom Toolbars and Menus
- Create a new custom toolbar
- Add menu command buttons to toolbars
- Create Global Toolbars
- Control the display of custom toolbars
- Create custom menus
- Control the display of custom menus
Basic Macro Concepts
- Understand the Macro sheet window
- Use the Macro toolbar
- Create, name and edit macros
- Review macro actions and arguments
- Run macros in various ways
- Understand different types of events
- Run a macro as an event
Conditional Macros and Macro Groups
- Understand macro names and macro groups
- Create conditional macros using various conditions
- Test and debug macros
Special Types of Macros
- Create macros to execute on startup
- Create macros for global shortcut keys
- Use the QBF (Query by Form) method to query data using a form, macro and a query
- Create various unbound forms to act as dialog boxes to run macros
Calendar Dates:
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Certificate Programs
Our certification programs give you the opportunity to build your proficiency in electronic imaging, page layout, Internet, and office productivity while saving you a considerable amount.
more >>
(PDF 55 kb)