United States Microsoft Visual Basic for Access 2010 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Visual Basic for Access 2010 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Visual Basic for Access 2010 freely available. Click on any of the linked lesson listings below to preview FREE!
Microsoft Access allows a user to create many different items: tables, forms, reports, macros, and queries. However, the greatest power lies in Modules. Modules contain Visual Basic for Applications (VBA) code that runs in the background, performing more complex operations than any of the other items can perform. This VTC course will discuss how to do many different processes in VBA Modules, including creating customized data items and classes, as well as referencing data that exists in a separate database. To begin learning today, simply click on the movie links.
Choose your media type:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction
|
||
| What the Course Is About | (06:35) | |
| Why Code VBA in Access | (06:18) | |
|
Objects
|
||
| What an Object Is | (04:58) | |
| Object Properties | (05:42) | |
| Object Methods | (04:54) | |
| Form Methods | (06:18) | |
| Referencing Data in Code | (06:14) | |
| What IS Is | (05:48) | |
| Application Object | (05:10) | |
| Window Object | (03:46) | |
|
Events and Event Procedures
|
||
| Events and Event Procedures Introduction | (06:31) | |
| Reading Data | (06:50) | |
| Form Events | (04:29) | |
| Object Events | (05:31) | |
| Events Causing Events | (04:54) | |
| Sample Event Procedure | (06:22) | |
|
Form and Record Navigation
|
||
| Record Navigation Buttons | (05:01) | |
| DoCmd Object | (05:11) | |
| Record Navigation Events | (06:01) | |
| Adding New Records | (03:58) | |
| Form Operation Events | (04:19) | |
| Report Operation Events | (04:33) | |
| Sample Navigation | (04:15) | |
|
Collections and User-Defined Data Types
|
||
| Creating Composite Data Types | (05:23) | |
| Declaring Variables of Composite Types | (04:23) | |
| Accessing Data in Composite Types | (04:39) | |
| Nested Types | (05:38) | |
| Dynamic Arrays | (05:29) | |
| Collections | (04:59) | |
| Creating a Collection | (05:27) | |
| Searching a Collection | (04:32) | |
| Sample Collection | (05:59) | |
|
VBA and Form Objects
|
||
| Checkbox | (04:22) | |
| Option Buttons | (04:59) | |
| VBA Code for Option Groups | (05:38) | |
| List Box Single Selection | (04:36) | |
| List Box Multiple Selection | (05:18) | |
| Filling List Box | (04:49) | |
| Sample Data Fill | (04:50) | |
|
Embedded SQL
|
||
| What Embedded SQL Is | (04:44) | |
| SELECT Statement | (05:45) | |
| WHERE Clause | (05:13) | |
| Computed Fields | (04:45) | |
| SQL Summation Functions | (05:24) | |
| SQL Row Limitation Functions | (05:07) | |
| Sample Query | (04:30) | |
| Sorting Results | (04:29) | |
| Grouping Results | (06:06) | |
| Sample Gathering | (02:36) | |
| Joins | (06:15) | |
| Sample Join | (04:09) | |
| Action Queries | (06:46) | |
|
Recordsets
|
||
| What a Recordset Is | (05:01) | |
| Creating a Recordset | (05:55) | |
| Opening Recordsets | (05:51) | |
| Recordset Navigation | (04:53) | |
| Finding Records | (05:33) | |
| Reading and Updating Records | (05:21) | |
| Adding and Deleting Records | (06:19) | |
| Snapshot Recordsets | (05:45) | |
| Sample Recordset | (06:27) | |
| Sample Recordset Use | (03:08) | |
| Sample Recordset Find | (05:33) | |
|
Classes
|
||
| What a Class Is | (07:01) | |
| Defining a Class and Data | (05:06) | |
| Class Properties | (06:27) | |
| Class Methods | (05:27) | |
| Initialize Method | (03:44) | |
| Sample Class Design | (04:27) | |
| Sample Class Code | (04:33) | |
|
Databases
|
||
| Database Object | (06:46) | |
| Connection Object | (07:05) | |
| Using Remote Databases | (06:32) | |
| Referencing Remote Databases | (05:58) | |
| Using Data from a Remote Database | (04:22) | |
|
Conclusion
|
||
| Course Wrap Up | (05:45) | |
| Planning for Events | (05:59) | |
| Navigation Forms | (06:00) | |
|
Credits
|
||
| About the Author | (05:28) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Visual Basic for Access 2010 |
| Author: | Robert Ekblaw |
| SKU: | 34363 |
| ISBN: | 978-1-61866-058-9 |
| Release Date: | 2012-08-24 |
| Price: | |
| Duration: | 7 hrs / 79 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
I have now completed my first on line course in MS Publisher 2003 with VTC. Author Kate. J.Chase is to be commended on her unassuming style and...
Algernon Williams