Question 1

The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.

Accepted Answer

A)   TableAdapter
B)   TblEmployBindingSource
C)   BindingSource
D)   DataGridView

Question 2

Write a LINQ statement to select the records in descending order by the Quantity field.

Accepted Answer

The answer of Write a LINQ statement to select the...

Question 3

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 Write a LINQ statement to select all...

Question 4

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

To actually view the records that result from a query,you need to assign the variable's contents to the DataSource property of a BindingSource object.

Question 5

Databases created using Microsoft Access are relational databases.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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?

Accepted Answer

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

Question 8

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

Accepted Answer

C

Question 9

A BindingNavigator control displays table data in a row and column format,similar to a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 10

The BindingSource object stores the position of the record pointer in its ____ property.

Accepted Answer

A)   View
B)   Position
C)   Navigation
D)   Cell

Question 11

In most tables,one of the fields uniquely identifies each record and is called the ____.

Accepted Answer

A)   exception
B)   foreign key
C)   primary key
D)   cell

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A)   TableAdapter
B)   DataGridView
C)   BindingSource
D)   BindingNavigator

Question 14

A group of related records is called a ____.

Accepted Answer

A)   table
B)   field
C)   datagrid
D)   primary key

Question 15

A ____ is a copy of the data (database fields and records) that can be accessed by an application.

Accepted Answer

A)   position property
B)   child table
C)   dataset
D)   bound control

Question 16

If a user is not allowed to add a record,you should deselect the ____ check box within the task list for the DataGridView control.

Accepted Answer

A)   Enable Adding
B)   Enable Deleting
C)   Edit Items
D)   BindingNavigatorAddNewItem

Question 17

Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

Accepted Answer

A

Question 18

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

Accepted Answer

A)   BindingNavigator
B)   Position
C)   BindingSource
D)   Copy to Output Directory

Question 19

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

Accepted Answer

A)   TableAdapter
B)   TblEmployBindingSource
C)   BindingSource
D)   DataGridView

Question 20

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

Exam 13: Working With Access Databases and Linq

The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.

Correct AnswerverifiedShow Answer

Write a LINQ statement to select the records in descending order by the Quantity field.

Correct AnswerverifiedShow Answer

Write a LINQ statement to select all bicycles with a price greater than $450.Arrange the bicycles in descending order by price.

Correct AnswerverifiedShow Answer

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.

Correct Answerverified11ea7cc1_5d5e_af35_928c_21d7f1530440_TB6958_00 To actually view the records that result from a query,you need to assign the variable's contents to the DataSource property of a BindingSource object.

Databases created using Microsoft Access are relational databases.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

A BindingNavigator control displays table data in a row and column format,similar to a spreadsheet.

Correct AnswerverifiedShow Answer

The BindingSource object stores the position of the record pointer in its ____ property.

Correct AnswerverifiedShow Answer

In most tables,one of the fields uniquely identifies each record and is called the ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A group of related records is called a ____.

Correct AnswerverifiedShow Answer

A ____ is a copy of the data (database fields and records) that can be accessed by an application.

Correct AnswerverifiedShow Answer

If a user is not allowed to add a record,you should deselect the ____ check box within the task list for the DataGridView control.

Correct AnswerverifiedShow Answer

Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

Correct AnswerverifiedA

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
11ea7cc1_5d5e_af35_928c_21d7f1530440_TB6958_00 To actually view the records that result from a query,you need to assign the variable's contents to the DataSource property of a BindingSource object.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified