Access: VBA

Access: VBA

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 4h 37m | 535 MB

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.

Topics include:

  • 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
Table of Contents

Introduction
1 Get the most out of Microsoft Access with VBA
2 What you should know

Introduction to Visual Basic for Applications
3 Introduction to object-oriented programming
4 Examine the Access object model
5 Work in the Visual Basic Editor
6 Create export and delete code modules
7 Create a subroutine
8 Create a function
9 Add comments to your code
10 Run a VBA procedure

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

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

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

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

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

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

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

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