FACULTY OF SCIENCE AND INFORMATION TECHNOLOGY

PROGRAMMING
IN VISUAL BASIC

ADVACNED CERTIFICATE IN
INFORMATION TECHNOLOGY

MIANZ INTERNATIONAL COLLEGE

Niyandhurumaage, 5th Floor, Alimas Magu, Male, Maldives
+960 7226650 | fsit@[Link]
OUR MISSION
TO COLLABORATIVELY PREPARE SOCIALLY CONSCIOUS PLANNERS, ORGANISERS AND

CRITICAL THINKERS WHO ACT WITH PURPOSE, INNOVATE AND EXCEL.

OUR VISION
WE WILL BE A FIRST CHOICE COLLEGE, INSPIRING EXCELLENCE AND TRANSFORMING LIVES,

THROUGH ORGANIZATION AND INNOVATION. WE WILL BE A LEARNING, SOCIALLY

RESPONSIBLE COMMUNITY, ENGAGING OUR STUDENTS IN THINKING CRITICALLY AND ACTING

PURPOSEFULLY.

OUR CORE VALUES

ORGANIZATION

LONG-TERM PLANNING

ANALYSIS AND EVALUATION

INNOVATION

EXCELLENCE

+960 7226650 | fsit@[Link]

MODULE CREDITS
15.0

CONTACT HOURS:
50 HOURS

MODULE OBJECTIVE
The Programming in Visual Basic module provides students with a solid foundation in
Visual Basic programming language and its application in developing software solutions.
Students will learn the fundamental concepts of Visual Basic, including the graphical
user interface (GUI) environment, programming structure, data types, operators, control
flow, and error handling.
Throughout the module, students will gain proficiency in utilizing the Visual Basic
Integrated Development Environment (IDE) to design and execute simple applications,
embed controls on forms, write code, and save projects. They will also learn how to
create interactive user interfaces by applying various controls and formatting input and
message boxes.
The module covers topics such as conditional statements, loop statements, multi-
window applications, file management, shape controls, line controls, and common dialog
controls. Students will also be introduced to the concept of data structures and learn
how to implement arrays for data manipulation and sorting.
By the end of the module, students will have developed the skills to design and develop
basic applications using Visual Basic, incorporating effective programming techniques
and user-friendly interfaces.

EXPECTED LEARNING COUTCOME

Understand the components and features of the Visual Basic 6.0 GUI
environment.
Apply programming concepts in Visual Basic 6.0, including data types,
operators, control flow, and application design.
Create interactive user interfaces using various controls and formatting
techniques in Visual Basic 6.0.
Implement decision-making structures and loop statements to control
program flow in Visual Basic 6.0.
Develop multi-window applications with menu bars, file management
controls, and image display in Visual Basic 6.0.

+960 7226650 | fsit@[Link]

 Utilize shape controls, line controls, and common dialog controls for
enhanced user interaction and file management in Visual Basic
applications.
Apply arrays for data manipulation and sorting in Visual Basic
applications
Understand the fundamentals of database management systems and
develop VB front-end applications with database connectivity.
Connect databases and navigate records using data control, DAO control,
and ADO control in Visual Basic.
Implement advanced user interface controls, format and customize list
view controls, utilize data bound controls, and manipulate data grid
controls effectively in Visual Basic applications.

MODULE DEATILS

Topic 1: : Introduction to Visual Basic 6.0 GUI and Environment

 Identify and describe the components of the Visual Basic 6.0 graphical user
interface (GUI) environment.
 Explain the features and functions of the Visual Basic 6.0 front end, including the
object window, code window, and tool box.
 Demonstrate proficiency in navigating the Visual Basic screen and utilizing key
windows, such as the properties window and project explorer window.
 Utilize the Visual Basic IDE to embed controls on a form, write code in the code
window, and save forms and projects.
 Describe the programming structure of Visual Basic, work with procedures, and
