Advanced queries and Reports Quiz

Why might certain fields be included in a query design even if they aren't wanted in the results?

• To make the query look more complex

• To find the correct records

• To confuse the user

• To increase the size of the database

What happens when you uncheck "Show" in the Query Design?

• The query will not find any records.

• The query will hide the field from the results.

• The query will show all fields in the results.

• The query will delete the field from the database.

Which field is hidden from the results of this query?

• MovieTitle

• MainActor

• BoxOffice

• Rating

What does the "Group By" aggregate function do?

• Counts the number of times values appear.

• Combines records with identical values.

• Adds together a field’s value across records.

• Finds the highest in a range of values.

Which aggregate function counts the number of times values appear?

• Sum

• Avg

• Count

• Min

What is the purpose of the "Sum" aggregate function?

• Finds the lowest in a range of values.

• Adds together a field’s value across records.

• Calculates the average of a range of values.

• Combines records with identical values.

Which aggregate function calculates the average of a range of values?

• Max

• Min

• Avg

• Count

What does the "Min" aggregate function do?

• Finds the highest in a range of values.

• Combines records with identical values.

• Finds the lowest in a range of values.

• Adds together a field’s value across records.

Which aggregate function finds the highest in a range of values?

• Max

• Sum

• Group By

• Avg

What button do you need to click in the Show/Hide block to create an aggregate query?

• Parameters

• Totals

• Insert Columns

• Delete Rows