Skip Ribbon Commands
Skip to main content
Version HistoryVersion History

Course ID

AVBA16

Title

Access Part 4 VBA

Price

$800.00

Duration

2

Audience

 

Level

 

Delivery Method

 

Software Assurance

 

Microsoft CPE

 

Course Audience

 

Course Objectives

Upon successful completion of this course, students will be able to:

  • share Access data with other applications.
  • use VBA to automate a business process.
  • create and modify a database switchboard and set the startup options.
  • secure and distribute databases.
  • share databases using a SharePoint site.

Course Description

This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft Office Access application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.

 

Course Prerequisites

To ensure the successful completion of Microsoft® Office Access® 2010: Level 4, the following Element K courses or equivalent knowledge is recommended:

  • Microsoft® Office Access Level 1
  • Microsoft® Office Access Level 2
  • Microsoft® Office Access Level 3

 

Course Outline

​Planning the application

Using command buttons and editing VBA code

Macros used to that automate an unbound form for running reports

Querying using forms

Command buttons

Expression builder

Unbound controls

Creating Switchboards

Creating Splash Screens

VBA Code:

Sub procedures

Calling sub procedures from forms

Functions

Loops

IF statements

Inserting an Active X Control and automating with VBA

Splitting a database

Security discussion and adding passwords​

Status

Active

Technology

Office

Category

Microsoft

SubCategory

Microsoft

Details

 

Attachments

Version: 2.0
Created at 2/10/2018 11:02 AM by Gaige Heiner
Last modified at 3/8/2018 10:42 AM by Gaige Heiner