Access Macros

Adding your own functionality

or

Say yes to programming

Created by Paul Scarrone / @PaulSCoder

Lets Get Started

Access File

What is a Macro?

Set of ordered instructions for the purpose of automating frequently used tasks

Programming you say

Basically yes with a focus on the basically

What does a Macro Look Like?

Lets do a Trivial Example Together

We are going to construct a form and give it some functionality

We start with a blank form

Then we Add Some Controls

Make a form that looks something like this

Some housekeeping

Its always a good idea to get an idea of what our controls are named and setup their default values.

Set the default text property of our text box to something fun.

Now for the Fun...Programming :)

Our Goal is to make this form change the value in the text field to happy/sad depending on the button clicked

Lets get into macro view

Right click a button and select 'Build Event'

Here is our 'Sad' button

Notice the action catalog to the right as well

Your turn!

Go ahead and try and make the happy button do its job

Congratulations

While this could be considered trivial being able to interact with properties is very important to generating rich applications

Remember programming is all small trivial pieces

Where do you see opportunties for useful macros?

Do you want to play a game?

Rock Paper Scissors

Checkout RPS

THE END?

BY Paul Scarrone