Comparison of Features Used in Programs
In Visual Basic variables are declared using Dim and then the name of
the variable, which could be anything of your choice. Dim is short for
DIMENSION. A Dim statement tells the computer to set up a place in the
memory with the right dimensions to store a piece of data that has a
certain data type. For example:
Dim k As Integer
Dim k As Integer sets up a place (location in memory) with the name k
and enough space to hold a whole number. “k” is a variable because the
values that this location have can vary. As well as setting up the
right size of space for a variable, a Dim statement sets up all the
...view middle of the document...
most high-level languages, real indicates that floating-point
representation is to be used when the number is stored or manipulated.
This implies that the number may contain a fractional part and that it
is processed to a limited number of significant figures.
This is used the same way in nearly all languages and doesn’t need to
be declared like an integer.
Character: These are also used the same way in nearly all the
languages and are set of symbols that may be represented by a computer
at a particular time. These symbols are called characters and can be
letters, digits, spaces, and punctuation marks and include
non-printing, control characters.
Boolean: can only have one of two values, true or false. This makes it
easy to use the values of Boolean variables to control the flow of the
Pointers: is the address or reference of a data element, which allows
it to be retrieved without further searching. Pointers allow fast
access to data because little searching is required. When used on the
data stored in the computer’s memory the pointer is usually the
address of the data in the memory. However in a database system the
pointer may be the primary key or the reference number of the related
These are basically used to point towards a particular place, for
Set rng= AciveSheet.Rows (1)
This basically point towards the first row of the active sheet.
Data Structures: is a group of related data items organised in a
computer. A data structure allows a large number of pieces of data to
be managed as a single set. Each type of data structure makes it easy
for the programmer to find and process the data in particular ways.
Each type of structure has its own strengths and weaknesses. Examples
of data structures are arrays, lists, tables, trees, strings and