Access: VBA (2019)

Course details

Enhance productivity by automating routine tasks and providing custom functionality not built into Access with a few basics in Visual Basic for Applications (VBA) code. In this course, Curt Frye introduces object-oriented programming and provides you with a solid grounding in the Access object model and the VBA programming language. Discover how to automate tasks with macros, work in the Visual Basic Editor, and write functions. Plus, learn about adding logic, reading data, controlling forms, and more.

Learning objectives
Working with macros
Running a VBA procedure
Debugging VBA code
Defining variables, constants, and calculations
Displaying a calculated result in a message box
Repeating tasks with loops
Manipulating database objects
Adding, editing, and deleting records
Looking up values in a table
Automating processes with macros

Concepts

0. Introduction

01 - Get the most out of Microsoft Access with VBA
02 - What you should know

1. Introduction to Visual Basic for Applications

03 - Introduction to object-oriented programming
04 - Examine the Access object model
05 - Work in the Visual Basic Editor
06 - Create, export, and delete code modules
07 - Create a subroutine
08 - Create a function
09 - Add comments to your code
10 - Run a VBA procedure

2. Define Variables, Constants, and Calculations

11 - Introduction to Access data types
12 - Declare variables and require declaration before using
13 - Manage variable scope
14 - Define constants and static variables
15 - Create a calculation using mathematical operators
16 - Display a calculated result in a message box
17 - Define an array
18 - Define and use an object variable

3. Add Logic to Your VBA Code

19 - Repeat a task using a For Next loop
20 - Step through all items of a collection using a For Each loop
21 - Repeat a task using a Do While loop
22 - Perform a task when conditions are met using an If Then statement
23 - Select actions using a Case statement

4. Debug Your VBA Code

24 - Manage errors in VBA code using On Error statements
25 - Step through a subroutine or function
26 - Set breakpoints in your code
27 - Verify output using the Immediate window
28 - Watch a value in a routine

5. Manipulate Database Objects Using DoCmd

29 - Open a form
30 - Open a report
31 - Open a table
32 - Open a query
33 - Close an object
34 - Close a database or quit Access
35 - Run a menu command
36 - Print the active database object
37 - Display or hide warnings

6. Read and Manipulate Table Data

38 - Display every row in a table (recordset)
39 - Add a new record to a table
40 - Edit values in an existing table row
41 - Preserve data integrity using transactions
42 - Display a table property using the TableDef object
43 - Close a recordset
44 - Delete the current record
45 - Find records within a table
46 - Move within a recordset
47 - Count the records in a recordset

7. Manipulate a Database Using the Application Object

48 - Summarize values in a table field
49 - Find the first or last value in a table field
50 - Look up a value in a table field
51 - Create a progress bar using the SysCmd object

8. Control Forms and Reports Using the Me Object

52 - Allow or disallow additions, deletions, and edits
53 - Manipulate form filters
54 - Set the caption and background picture
55 - Requery and repaint forms
56 - Discover a record source
57 - Render a form or report visible or invisible

9. Automate Processes Using Macros

58 - Introduction to Access macros and data macros
59 - Create macros
60 - Work with data macros
61 - Run a macro by clicking a command button
62 - Manage macro security settings

Conclusion

63 - Next steps