Exam 2: Access 2 Querying a Database

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

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

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?

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

Less than ( ), and NOT (not equal to) are examples of ____.

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

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

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

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

Unless you specify otherwise, Access assumes that the criteria you enter involve equality (exact matches).

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

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

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

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

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click ____ on the ribbon, and then click the Report Wizard button.

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.

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

Grouping means creating groups of records that share some common characteristic.

A property sheet is a window containing the various properties of the object.

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.