Exam 12: Access Databases and Linq

You can use Visual Basic to access the data stored in databases by using a database management system.

A ____ is a group of related fields that contain all of the necessary data about a specific person, place, or thing.

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.

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

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

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

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -An intersection of a row and column in a DataGridView.

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

What is a relational database?

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -Database field(s) that uniquely identifies each record.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A product for creating computer databases.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A database that stores information in tables composed of columns and rows.

Controls in an interface that is connected to objects in the dataset are called ____ controls.

Exception handling in your code takes the form of the ____ statement.

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

Before an application can access the data stored in a database, you need to connect the application to the database using ____.

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

Connecting an object to a control is called ____.

When an application is running, you can use the ____ control to move from one record to the next in the dataset, as well as to add or delete a record and save any changes made to the dataset.

Each record in a table contains ____ fields.