Exam 14: Access Databases and SQL

Which of the following sorts the records for the PartsDataSet by the Price field?

When you don't know the specific value to include in the criteria,you use a ____.

Which of the following locates the record whose PartNum field contains KL542,and then assigns the record to the row variable?

The following sample of code contains errors. Rewrite the incorrect statements to correct all errors. -' Delete a record from the dataset Dim row As TextData row = CustomerDataSet.tblCustomer.LookForCustID(3146) Delete() Try TblCustomerTableAdapter.Save(CustomerDataSet.tblCustomer) Catch ex As Exception MessageBox.Show(ex.Message,"Delete record", MessageBoxButtons.OK, MessageBoxIcon.Information) End Try

Case 1 - LuvUrPet The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather collar black 25.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 15.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar red 12.00 10 5787 solid collar blue 12.00 15 -What method could be used to invoke the previous query during run time?

The following sample of code contains errors. Rewrite the incorrect statements to correct all errors. -' Save dataset changes to a database Try TblTabletsBindingSource.Update(TabletsDataSet) Catch ex MessageBox.Show(ex.Message,"Tablet Data", MessageBoxButtons.OK, MessageBoxIcon.Information) End Catch

The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. -Write the statement to sort the records in alphabetic order by last name.

The statement SELECT YearWon,Title,ProductionCo FROM tblMovies WHERE YearWon >= 2006 selects all of the fields from records for the year 2006 and later.

The default order of the ORDER BY clause is descending.

Case 1 - LuvUrPet The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather collar black 25.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 15.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar red 12.00 10 5787 solid collar blue 12.00 15 -An application using the dataset should allow a user to type in a price to use to query the dataset.Which of the following clauses would allow a user to select the records for collars with a price of 15 or more?

Most of the time,you will know in advance the values to include in the criteria of a query.

Which of the following SELECT statements will select the ItemNum and ItemDesc fields from the tblItems table?

The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. -Write the statement to add a new record to the dataset.

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that allows the user to provide a specific MemberID.The query should select all fields.

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that allows the user to select the members with a fee greater than or equal to the fee amount provided by the user.The query should select the MemberID,LastName,FirstName,and Fee fields.

An Insert query uses the ____ statement to add a record to a database.

The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. -Three records were added to the ContractsDataSet.Write the statement to save the records in the Contracts database.

In order for an application to use a query during run time,you will need to save the query and then invoke it from code.

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that inserts the following record into the tblMembers table: MemberID - 25631 Name - Jane Doe Date Joined - 2012 Fee - 65 Membership Type - Adult

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that selects only the records for the Senior members.Select all of the fields.