Access VBA Level 2

Inhouse

Price on request
  • Typology

    Course

  • Methodology

    Inhouse

  • Duration

    1 Day

Description

This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access. The course is aimed at those with little or no previous.

Important information

Government funding available

To take into account

A sound knowledge of Windows and MS Access including, table creation, query and report writing functions, macro development and relational database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential .

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

DESCRIPTION
This course has been designed for the advanced Access user who wishes to make use of the more powerful facilities of MS Access made available by VBA. This course explores the VBA language introducing features and functionality that will encourage confidence, control and creative use of MS Access. The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Throughout the course the theme of adopting good programming practices will be encouraged and advice will be given on planning applications systematically, efficiently and economically. The techniques covered are typical of those encountered in a business database application; focusing in particular on triggering VBA from objects such as queries and forms.


PREREQUISITES
A sound knowledge of Windows and MS Access including, table creation, query and report writing functions, macro development and relational database concepts gained from practical experience or by prior attendance on an "Access Advanced User" course is essential.




More on Forms and VBA
  • Export Reports to Word, Excel, email
  • Use the Calendar Control
  • Using Combo and List boxes
Error Handling in VBA
  • Trapping Errors
  • Writing Useful Error Handles
  • Using VBA debug features
Manipulating Data through Data Access Objects
  • Data Access Objects (DAO)
  • ActiveX Data Objects (ADO)
  • Handling Databases
  • Database, Recordsets and Dynaset Objects
  • Finding and Editing Records in a Recordset




Price on request