Exam 14: Access Databases and SQL

Click ____ on the shortcut menu to start the TableAdapter Query Configuration Wizard.

A ____ is a query that uses the parameter marker in place of the criteria's value.

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

You save a query that contains the SELECT statement by associating the query with one or more methods.

Because it is possible for an error to occur when saving data to a database,it's a good programming practice to place the Update method within the ____ block of a Try…Catch statement.

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.

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

What is a parameter query and how is it used?

____ is a set of statements that allows you to access and manipulate the data stored in many database management systems on computers of all sizes,from large mainframes to small microcomputers.

Which of the following statements selects the Title and ProductionCo fields from records whose title begins with the word "The" followed by a space and zero or more characters,and then sorts the records in descending order by the ProductionCo field?

Write a SQL SELECT statement that selects the MemberID,LastName,JoinDate,and MemberType fields from all of the records.

Write a SQL SELECT statement that selects only the records for the Senior members.Select all of the fields.

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.

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

You can use the ____ associated with a query to invoke the query during run time.

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

The syntax to add a record to a dataset is ____.

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

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

The file that contains information about the tables,fields,records,and properties included in the dataset has an ____ extension.