Question 1

Which query wizard helps you build a crosstab query?
A) Select Query Wizard
B) Crosstab Query Wizard
C) Simple Query Wizard
D) Find Aggregates Query Wizard

Accepted Answer

The Crosstab Query Wizard is specifically designed to build crosstab queries, which allow for data to be summarized and displayed in a grid format with rows and columns. The other query wizards do not have this functionality.

Question 2

A summary query calculates statistics about ____.
A) one record
B) groups of records
C) one field
D) groups of fields

Accepted Answer

A summary query calculates statistics about groups of records. It can calculate statistics such as sum, average, minimum, maximum, and count for groups of records based on a specific field or combination of fields.

Question 3

Which aggregate function is used to find the average of values in a field?
A) Avg
B) Average
C) Mean
D) Mode

Accepted Answer

The Avg function is used to find the average of values in a field. Both Average and Mean can also be used, but Avg is the most commonly used syntax in SQL. Mode is used to find the value that appears most frequently in a set of data, but it is not used to find the average.

Question 4

The ____ function returns the number of characters in a field.

Accepted Answer

The answer of The ____ function returns the number of...

Question 5

Which aggregate function would NOT work well on a Short Text field?
A) Sum
B) Min
C) Max
D) Count

Accepted Answer

Sum is an aggregate function that adds up numerical values. Short Text fields cannot be summed up as they contain strings of text rather than numerical values. Therefore, it would not work well on a Short Text field.

Question 6

When you create a summary query, which row is added to the query design grid?
A) Criteria
B) Table
C) Field
D) Total

Accepted Answer

When creating a summary query, the row that needs to be added to the query design grid is the Total row. This enables you to specify the type of summary information you want to retrieve from your data, such as counts, sums, averages, and other statistical information. Adding a Total row also enables you to group and sort your data based on one or more fields, which is useful when trying to identify trends or patterns in your data.

Question 7

Which arithmetic operator signifies exponentiation?
A) #
B) *
C) /
D) ^

Accepted Answer

The caret symbol (^) is used to signify exponentiation in arithmetic.

Question 8

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Accepted Answer

The answer of ____ queries summarize data in which one...

Question 9

Drag a(n) ____________________ handle to modify the shape, but not the size, of a drawing object.

Accepted Answer

The answer of Drag a(n) ____________________ handle to modify the...

Question 10

The ____ function returns a number of characters from the first part of a field.

Accepted Answer

The answer of The ____ function returns a number of...

Question 11

The data displayed in a query is sometimes called a(n) ____ view of the data.

Accepted Answer

The answer of The data displayed in a query is...

Question 12

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 13

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

Accepted Answer

The answer of Use the ____ check box in the...

Question 14

A(n) ____ query is used to calculate statistics about a group of records.

Accepted Answer

The answer of A(n) ____ query is used to calculate...

Question 15

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Accepted Answer

The answer of The Find ____ Query Wizard is used...

Question 16

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

Accepted Answer

The answer of Use the ____ Query Wizard to guide...

Question 17

The wildcard character that represents one character in query criteria is the ____.
A) asterisk (*)
B) exclamation point (!)
C) tilde (˜)
D) question mark (?)

Accepted Answer

The question mark represents a single character in query criteria.

Question 18

Which aggregate function is used to find the total of values in a field?
A) Sum
B) Sub
C) Subtotal
D) Total

Accepted Answer

The answer of Which aggregate function is used to find...

Question 19

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?
A) Group By row
B) Total row
C) Values row
D) Crosstab row

Accepted Answer

The answer of Which row in the query design grid...

Question 20

Which aggregate function is used to find the number of values in a field?
A) Values
B) Num
C) Number
D) Count

Accepted Answer

The answer of Which aggregate function is used to find...

Quiz 6: Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Which query wizard helps you build a crosstab query?

A summary query calculates statistics about ____.

Which aggregate function is used to find the average of values in a field?

The ____ function returns the number of characters in a field.

Which aggregate function would NOT work well on a Short Text field?

When you create a summary query, which row is added to the query design grid?

Which arithmetic operator signifies exponentiation?

____ queries summarize data in which one or more fields are chosen for the row headings, another for the column heading, and yet another for the field summarized within the datasheet itself.

Drag a(n) ____________________ handle to modify the shape, but not the size, of a drawing object.

The ____ function returns a number of characters from the first part of a field.

The data displayed in a query is sometimes called a(n) ____ view of the data.

The Find ____ Query Wizard is used to determine whether a table contains duplicate values in one or more fields.

Use the ____ check box in the query design grid to select or unselect a field to display in the resulting datasheet.

A(n) ____ query is used to calculate statistics about a group of records.

The Find ____ Query Wizard is used to find records in one table that do not have related records in another table.

Use the ____ Query Wizard to guide you through the steps of creating a crosstab query.

The wildcard character that represents one character in query criteria is the ____.

Which aggregate function is used to find the total of values in a field?

Which row in the query design grid identifies which of the three positions each field takes in the crosstab query?

Which aggregate function is used to find the number of values in a field?