This course is designed for advanced Access and Excel users to gain essential and practical skills of Visual Basic Application (VBA) Programming that can be used in day to day Business activities.

 

This course uses a real project to demonstrate the application of VBA in each phase. This course is delivered by in-class lectures, demonstrations, group discussion, and hands-on activities at the computer. Course participants should be prepared to allocate a significant number of outside-class hours to both the learning process and the production of application projects.

 

Upon completion of this course, students will be able to design user-orientated application, create and modify VBA procedures and functions, and automate daily tasks in variety of Microsoft Application environment.

 

 

·         Background

·         Confidentiality

·         Historical Usage

·         Foreseeing the end product

·         Development ideas

 

·         Creating and Editing Macro in MS Excel and MS Access

·         Introducing the Visual Basic Editor

·         About Objects and Collections

·         Properties and Methods

·         VBA programming fundamentals

·         Debugging and error handling

·         ADO Overview

·         Connecting to a Database

·         Working with Recordsets

·         Retrieving and Browsing Data

 

·         Introducing Microsoft Office Objects

·         FileDialog Object

·         Different usage of FileDialog in MS Excel and MS Access

 

·         Using other Microsoft Dialogs

 

·         Review Access Queries

·         Data Manipulation Language

·         Data Definition Language

·         Running Queries in VBA

·         Executing SQL in VBA

 

·         Data calculation with Queries

·         Aggregate Queries

·         Complex PivotTables

·         Creating PivotTable in VBA

 

·         Different Options for Importing Access Data

·         Using Microsoft Query

·         Automating Excel from Access

·         Running Excel VBA from Access

·         Displaying a UserForm

·         Creating a UserForm

·         Directly accessing controls in UserForms

·         Displaying a Progress Indicator

·         Creating Wizards

·         Understanding Excel’s Add-in Manager

·         Creating an Add-in

·         Customizing the Ribbon

·         Using VBA to customize shortcut menus

·         Providing help for your applications

·         VBA in Outlook

（更多资料和具体参加方法）