Access 2016 VB Programming Advanced

Access 2016 VB Programming Advanced

09:27 23 July in

Length

1 Day

Experience Needed

Access 2016 Visual Basic Programming – Introduction

Summary

This course is designed to give the advanced Access user the ability to design applications in Access 2016 using Visual Basic for Applications (VBA) – the underlying programming language for Microsoft Applications.

Course Content

Gathering Information in a Dialog Box

  • Creating an Application from Scratch
  • Using Dialog Boxes in your applications
  • Creating a Dialog Box to go to a specific record
  • Filtering Data in a Report

Display Custom Menues and Toolbars

  • Using Menus and Toolbars in Your User Interface
  • Creating a Custom Menu Bar
  • Customizing Toolbars
  • Creating a Custom Toolbar for the Subscribers Form
  • Creating Toolbar Buttons to Run Visual Basic Code

Exploring Objects and Collections

  • Introducing the Issues Application
  • Understanding Objects and Collections
  • Referring to Objects and Collections
  • Using the For Each Statements with a Collection
  • Using a Multiple-Selection List Box
  • Working Directly with Database Objects
  • Finding and Changing Data in a Record set
  • Creating a Running an Action Query

Sharing Data with Other Applications

  • Using Automation Objects
  • Sending Commands to Microsoft Word
  • Getting Information from Another Application
  • Working with Folders in Microsoft Outlook

Navigating Through Your Application

  • Making Forms Work Together
  • Displaying Related Records in a Pop- Up Form
  • Opening a Form to Add Related Records

Putting Final Touches in an Application

  • Controlling How your Application Starts
  • Providing a Startup Form for Your Application
  • Completing the Switchboard Form for the Subscription Database
  • Customizing Your Application’s Appearance
  • Replacing the Access Splash Screen
  • Preparing to Distribute Your Application to Users

Customizing Reports with Visual Basic

  • Using Standard Reporting Features
  • Responding to Report Events
  • Customizing Reports by Setting Properties at Run Time
  • Changing Report Layout Programmatically
  • Calculating Totals While a Report is Printing

Connecting to the Web

  • Using Hyperlinks
  • Creating Hyperlink Controls on a Form
  • Storing Hyperlinks in a Table
  • Following Hyperlinks from Visual Basic
  • Modifying Hyperlinks Using Visual Basic
  • Creating Web Pages for your Application
  • Creating a Data Access Page to Review Data
  • Adding Scripts to Data Access Pages

Comprehensive training and customized learning programs for your organization