MS Access 2007 Advanced (Macros)

Mouse Training

Training

Inhouse

Price on request

The best Access courses

See all

See all

Description

  • Type

    Training

  • Level

    Advanced

  • Methodology

    Inhouse

  • Duration

    1 Day

This course will provide users that have existing Intermediate level skills in Access to build on their knowledge. The Advanced course 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

About this course

To maximize the gain you receive from our MS Access 2007 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 Group Onsite Training - Charged at £595 per day. Thats for up to 8 delegates costing less than £75 per person! All prices are excluding VAT and per day. Travel cost outside the M25 applies.
Students per class: 8

See related categories

MS Access 2007 Advanced (Macros)

Price on request

The best Access courses

See all

See all