Question 1

You can use a(n) ____ to specify both the records to select in a dataset and the order in which to arrange the records.

Accepted Answer

A)  condition 
B)  parameter 
C)  query 
D)  aggregate operator

Question 2

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?

Accepted Answer

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

Question 3

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

Accepted Answer

A)  AddNewItem 
B)  Properties 
C)  Insert Standard Items 
D)  Edit Items

Question 4

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?

Accepted Answer

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()

Question 5

When you drag an object from a dataset to an empty area on the form, the computer creates a control and automatically binds the object to it.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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 11

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.

Accepted Answer

A)  table 
B)  record 
C)  dataset 
D)  field

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

What is the DataGridView control and how is it used?

Accepted Answer

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

Question 14

The BindingSource object's ____ methods move the record pointer to the first, last, next, or previous record in the dataset.

Accepted Answer

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

Question 15

The field used to link a child table to a parent table is known as the ____ in the child table.

Accepted Answer

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

Question 16

Databases created using Microsoft Access are relational databases.

Accepted Answer

A) True 
 B)False

Question 17

Connecting an object to a control is called ____.

Accepted Answer

A)  linking 
B)  Order By clause 
C)  LINQ 
D)  binding

Question 18

A(n) ____ is an electronic file that contains an organized collection of related information.

Accepted Answer

A)  field 
B)  computer database 
C)  dataset 
D)  exception

Question 19

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

Accepted Answer

A)  bound controls 
B)  navigator controls 
C)  tables 
D)  fields

Question 20

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

Exam 13: Working With Access Databases and Linq

You can use a(n) ____ to specify both the records to select in a dataset and the order in which to arrange the records.

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

When you drag an object from a dataset to an empty area on the form, the computer creates a control and automatically binds the object to it.

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.

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

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

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.

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

What is the DataGridView control and how is it used?

The BindingSource object's ____ methods move the record pointer to the first, last, next, or previous record in the dataset.

The field used to link a child table to a parent table is known as the ____ in the child table.

Databases created using Microsoft Access are relational databases.

Connecting an object to a control is called ____.

A(n) ____ is an electronic file that contains an organized collection of related information.

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

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