Professional Course
5.0 (1 Reviews)

Microsoft® Access VBA (Visual Basic for Applications)

Length
2 days
Price
695 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
Length
2 days
Price
695 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
This provider usually responds within 48 hours 👍

Course description

Microsoft Office Access 2010 is the newest version of Microsoft's popular database program. This advanced level is intended to help those who are familiar with Access do more with their database by exploring form controls and data management.

Upcoming start dates

1 start date available

Contact provider for more information.

  • Classroom
  • Ottawa

Who should attend?

Experienced and Intermediate-Level Database and Microsoft Excel and Access Users, General Managers, Database Managers, Database Developers and Programmers.This course requires the following prerequisites:User Knowledge of Microsoft WindowsIntermediate Knowledge of Microsoft Access

Training content

Section 1: Advanced Data Management

  • Referential Integrity
  • Table Relationships
  • An Introduction to SQL
  • Modal Dialog Boxes

Section 2: Advanced Form Tasks

  • Using Subforms
  • Creating a Navigation Form
  • Advanced Form Controls
  • Exporting a Form
  • Other Form Tasks

Section 3: Pivoting Data

  • Creating a PivotTable
  • Using PivotTables
  • Advanced PivotTable Tasks
  • Creating a PivotChart
  • Using PivotCharts

Section 4: Advanced Topics

  • Access and Windows
  • Splitting Your Database
  • Using Outlook with Access
  • Using Access 2010 with SharePoint Server
  • Access and Web Databases

Section 5: Macros and Visual Basic for Applications (VBA)

  • Macro Basics
  • More about Macros
  • Access and VBA
  • Building Advanced Procedures
  • Using VBA in a Database

Why choose BBLN?

In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.

All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.

We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.

Reviews

Average rating 5

Based on 1 reviews.
Write a review!
5/5
Anonymous
11 Jul 2019

Engaging activities and clear instructions from the instructor made the session enjoyable and informative.

Contact this provider

Contact course provider

Fill out your details to find out more about Microsoft® Access VBA (Visual Basic for Applications).

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Building Blocks Learning Network
170 Laurier Ave. West, Suite 700
K1P 5V5 Ottawa Ontario

Building Blocks Learning Network

Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...

Read more and show all training delivered by this supplier

Ads