Question 1

What are the advantages to storing data in a relational database?

Accepted Answer

The answer of What are the advantages to storing data...

Question 2

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 records.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 3

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.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 4

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 code to calculate the average price of all of the bicycles in inventory.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 5

Write the code needed to include a Try...Catch statement that will handle an error that might occur while saving in an application. Use the following statements in the Try block, along with a message for the user of the Student Data Application that notifies the user the changes have been saved. Provide an error message if an exception occurs. 
Me.Validate() 
Me.TblStudentBindingSource.EndEdit() 
Me.TableAdapterManager.UpdateAll(Me.StudentsDataSet)

Accepted Answer

The answer of Write the code needed to include a...

Question 6

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?
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

Accepted Answer

To ensure the user can add records but cannot delete any records, it is only necessary to remove the Delete button from the TblCustomerBindingNavigator control. This will prevent the user from accidentally or intentionally deleting any records, while still allowing them to add new records and save any changes made to existing records. Removing the Add new button or Save button is not necessary to achieve this goal.

Question 7

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

Accepted Answer

The answer of Write the statements to move the record...

Question 8

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.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 9

What is the DataGridView control and how is it used?

Accepted Answer

The answer of What is the DataGridView control and how...

Question 10

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

Accepted Answer

The answer of Write the statements to move the record...

Question 11

Problems - Correcting Logic and Code Errors 
The following sample of code contains errors. Rewrite the incorrect statements to correct all errors. 
Private Sub TblItemsBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblItemsBindingNavigatorSaveItem.Click 
Try 
Validate() 
Me.TblItemsBindingSource 
Me.TableAdapterManager.UpdateAll(Me.ItemsDataSet) 
MessageBox.Show("Changes saved", "Books Galore", 
MessageBoxButtons.OK, 
MessageBoxIcon.Information) 
Catch ex 
MessageBox.Show(ex.Message, "Books Galore", 
MessageBoxButtons.OK, 
MessageBoxIcon.Information) 
End 
End Sub

Accepted Answer

The answer of Problems - Correcting Logic and Code Errors...

Question 12

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

Accepted Answer

The answer of Relational databases contain multiple tables that relate...

Question 13

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.
 Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?
A) Dim records = From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order By invoice.CustomerNum
Select customer
B) Dim records = From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order invoice.CustomerNum Ascending
Select customer
C) Dim records = From CustomerDataSet.tblCustomer
Where customer.InvoiceAmt > 200
Order invoice.CustomerNum
Select customer
D) Dim records = From customer In CustomerDataSet.tblCustomer
Where customer.InvoiceAmt
Order By invoice.CustomerNum
Select customer

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 1 -...

Question 14

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 bicycles with a price greater than $450. Arrange the bicycles in descending order by price.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 15

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

Accepted Answer

The answer of List the five objects that are placed...

Question 16

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.
 Which of the following statements will calculate a total for all of the unpaid invoices?
A) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer
Select customer.InvoicePaid Into Sum()
B) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer
Select customer.InvoiceAmt Into Sum()
C) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer
Where customer.InvoicePaid.ToUpper = "N"
Select customer.InvoiceAmt Into Average()
D) Dim decTotalUnpaid = Aggregate customer In CustomerDataSet.tblCustomer
Where customer.InvoicePaid.ToUpper = "N"
Select customer.InvoiceAmt Into Sum()

Accepted Answer

Option D includes a filter to only select invoices where the InvoicePaid field is equal to "N". Then it selects the InvoiceAmt field to sum up all the unpaid invoices.

Question 17

Define the terms "record," "field," and "table." Provide examples of each term when you are defining them.

Accepted Answer

The answer of Define the terms "record," "field," and "table."...

Question 18

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 calculate the total value of the inventory.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Question 19

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

Accepted Answer

The answer of Private Sub btnNext_Click(ByVal sender As Object, ByVal...

Question 20

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.

Accepted Answer

The answer of Writing LINQ Statements 
The tblBicycle table contains...

Quiz 13: Working With Access Databases and Linq

What are the advantages to storing data in a relational database?

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 records.

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

What is the DataGridView control and how is it used?

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

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

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

Define the terms "record," "field," and "table." Provide examples of each term when you are defining them.

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 calculate the total value of the inventory.