Exam 14: Access Databases and Sql

The parameter marker is a(n) ____.

The ____ provides an easy way of associating the query with one or more methods.

A Delete query uses the ____ statement to delete a record from a database.

One record is added to the AccountsDataSet. Which of the following statements will save the record in the Accounts database?

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

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

The Query Builder places the WHERE clause's condition in parentheses because the parentheses are required.

Problems - Correcting Logic and Code Errors 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

Members 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 the MemberID, LastName, and FirstName fields for all family members. Sort the records in descending order by the JoinDate field.

Members 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 all of the fields and records in the table. Sort the records in ascending order by the MemberType field.

Members 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

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

Which of the following SELECT statements will select the ProdNum field from the tblProducts table, and then sort the records in descending order by the Price field?

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

The tblStudent table contains nine fields, one of which is the StudentID field. A user can type in any StudentID to select a particular student. The user provides 124541 as the StudentID to select. Which of the following statements deletes the student record specified by the user?

Members 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 the MemberID, LastName, JoinDate, and MemberType fields from all of the records.

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

Case-Based Critical Thinking Questions 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. An application using the dataset allows the user to provide an ItemNum to select a record to delete from the dataset. Which function must also be used in the code for the Delete button on the form to work properly?

If you want the records in a dataset to appear in a particular order when the application is started, you enter the Sort method in the form's ____.

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