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: Dec. 14
- Location: Edmonton
- Time: 9:00 am - 4:00 pm (Note on end times)
- Duration: 3 Days
on the number or students and pace of the class.
It is important to allow for the class to run a little bit longer,
or finish a little sooner, than expected.
- Delivery Method(s):Instructor Led
- Seats Available: YES
- Category:Microsoft Access Training Seminars and Courses
that provides you with the quality training that
you have come to expect, and combines it with
flexible learning and a self paced environment.
For more information click here.
- Course Outline
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.
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
- 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
- Declaring Variables and Constants
- VBA Data Types
- Understanding Procedure Types
- Declaring Procedures as Public or Private
- Passing Arguments
- Giving a Function a Data Type
- Implementing Error Handling
- Debugging Code
- 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
- Branching and Looping
- Using If…Then…Else
- Using Select Case
- Using For…Next
- Using Do Loops
- Using GoTo
- Introducing Array Variables
- Declaring an Array Variable
- Understanding the Array's Index
- Working with Array Elements
- Arrays with Multiple Dimensions
- Expanding to Dynamic Arrays
- Introducing Objects
- Reading and Setting Properties
- Invoking Methods
- Working with Collections
- Working with an Object Model
- Creating Your Own Objects
- Working with Events
- What's Scope?
- Measuring the Lifetime of a Variable or Constant
- Using Static Variables
- Opening and Closing Forms
- The Form Module and Event Handling
- Performing Common Tasks
- Handling Errors at the Form Level
- Working with Multiple Form Instances
- Responding to Events
- The Event Sequence for Controls
- The Event Sequence for Forms
- The Event Sequence for Reports
- Canceling Events
- Populating a List Control
- Adding to the List – or Not
- Working with Multiselect Controls
- Considering Callback Functions
- Working with Text Boxes
- Using Controls in Option Groups
- Working with Subforms
- Working with the Tag Property
- 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
- Investigating the Application Collections
- Retrieving Lists of Objects
- Working with Object Properties
- Programmatically Determining Dependencies
- 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
- 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
- What is ADOX?
- Creating Tables
- Securing Objects
- Coding for Concurrency
- Retrieving a User Recordset
- Using Other Schema Recordsets
- Understanding the Place of Access in Office
- Prerequisites & Certificates
Access - Level III or equivalent knowledge/experience
Certificate of completion
- Cancellation Policy
10 business days cancellation or full course fee will be charged
- Map & Reviews
Technology Training Centre
[ View Provider's Profile ]
TTC, B-11 Cameron Library
University of Alberta
Canada T6G 2J8
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
Registration is fast, and will take approximately 3 minutes. There is no membership fee.
» You are also welcome to Make an Offer
In either case, our Make an Offer feature gives you the opportunity to name
your own price. Try it out, you might get lucky, just keep in mind it can
take up to 1 full business day to get a response!
This course is also scheduled on the following dates:
Not interested in this Course?
Tell us why:
This page has been viewed 20 times.