If you can't explain it simply,
you don't understand it well enough.
-Albert Einstein
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
NEW Release: Access Developer Level 3   dismiss
 
 
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.
Sorry!
 

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

 
 
 

Student Interaction: Visual Basic 202

Richard on 1/1/2008:  In VB202 we'll build our own real-world application: a Hot Dog Stand. We'll work more with text files, including creating a log of orders. We'll import that into Excel. We'll also cover user-defined types, arrays, and TONS of new functions.
Robert M. Lilly on 2/5/2008: You might want to correct the value of more Variables to(13.00).

Instead of(3:00).

Richard Rost on 2/5/2008: Yes, thank you Robert. The TIME listed for the lesson is 13 minutes, not 3 minutes. My bad. Typo! I'll have to update the system accordingly. That means the course is 90 minutes long, not 80 as previously listed. Cool.
gilbert on 2/7/2008: needs lessons or tutorials on how to use ms access in vb6. and how to set the datagrid control to auto size with the window when i run the program
Richard Rost on 2/8/2008: I will be covering attaching to an Access database in a future lesson. I'll also be covering lots more controls - including DataGrid.
Karl Peters on 6/2/2009: I know your very busy creating alot of video tutorials on many different subjects, but i was wondering if a VB 203 will be comming out in the very near future? And how many more VB videos do you plan on creating? Really looking forward to future VB learning videos
Richard Rost on 6/11/2009: Karl, my focus right now is on the Office 2007 tutorials. I'm not certain when the next VB6 video will be out.
Alex Hedley on 9/15/2010: DateAdd Interval

yyyy Year
q Quarter
m Month
y Day of year
d Day
w Weekday
ww Week of year
h Hour
n Minute
s Second

Bizimana Bizimana on 8/6/2013: Hi,Richard I would to know if you have Java programming course.
Thanks.

Reply from Richard Rost:

Nope. Sorry. I'm planning on putting together a JavaSCRIPT class in the future, but that's a totally different animal.

 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP