Exam 12: Access_Module_2

A summary function is a function that performs some mathematical function against a group of records. ____________________

A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________

The field or fields on which records are sorted is called the sort key.

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

To include all fields for a table in the design grid, double-click the ____________________ in the field list.

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

A(n) ____________________ function is a function that performs some mathematical function against a group of records.

You can include ____ in calculations to indicate which calculation should be done first.

The results of a query display in ____________________ view.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

When you sort data, duplicates are not included.

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

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

To save a query, click the Save button on the ____.

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

To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________

The only calculated fields you can create in Access are those involving addition and subtraction.

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

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