design and execute simple applications.
Topic 2: Data Types, Operators, and Statements in Visual Basic
 Analyze and apply various data types in Visual Basic 6.0, including numeric, string,
and Boolean data types, to effectively store and manipulate data.
 Evaluate and utilize different operators, such as mathematical operators,
relational operators, and logical operators, to perform calculations and make
logical decisions in Visual Basic 6.0.

+960 7226650 | fsit@[Link]

 Construct and execute statements in Visual Basic 6.0 to control program flow,
including conditional statements, loops, and error handling.
 Demonstrate proficiency in declaring variables and constants in the declaration
section of the code window, considering scope and data type requirements.
 Design and develop simple applications using Visual Basic 6.0, employing
variables, statements, and basic programming concepts to achieve desired
functionality.
Topic 3: User Interface Design and Input Handling in Visual Basic 6.0
 Apply the appropriate controls, such as text box, label box, command button, list
box, combo box, and option button, to create interactive user interfaces in Visual
Basic 6.0.
 Utilize input and message boxes effectively to interact with users and display
information or gather input in Visual Basic 6.0.
 Format input and message boxes to enhance their appearance and provide a
user-friendly experience in Visual Basic 6.0.
 Demonstrate an understanding of the VAL function and its role in converting
strings to numeric values in Visual Basic 6.0.
 Implement print statements to output information to the printer in Visual Basic
6.0.
Topic 4: Control Statements and Loop Structures in Visual Basic 6.0
 Apply control statements, including IF statements, in Visual Basic 6.0 to control
the flow of program execution based on specified conditions.
 Construct and analyze various types of IF statements, such as simple IF
statements, multiple IF statements, compound IF statements, and nested IF
statements, to create decision-making structures in Visual Basic 6.0
 Implement the Select Case statement in Visual Basic 6.0 to streamline decision-
making processes and improve code readability.
 Utilize loop statements, such as Do While statements and For loops, in Visual
Basic 6.0 to repeat sections of code based on specific conditions or a fixed number
of iterations.

+960 7226650 | fsit@[Link]

 Create and evaluate nested loop structures, including nested For loops, in Visual
Basic 6.0 to solve complex problems and manipulate data efficiently.
Topic 5: Advanced Form Design and Controls in Visual Basic
 Demonstrate proficiency in working with MDI forms to create a multi-window
application.
 Apply the appropriate properties to link child forms with an MDI form.
 Create a menu bar and define menu items using the menu editor to enhance user
navigation.
 Utilize drive list box, dir list box, and file list box controls for efficient file
management within the application.
 Incorporate picture box and image box controls to insert and display images with
proper differentiation.
Topic 6: Working with Visual Basic Controls and Dialogs
 Analyze the purpose and functionality of shape controls in Visual Basic and
demonstrate the ability to insert and manipulate them in a form.
 Evaluate the purpose and functionality of line controls in Visual Basic and
demonstrate the ability to insert and customize them in a form.
 Demonstrate proficiency in utilizing the common dialog control to interact with
users and perform file-related operations in Visual Basic.
 Design and develop applications that incorporate common dialog controls,
utilizing their features to enhance user interaction and file management.
 Apply problem-solving skills to identify and resolve common issues related to
shape controls, line controls, and common dialog controls in Visual Basic
applications.
Topic7: Data Structures and Arrays in Visual Basic
 Analyze the concept of data structures and their importance in programming.
 Implement single-dimensional arrays to store and manipulate collections of data.
 Apply double-dimensional arrays to manage and organize complex data sets.
 Employ the bubble sorting method to arrange array elements in ascending or
descending order.

+960 7226650 | fsit@[Link]

 Develop and execute sample programs that demonstrate proficiency in using
arrays for data manipulation and sorting.
Topic 8: Database Management and Connectivity in Visual Basic
 Explain the fundamentals of a database management system and its role in
information technology.
 Utilize the Visual Data Manager tool to create, structure, and edit database tables.
 Identify and differentiate various data types used in database management
