Exam 13: Working With Access Databases and Linq

Write the code to calculate the average price of all of the bicycles in inventory.

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

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

A relational database can contain one or more tables.

Which of the following statements will calculate a total for all of the unpaid invoices?

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.

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

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

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

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

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

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

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

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

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

What is the DataGridView control and how is it used?

Write a LINQ statement to calculate the total value of the inventory.

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

A ____ is a single item of information about a person,place,or thing-such as a name,a salary amount,a Social Security number,or a price.

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.