Microsoft Access 2003

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.

On Request Only - Contact DPA

Course InformationRelated Training

Duration: One-Day Course
Platform: Windows Only
Fee: Call for information

We recommend one to eight people for this course.

Course Content Download PDF (57kb)

Custom Toolbars and Menus

Basic Macro Concepts

Conditional Macros and Macro Groups

Special Types of Macros

Application Overview: Microsoft Access 2003

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.