Tutorials   News   Tips   Forums   Help   Logon   Order  
 
 
 
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
 
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

 

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

 

 
Learn
 
Microsoft Access
Microsoft Excel
Microsoft Word
Microsoft Windows
Microsoft PowerPoint
Adobe Photoshop
Visual Basic
Active Server Pages
Online Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
WalkThru Tutorials
Free Upgrades
Insider Circle
Info
 
Latest News
New Releases
User Forums
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Help
 
Live Chat
Customer Support
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Live Chat
General Contact Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Try Us
 
Free Lessons
Online Theater
Mailing List
Course Indexes:   Microsoft Access   Microsoft Excel   Microsoft Word   Microsoft PowerPoint   Visual Basic (VB)   Photoshop   Active Server Pages (ASP)  
Keyword Search Cloud:   What's This?   courses   microsoft access tutorials   vlookup   access   cartesian   excel   dlookup   vba   attendance   access 2007   sql   windows 7   combo box   pivot table   visual basic   test   iif   word   calendar   query   conditional formatting   pivot tables   photoshop   hlookup   access 101   excel 202   excel 2007   student attendance   update query   my account   word 2007   append query   quickbooks   queries   dsum   reports   powerpoint   if   microsoft access   dmax   mail merge   relationships   ms access   access 2010   vb   dcount   subforms   excel 2003   handbooks   html   599cd   combobox   if function   security   microsoft word   after update  
Copyright 2012 by 599CD.com, All Rights Reserved