Exam 12: Access_Module_2

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

Critical Thinking Questions Case 2-1 PrattLast needs to gather some additional statistics on its managers. A manager at PrattLast has created an initial query that calculates the accounts located in specific cities. The manager is unsure what aggregate functions to use for additional calculations. -Which aggregate function will find the customer with the largest amount paid?

Case 2-2 PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -The caption for the Start Date field should be Started when the query results display. How can PrattLast change the caption?

For group calculations, Microsoft Access supports ____ built-in statistics.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

A(n) ____________________ query is a query that prompts for input whenever it is used.

____________________ are symbols that represent any character or combination of characters.

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 sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

To order the records in the answer to a query in a particular way, you ____ the records.

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.

You can export data from Access to the standard Word format.

To include the Total row in the design grid, click the ____ button on the DESIGN tab.

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

The asterisk (*) wildcard represents any collection of characters.

To show the Navigation Pane if it is hidden, click the ____ Button.

The question mark (?) wildcard represents any collection of characters.

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

Crosstab queries are useful for summarizing data by category or group.

To re-use saved export steps, click the Saved Exports button on the ____ tab on the ribbon.