Exam 14: Access Databases and Sql

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?

The ____ clause is used to arrange the records in either ascending (the default) or descending order by one or more fields.

The tblTruck table has two text fields named Make and Model, and one numeric field named Year. Which of the following statements adds the record 2013 Ford F150 to the table?

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

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. You must first ____ to begin creating a SQL query.

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

Contracts The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. Write the statement to find the record of a contract with the last name Green and assign the record to a row variable that you declare. Then write the statement to delete that record from the database.

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 members having a last name that begins with the letter J.

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 provide a specific MemberID. The query should select all fields.

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

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. Which of the following is not true regarding the Query Builder?

You use the ____ clause, which contains a condition, to limit the records you want to view.

The wildcard character is the ____.

You use the REMOVE statement to delete records.

The default order of the ORDER BY clause is descending.

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

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

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

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