FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Working With Access Databases and Linq

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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

A) ASP
B) SQL
C) Java
D) Language-Integrated Query

E) C) and D)
F) A) and B)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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. $\begin{array} { | l | l | l | l | l | } \hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \\\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \\\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \\\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \\\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \\\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \\\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \\\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \\\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \\\hline\end{array}$ -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) Remove the Add new button from the TblCustomerBindingNavigator control.
B) Remove the Delete button from the TblCustomerBindingNavigator control.
C) Remove the Save button from the TblCustomerBindingNavigator control.
D) b and c

E) All of the above
F) None of the above

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

A group of related records is called a ____.

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.

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

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

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.

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.

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

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

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

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

The BindingSource object's ____ methods move the record pointer to the first,last,next,or previous record 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

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

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

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

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

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

A relational database can contain one or more tables.