To access the old site click here! X

  • Course
  • Vendor

This course is designed for students with advanced Access skills who are new to Visual Basic programming. Topics & theories covered include reasons for using VBA in Access, good coding habits, using variables, constants & data types, error handling....

  • Course Start Date: 2019-03-06
  • Time: 09:00:00 - 16:00:00
  • Duration: 2 Days
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led
$450.00
March 6th
2 seats left!
or make an offer

Course Outline

Pre-Requisites

Access - Level III or equivalent knowledge/experience

Lessons

This course is designed for students with advanced Access skills who are new to Visual Basic programming. Topics and theories covered in this course include reasons for using VBA in Access, good coding habits, using variables, constants and data types, error handling, debugging code, using procedures, subroutines vs. functions, conversion, date, math, string, format and its functions, input and message boxes, logical programming commands, arrays, objects, and classes and instantiation. Other topics include working with forms, events, combo boxes, multi-select lists, text boxes, and sub forms.

Course Content
Why Access? Why VBA?

  • Understanding the Place of Access in Office
    • Choosing Between Access and Excel
    • Choosing Between Access and OneNote
  • Understanding Access Programming Choices
    • Using Macros
    • Using SQL
    • Using VBA
Getting Around in the Visual Basic Editor
  • Your First Glance at the Visual Basic Editor
  • Introducing the VBA Modules  
  • Entering and Running VBA Code
  • Getting Help on Code
  • Establishing Good Habits in Coding
Using Variables, Constants, and Data Types
  • Declaring Variables and Constants
  • VBA Data Types
Using Procedures
  • Understanding Procedure Types
  • Declaring Procedures as Public or Private
  • Passing Arguments
  • Giving a Function a Data Type
  • Implementing Error Handling
  • Debugging Code
Choosing the Right VBA Function
  • Introducing VBA's Built-in Functions
  • Converting Data Types with VBA Functions
  • Working with Date Functions
  • Using Mathematical and Financial Functions
  • Using String Functions
  • Using the Format Function
  • Using the Is Functions for Flawless Processing
  • Interacting Functions
Using Flow-of-Control Statements
  • Branching and Looping
  • Using If…Then…Else
  • Using Select Case
  • Using For…Next
  • Using Do Loops
  • Using GoTo
Working with Arrays
  • Introducing Array Variables
  • Declaring an Array Variable
  • Understanding the Array's Index
  • Working with Array Elements
  • Arrays with Multiple Dimensions
  • Expanding to Dynamic Arrays
Understanding Objects
  • Introducing Objects
  • Reading and Setting Properties
  • Invoking Methods
  • Working with Collections
  • Working with an Object Model
  • Creating Your Own Objects
  • Working with Events
Understanding Scope and Lifetime
  • What's Scope?
  • Measuring the Lifetime of a Variable or Constant
  • Using Static Variables
Working with Forms
  • Opening and Closing Forms
  • The Form Module and Event Handling
  • Performing Common Tasks
  • Handling Errors at the Form Level
  • Working with Multiple Form Instances
Analyzing the Access Event Model
  • Responding to Events
  • The Event Sequence for Controls
  • The Event Sequence for Forms
  • The Event Sequence for Reports
  • Canceling Events
Working with List and Combo Boxes
  • Populating a List Control
  • Adding to the List – or Not
  • Working with Multiselect Controls
  • Considering Callback Functions
Working with Other Controls
  • Working with Text Boxes
  • Using Controls in Option Groups
  • Working with Subforms
  • Working with the Tag Property
Working with Reports
  • Introducing the Report Module and Events
  • Opening and Closing Reports
  • Passing Arguments Using OpenArgs
  • Populating the Report
  • Handling Report-Level Errors
  • Using VBA to Determine Group Properties
Working with the Application Collections
  • Investigating the Application Collections
  • Retrieving Lists of Objects
  • Working with Object Properties
  • Programmatically Determining Dependencies
Retrieving Data with ADO
  • What's ADO and Why Do You need It?
  • Using the ADO Connection Object
  • Working with Command Objects
  • Understanding the Different Types of Recordsets
  • Creating and Opening a Recordset
  • Filtering Recordsets
  • Using the Recordset Property
Manipulating Data with ADO
  • Moving Through a Recordset
  • Finding Data in a Recordset
  • Adding Data Using a Recordset
  • Deleting Data in a Recordset
  • Updating Data in a Recordset
  • Using Transactions to Commit Groups of Records – or Not
Creating Objects with ADOX
  • What is ADOX?
  • Creating Tables
  • Securing Objects
Performing Advanced Data Operations
  • Coding for Concurrency
  • Retrieving a User Recordset
  • Using Other Schema Recordsets

Cancellation Policy

10 business days cancellation or full course fee will be charged

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada   

About Technology Training Centre

x

Technology Training Centre is THE place for computer software training in Alberta.
This is where you come to learn how to get more from the computer or the mobile device in front of you.
Register for courses on Microsoft Office and the Adobe Creative Suite along with customized one on one or group training.
Come to the heart of the University of Alberta campus to learn from our instructors. These highly skilled professionals will also travel across the province to deliver exceptional training for you and your company.
We have your MS Office needs covered, including training on upgrading to a newer version of the software. We offer courses in Microsoft Word, Excel, PowerPoint, Access, SharePoint, Publisher, SQL, Visio, Project, Outlook, OneNote, and InfoPath.
Our graphic designers will train you in Adobe Photoshop, InDesign, Illustrator, Dreamweaver, Acrobat, Lightroom, and Visual Design. If you need training for your digital camera, we’ll provide that as well.

You will also receive:
•    6 months of email support on courses.
•    The option to retake courses within 6 months at no additional charge.
•    Training from instructors that use each of the software packages they teach and have the ability to go beyond what is covered in the outline.
 

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 195 reviews.

The course was excellent, the instructor Rachel was great.
No comment
No comment
Was a very informative course.
No comment
My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.
I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL
No comment
No comment
No comment
The information learned in this course will assist me in my current role. Enjoyed the class.
No comment
I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unf ... Read more
x

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unfortunately all my notes are in the beginning of the book as we, only looked it once, when a student asked what page we were on.

No comment
More useful contents can be fit in and taught in this class definitely.
No comment
Worthwhile training that provided me with the skills needed to use Onenote.
No comment
No comment
I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course le ... Read more
x

I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course learning something. Thanks for the informative day. Doreen

Course Reviews

This course has an overall avarage rating of 4.22 out of 5 based on 1 reviews.

Previous

Carrie Mydlak attended this course Dec 2017

Facilities

Course Content

Delivery Structure

Instructor Ability

No comment

More Courses from Technology Training Centre

TECHNOLOGY TRAINING CENTRE
2019-01-23
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-13
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-03-01
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-17
Edmonton

More Courses in 'Microsoft Access Training Seminars and Courses' Category

GLOBAL KNOWLEDGE
2019-03-27
Edmonton
GLOBAL KNOWLEDGE
2019-04-01
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-25
Edmonton
GLOBAL KNOWLEDGE
2019-06-12
Edmonton