Exam 13: Working With Access Databases and Linq

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

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

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

Writing LINQ Statements The tblBicycle table contains five fields: ItemNum, ItemName, Color, Price, and Quantity. The Price and Quantity fields are numeric; all other fields are text. The dataset name is BicycleDataSet. 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 selects all of the records in the tblStudents table?

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

A relational database can contain one or more tables.

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

The ____ clause of LINQ is used to arrange the records in either ascending (the default) or descending order by one or more fields.

List the five objects that are placed in the component tray when a table object is bound to a DataGridView control.

Private Sub btnNext_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnNext.Click ' moves to the next record TblClientBindingSource.MovePrevious() End Sub Private Sub btnPrevious_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnPrevious.Click ' moves to the previous record TblClientBindingSource.MoveNext() End Sub Private Sub btnDisplay_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDisplay.Click ' displays all clients or ' specific clients for a certain state Const strPROMPT As String = "Enter one or more " & "letters. Leave blank to retrieve all records." Dim strSearch As String ' get user input strSearch = InputBox(strPROMPT, "Find State").ToUpper ' select the appropriate records Dim records = ClientDataSet.tblClient For client.State.ToUpper Like strSearch & "*" Select ' display the records TblClientBindingSource.DataSource = records End Sub

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

The ____ statement is used for exception handling in a procedure.

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

The intersection of a row and a column in a DataGridView control is called a ____.

The tblItems table contains a numeric field named Price. Which of the following statements finds the lowest price for an item and assigns the result to the dblLowPrice variable?

Relational databases contain multiple tables that relate to each other in some way. How are primary and foreign keys used in such a database?

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

The computer can retrieve data stored in a relational format both quickly and easily, but the data must be displayed in a specific order.

Case-Based Critical Thinking Questions Case 1 - MaidToOrder The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers. 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?