microsoft+access+training+course - how does macros work

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+training+course - How does macros work with Access

microsoft+access+training+course - How does macros work with Access

resolvedResolved · Low Priority · Version Standard

Deborah has attended:
Access Intermediate course

How does macros work with Access

How does macros work wiith access

RE: how does macros work with Access

Macros in Access are built step by step rather than like a video recording in Excel, Word and PowerPoint.

Each step is programmed into the macro, like lines of code.
There are 3 main parts to each line of code.

The ACTION, ARGUMENTS and COMMENTS

ACTIONS define what you want to do to a specific object
ie. OPEN (a form)

ARGUMENTS specify which object you want the action done to.
ie open TABLE

COMMENTS allow you to describe the step you are taking in english, so you can refer back to what you have created.


 

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips


Server loaded in 0.09 secs.