Exam 11: Creating Advanced Reports

____________________ functions are used in an expression to calculate a value based on a field that is not included in the Record Source property for the form or report.

Free

(Short Answer)

4.9/5

(36)

Question 1

Correct Answer:

Verified

Domain,Domain aggregate

Explain how the Page N of M option in the Page Numbers dialog box will present in the first three pages of a ten page report.

Free

(Essay)

4.8/5

(31)

Question 2

Correct Answer:

Verified

The Page N of M option means that the page number expression will say Page 1 of 10, Page 2 of 10, Page 3 of 10 in a ten page report.

The x-axis is also called the ____ axis.

Free

(Multiple Choice)

4.8/5

(37)

Question 3

Correct Answer:

Verified

____________________, also called graphs, are visual representations of numeric data that help users see comparisons, patterns, and trends in data.

(Short Answer)

4.9/5

(35)

Question 4

Layout in Access forms and reports means ____.

(Multiple Choice)

4.8/5

(29)

Question 5

Suzy has created a report that tracks the animals going in and out of the animal shelter where she works. Each animal's ID number is shown in the AnimalID Footer section. She wants to print each animal's record as a separate document so it can be used in the animal's file. How would she do this?

(Essay)

4.8/5

(37)

Question 6

Which chart type would best illustrate the cumulative total sales effort by month for several employees for a given year?

(Multiple Choice)

4.8/5

(40)

Question 7

Before using the Chart Wizard, it's a good idea to plan what specific fields you want the chart to display.

(True/False)

4.9/5

(24)

Question 8

Which chart type would use vertical bars to show annual sales for different sales representatives?

(Multiple Choice)

4.9/5

(43)

Question 9

The ____ layout positions labels across the top in the Page Header section forming columns of data with text boxes positioned in the Detail section.

(Multiple Choice)

4.7/5

(39)

Question 10

Charts can be added to forms or queries . _________________________

(True/False)

4.7/5

(36)

Question 11

To change the color of the bars on a chart you must work in Report View. _________________________

(True/False)

4.8/5

(36)

Question 12

Each type of control on a report has formatting properties.

(True/False)

4.9/5

(42)

Question 13

The chart type that shows comparisons of values in vertical bars is a(n) ____________________ Chart.

(Short Answer)

4.9/5

(30)

Question 14

The ____ area of a chart determines what field the bars on the chart represent.

(Multiple Choice)

4.8/5

(36)

Question 15

Which chart type would best show cumulative sales by several representatives over time?

(Multiple Choice)

4.8/5

(32)

Question 16

You cannot always see actual chart values in Design View. _________________________

(True/False)

4.8/5

(42)

Question 17

A(n) ____________________ report repeats information in more than one column on the page.

(Short Answer)

4.9/5

(32)

Question 18

The Stacked layout is most often used in reports.

(True/False)

4.8/5

(32)

Question 19

Which chart type would be used to best compare the annual sales for a different products for a given year?

(Multiple Choice)

4.9/5

(36)

Question 20

Showing 1 - 20 of 69

____________________ functions are used in an expression to calculate a value based on a field that is not included in the Record Source property for the form or report.

Explain how the Page N of M option in the Page Numbers dialog box will present in the first three pages of a ten page report.

The x-axis is also called the ____ axis.

____________________, also called graphs, are visual representations of numeric data that help users see comparisons, patterns, and trends in data.

Layout in Access forms and reports means ____.

Suzy has created a report that tracks the animals going in and out of the animal shelter where she works. Each animal's ID number is shown in the AnimalID Footer section. She wants to print each animal's record as a separate document so it can be used in the animal's file. How would she do this?

Which chart type would best illustrate the cumulative total sales effort by month for several employees for a given year?

Before using the Chart Wizard, it's a good idea to plan what specific fields you want the chart to display.

Which chart type would use vertical bars to show annual sales for different sales representatives?

The ____ layout positions labels across the top in the Page Header section forming columns of data with text boxes positioned in the Detail section.

Charts can be added to forms or queries . _________________________

To change the color of the bars on a chart you must work in Report View. _________________________

Each type of control on a report has formatting properties.

The chart type that shows comparisons of values in vertical bars is a(n) ____________________ Chart.

The ____ area of a chart determines what field the bars on the chart represent.

Which chart type would best show cumulative sales by several representatives over time?

You cannot always see actual chart values in Design View. _________________________

A(n) ____________________ report repeats information in more than one column on the page.

The Stacked layout is most often used in reports.

Which chart type would be used to best compare the annual sales for a different products for a given year?

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters