Course Outline

Access 2003 Macros
Learn to create, edit and save macros using the Access macro language. Explore combining macros, queries and forms and creating dialog boxes and menus. Learn how to use simple expressions and functions to control the logical flow of a macro and how to use forms and queries to store variables. 12 hours
Creating Macros
  • What is a macro?
  • Running a macro manually
  • Macro design window
  • Starting and saving a macro group
  • Naming a macro
  • Selecting an action
  • Selecting an action argument
  • Creating a macro to View/Edit Tables/Queries
  • Creating a macro to provide a message
  • Creating a macro to view a report
  • Creating a macro to transfer data
  • Editing in a macro group
  • Safe guarding a macro group

Menus and Forms

  • Understanding events
  • Command buttons using an existing macro
  • Building a new macro with On Click property
  • Renaming a referenced macro

Integrating Forms, Reports and Macros

  • Form controls as report criteria
  • Checking for null condition

Custom Command Buttons

  • Creating record navigation buttons
  • Duplicating fields from previous record
  • Creating buttons that modify control data

Form Controls as Query Criteria

  • Form controls as query criteria
Macros that Select Records
  • Creating a submenu
  • Using macros to synchronize forms
  • Creating a form to select random records

Record Processing

  • Creating historical data tables
  • Using tag property for messages

Changing Form and Control Properties

  • Using visible property for messages
  • Using enabled property to dim controls

Special Topics

  • (Optional) Storing default values for form controls
  • Using a version table
  • Creating a start up macro (Autoexec)
  • Startup and exiting tools
  • (Optional) Multi-MDB applications

 

Prerequisites:  MS Access Level 3 or equivalent experience.
Revised 7/6/10
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600