Mid term 2 review
The records in a __sequential____ access file must be
stored and retrieved in consecutive order.
A single item of information about a person, place, or thing is called
The records in a ___random____ access file can be stored
and retrieved in any order.
A data file is organized into fields and __records____.
_Randoms___ access files are used for on-line activities,
such as making airline reservations.
Each record in a random access file has a unique _record number__
that indicates the record's position in the file.
Random access files are also referred to as __direct_____
access files because a record can be accessed, by its record number.
A __record____ is a group of related fields that contain
all of the necessary data about a person, place, or thing.
When displayed in a text editor, fields in a sequential access file are
separated by a(n) ___comma____.
In a _sequential_____ access file, the number of characters
contained in a field usually varies from record to record.
Visual Basic appends a _carriage return_ to the end of each
record in a sequential access file.
Records in a sequential access file are referred to as _variable
Quotation marks appear around string data in a _sequential
__access file when the file is displayed in a text editor.
When viewing a data file in a text editor, each record in a sequential___
access file appears on a separate line.
If the data in a field in a random access file is shorter than the length
of the field, Visual Basic pads the unused space with __blank___
Numeric fields in a random access file are stored in a compressed format
You use Visual Basic's __Type_____ statement to define a
The variables contained in a record variable are called ___field__
You separate a record variable's name from a
field variable's name with a(n) Period.
The Visual Basic statement Dim StudentRec as StudentStruc, declares a
variable named _StudentRec as __
You use the Type statement in a _code module_____ to define
a record structure for item records.
A __code module____ is a separate file, added to your
application, that contains no form and no controls--only code.
The _Type___ statement for a random access defines the
record structure for the item records.
You can use Visual Basic's __Open____ statement to either
create a new random access file or open an existing random access file.
Opening a file for Random allows you to both read and ___write___
to the file.
You can use Visual Basic's __Len___ function to calculate
the length of a record.
The mode used to open random access files is always __Random________.
You can use Visual Basic's _Put__ statement to write a
record to a random access file.
You can use Visual Basic's _Close_____ statement to close a
random access file.
You initialize a random access file by writing spaces to the string
fields and a(n) __0___ to the numeric fields.
You can use Visual Basic's _Space____ function to
initialize a field variable that was declared as a string.
You can use Visual Basic's ___Get____ statement to read a
record from a random access file.
When a multiform project is run, Visual Basic automatically loads and
displays only one of the forms contained in the project.
That form is called the __Startup___ form.
A __relational_ database stores information in tables,
which are composed of columns and rows.
What does ADO stand for? ActiveX Data
What does SQL stand for? Structured Query
Page 601 – 603 #1
One hand on problem that connect the VB to Access using ADO control.