Exam 3: Querying a Database

In the accompanying figure, you can delete the table by right-clicking the field list and clicking ____ on the shortcut menu.

Critical Thinking Questions Case 2-2 Business analysts at Camashaly would like to be able to calculate the total of their Salary YTD and their Incentive YTD. Assume that the result should be stored in a field called Total Compensation. What is the formula to calculate total compensation?

If you specify more than one sort key, the sort key on the left will be the minor sort key and the one on the right will be the major sort key.

To combine criteria with ____________________, the criteria must go on separate lines in the Criteria area of the grid.

The question mark (?) wildcard represents any individual character.

To sort records by amount paid within business analyst number, specify Business Analyst Number as the ____________________ key.

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

To create a top-values query, use the Top Values box on the Design tab to change the number of records to be included from All to the desired number.

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

To export data from a query to Excel, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Excel button.

The results of a query display in ____________________ view.

The accompanying figure shows a join of the Business Analyst and Client tables. ____________________ properties are the properties that indicate which records appear in a join.

Explain the difference between an inner join and an outer join.

To find all clients whose amount paid is less than $2,000.00, use the ____________________ operator.

To find all clients whose amount paid is greater than $1,000.00 and whose business analyst is analyst 11, enter each criterion on different lines.

Critical Thinking Questions Case 2-1 Camashaly needs to gather some additional statistics on its clients. An employee at Camashaly has created an initial query as shown in the accompanying figure that calculates the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. Which aggregate function will count the number of records?

The asterisk (*) wildcard represents any individual character.