Up and Running with VBA in Access [repost]

Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in VBA code. Author Curt Frye introduces object-oriented programming and provides database designers with a foundation in the Access object model and the Visual Basic for Applications (VBA) programming language. The course covers automating tasks with macros, working in the Visual Basic Editor, writing functions, adding logic, reading data, controlling forms, and more.

Introduction 2m 23s
Welcome 58s
What you should know before watching this course 40s
Using the exercise files 45s

1. Automating Processes Using Macros 20m 32s
Introducing Access Automation 3m 45s
Running macros 2m 30s
Working with data macros 4m 15s
Running a macro by clicking a command button 6m 12s
Managing macro security settings 3m 50s

2. Introducing Visual Basic for Applications (VBA) 27m 54s
Introducing object-oriented programming 3m 11s
Examining the Access Object Model 4m 29s
Working in the Visual Basic Editor 2m 59s
Creating, exporting, and deleting code modules 6m 59s
Creating a subroutine 1m 41s
Creating a function 4m 12s
Adding comments to your code 3m 0s
Running a VBA procedure 1m 23s

3. Debugging Your VBA Code 19m 46s
Managing errors in VBA code using On Error statements 5m 18s
Stepping through a subroutine or function 3m 51s
Setting breakpoints in your code 2m 56s
Verifying output using temporary message boxes 4m 38s
Watching a value in a routine 3m 3s

4. Defining Variables, Constants, and Calculations 43m 35s
Introducing Access data types 3m 23s
Declaring variables and requiring declaration before use 6m 21s
Managing variable scope 5m 5s
Defining constants and static variables 5m 23s
Creating a calculation using mathematical operators 5m 12s
Displaying a calculated result in a message box 7m 24s
Defining an array 6m 21s
Defining and using an object variable 4m 26s

5. Adding Logic to Your VBA Code 28m 37s
Repeating a task using a For…Next loop 4m 15s
Stepping through all items of a collection using a For…Each loop 4m 42s
Repeating a task using a Do…While loop 4m 15s
Repeating a task using a Do…Until loop 3m 42s
Performing a task when conditions are met using an If…Then statement 6m 40s
Selecting actions using a Case statement 5m 3s

6. Manipulating Database Objects Using DoCmd 40m 0s
Opening a form 6m 18s
Opening a report 4m 45s
Opening a table 3m 30s
Opening a query 3m 24s
Closing an object 3m 59s
Closing a database or quitting Access 3m 52s
Sounding beeps and displaying the hourglass cursor 4m 6s
Running a menu command 2m 28s
Printing the active database object 3m 1s
Displaying or hiding warnings 4m 37s

7. Reading and Manipulating Table Data 48m 26s
Displaying every row in a table (Recordset) 3m 42s
Adding a new record to a table 3m 34s
Editing values in an existing table row 6m 23s
Preserving data integrity using transactions 4m 37s
Displaying a table property using the TableDef object 4m 14s
Closing a Recordset 3m 39s
Deleting the current record 4m 49s
Finding records within a table 8m 32s
Moving within a Recordset 5m 12s
Counting the records in a Recordset 3m 44s

8. Manipulating a Database Using the Application Object 16m 30s
Summarizing values in a table field 3m 22s
Finding the first or last value in a table field 2m 58s
Looking up a value in a table field 3m 31s
Create a progress bar using the SysCmd object 6m 39s

9. Controlling Forms and Reports Using the Me Object 30m 7s
Allowing or disallowing additions, deletions, and edits 5m 9s
Manipulating form filters 6m 15s
Setting the caption and background picture 5m 25s
Requerying and repainting forms 4m 40s
Discovering a record source 3m 3s
Setting the ScrollBars property 2m 52s
Rendering a form or reporting visible or invisible 2m 43s

Conclusion 53s
Additional resources and final thoughts 53s