Visual Basic for Applications and Sheet No.

Topics: Visual Basic, Visual Basic for Applications, Microsoft Visual Studio Pages: 25 (6743 words) Published: February 6, 2013


INFORMATION SHEET NO. 1: What is Visual Basic?4
INFORMATION SHEET NO. 2: The Visual Basic Environment5
INFORMATION SHEET NO. 3: Common Visual Basic Controls11
Setting properties to a TextBox12
Operations Sheet No. 1: Opening Visual Basic 614
Operation Sheet No. 2: Saving in Visual Basic 6.016
Operations Sheet No. 3: Closing Visual Basic 6.017
Operations Sheet No. 4: Inserting Object in Visual Basic 6.018 INFORMATION SHEET NO. 4: Variables20
Explicit Declaration20
Using Option Explicit statement20
Scope of variables21
Local Variables21
Static Variables21
Module Levele Variables22
Public vs Local Variables23
INFORMATION SHEET NO. 5: Datatypes, Modules and Operators24 Modules24
Data types in Visual Basic 624
Operators in Visual Basic25
INFORMATION SHEET NO. 6: Control Structures28
If...Then selection structure28
If...Then...Else selection structure28
Nested If...Then...Else selection structure28
Select...Case selection structure30
INFORMATION SHEET NO. 7: Looping structures31
Do While... Loop Statement31
While... Wend Statement31
Do...Loop While Statement31
Do Until...Loop Statement31
The For...Next Loop32
With...End With statement33
INFORMATION SHEET NO. 8: Function and Procedures35
Sub Procedures35
Event Procedures35
General Procedures36
Function Procedures37
Property Procedures37
INFORMATION SHEET NO. 9: Control Arrays38
Sharing Event Procedures38
Creating Controls at Run Time40
Iterating on the Items of a Control Array43
Arrays of Menu Items44
INFORMATION SHEET NO. 10: Database Terminology46
OPERATION SHEET NO. 3: Creating Database Using Add-ins49
OPERATION SHEET NO. 4: Connecting Database Using Data Control51 OPERATION SHEET NO. 5: Saving A Record to the Database53
OPERATION SHEET NO. 6: Searching, and Deleting Record54
OPERATION SHEET NO. 7: Searching, and Updating Record56
JOB SHEET NO. 1: Database58
JOB SHEET NO. 2: Data Entry Program59
JOB SHEET NO. 3: Search Program61
JOB SHEET NO. 4: Delete Program63
JOB SHEET NO. 5: Edit Program65
JOB SHEET NO. 6: View Program67

LO1. Getting Started with Visual Basic

What is Visual Basic?
The Visual Basic Environment
Common Controls
Opening VB 6
Saving in VB6
Variables, Datatypes and Operators

INFORMATION SHEET NO. 1: What is Visual Basic?

Visual Basic has evolved in the programming industry for a quite some time. It originated in the early programming language called BASIC (Beginners All-purpose Symbolic Instruction Code) which is a high-level programming language developed at Dartmouth College in the mid-1960s by John Kemeny and Thomas Kurtz. BASIC gained its popularities mostly because of two implementations, Tiny BASIC and Microsoft BASIC, which made BASIC the first lingua franca of microcomputers.

Other important implementations have been CBASIC (Compiled BASIC), Integer and Apple soft BASIC (for the Apple II), GW-BASIC (for the IBM PC), Turbo BASIC (from Borland), and Microsoft QuickBasic. The language has changed over the years. Early versions are unstructured and interpreted. Later versions are structured and often compiled. BASIC is often taught to beginning programmers because it is easy to use and understand and because it contains the same major concepts as many other languages thought to be more difficult, such as Pascal and C.

During these early programming languages, Microsoft came up of its version of a programming language, which is object-oriented with the combination of the conventional written programming language and a Drag and Drop procedure. Compared to other versions of this type, Visual Basic can produce the...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Visual Basic 6.0 Essay
  • Visual Basic Essay
  • Essay on Visual Basic
  • Visual Basic for Applications and Function Essay
  • Visual Basic for Applications and Staff Members Essay
  • Visual Basic Fox Pro Essay
  • The History of Visual Basic Essay

Become a StudyMode Member

Sign Up - It's Free