16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

Access 2003: Macro Automation 8:30am-12:00pm

Available Dates: Request Dates
Class Length: Half day

Class Outline:

Course Outline
Unit 3 : Macros
Topic A: 0 Creating, running, and modifying macros
A-1: Creating and running a macro
A-2: Modifying a macro
Topic B: 0 Attaching macros to the events of database objects
B-1: Attaching a macro to the Open event of a form
B-2: Attaching a macro to a command button
B-3: Using a macro to resize and move a form’s window
Unit 4 : Advanced macros
Topic A: 0 Creating macros to provide user interaction
A-1: Creating a data validation macro
A-2: Creating a data-entry macro
Topic B: 0 Creating macros that require user input
B-1: Creating a macro that runs a parameter query
Topic C: 0 Creating the AutoKeys and AutoExec macros
C-1: Creating an AutoKeys macro
C-2: Creating an AutoExec macro
Topic D: 0 Creating macros for data transfer
Unit 3 : Working with form controls
Topic A: 0 Working with dialog boxes
A-1: Examining the properties of a dialog box
A-2: Creating a dialog box
Topic B: 0 Working with macro groups
B-1: Examining a macro group
B-2: Creating a macro group
B-3: Attaching a macro group to an event