Programming Courses
Two courses are currently available that teach programming.
Introduction to Microsoft Visual Basic 6
Course Objectives | Course Outline | Who Should Attend | Practical Work | Pre-requisites
Course Objectives
A three-day course: A thorough opportunity to create straightforward applications using Microsoft Visual Basic Professional. Delegates will also be able to develop and maintain systems using the core features of Visual Basic.
Course Outline
During the course we will cover:
- Visual Basic Development Environment
- Visual Basic File Types
- Understanding Event Driven Programming
- Using Methods, Properties and Events
- Data Types Variables and Constants
- Program Structures
- Input Box and Message Box
- Intrinsic Controls
- Designing and working with dialog boxes
- MS Windows Common Dialog Controls
- Providing application menus
- Visual Basic techniques using custom controls, drag and drop
- Creating and using MDI applications
- Manipulating the file system
- Binary and Sequential Files
- Sequential Access
- Text Files on Disk
- Open, Save and Close Files
- Writing Reading & Closing Files
- Binary Access
Who should attend
This course is designed for potential Visual Basic programmers or those wishing to create applications using the Visual Basic language.
Practical work
Each delegate will carry out various practical exercises during the course, which involves them working through examples of each subject covered, or build a program to help them understand the subject.
Pre-requisites
Prior knowledge of Visual Basic or any other programming language is not essential. However, a basic understanding of programming methods and some exposure to basic VB code (for example application macros in VBA) would be an advantage.
Automating Access using Macros and
Visual Basic for Applications
Course Objectives | Course Outline | Who Should Attend | Practical Work | Pre-requisites
Course Objectives
A three-day course: Covering using the power of Visual Basic for Applications to automate Microsoft Access databases making them easier for your end-users to operate.
Course Outline
During the course we will cover:
- Creating Macros
- Visual Basic for Applications Development Tools
- Using the Macro Converter
- VBA Language Concepts
- Declaring Data Types
- Commands and Statements
- Variables and Constants
- Controlling program flow using
If..Then..Else,Do..Loops andFor..NextConstructs - Using Methods, Properties and Events
- Programming Access forms and controls
- The input box and the message box
- Programming the database and associated objects
- Using
For Each..NextandWith..End WithConstructs - Examining the Object Model with the Object Browser
- Integrating Access with other Office programs
- Using error handling and debugging code
Who should attend
This course is designed for Access developers or those wishing to use Access database files from other Microsoft Office applications.
Practical Work
Each delegate will carry out various practical exercises during the course, which involves them working through examples of each subject covered.
Pre-requisites
Prior knowledge of Visual Basic or any other programming language is not essential although a basic understanding of programming concepts would be an advantage. However, delegates would require an understanding of Microsoft Access at least to the level covered by our Beyond the Basics course.
