MS Access 2003 Advanced (Macros)

Training

In London

Price on request

Description

  • Type

    Training

  • Level

    Advanced

  • Location

    London

  • Duration

    1 Day

This course will provide users that have existing Intermediate level skills in Access to build on their knowledge. It will focus on automating repitive tasks in Access using Macros. We will also be focusinng on creating a user interface for your Access database. Suitable for: Existing Access users whom need to start automating database tasks or simply complex database sequences

Facilities

Location

Start date

London
See map
7th Floor Crystal Gate 28-30 Worship Street, EC2A 2AH

Start date

On request

About this course

To maximize the gain you receive from our MS Access 2003 Advanced training course, it is recommended that you have attended our MS Access Intermediate course or that you are at a similiar level.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course Contents

Macros

  • AnOverview
  • Creating Macros and Running Macros
  • Various Macro Actions

Names Macros

  • Using ^ + letter
  • Using ^ + Number
  • Function keys

Conditional Macros

  • Msgbox
  • Set value
  • Using functions

Event Procedures

  • On open/close
  • On got/lost focus

Creating a Switchboard (User Interface)

  • Designing a switchboard
  • Using Macros associated with Command Buttons
  • Using Macros associated with Code
  • Formatting switchboard forms
  • Creating a Splash Screen
  • Using autoexec
  • Custom toolbar
  • Custom menu
  • Start-up Menu

VBA

  • Sample subroutine
  • Sample function

Time: The course starts at 09:30 and runs until 16:30.

The course is run on a date that suits you! We do not run public scheduled courses.

Additional information

Payment options: All our courses are charged at a flat rate per day. One to One - Charged at £450 per day Training our Training centre - Charged at £695 per day All prices are excluding VAT and per day. Travel cost outside the M25 applies.

MS Access 2003 Advanced (Macros)

Price on request