Course

In London

£ 490 + VAT

Description

  • Type

    Course

  • Location

    London

  • Duration

    2 Days

define event driven programming. identify and manipulate objects and collections. declare and use variables and understand their scope. implement control structures such as if.then and for.next to control program flow. use data access objects to view and manage data. debug code and trap errors

Facilities

Location

Start date

London
See map
210 Borough High St, SE1 1JX

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

course description
after completing this course, participants will be able to:
  • define event driven programming
  • identify and manipulate objects and collections
  • declare and use variables and understand their scope
  • implement control structures such as if.then and for.next to control program flow
  • use data access objects to view and manage data
  • debug code and trap errors
topic
  • reasons for using access vba-event driven programming; code in modules and behind forms and reports; sub procedures and function procedures ;
  • code creation-creating simple code; declaring and using variables; understanding the scope and life time of variables; using operators in code; string manipulation; using macro actions in code
  • control structures-creating if.then.elseif blocks; creating select.case statements; using do.until and do.while loops; using for.next loops
  • objects and collections-understanding the object hierarchy, collections and objects; using object properties and methods;understanding data access objects; declaring and setting object variables; using recordsets for reading and editing
  • debugging code-suspending execution and stepping through code; using the immediate window; error handling code
  • automation-creating automation objects; accessing linking and embedding objects.

Access - vba

£ 490 + VAT