Follow Us :

Access 2007 VBA

Course_Reference: 
DAC07VBA
Summary: 

In “Access 2007 Programming Using VBA” you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database You will learn how to use the individual elements of this powerful programming language in order to design, develop and run VBA code.

PreRequisites: 

Before attending this course, students need to be able to: Understand database design and create tables, forms and reports. Have created queries and understand how to use query expressions.

Audience: 

The target students for this course are those individuals who regularly use Access and wish to extend its capabilities through programming.

Objectives: 

By the end of the course, you should be able to:

• Understand and use the VBA Development Environment
• Work with Procedures and Functions
• Understand and use Access Objects
• Work with Expressions, Variables, and Intrinsic Functions
• Control Program Execution with Decision statements and loops
• Work with the ADODB Recordset object
• Debug Code and create Error Handling statements

  • Getting Started
  • Working with Procedures and Functions
  • Understanding Objects
  • Using Expressions, Variables, and Intrinsic Functions
  • Controlling Program Execution
  • Working with Recordsets
  • Debugging Code
  • Handling Errors

Software Vendor

IT Technical

Business Skills