FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Access 2 Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

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

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 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 include all fields for a table in the design grid, double-click the ____________________ in the field list.

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

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

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

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.

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

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.

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

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

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

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

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

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

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?