Microsoft Access Visual Basic
Aims:
The focus of this course is to develop Access programming skills. On completion of the course, delegates will be able to develop and maintain an entire Access application
Prerequisites:Delegates must be familiar with all features covered in the Access Introductory and Advanced level courses, particularly Form Design, Basic Macros and advanced level Queries
Duration:Three Days
Fees:Course fees for this particular course will depend on your chosen Training solution. Please contact one of our advisors for further details
PDF Course Download
You can download a PDF version of the course.
Download Microsoft Access Visual Basic course outline.
If you don't have Adobe Acrobat Reader, this can be downloaded from the www.adobe.com web site.
If you are interested in our Microsoft Access Visual Basic course call us on
0113 243 2226
Enquire about
this course Now
- Macro Revision
- Limitation of Macros
- Why use Visual Basic
- Overview of Functions & Subprocedures
- Understanding Event Procedures & Modules
- The concepts of object based code
- The three types of Event: Form, Section, Control
- Writing & Using a User Defined Function
- Passing parameters to a Function
- Using Macro commands in Visual Basic
- The Immediate Window
- Methods & Properties
- Controlling program flow
- Creating & Declaring Variables
- Using the Debug Window
- Using the Menu Editor
- Trapping Run-Time Errors
- Using MsgBox & InputBox
- Calling one Procedure from another
- Record Sets
- Using VB to Call SQL Statements
- Using VB to Write HTML Files
