Ms Access Macro Work

Only available on StudyMode
  • Download(s) : 22
  • Published : December 6, 2012
Open Document
Text Preview
Intro To Macros

http://www.mousetraining.co.uk

Microsoft Access 2003 Macros Training Manual
http://www.mousetraining.co.uk

Table of Contents
SECTION ONE.................................................................................6 Intro to Macros ..................................................................................................................6 What is a Macro?.............................................................................................................7 Creating a Macro .............................................................................................................8 Action Pane .................................................................................................................9 Argument Pane............................................................................................................9 Argument Pane..........................................................................................................10 Editing a macro..............................................................................................................14 Using the Macro ............................................................................................................15

SECTION TWO ..............................................................................18 Macro Groups ..................................................................................................................18 Creating a Macro Group ................................................................................................19 Running a Macro within a Group..............................................................................20

SECTION THREE ..........................................................................22 Auto Keys..........................................................................................................................22 Auto Keys......................................................................................................................23 Assign an action or set of actions to a key ................................................................23

SECTION FOUR ............................................................................26 Event Procedures .............................................................................................................26 What is an event?...........................................................................................................27 Attaching Macros to Events ......................................................................................27 Different Types of Events..............................................................................................29 Working with command Buttons...................................................................................33

SECTION FIVE...............................................................................38 Conditional Macros .........................................................................................................38 Conditional Macros .......................................................................................................39 Conditions .................................................................................................................39 The Expression Builder .................................................................................................42 Validating Data .........................................................................................................42 Displaying Messages and Cancelling Events ............................................................43 Displaying the Message ..................................................................................43 Cancelling the Event.......................................................................................44 The SetValue Action...
tracking img