Exam 7: Access_Module_2

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.

In ____________________ files, the width of any field is the same on every record.

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 standard deviation?

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?

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

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query.

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.

When you sort data in a query, the records in the underlying table are actually rearranged.

To indicate grouping in Access, select ____ as the entry in the Total row for the field to be used for grouping.

To sort records by amount paid within book rep number, specify Book Rep Number as the ____________________ key.

Case 2-2 ​ PrattLast Associates needs to find the account managers whose start date is earlier than 1/1/2015. -What criteria should PrattLast enter in the Start Date column of the design grid?

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

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

The results of a query display in ____________________ view.

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

When you enter text data in a criterion, you must enclose the text in quotation marks.

To create a crosstab, click the ____ button on the CREATE tab.

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

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 change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.