Category
ICT
Course Type
Microsoft
Price Per Delegate
£695 +VAT
Public Scheduled Course
Price Per Course
£2,385 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
3 Days
Full/Part Time
Part Time
Provider
Dates and Locations
Contact us for the latest course dates.
Book courseThis course is intended for users who need to use the added functionality of Access Visual Basic for Applications to build, maintain, manipulate and automate databases.
Objectives:
At the end of the course users will be able to understand and create VBA code. You will be able to create procedures and functions and use VBA to manipulate data from tables and queries.
Prerequisites:
An advanced understanding of creating Access databases, including table and form design.
- Exploring the Visual Basic Editor
- Running Code from the Immediate Window
- Understanding Objects & Dot Syntax
- Creating & Organising Modules
- Commenting & Editing VBA Code
- The Access Object Model
- Understanding Procedures
- Organising Code using With...End With
- Writing Clear & Structured Code
- Calling Procedures from Different Locations
- Using the DoCmd Object to Control Access Interface Features
- Understanding & Naming Variables
- Declaring Variables & Data Types
- Declaring & Using Constants
- Assigning Values & Objects to Variables
- Performing Calculations in VBA Code
- Creating & Customising Message Boxes
- Receiving Information from Message Boxes
- Creating Input Boxes to Receive User Data
- Understanding & Customising Input Boxes
- Understanding & Using Intrinsic Functions
- Writing User-Defined Functions
- Using User-Defined Functions in VBA & the Access Interface
- Controlling Program Flow Using IF Structures
- Using Select Case Structures
- Repeating Code Using Loops
- Definite Loops
- Indefinite Loops
- Understanding Arrays & Their Uses
- Declaring & Populating Arrays
- Using Multi-Dimensional Arrays
- Creating DAO & ADO Recordsets
- Using SQL to Create Recordsets
- Navigating in Recordsets
- Updating Tables Using Recordsets
- Writing Code for Forms & Reports
- Working with Controls
- Linking to Excel & Word
- Passing Data to Outlook Emails
- Identifying Error Types
- Reducing & Debugging Errors
- Writing Code to Handle Errors
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.
