Access: VBA
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to leverage the Visual Basic for Applications (VBA) programing language in Access to create robust desktop database applications.
Syllabus
Introduction
- Get the most out of Microsoft Access with VBA
- What you should know
- Introduction to object-oriented programming
- Examine the Access object model
- Work in the Visual Basic Editor
- Create, export, and delete code modules
- Create a subroutine
- Create a function
- Add comments to your code
- Run a VBA procedure
- Introduction to Access data types
- Declare variables and require declaration before using
- Manage variable scope
- Define constants and static variables
- Create a calculation using mathematical operators
- Display a calculated result in a message box
- Define an array
- Define and use an object variable
- Repeat a task using a For…Next loop
- Step through all items of a collection using a For…Each loop
- Repeat a task using a Do…While loop
- Perform a task when conditions are met using an If…Then statement
- Select actions using a Case statement
- Manage errors in VBA code using On Error statements
- Step through a subroutine or function
- Set breakpoints in your code
- Verify output using the Immediate window
- Watch a value in a routine
- Open a form
- Open a report
- Open a table
- Open a query
- Close an object
- Close a database or quit Access
- Run a menu command
- Print the active database object
- Display or hide warnings
- Display every row in a table (recordset)
- Add a new record to a table
- Edit values in an existing table row
- Preserve data integrity using transactions
- Display a table property using the TableDef object
- Close a recordset
- Delete the current record
- Find records within a table
- Move within a recordset
- Count the records in a recordset
- Summarize values in a table field
- Find the first or last value in a table field
- Look up a value in a table field
- Create a progress bar using the SysCmd object
- Allow or disallow additions, deletions, and edits
- Manipulate form filters
- Set the caption and background picture
- Requery and repaint forms
- Discover a record source
- Render a form or report visible or invisible
- Introduction to Access macros and data macros
- Create macros
- Work with data macros
- Run a macro by clicking a command button
- Manage macro security settings
- Next steps
Taught by
Curt Frye
Related Courses
Excel/VBA for Creative Problem Solving, Part 3 (Projects)University of Colorado Boulder via Coursera Everyday Excel, Part 1
University of Colorado Boulder via Coursera Microsoft Excel - Excel from Beginner to Advanced
Udemy The Ultimate Microsoft Office 2016 Training Bundle
Udemy Excel with Microsoft Excel VBA User Forms
Udemy