Sequence Check - Answers The control number flows sequentially and any sequence or duplicated
control numbers are rejected or noted on an exception report. For example, invoices are numbered
sequentially. The day's invoices begin with 12001 and end with 15045. If any invoice larger than
15045 is encountered during processing, the invoice is rejected as an invalid invoice number.
Limit check - Answers Data should not exceed a predetermined amount. For example, payroll checks
should not exceed $4,000. If a check exceeds this amount, the data would be rejected for further
verification.
Range check - Answers Data should be within a predetermined range of values. For example, product
type codes range from 100 to 250. Any code outside this range should be rejected as an invalid
product type.
Validity check - Answers Programmed checking of the data validity in accordance with predetermined
criteria. For example, a payroll record contains a field for marital status and the acceptable status
codes are M or S. If any other code is entered, it should be rejected.
Reasonableness check - Answers Input data are matched to predetermined reasonable limits or
occurrence rates. For example, a widget manufacturer usually receives orders for no more than 20
widgets. If an order for more than 20 widgets is received, the program should output a warning.
Table lookups - Answers Input data comply with predetermined criteria maintained in a
computerized table of possible values. For example, the input clerk enters a city code of 1 to 10. This
number corresponds with a computerized table that matches to a city name.
Existence check - Answers Data are entered correctly and agree with valid predetermined criteria. For
example, a valid transaction code must be entered in the transaction code field.
Key verification - Answers The keying process is repeated by a separate individual using a machine
that compares the original keystrokes to the repeated keystrokes. For example, the worker number is
keyed twice and compared to verify the keying process.
Check digit - Answers A numeric value that has been calculated mathematically is added to data to
ensure that the original data have not been altered or incorrect.
Completeness check - Answers A field should always contain data rather than zeros or blanks. A
check of each byte of that field should be performed to determine that some form of data, not blanks
or zeros, is present. For example, a worker number on a new employee record is left blank. This is a
key field, and the request would be rejected if left blank.
Duplicate check - Answers New transactions are matched to those previously input to ensure that
they have not already been entered. For example, not paying a vendor invoice twice.
Logical relationship check - Answers If a particular condition is true, then one or more additional
conditions or data input relationships may be required to be true and consider the input valid. For
example, the hire date of an employee may be required to be more than 16 years past his date of
birth.
< or > - Answers Strictly less than or greater than
<= or >= - Answers less/greater than or equal
= - Answers equal
<> - Answers not equal
Is - Answers Compares two object reference variables
& - Answers concatenate
Logical AND - Answers All conditions are true
Logical OR - Answers At least one condition is true
Logical XOR - Answers One and only one condition is true
Logical NOT - Answers Condition is not true
Logical BETWEEN - Answers Upper and lower range, be careful to ensure the upper and lower limit
are included if you want them to be
Object - Answers Programming constructs that encapsulate data, behavior, and identity. Object data
is contained in the fields, properties, and events of the object, and object behaviors are defined by
the methods and interfaces of the object.
A combination of code and data that can be treated as a unit. An object can be a piece of an
application, like a control or a form. An entire app can be an object.
, Classes are cookie cutters, objects are cookies.
Objects have identity — two objects with the same set of data are not necessarily the same object.
(e.g. two blank worksheets)
Objects are categorized into classes (definition forthcoming)
Each individual object is an instance of a class
Example - an individual employee
Encapsulation - Answers The characteristic of object-orientation in which data and behavior are
bundled into a class and hidden from the outside world.
Sometimes referred to as data hiding, it is the technique of making the fields in a class private (so that
the data can only be seen by the class that owns it).
Access to the data and behavior (methods) is provided and controlled through an objects interface.
This prevents the code and data being randomly accessed by other code defined outside the class.
Class - Answers Each individual object in VB is defined by a class. A class describes the variables,
properties, procedures, and events of an object. Objects are instances of classes; you can create as
many objects you need once you have defined a class.
Classes are cookie cutters, objects are cookies.
A class is a group of objects that share the same attributes, operations, relationships, and semantics.
Objects of different data types do not belong to the same class.
You can think of a class as an object oriented template. A class defines the data and behavior.
Programmers use a class as a template to create objects. The objects are instances of this class and
inherit the class data and behaviors.
Example - employee class made up of individual employee objects
Instantiation - Answers The process of creating an instance of an object.
Dim variablename As [New] { objectclass | object}
Load a form = instantiate a form, then you instantiate controls
Collection - Answers A collection is a group of items with the same characteristics, often a group of
objects of the same class.
Using a collection provides a convenient way to refer to a group of objects and collections as a single
object.
Example of iterative processing w/ collection:
For Each cControl In Me.Controls
If TypeName(cControl) = "TextBox" Then
boxnum = Mid(cControl.Name, 8, 1)
MsgBox(boxnum)
Checkit_Numeric(cControl.Text, myflag, boxnum)
End If
Next cControl
Attribute - Answers An attribute is a quality or characteristic ascribed to or considered to belong to,
or be inherent in, a person or thing. For example, a flowers properties could include rose, pink, sweet,
etc.
Property - Answers A property is an attribute to which you assign a value. A flower's attributes could
include species, color, smell, etc.
Operation - Answers A behavior of an object. Operations are implemented in classes via methods.
Methods are identified and invoked by their signatures, including name, parameters, and return type.