Question 1

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

Accepted Answer

The answer of To combine criteria with ____________________, each criterion...

Question 2

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

Accepted Answer

The answer of ____________________ are symbols that represent any character...

Question 3

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?

Accepted Answer

The answer of Critical Thinking Questions 
Case 2-1 
PrattLast needs...

Question 4

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

Accepted Answer

The answer of A(n) ____________________ function is a function that...

Question 5

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

Accepted Answer

A)  compound conditions 
B)  comparison operators 
C)  compound values 
D)  conditions

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  STDEV 
B)  VAR 
C)  MAX 
D)  LOW

Question 9

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

Accepted Answer

A)  Expression Builder 
B)  Builder box 
C)  Build 
D)  Field Builder

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  curly braces { } 
B)  brackets [ ] 
C)  parentheses ( ) 
D)  slashes //

Question 12

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

Accepted Answer

The answer of To sort records by amount paid within...

Question 13

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

Accepted Answer

The answer of To include all fields for a table...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

A)  CREATE 
B)  DATABASE TOOLS 
C)  REPORT 
D)  FILE

Question 16

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.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Crosstab Wizard 
B)  Query Wizard 
C)  Statistics 
D)  Chart

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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.

Accepted Answer

A) True 
 B)False

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.

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.