Access 2010 Creating Macros

Objective

Learn to set security options in Access that affect macros. Learn to create and edit user interface macros, embedded macros, and data macros. Learn to convert macros to Visual Basic for Applications (VBA) code.

Prerequisite Skills

Comfortable creating Access databases, tables, and queries.
(Suggested courses: Access 2010 Getting Started, Access 2010 Creating Tables, Access 2010 Enhancing Tables, Access 2010 Working with Table Relationships, Access 2010 Creating Select Queries, and Access 2010 Creating Advanced Queries)
Comfortable with forms and basic reports in Access
(Suggested courses: Access 2010 Creating Forms, Access 2010 Enhancing Forms, Access 2010 Creating Reports, and Access 2010 Enhancing Reports)

Course Description

Do you want to perform multiple database actions in a single step?

Attend this course if you want to:

Understand macro security settings.
Open databases that contain macros.
Use the Trust Center to set Trusted Locations and modify Trusted Documents.
Create user interface macros.
Work with embedded macros.
Work with data macros.
Add comments to a macro's design.
Use the If option to add conditions to a macro.
Convert macros to VBA code.

Class Length

90 minutes

Delivery Options

Virtual classroom - public
($70 per student; check times and register here)
Virtual classroom - dedicated (up to ten people from the same organization)
($480 per class; contact us for more details)
Virtual classroom - one on one
(Register for a 45-minute 1-on-1 Application Support session. Cost is $70 per student per session.)
On-site instructor-led
(Contact us for details)