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

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training+course · Courses in microsoft access · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

How does macros work with Access

Deborah has attended:
Access Intermediate course

by - delegate Deborah [1 post] (2007 Feb 6 Tue, 09:54) Reply

How does macros work wiith access

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: how does macros work with Access

by - trainer Richard platinum contributer [785 posts] (2007 Feb 6 Tue, 11:17) Reply

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.

· Tips for designing databases in Microsoft Access
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Microsoft Access 2007: New Features
· Microsoft Access Training Unleashes the Power of the Pivot Table

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips