Course

In Birmingham

£ 550 + VAT

Description

  • Type

    Course

  • Location

    Birmingham

  • Duration

    2 Days

This course is designed to introduce experienced Access users to the Visual Basic for Applications (VBA) programming language. It will show how to use VBA to extend the capabilities of Access forms, and how to use detain Access database files from other Office applications.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

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

This course is designed to introduce experienced Access users to the Visual Basic for Applications (VBA) programming language. It will show how to use VBA to extend the capabilities of Access forms, and how to use detain Access database files from other Office applications.All the Open Scheduled VBA courses delivered by PPI Learning Services are suitable for all delegates no matter what version of Office they are working with in their own company's environment. We have chosen the middle ground as the delivery mechanism; so all VBA course will be delivered using Office 2000. If a specific version of VBA is required, then a private VBA course will need to be arranged with the PPI Learning Services Sales Executive.Course content

  • The Visual Basic programming environment in Access, when to useVBArather than macros, the object browser.
  • The Visual Basic editor, Visual Basic modules, editor options, editor views.
  • The concepts of object-oriented programming, Visual Basic syntax.
  • The structure of procedures, the declaration section, comments, keywords, indenting code, navigating code using the keyboard, bookmarks, the last position command, getting assistance from the editor when entering code.
  • Declaring variables, variable scope, variable type, type conversion functions, constants, arrays.
  • Control structures
    • The with statement
    • If statements
    • Select Case
    • Do Loop
    • For Next Loops
  • User interaction
    • The MsgBox statement
    • The InputBox function
  • Pausing code execution, locating errors in code, handling run-time errors, setting bookmarks, setting breakpoints, tracing the execution path using the call stack, setting watches.
  • Viewing variable and array values in break mode, compiling program code.
  • Manipulating record sets withVBA, finding records in a recordset, creating and deleting tables or queries withVBA.
  • Using ActiveX data objects (ado) to open and work with databases from other office programs such as Word or Excel.

Access VBA

£ 550 + VAT