Exam 12: Access Databases and Linq

In a two-table database, one of the tables is referred to as the parent table and the other is referred to as the ____________________ table.

What two methods are used in conjunction with previewing the contents of a dataset and explain their use?

How does one have the computer create a bound control?

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

Name five aggregate methods LINQ provides when querying a dataset.

What buttons are contained on a BindingNavigator control and what additional items can you include on a BindingNavigator control?

A group of related records is called a ____.

In order to access the data stored in a database, an application needs to be connected to the database.

You may only bind an object to a control that the computer creates for you.

The _________________________ Wizard lists a connection to the database file in the Server Explorer window and adds a dataset's name to the Data Sources window.

Describe how table data is displayed using the DataGridView control.

The copy of the data that is accessed by the application is referred to as a(n) _____.

A(n) ____ operator returns a single value from a group of values.

The BindingSource object stores the position of the record pointer in its ____________________ property.

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

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 electronic file that contains an organized collection of related information.

Databases created using Microsoft Access are ____ databases.

The ____ object connects the database to the DataSet object.

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

Why is the DataGridView control one of the most popular controls for displaying table data?