"People do not invest in education because they are rich. They become rich because they invest in education."

- Gabriel Verhoef

Access 2010 Programmers Reference (Using VBA)

In this course, students will apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2010.



Access 2010 Programmers Reference (Using VBA) course offered at MasterGrade IT.
If you are familiar with Access, you are aware of all the benefits it holds. Access VBA is a development environment that is used to create computer-based databases.

To compliment it, it works with a programming language called Visual Basic for applications (VBA) and various libraries.

Do you want to:

• Use buttons and controls to click your way through a Database?
• Make your Access Forms come alive and automate tasks for you?
• Get your Reports to be more functional than the ordinary?
• Limit functionality based on who is logged on or who is opening a Form or Report?
• Use SQL strings in your Database to get data from multiple source with speed and easy?
• Program your own ‘Rocket Science’ into your Database and make it super functional?
• and much more…

Who will benefit

Anyone using the Microsoft Office system to prepare spreadsheets or tables.

Access 2010 Programmers Reference (Using VBA)

Lesson 1: Introduction to Microsoft Access 2010

  • Access database basics
  • Access database objects

Lesson 2: New FeaturesDevelopment Environment

  • Forms
  • Macros
  • Integration with SharePoint
  • Browser interface/Applications
  • What’s gone or deprecated

Lesson 3: Upgrade and converting to Access 2010 To Convert or To Enable

  • Installing multiple versions of Access on one PC
  • Converting a secured database
  • Converting a replicated database
  • Access 2010: 64- Bit Considerations

Lesson 4: Macros in Access 2010 VBA versus macros in Access

  • Types of macros
  • Creating macros in Access 2010
  • Macro objects and embedding macros
  • Data Macros

Lesson 5: Using the VBA Editor

  • Anatomy of the VBA editor
  • Testing and debugging VBA code
  • Using option statements

Lesson 6: VBA basics

  • The mindset of a programmer
  • Other VBA components
  • VBA Objects
  • Using code behind forms and reports

Lesson 7: Using VBA in Access

  • When events fire
  • VBA Procedures
  • Evaluating expressions in VBA
  • Using record sets
  • using multiple record sets
  • Using VBA in forms and reports
  • Debugging VBA
  • Investigating variables
  • Common VBA techniques
  • String concatenation techniques
  • VBA error handling

Lesson 8: Creating classes in VBA

  • Why use classes
  • Naming and identifying objects
  • Using class events
  • Forms and reports as objects
  • Creating a clone method
  • Creating and using collection classes
  • The three pillars

Lesson 9: Extending VBA with APIS

  • Introducing the Windows API
  • Introducing linking
  • Declaring APIs
  • Understanding C Parameters
  • Err. Last DLL Error

Lesson 10: Working with the windows registry

  • About the registry
  • Using the built-in VBA registry functions
  • Using the windows registry APIs

Lesson 11: Using DAO to access data

  • Data access objects
  • Referring to DAO objects
  • The database objects
  • DAO object properties
  • Creating schema objects with DAO
  • Data access with DAO
  • Append-only fields

Lesson 12: Using ADO to access data

  • Introduction to ADO in Access
  • Connecting to ADO data sources
  • Data access with ADO
  • Using ADO events
  • Schema record sets with ADO
  • Creating schema with ADOX

Lesson 13: Using SQL strings with VBA

  • Working with SQL strings in VBA
  • Using SQL when opening forms and reports
  • The ReplaceOrderByClause and

Lesson 14: Using VBA to enhance forms

  • VBA basics
  • Creating forms the 2010 way

Lesson 15: Enhance reports with VBA

  • Introduction to reports
  • Important report events and properties
  • Report properties
  • Working with charts
  • Layout views

Lesson 16: Customizing the ribbon

  • Ribbon overview
  • Ribbon customizing using the options dialog box
  • Creating an Integrated ribbon
  • Creating a ribbon from scratch
  • More ribbon tips

Lesson 17: Customizing the Office backstage

  • Introducing the Office backstage
  • Writing a backstage customization
  • Designing the layout of components
  • Extending the existing backstage
  • Backstage-specific callbacks
  • Backstage scenarios

Lesson 18:  Working with Office 2010

  • Working with Outlook 2010
  • Working with Excel 2010
  • Working with Word 2010

Lesson 19: Working with SharePoint

  • SharePoint 2010
  • Access features overview
  • SharePoint features in Access
  • Access features on SharePoint

Lesson 20: Working with .NET

  • Overview
  • Visual Studio .NET 2010
  • Using Access database in .NET
  • Automating Access with .NET
  • Creating COM Add-Ins for Access
  • Using .NET code in Access

Lesson 21: Building client-server applications with Access

  • Database application evolution
  • The ACCDB/MDB file format
  • The ADP file format
  • ACCDB/MDB versus ADP
  • Controlling the logon process
  • Binding ADO recordsets
  • Working with Unbound forms

Lesson 22: The Access 2010 templates

  • Access 2010 template features
  • Application parts
  • The ACCDT file format

Lesson 23: Access runtime deployment

  • The Access 2010 runtime
  • Deploying the Access runtime
  • Lesson24: Database security
  • ACCDB file security
  • MDB file security

Lesson 25: Access 2010 security features

  • The Office Trust Center
  • Disable mode
  • Digital signatures and certificates
  • Access database engine expression service



Learning Materials:



What course next:

5 Days

All included

Microsoft Access »

Introduction to Programming »  

Get a Quote today »


Course Content
Access 2010 Programmers Reference (Using VBA)

   • Introduction to Microsoft Access 2010
   • New Features
   • Upgrade and converting to Access 2010
   • Macros in Access 2010
   • Using the VBA Editor
   • VBA basics
   • Using VBA in Access
   • Creating classes in VBA
   • Extending VBA with APIS
   • Working with the windows registry
   • Using DAO to access data
   • Using ADO to access data
   • Using SQL strings with VBA
   • Using VBA to enhance forms
   • Customizing the ribbon
   • Working with Office 2010
   • Working with SharePoint
   • Working with .NET
   • Building client-server applications with Access
   • The Access 2010 templates
   • Access runtime deployment
   • Database security
   • Access 2010 security features



Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.






Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

- René Leandro Borges

I enjoyed doing the course in my own time!

- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.