Visual Basic Progressor


visual-basic-progress-460x200

Move past the basics learned in the Primer course to build larger applications that work with files or data.

3 days or 8 evenings


Overview

What does the course cover?

Attendees will focus on problem solving to solve basic computing problems as well as learning standard algorithms for sorting and searching data.

Aims

Why take this course?

The aim of this course is to advance users past the early stages of program development introduced with our Visual Basic Primer course.

Audience

Who should attend?

This course is aimed at new programmers having completed and passed the exam for the Visual Basic Primer course(or equivalent).


Certification

When you complete this course you will be awarded an internationally recognised accreditation certificate like this:
specialist_cert

Course content

What will be covered throughout the course

  • Working with Files
  • User-defined types
  • Enumerated types
  • Text files
  • Modes of operation
  • Reading and writing records
  • Searching and processing text files
  • Text files and listboxes
  • Working with fixed format text files
  • Using Functions
  • Functions and parameter passing mechanisms
  • Function scope
  • Sorting techniques
  • Global variables
  • Recursive functions
  • Sorting and Searching techniques
  • Sorting arrays of numbers and strings-Bubble sort, Insertion sort, QuickSort
  • Searching algorithms
  • Binary search
  • Arrays
  • Creating an Array
  • Multi-dimensional arrays
  • Looping through an array
  • Working with menus
  • Pop-up menus and drop down menus
  • Data Access
  • Overview of database terminology
  • Basic database access using bound controls


Skills you’ll learn

What you’ll be able to do after the course

  • To be able to sort and search arrays and text files.
  • To be able to create functions
  • To understand the scope and parameter passing mechanisms.
  • To be able to create user defined types.
  • Create fixed format files
  • To understand the concept of a recursive function.
  • Be able to work with multi-dimensional arrays.
  • Basic database work.

How you can apply these skills

What you’ll be able to do after the course

  • Stepping stone to more advanced Excel
  • Building an application that can manage a data file
  • Break your code up into more manageable units
  • Defining data structure when dealing with complex data
  • Storing structured data in a file
  • Calculating a factorial
  • Storing multiple data blocks in memory
  • Display information from a database

Ready to get more info on dates and pricing?

Please enquire now and one of our Course Advisors will get back to you shortly