MS Access 2000 Advanced Training in LondonMS Access 2000 Advanced Training Course

Our MS Access 2000 Advanced course will provide users that have existing Intermediate level skills in Access to build on their knowledge. The Advanced course will focus on automating repetitive tasks in Access using Macros. We will also be focusing on creating a user interface for your Access database.

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

Unlike training companies offering scheduled courses, we offer the alternative of your Microsoft Access Training Course delivered in central London on a date of your choice, either onsite or at our offices near Moorgate, Bank or Liverpool Street either 1 to 1 or as part of a group.


Access 2000 Advanced Course Microsoft Access 2000 Advanced

Audience: This course is designed for existing Access users whom need to start automating database tasks or simply complex database sequences.

Access 2000 Advanced Course Objectives: After the course, you will be able to:

Requirements: You must have sound Access skills and understand key concepts of a database, equivalent to our intermediate course contents

Course Duration :This is a 1 day Access 2000 Advanced course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access 2000 Advanced course can be run Onsite, at our Access training centre or any preferred location in the UK. The course is run on a date that suits you! We do not run public scheduled courses.

Access 2000 Advanced Training Course Contents

Macros

  • An Overview
  • 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

 


 

Evening Courses More 2000 Courses

What can I expect?

Training Course FormatsFormats / Locations

Course BookingHow to book your course

Course Cost Explained

All our courses are charged at a flat rate per day.

NO NEED FOR UPFRONT PAYMENT!

Tips & Tricks

Get usefull tips and tricks with your favourite RSS Feed

 

Let us contact you. Simply select the button below and a member of our team will contact you back.

 


www Mouse