systems.
 Develop VB front-end applications with database connectivity to establish a link
between the user interface and the back-end database.
 Retrieve records from the back-end database and display them in the front-end
application for user interaction.
Topic 9 Explaining about the Loop Statements
 Demonstrate proficiency in connecting databases using data control, DAO (Data
Access Object) control, and ADO (ActiveX Data Object) control.
 Apply record navigation techniques to efficiently access and manipulate data
within a database.
 Explain the concepts of record source and record set in the context of database
connectivity in Visual Basic.
 Develop a mini database application utilizing data control, DAO control, or ADO
control, showcasing effective database connectivity and record manipulation.
 Successfully complete assignments related to connecting databases, record
navigation, and developing mini database applications using appropriate control
methods.
Topic 10: Advanced User Interface Controls and Data Management
 Analyze and implement advanced user interface controls: Students will be able
to evaluate the functionality of list view controls and data grid controls in Visual
Basic and implement them effectively in user interface designs.

+960 7226650 | fsit@[Link]

  Customize and format list view controls: Students will be able to apply formatting
options, set headers, and display records in a list view control to enhance the
user experience.
 Utilize data bound controls for efficient data management: Students will be able
to work with data bound controls, perform record operations such as adding,
editing, searching, deleting, and viewing records in a front-end application.
 Design and manipulate data grid controls: Students will be able to configure data
grid controls, set headers, format display, and utilize data binding to effectively
present and manage tabular data in Visual Basic applications.
 Apply best practices for user-friendly record operations: Students will be able to
implement intuitive interfaces and efficient workflows for adding, editing,
searching, deleting, and viewing records, ensuring a smooth user experience.

ASSESSMENTS
INTERNAL EXAM 50

ASSIGNMENTS 30

PRACTICALS 20

EXTERNAL EXAM 50

THEORY 50

REFERENCE MATERIALS
Visual Basic Developers Guide to ASP and IIS by A. Russell Jones (1999)
OOP: Building Reusable Components with Microsoft Visual Basic .NET By Ken Spencer, Tom
Eberhard, John Alexander (2002)
Programming Distributed Applications with COM and Microsoft Visual Basic 6.0 / Ted
Pattison. (1998)
Learning Visual Basic 6.0, Singh, Vishnu P, Computech Publications (2007)
Programming in Visual Basic (VB) by Olga Maria Stefania Cucaro (2021)
Design Patterns and Object-Oriented Programming in Visual Basic 6 and [Link] by Cooper
J.W. (2018)
Gaddis, T. (2018). Starting Out with Visual Basic. Pearson. (Chapter 9: Shapes, Lines, and
Common Dialog Boxes)

+960 7226650 | fsit@[Link]

Perry, G. (2019). Visual Basic in easy steps: Covers Visual Basic 2019. In Easy Steps Limited.
(Chapter 6: Forms and Controls)
Coronel, C., Morris, S., & Rob, P. (2018). Database Systems: Design, Implementation, and
Management. Cengage Learning.
Foxall, J. (2019). Visual Basic 2019 in 24 Hours, Sams Teach Yourself. Sams Publishing.
Kiong, L. V. (2019). Visual Basic 2019 Made Easy. CreateSpace Independent Publishing
Platform.
Mansfield, R. (1998). Visual Basic 6.0: A Beginner's Guide. McGraw-Hill.
Petroutsos, E. (1998). Mastering Visual Basic 6. Sybex.
Aitken, P. G. (1998). Visual Basic 6 Programming Blue Book: The Most Complete, Hands-On
Resource for Writing Programs with Visual Basic 6. Coriolis Group Books.
Farrell, J. (2011). Programming Logic and Design, Comprehensive (7th ed.). Cengage
Learning.
McMillan, M. (2006). Absolute Beginner's Guide to VBA (2nd ed.). Pearson Education.
Petroutsos, E. (2002). Mastering Visual [Link] Database Programming. Sybex.

+960 7226650 | fsit@[Link]