Exam 13: Access Databases and Linq

If a table object's control type is changed from DataGridView to ____________________, the computer automatically provides the appropriate controls when you drag the table object to the form.

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

The ____ object stores the information you want to access from the database.

In most cases, you will use the ____ object to save changes to the database, because it can handle saving data to multiple tables in the DataSet .

The most commonly used aggregate operators are Average , Count , Max , Min , and Sum .

The way Visual Basic saves changes to a local database file is determined by the file's _________________________ property.

The AutoSizeColumnsMode property has ____ different settings that control the way the column widths are sized in the DataGridView control.

Connecting an object to a control is called ____.

What are the advantages of storing data in a relational database?

Each record in a table contains ____ fields.

One restriction of a relational database is that it may contain only one table.

Describe the default action taken by Visual Basic if you do not take specific steps in your code to handle exceptions.

A ____ specifies the fields and records to retrieve from the database, as well as the order in which to arrange the fields and records.

Describe two ways to bind an object in a dataset to an existing control on the form.

A _________________________ control displays the table data in a row-and-column format, similar to a spreadsheet.

Databases created using Microsoft Access are ____ databases.

You can create a query in Visual Basic using a language feature called ____.

A dataset is stored in the computer's ____ memory.

How does one have the computer create a bound control?