Access VBA

Wise Owl

Short course

Inhouse

£ 1001-2000

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Inhouse

  • Class hours

    12h

  • Duration

    2 Days

  • Start date

    Different dates available

If you have mastered tables, queries, forms and reports in Access, it is maybe time to learn. This two-day course shows you how to use Access VBA to automate your databases, making your database development easier - and more fun! Suitable for: This Access VBA macros course is aimed primarily at businesses and public sector organisations

Important information

Documents

  • Access Visual Basic

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

Delegates should only attend this course if they have a good working knowledge of Access basics, and if they are proficient computer users. Experience of programming, while useful, is not essential.

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

  • The VBA code editor
  • Messages & variables
  • Creating functions
  • Visual Basic explained
  • Attaching code to forms
  • Looping
  • Recordsets
  • Debuggin and error handling
  • Case Studies
  • Linking to Excel & Word

Teachers and trainers (3)

Andrew Gould

Andrew Gould

Senior Trainer

Andy Brown

Andy Brown

Microsoft Trainer & Programmer

David Wakefield

David Wakefield

Director / Programmer / Trainer

Course programme

The VBA code editor
  • Two ways to create modules
  • Using Project Explorer
  • Basic subroutines and comments
Messages and variables
  • The all-powerful DoCmd object
  • Displaying messages
  • Getting input from users
  • Using variables
Creating functions
  • Passing arguments
  • Returning values
Visual Basic explained
  • Objects and collections
  • Methods and properties
  • The Access object model
  • Getting help in VBA
Attaching code to forms
  • Attaching code to buttons
  • Attaching code to events
  • Manipulating form/control properties
  • Making code not form-specific
Looping
  • The four types of loop
  • Looping over all open forms
  • Looping over controls
  • Looping over Access Objects
Recordsets
  • Choosing ADO or DAO
  • Adding data
  • Editing data
  • Deleting data
Debugging and error handling
  • Stepping through macros
  • Setting breakpoints
  • Trapping for errors
Case studies
  • Navigation buttons
  • Creating a simple menu
  • Validating forms
  • Criteria forms

If time

Linking to Excel and Word
  • Referencing other applications
  • Manipulating Excel from Access

If time

Modifying queries
  • Basic SQL statements
  • Amending queries' SQL

Additional information

Students per class: 6
Contact person: Rachel Brook

See related categories

Access VBA

£ 1001-2000

The best Access courses

See all

See all