Access VBA

Inhouse

£ 1001-2000

Description

  • Typology

    Workshop

  • Level

    Intermediate

  • Methodology

    Inhouse

  • Class hours

    12h

  • Duration

    2 Days

  • Start

    Different dates available

Description

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

Starts

Inhouse

Starts

Different dates availableNow taking bookings

To take into account

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

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

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

Access VBA

£ 1001-2000