CTS Training

This course is designed for experienced users of Access who wish to understand the VBA programming environment. At the conclusion of this course, participants will be able to create automated forms and reports and use VBA to manipulate the Access data.

Duration:

3 Days

Audience:

The course has been designed for the advanced user who needs to design and create automated applications in Microsoft Access.

Prerequisites:

Participants must have completed the Advanced Access course or have equivalent level knowledge of using Access.

Course Content:

Writing Procedures
• Naming a Procedure
• Naming rules
• Event Procedures
• Guidelines For Entering Code
• Reviewing the Code

Objects, Properties & Methods
• Objects, Properties and Methods
• Collections and Objects
• Exclamation Marks, Dots & Brackets
• Properties
• Methods

Data Types, Variables & Operators
• Data Types and their uses
• Working with Variables
• Working with Constants
• Operators and expressions
• Message Boxes
• Button Arguments and Values
• Changing Format of Dates
• Getting User Input
• Joining Text and Numbers
• Performing Calculations
• Working With Large Messages
• Converting Data types
• Scope and Lifetime of a Variable
• Procedure, Module, Public level Variables

Decision Structures in VBA
• If then
• If then Else
• Select Case structure
• Using Vb constants

Working with Loops
• Do Until ...loop
• Do While ...loop
• For ...Next statement
• For Each statement

Working with Objects
• What is an object in VBA
• Properties of objects
• Objects of containers of other objects
• AccessObject Object
• Using an Object Variable
• Checking for Selected Items
• Dynamic Procedures
• Properties of Objects
• Storing the Name of An Object
• Object Variable –v- Variable
• Special Objects
• The Me Property
• Application Objects

Navigation
• Searching for a Record
• SetFocus Method
• Going Back
• Changing the Record Order
• SQL Statements
• Reading & Writing SQL Statements

Data Access Objects
• Understanding DAO and ADO
• ADO Object Model
• Working with RecordSets
• Creating a RecordSet
• Close the RecordSet
• Finding Specific Records
• RecordSet Boundaries
• Moving through a RecordSet
• Filtering a RecordSet
• Editing Data in a RecordSet
• Adding a New Record
• Deleting Records

Working with other Applications
• Sending Emails from Access
• Setting a reference to Outlook
• Passing data from Access to Outlook
• Creating personalised emails with Access Data
• Creating an instance of Microsoft Word
• Merging Access data with Word.
• Creating personalised letters