Exam 13: Working With Access Databases and Linq

Write the statement needed to assign the contents of the records variable to the BindingSource object for the tblBicycle table.Explain why this should be done in an application.

Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

Which of the following statements selects all of the records in the tblStudents table?

A database file contained in a project is referred to as a logic database file.

You need to make sure the user of the application can add records but cannot delete any records.Which of the following needs to be performed?

Databases created using Microsoft Access are relational databases.

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

The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.

A ____ is a copy of the data (database fields and records)that can be accessed by an application.

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

If a user is not allowed to add a record,you should deselect the ____ check box within the task list for the DataGridView control.

A group of related records is called a ____.

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

Write a LINQ statement to select the records in descending order by the Quantity field.

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

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

Write the statements to move the record pointer to the previous and next records in the dataset for the Vehicle table.

Write a LINQ statement to select all bicycles with a price greater than $450.Arrange the bicycles in descending order by price.

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

The ____ object can be used to save to the database any changes made to the data contained in the DataSet.