Access VBA Programming

City University London

Short course

In Islington

Price on request

The best Office Systems courses

See all

See all

Description

  • Type

    Short course

  • Location

    Islington

The course teaches in-depth Access VBA programming techniques that enable the developer to go beyond capabilities offered by basic Access usage and smooth out the rough edges that Access leaves behind. This fully handson course provides hundreds of example programs that you can modify and deploy in your own database work. The course covers the three available object models (Access objects, DAO and ADO), explains the differences between them and how to use them confidently. The course concludes with examples of how to extend Access to interact with the other Microsoft applications such as Excel, Word and Outlook. Course Information Start DateStart TimeDurationCostCourse CodeApply Thursday 19 January 2017 18:30 - 20:30 10 weekly classes £480.00 CS1549 Apply Now Tutor Info Andrew Sekiewicz has worked as a full-time trainer, including teaching Access. He has set up many database projects including an Examinations database for a London teaching hospital, an information system for a charity and a system to monitor workstation usage for City University London. Eligibility Working knowledge of MS Access; basic programming as taught in VBA in Excel English Requirements Applicants must be proficient in written and spoken English.

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

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

Subjects

  • Excel
  • Access
  • Basic
  • IT
  • Basic IT training
  • Database
  • Database training
  • Basic IT
  • Teaching
  • English
  • Programming
  • MS Excel

Course programme

What will I learn?

Introduction and overview; the Visual Basic Editor; standard modules and class modules; attaching buttons to forms and writing VBA procedures and functions; code generated by Command Button wizards; error handling code; debugging your programs by stepping through code and using the Immediate window

VBA: basic programming with variables and data types, If statements, VBA's inbuilt functions

Use Access objects to write programs to control Forms and Reports; transfer data to and from Excel and other databases; import text files

Place advanced controls on Forms (subforms, combo boxes, toggle buttons, list boxes) and create programs for their events

An introduction to Access SQL: Select statements; Group By clauses; Update, Insert and Delete statements; Joins and Union queries

The three types of loop that are used to make programs repeat commands (Do loops, For loops, For Each loops)

Programming the DAO (Data Access Objects), the object model that is intrinsic to Access, with an emphasis on Recordsets (programs that enable you to work with your data); also connecting to other databases, and Container objects

Programming the ADO (Active X Data Objects), a component of Microsoft's universal data access strategy, including ADO recordsets

Connecting Access to other applications in both directions using OLE Automation and ADO, for example create an Excel chart from Access data

Additional information

Teaching and Assessment

Teaching takes the form of theoretical explanation and pre-supplied programs to demonstrate the implementation of the theory. Short exercises take place in order to reinforce the student's grasp of a topic. The tutor is happy to answer questions and follow up students' particular needs and interests where possible. The course assumes prior knowledge of Access and VBA, but revision materials are provided for the student to follow up offline.

See related categories

Access VBA Programming

Price on request

The best Office Systems courses

See all

See all