Skip to Content

Bookings and Enquiries: 0800 077 36 46

Microsoft Access Developer Course – VBA in Access Part 2 – Access Objects & DAO

Microsoft Access Developer Course – VBA in Access Part 2 – Access Objects & DAO

2 Days Crawley £480.00+VAT
Available Date(s): Call for dates
Print

Is this course right for me?

Our VBA in Access Part 2 – Access Objects and DAO is designed for existing experienced users of Access.

Delegates must be able to confidently create fully relational databases including tables, forms, reports and queries before attending this course. Basic VBA experience is required, which can be gained by attending our VBA in Access Part 1

Training course objectives:

  • Use the Access Object Model
  • Use the DAO – Data Access Object Model
  • Transfer information to Word and Excel

Versions Available

2003, 2007, 2010

Related Training Courses in Our Range

  • Access Advanced Queries and Reports
  • Access Advanced Database Design
  • VBA in Access Part 1 – Automation
  • SQL Foundation

Variables and Arrays

  • Review of variables
  • Creating arrays
  • Using arrays

Looping

  • Do While
  • Do Until
  • For Next

Nested Control Structures

  • Using loops and conditionals

The Access Object Model

  • Collections
  • The For Each . . . Next Loop
  • Using TypeOf
  • Dynamic list boxes

Data Access Objects

  • Data Access Object model
  • Collections
  • Using containers

DAO

  • Opening recordsets
  • Manipulating recordsets
  • Navigating and positioning in recordsets
  • Counting records
  • Finding records

DAO

  • Creating QueryDefs
  • Working with SQL

Sharing Data With Other Applications

  • Setting references to other applications
  • Interacting with Word
  • Word VBA commands
  • Interacting with Excel
  • Excel VBA commands
Contact

Call our expert Learning and Development team today on
0800 077 36 46 for more details about the training options available to
you or to book your course.