Microsoft Office 2007/2010
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.
Microsoft Office 2007-2010 Training Courses
Microsoft Access 07/10
Introduction
Microsoft Access 07/10
Intermediate
Microsoft Access 07/10
Macros
Microsoft Access VBA
Introduction
Microsoft Excel 07/10
Introduction
Microsoft Excel 07/10
Intermediate/Advanced
Microsoft Excel 07/10
Formulas and Functions
Microsoft Excel 07/10
Macros
Microsoft Excel 2007
Upgrade
Microsoft Excel 2010
Upgrade
Microsoft Office 2010
Upgrade
Microsoft OneNote 07/10
Introduction 
Microsoft Outlook 2007
Introduction/Intermediate
Microsoft Outlook 2010
Introduction/Intermediate
Microsoft PowerPoint 07/10
Introduction
Microsoft PowerPoint 2007
Intermediate/Advanced
Microsoft PowerPoint 2010
Intermediate/Advanced
Microsoft PowerPoint 2007
Upgrade
Microsoft PowerPoint 2010
Upgrade
Microsoft Project 2007
Introduction
Microsoft Project 2007
Intermediate
Microsoft Project 2010
Introduction
Microsoft Project 2010
Intermediate
Microsoft Publisher 2007
Introduction
Microsoft SharePoint 2007
Introduction
Microsoft SharePoint 2010
Introduction
Microsoft SharePoint 2010
Upgrade
Microsoft Visio 2007
Introduction
Microsoft Visio 2010
Introduction
Microsoft Word 07/10
Introduction
Microsoft Word 07/10
Intermediate/Advanced
Microsoft Word 07/10
Styles and Forms
Microsoft Word 2007
Upgrade
Microsoft Word 2010
Upgrade
Microsoft Access 2007/2010
Macros
Course Information
Duration: One-Day Course
Platform: Windows Only
Fee: $325 CDN (+HST)
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. 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. In addition, you will learn to develop Macros for global keyboard shortcuts.
Please note that this course is not a VBA programming course, but instead uses Macro objects in Access.
Course Content
Basic Macro Concepts
- Understand the Macro sheet window
- Use the Macro tools on the Ribbon
- Create, name and edit macros
- Review macro actions and arguments
- Understand different types of events
- Run macros in various ways including embedding on a form
Conditional Macros and Macro Groups
- Understand macro names and macro groups
- Create conditional macros using a variety of 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
(PDF 55 kb)