Exam 13: Working With Access Databases and Linq

A group of related records is called a ____.

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

When an application is running, you can use the ____ control to move from one record to the next in the dataset, as well as to add or delete a record and save any changes made to 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 a LINQ statement to calculate the total value of the inventory.

The ____ property (of the DataGridView) allows you to format a column's data, as well as change the column's width and alignment.

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

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

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 are responsible for connecting the Access database that contains the tblCustomer table to an application. You must first use the Data Source Configuration Wizard to ____.

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

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

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

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)

When you drag an object from the Data Sources window to an existing control, the computer does not create a new control; rather, it merely binds the object to the existing control.

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

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

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

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

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. To create a DataGridView control on the form, you would click on the ____ object in the Data Sources window and drag it to the form.