Access 2007 Visual Basic for Applications (VBA)

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information

Description: This course is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

Days: 1

Prerequisites: Successful candidate does not need experience in programming language. Candidates should possess advanced skills in Access.

Unit 1: Visual Basic Editor

Topic A: Objects

· Discussing objects

· Examining the Properties window

· Modifying the object properties

· Writing code to change object properties

· Using a method

· Associating code with an event

Topic B: Object Browser

· Examining the Object Browser window

· Searching in the Object Browser

Topic C: Collections

· Understanding collection objects

· Using the Controls collection

Unit 2: Programming basics

Topic A: Working with data

· Examining data types and variables

· Declaring variables explicitly

· Using operators

· Using the interaction functions

Topic B: Scope

· Observing modules and procedures

· Examining procedure- and module-level scope

· Understanding public scope

· Creating a Sub procedure

· Calling a Sub procedure

· Creating a Function procedure in a standard module

· Calling a Function procedure

Unit 3: Control structures

Topic A: Decision structures

· Using the If…Then statement

· Using the If…Then…Else statement

· Using the If…Then…ElseIf statement

· Using the Select Case statement

Topic B: Loop structures

· Using the For…Next loop

· Using the For Each…Next loop

· Using the Do While…Loop

Unit 4: ActiveX Data Objects

Topic A: Getting started with ActiveX Data Objects

· Discussing ADO

· Discussing ADO collections

Topic B: Working with ActiveX Data Objects

· Connecting to a database

· Creating a Recordset object

· Navigating a Recordset

· Saving and canceling changes

Unit 5: VBA debugging tools

Topic A: Errors in code

· Discussing types of errors

Topic B: Debugging techniques

· Discussing debugging tools

· Setting a breakpoint

· Adding a watch expression

· Using Step Into

· Deleting a watch expression

· Working with the Immediate window

· Using the Locals window

Topic C: Handling runtime errors

· Writing error-handling code

Price: $425
Group Rate: $1,395
(Up to 12)

CompuWorks is Boston's leading independent training and IT services company. Since 1987, CompuWorks has been creating successful training programs for some of the largest organizations in Boston and all of New England. Our award winning classroom and vbook training covers everything from Microsoft Office, Server 2008, Exchange 2010, and SharePoint 2010to SQL 2008, Dynamics, Hyper-V Virtualization, and .NET. CompuWorks specializes in consultative training and can help your company develop a training program that fits your exact business needs. While known as Boston’s top technical and Microsoft Office training company, we also provide instructor led training in vBooks,VMware, CompTIA, Linux, Google Apps, Oracle, Adobe, ASL, Project Management, custom applications and more. All of our classroom training can be done at your location or we can train you at our state-of–the-art Boston training facility, the Boston Training Center.

CompuWorks can also assist your team with roll outs of new technology including deployment, creating the training path, developing the curriculum, and training your end users or we can be your complete outsourced training department solution and take all the work out of your hands. Check out our vbooks for the new elearning.

CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Information Worker Solutions & Learning Solutions. CompuWorks recently was named to the list of top 100 woman-owned businesses in Massachusetts by the prestigious Commonwealth Institute. The Boston Business Journal ranks CompuWorks as the largest independently owned training company in the region and Diversity Business ranks CompuWorks in the Top 50 Diversity businesses in Massachusetts.

Access 2007 Visual Basic for Applications (VBA)

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information

Register for Classes

Also from CompuWorks

Access 2007 Visual Basic for Applications (VBA)

**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**

Register for Classes

Also from CompuWorks

Newsletter

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information