logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Access 2016 Part 4 VBA

SS Course: 3000109

Course Overview

TOP

You will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

 

                                                                  

Scheduled Classes

TOP

What You'll Learn

TOP

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.

Outline

TOP
Viewing outline for:

Lesson 1: Planning the application

Lesson 2: Using command buttons and editing VBA code

Lesson 3: Macros used to that automate an unbound form for running reports

Lesson 4: Querying using forms

Topic A: Command buttons

Topic B: Expression builder

Topic C: Unbound controls

Lesson 5: Creating Switchboards

Lesson 6: Creating Splash Screens

Lesson 7: VBA Code:

Topic A: Sub procedures

Topic B: Calling sub procedures from forms

Topic C: Functions

Topic D: Loops

Topic E: IF statements

Lesson 8: Inserting an Active X Control and automating with VBA

Lesson 9: Splitting a database

Lesson 10: Security discussion and adding passwords

Prerequisites

TOP

To ensure the successful completion of Microsoft Office Access Part 4 VBA, the following Logical Operations courses or equivalent knowledge is recommended:

  • Microsoft Office Access Part 1
  • Microsoft Office Access Part 2
  • Microsoft Office Access Part 3

    Who Should Attend

    TOP

    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.

    Next Step Courses

    TOP