
Microsoft Visual Basic for Access 2010
by Robert Ekblaw
Start the free chapterMicrosoft 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.
Course content
Introduction2 lessons
Objects8 lessons
Events and Event Procedures6 lessons
Form and Record Navigation7 lessons
Collections and User-Defined Data Types9 lessons
- Creating Composite Data Types5:231 credit or ad
- Declaring Variables of Composite Types4:231 credit or ad
- Accessing Data in Composite Types4:391 credit or ad
- Nested Types5:381 credit or ad
- Dynamic Arrays5:291 credit or ad
- Collections4:591 credit or ad
- Creating a Collection5:271 credit or ad
- Searching a Collection4:321 credit or ad
- Sample Collection5:591 credit or ad
VBA and Form Objects7 lessons
Embedded SQL13 lessons
- What Embedded SQL Is4:441 credit or ad
- SELECT Statement5:451 credit or ad
- WHERE Clause5:131 credit or ad
- Computed Fields4:451 credit or ad
- SQL Summation Functions5:241 credit or ad
- SQL Row Limitation Functions5:071 credit or ad
- Sample Query4:301 credit or ad
- Sorting Results4:291 credit or ad
- Grouping Results6:061 credit or ad
- Sample Gathering2:361 credit or ad
- Joins6:151 credit or ad
- Sample Join4:091 credit or ad
- Action Queries6:461 credit or ad
Recordsets11 lessons
- What a Recordset Is5:011 credit or ad
- Creating a Recordset5:551 credit or ad
- Opening Recordsets5:511 credit or ad
- Recordset Navigation4:531 credit or ad
- Finding Records5:331 credit or ad
- Reading and Updating Records5:211 credit or ad
- Adding and Deleting Records6:191 credit or ad
- Snapshot Recordsets5:451 credit or ad
- Sample Recordset6:271 credit or ad
- Sample Recordset Use3:081 credit or ad
- Sample Recordset Find5:331 credit or ad