Prometheus Lesson 13 - Exam 3

Question 1

___ are used to display results from fields on different tables.

Answer 1

multi-table queries

Question 2

___ are used to group query results into categories based on the values for a field and then perform calculations for each category.

Answer 2

Aggregate queries

Question 3

Which type of query performs summary calculations across all of the records for a particular field.

Answer 3

Aggregate Queries

Question 4

___ are used to create a multi-dimensional view of data

Answer 4

Cross-Tab

Question 5

How many “group by” fields does each cross-tab query contain?

Answer 5

2 or more

Question 6

What are the 4 views of a Report?

Answer 6

Report View - allows you to see finished product of the report

Print Preview - shows you how it will look on PDF

Design View - changes the appearance of the report

Layout - compromise between Design View and Report View (displays the records and allows for resizing)

Question 7

When exporting a report to a text file, the ___ is used to separate the column widths by space, comma, or semi-colon

Answer 7

Delimiter