Mid term 2 review
1.
The records in a __sequential____ access file must be
stored and retrieved in consecutive order.
2.
A single item of information about a person, place, or thing is called
a(n) _field____.
3.
The records in a ___random____ access file can be stored
and retrieved in any order.
4.
A data file is organized into fields and __records____.
5.
_Randoms___ access files are used for on-line activities,
such as making airline reservations.
6.
Each record in a random access file has a unique _record number__
that indicates the record's position in the file.
7.
Random access files are also referred to as __direct_____
access files because a record can be accessed, by its record number.
8.
A __record____ is a group of related fields that contain
all of the necessary data about a person, place, or thing.
9.
When displayed in a text editor, fields in a sequential access file are
separated by a(n) ___comma____.
10.
In a _sequential_____ access file, the number of characters
contained in a field usually varies from record to record.
11.
Visual Basic appends a _carriage return_ to the end of each
record in a sequential access file.
12.
Records in a sequential access file are referred to as _variable
length__ records.
13.
Quotation marks appear around string data in a _sequential
__access file when the file is displayed in a text editor.
14.
When viewing a data file in a text editor, each record in a sequential___
access file appears on a separate line.
15.
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___
(spaces).
16.
Numeric fields in a random access file are stored in a compressed format
called ___binary___.
17.
You use Visual Basic's __Type_____ statement to define a
record structure.
18.
The variables contained in a record variable are called ___field__
variables.
19.
You separate a record variable's name from a
field variable's name with a(n) Period.
20.
The Visual Basic statement Dim StudentRec as StudentStruc, declares a
variable named _StudentRec as __
StudentStruc
type..
21.
You use the Type statement in a _code module_____ to define
a record structure for item records.
22.
A __code module____ is a separate file, added to your
application, that contains no form and no controls--only code.
23.
The _Type___ statement for a random access defines the
record structure for the item records.
24.
You can use Visual Basic's __Open____ statement to either
create a new random access file or open an existing random access file.
25.
Opening a file for Random allows you to both read and ___write___
to the file.
26.
You can use Visual Basic's __Len___ function to calculate
the length of a record.
27.
The mode used to open random access files is always __Random________.
28.
You can use Visual Basic's _Put__ statement to write a
record to a random access file.
29.
You can use Visual Basic's _Close_____ statement to close a
random access file.
30.
You initialize a random access file by writing spaces to the string
fields and a(n) __0___ to the numeric fields.
31.
You can use Visual Basic's _Space____ function to
initialize a field variable that was declared as a string.
32.
You can use Visual Basic's ___Get____ statement to read a
record from a random access file.
33.
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.
34.
A __relational_ database stores information in tables,
which are composed of columns and rows.
35.
What does ADO stand for? ActiveX Data
Objects
36.
What does SQL stand for? Structured Query
language
B.
Page 601 – 603 #1
– 14
C.
One hand on problem that connect the VB to Access using ADO control.