VBA Excel/Access

Course

In Poole

£ 350 + VAT

Description

  • Type

    Course

  • Location

    Poole

  • Duration

    2 Days

The course will concentrate primarily on Excel for the examples but will also use Access. Most of the concepts are directly transferable between the applications. Suitable for delegates wishing to extend their knowledge of the Microsoft Application suite. No programming experience is assumed but any experience that delegates may have will be advantageous

Facilities

Location

Start date

Poole (Dorset)
See map
Phoenix House, Marshes End, Upton Road, BH17 7AG

Start date

On request

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

Introduction to VBA

· Variables

· Data types

· Arrays

· User defined types

· Constants

Testing for conditions and repeating actions

· Conditions

· Loops

Writing re-useable code

· Event procedures

· Functions and Subroutines

· Parameters

· Scope

What is an object model?

Writing data to files

· Updating values in an Access database

· Updating cell values in an Excel worksheet

Working across applications

VBA Excel/Access

£ 350 + VAT