Visual Basic Programming 5 Days Language: English
DESCRIPTION This comprehensive 5-day training will give you a jump start in writing applications with the most popular programming language ever: Visual Basic. Students learn application development in "hands-on" sessions: programming real life examples for recognizable situations. The course emphasizes communication with databases and text files. Participants learn to take advantage of Visual Basic's highly productive "plug-in" controls to create Windows programs easily and enjoyably. The course will leave you with reusable code for standard situations, and code that can be easily modified to your needs. You will be introduced to all the best web sites on VB, offering you tons of free code, discussion platforms and sample programs.	WHAT YOU WILL LEARN Use Visual Basic to create executable files and to distribute them to your users Use many excellent controls from the CD and from the Web, with ready-to-use code Write code for events and general procedures, applying good programming and naming practices Get to use Visual Basics’built-in functions on your forms and data Create dynamic Menus storing the last used files in the Registry Avoid errors with Debugging and handle run-time errors. Connect to and modify databases using DAO, ODBC and ADO. Take advantage of Windows API functions Manage Office and other applications from VB. Learn to develop more efficiently using the Net.
WHO SHOULD ATTEND: Anyone wanting to create and distribute .exe files with Visual Basic This course will satisfy any self-made programmer wanting to acquire good programming practices and adding in-depth knowledge fast.	ASSUMED KNOWLEDGE Good knowledge of any Windows environment and how to use a Windows-based application is assumed. Some knowledge of database concepts is recommended

 

COURSE OUTLINE

 

DAY 1 - SESSION 1: EXPLORING VB

 

·            Exploring Visual Basic by programming a first application

·            The programming model: Object Oriented Programming & Event Driven Programming, run-time & design-time, the basics of programming in VB(A)

·            Starting a Visual Basic project, adding forms, main project and form properties basic controls

·            Referencing libraries

·            Compile your project into a “.exe” file

·            Distribute the application using the Package & Deployment Wizard

·            The Setup.exe and Uninstall.exe.

·            Visual Basic Naming conventions

 

DAY 1 - SESSION 2: WORKING WITH PROCEDURES, VARIABLES AND CONSTANTS

 

·            Procedures: typology, scope, passing arguments

·            Variables: data variables & object variables, implicit & explicit declarations, types of variables and memory usage

·            Variables: Conversion function & functions for testing variable types and contents

·            Variables: User-Defined Variables

·            Variables: all about Arrays

·            Constants: declaration & use

 

DAY 2 - SESSION 3: MANAGING THE FLOW OF APPLICATIONS

 

·            Using Loop Structures: Do While - Loop, Do Loop - Until, While… Wend, For - Next, For Each – In Statements

·            Using Decision Structures: If-Then-Else, Select Case Statements

·            Nesting conditional and repetitive code

 

 

DAY 2 - SESSION 4: CONTROLS WORKSHOP

 

·            Overview of frequently used controls & where to get them.

·            Working with control arrays.

·            Reusable code for: Frame, Option Buttons, CheckBox, Line, Shape, PictureBox, Listbox, ComboBox, DriveListbox, DirListbox, FileListbox, Image Control, ImageList, ImageCombo, Timer & ProgressBar, Calendar, Common Dialog Control, HScrollBar, VScrollBar, FlatScrollBar, UpDown, Slider, StatusBar

 

 

DAY 3 - SESSION 5: FUNCTIONS WORKSHOP

 

·            Message functions: MsgBox, InputBox

·            Text functions: Left, Mid, Right, Trim, LTrim, RTrim, Format, InStr, Asc, Chr

·            Date functions: Date, Now, Time, Day, Month, Year, DateAdd, DatePart

·            File & system functions: Kill, FileCopy, FileLen, GetAttr, SetAttr, Dir, CurDir, MkDir, RmDir, ChDir, Shell

·            Other functions: Choose

 

DAY 3 - SESSION 6: ERROR HANDLING

 

·            Debugging and Error Handling strategies.

·            Debugging: Tools available in the programming environment.

·            Error Handling: Syntax for managing run-time error handling

 

DAY 3 - SESSION 7: WORKING WITH TEXT FILES

 

·            Reading from and writing to text files

·            Exercise: logging user actions in a .log file

·            Exercise: storing application options in an .ini file

 

DAY 3 - SESSION 8: DESIGNING MENUS & USING THE REGISTRY

 

·            Design a menu a design time

·            Changing a menu at run-time

·            Reading values from the Registry

·            Writing values to the Registry

·            Exercise: Displaying a list of last used files (CPU) in the menu.

 

DAY 4 - SESSION 9: DATABASE PROGRAMMING

 

·            Programming with Data Access Objects (DAO).

·            ODBC & ODBC Direct

·            ADO programming

·            VB data bound controls for DAO and ADO.

·            Exercise: Working on MS Access data in VB

 

DAY 5 - SESSION 10: PROGRAMMING WINDOWS WITH API CALLS

 

·            How to dialog with Microsoft Windows

·            Analysing an API call

·            Reusable code: capturing the windows login, browsing for directories and files, picking colours.

 

DAY 5 - SESSION 11: DRAG & DROP

 

·            Responding to Drag & Drop user actions

 

DAY 5 - SESSION 12: PAINTING & GRAPHICS

 

·         Functions and objects for Painting

·         Colour coding

·         Printing

 

DAY 5 - SESSION 13: THE POWER OF AUTOMATION

 

·         Inter-Office programming: managing Word, Excel, PowerPoint, Outlook, and PowerPoint from Visual Basic.

·         Exercise: create a PivotTable and Chart in MS Excel and copy & pasting them to MS Word

 

 

DAY 5 - SESSION 14:  ADVANCED TOPICS

 

·         Designing controls in ActiveX projects

·         Designing function libraries with .dll files

·         Concepts of Class Programming

·         Exercise: A class for text editing

·         Visual Basic 7.0 or CNET: a preview & discussion!