Exam 13: Working With Access Databases and Linq

The BindingSource object's ____ methods move the record pointer to the first,last,next,or previous record in the dataset.

The controls connected to an object in a dataset are known as ____.

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

Each column in a table represents a record and each row represents a field.

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

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

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 a LINQ statement to select all blue bicycles.Order the bicycles in ascending order by quantity.

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.

A label,text box,or button can be added to the BindingNavigator control by accessing the control's task box and clicking ____.

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

Write the statements to move the record pointer to the first and last records in the dataset for the Customer table.

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. InvoiceNum CustomerNum InvoiceDate InvoiceAmt InvoicePaid 631 13020 01/15/2013 200.00 632 15411 01/20/2013 685.00 633 10002 01/23/2013 75.00 634 13104 01/23/2013 150.00 635 12124 01/26/2013 75.00 636 13328 02/02/2013 350.00 637 10206 02/02/2013 175.00 638 10334 02/07/2013 450.00 -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?

A relational database can contain one or more tables.

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

The following sample of code contains errors. Rewrite the incorrect statements to correct all errors -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

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 a LINQ statement to select the records in descending order by the Quantity field.

An error that occurs while an application is running is called a(n)____.

A(n)____ stores information in tables composed of columns and rows,similar to the format used in a spreadsheet.

A group of related records is called a ____.

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