Exam 14: Access Databases and SQL

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

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

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?

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

The FillByMake method is associated with a parameter query.Which of the following statements invokes the method and passes the contents of the txtMake control's Text property?

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

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

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.

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.

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

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 deletes member 42315 from the tblMembers table.

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

The wildcard character is the ____.

The parameter marker is a(n)____.

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

You use the REMOVE statement to delete records.

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

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.

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

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