Deck 24: Im Suffering From Information Overload Access Databases

Question 1

In order to maintain accurate records, most businesses store information about their employees, customers, and inventory in Excel spreadsheets.

Answer 1

False

Question 2

In most applications, the code to fill a dataset with data belongs in the form's Fill event procedure.

Answer 2

False

Question 3

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.

Answer 3

False

Question 4

Parent and child tables in a database are referred to as master and detail tables, respectively.

Question 5

A(n) ____ is a single item of information about a person, place, or thing.

A) file
C) record
B) entity
D) field

Question 6

The easiest way to bind an object to a dataset is by dragging the object from the Data Sources window to the control.

Question 7

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

Question 8

You cannot bind an object in a dataset to an existing control on the form.

Question 9

When an exception occurs in the Catch block's code, the computer processes the code contained in the Try block.

Question 10

When a table or field object is dragged to a form, the computer adds the appropriate controls and objects to the application.

Question 11

A group of related records is called a ____.

A) relation
C) collection
B) table
D) related entity

Question 12

Connecting an object to a control is called ____.

A) attaching
C) binding
B) bonding
D) attachment

Question 13

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

Question 14

In most tables, one of the fields uniquely identifies each record and is called the ____.

A) primary key
C) indexed key
B) secondary key
D) key value

Question 15

If you do not take deliberate steps in your code to handle the exceptions, Visual Basic handles them for you.

Question 16

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

Question 17

A TableLayoutView control displays data in a row and columnar format, similar to a spreadsheet.

Question 18

In the Load event procedure, you enter code you want processed before the form appears on the screen.

Question 19

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

Question 20

The BindingSource object provides the connection between the DataSet and the bound controls on a form.

Question 21

The syntax for the bindingSource object's position property is ____.

A) bindingSourceName.Position
B) Position.bindingSourceName
C) bindingSourceName(Position)
D) Position(bindingSourceName)

Question 22

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

Question 23

The position of the record pointer is stored in the object's ____ property.

A) PlaceHolder
C) RecordPointer
B) RecordPosition
D) Position

Question 24

An error that occurs while an application is running is called a(n) ____.

A) bug
C) exception
B) runtime upset
D) inception

Question 25

A form's ____ event occurs when the application is started and the form is displayed the first time.

A) Show
C) Displayed
B) Load
D) OnScreen