Developing macros with Macro Designer


show more Developing macros with Macro Designer provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features show less
please wait ...

Developing macros with Macro Designer

Access 2010 has enhanced the Macro Designer window and tools to make it easy to develop macros from scratch. Let's start by going to the Create tab and then over here and click on Macro and that starts a new macro. The first thing you'll notice is that the Macro Designer now works right inside Access without opening up a subprogram. It's structure looks much more like real programming than the previous macro grid. It features an IntelliSense Builder. To get started choose the first action off the drop-down list. I'll choose OpenReport. As you choose your actions, boxes will appear to set your conditions and parameters.

I'll choose my Report Name and we'll use Salaries Report. If I want to add a filter right here I could. For my second action I could pick it off of the dropdown list. But let's take a look at the Action Catalog over here on the right-hand side. The actions are all grouped together by their function. If I click on the plus signs I can open them all ...

Developing macros with Macro Designer
Video duration: 2m 31s 36m 35s Intermediate

Viewers:

Developing macros with Macro Designer provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features

Subject:
Business
Software:
Access
Author:
please wait ...