Support

Access 2007 VBA Course

3 sessions available starting from $1,155.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

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...

see more

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

see less

Choose from 3 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 18-Jul-11 + 26-Jul-11 + 03-Aug-11

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 12-Sep-11 + 20-Sep-11 + 28-Sep-11

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $1,155.00

Notes:

Course Dates: 14-Nov-11 + 22-Nov-11 + 30-Nov-11

Type

  • Class / Group Sessions



My Other Listings

Access 2007 Advanced Course
Access 2007 Advanced Course
2 sessions available starting from $770.00
Excel 2003 Course - Intermediate
Excel 2003 Course - Intermediate
6 sessions available starting from $700.00
Illustrator CS4 Introduction Course
Illustrator CS4 Introduction Course
1 session available for $770.00

see all listings »


Found In