4 hours ago: I made a few modifications to the website yesterday so if you see any JavaScript errors let me know. Thanks.  Dismiss
Computer Learning Zone CLZ Access Excel Word Windows

Our academic system rewards people who know a lot of stuff... but at the end of the day who do you want: the person who can figure things out that they've never seen before or the person who can rattle off a bunch of facts?

-Neil deGrasse Tyson
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Courses - Microsoft Visual Basic 202
Description: Intermediate Microsoft Visual Basic
Running Time: 90 minutes
Pre-Requisites: Visual Basic 201 strongly recommended
Versions: We use Microsoft Visual Basic 6.0, but lessons are valid for most earlier versions of VB, including 4 and 5. If you have VB.NET or VB 2005, the Visual Basic code we use is similar, but the programming interface has changed. These VB courses do NOT cover VBA (Visual Basic for Applications) which is what you need for Microsoft Office programming. For VBA, see the individual Office applications (Word, Excel, Access, etc.) Click here for more information on VB.NET courses.

Order Now: $19.99



 Click here for the Teacher's Outline
Notice: this course covers the older Visual Basic 6.0 programming application. Microsoft no longer sells VB6. If you want to learn VB6, you'll have to find a used copy somewhere like eBay or Craigslist. We will be updating this course for use with Visual Basic 2013 soon. If you've purchased this course within the last year, you'll get a free upgrade when it's released.

This course follows VB201. We'll spend a great deal of time in this class building a Hot Dog Stand application. Now, there's not a lot to show as far as different screen-shots go, but you will be learning lots of new Visual Basic techniques as well as tying together a lot of the material you've already learned thus far into a working, real-world application.

We'll start out by building our form to sell Hot Dogs, Fries, and Drinks. Notice the scroll bar spinner buttons to change the quantities. Our program will automatically calculate all of the totals and tax. We'll learn about the FormatCurrency function.


We'll use our file output techniques from VB201 to create a sales log of all of our orders for the day. We'll learn about the Open For Append command to add information to an existing file.


I'll then show you how to load this information into Microsoft Excel to perform your "daily bookkeeping" on it.

If you don't have Excel, don't panic. We only spend a few minutes with it.

We'll also learn how to create a printable receipt out of a text file that you can then save or print for your customers.


Now we're done with the Hot Dog Stand (for this class). We'll next learn more about variable types, user-defined types, fixed-length strings, and arrays.


We'll learn more about the difference between public and private variables, adding our own custom modules, adding private and public subs in those modules, how to change from a startup form to a Sub Main, static variables, and constants.

Lots of fundamental programming techniques in this course, so
there's not too much to show you in the form of screen shots.

Finally, we'll cover a whole ton of programming "stuff" we haven't gotten to yet: integer division, converting to upper/lower case, number and date formatting, calculating dates, and more. See the Teacher's Outline for a complete list of all of the functions we cover in this class. There are a lot of them!


 Click here for the Teacher's Outline

Try a FREE Demo Lesson



The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 2/22/2024 4:03:52 PM. PLT: 0s