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

Our MS Access 97 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 97 Advanced training course, it is recommended that you have attended our MS Access Intermediate course or that you are at a similar 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 97 Advanced Course Microsoft Access 97 Advanced Course

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

Access 97 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 97 Advanced course. The course starts at 09:30 and runs until 16:30

Course Locations / Schedule

This Access 97 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 97 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 97 Courses

What can I expect?

Training Course FormatsFormats / Locations

Course BookingHow to book your course

Course Cost Explained

Ms Office Courses are charged at a flat rate per day.

One to One - Charged at £450 per day

Group Onsite Training - Charged at £695 per day

Training at our training centre - Charged at £695 per day

MS Office Only

Technical Applications POA

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