Chapter 24: I’m Suffering from Information Overload (Access Databases)
TRUE/FALSE
1. In order to maintain accurate records, most businesses store information about their employees,
customers, and inventory in Excel spreadsheets.
2. A relational database can contain one or more tables.
3. The field used to link a child table to a parent table is called the Foreign key.
4. Parent and child tables in a database are referred to as owner and detail tables, respectively.
5. You can display the data in a relational database in any order.
6. A Dataset is a copy of the data that can be accessed by an application.
7. A TableLayoutView control displays data in a row and columnar format, similar to a spreadsheet.
8. The BindingNavigator control can only be used to add, delete, and save records.
9. The BindingSource object provides the connection between the DataSet and the bound controls on a
form.
10. The intersection of a row and column in a DataGridView control is called a cell.
11. In most applications, the code to fill a dataset with data belongs in the form’s Fill event procedure.
12. If you do not take deliberate steps in your code to handle the exceptions, Visual Basic handles them for
you.
13. When an exception occurs in the Catch block’s code, the computer processes the code contained in the
Try block.
14. When the Copy to Output Directory property is set to its default setting, Copy always, the file is
copied from the project folder to the project folder’s bin\Project folder each time you start the
application.
15. You cannot bind an object in a dataset to an existing control on the form.
MULTIPLE CHOICE
1. A ____ is an electronic file that contains an organized collection of related information.
a.
computer list
c.
computer record
b.
computer database
d.
computer sheet
2. A ____ stores information in tables composed of columns and rows, similar to the format used in a
spreadsheet.
a.
relational database
c.
relational base
b.
relational computer
d.
relational data
3. A(n) ____ is a single item of information about a person, place, or thing.
a.
file
c.
record
b.
entity
d.
field
4. A(n) ____ is a group of related fields that contain all of the necessary data about a specific person,
place, or thing.
a.
file
c.
record
b.
entity
d.
field
5. A group of related records is called a ____.
a.
relation
c.
collection
b.
table
d.
related entity
6. In most tables, one of the fields that uniquely identifies each record and is called the ____.
a.
primary key
c.
indexed key
b.
secondary key
d.
key value
7. Connecting an object to a control is called ____.
a.
attaching
c.
binding
b.
bonding
d.
attachment
8. The ____ stores objects that do not appear in the user interface while an application is running.
a.
component tray
c.
menu tray
b.
task list
d.
object tray
9. The ____ property determine the way the column widths are sized in the DataGridView control.
a.
AutoSizeColumns
c.
AutoSizeColumnsMode
b.
AutoResizeMode
d.
AutoResizeColumns
10. A form’s ____ event procedure uses the TableAdapter object’s Fill method to retrieve the data from
the database and store it in the DataSet object.
a.
Show
c.
Displayed
b.
Load
d.
OnScreen
11. An error that occurs while an application is running is called a(n) ____.
a.
bug
c.
exception
b.
runtime upset
d.
inception
12. You can use the ____ statement to handle exceptions that occur while an application is running.
a.
Error…Catch
c.
Error…Block
b.
Try…Catch
d.
Try…Block
13. The way Visual Basic saves changes to a local database file is determined by the file’s ____ property.
a.
Output Section
c.
Output Directory
b.
Copy to Production
d.
Copy to Output Directory
14. The BindingSource object stores the position of the record pointer in the object’s ____ property.
a.
PlaceHolder
c.
RecordPointer
b.
RecordPosition
d.
Position
15. You can use the BindingSource object’s ____ methods to move the record pointer to the first, last,
next, or previous record in the dataset.
a.
Move
c.
MoveRecord
b.
Point
d.
Pointer
