Deck 13: Creating Advanced Reports

Question 1

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

Answer 1

True

Question 2

The ____ layout is most often used in forms.

A) Formula
B) Stacked
C) Tabular
D) Datasheet

Answer 2

B

Question 3

The chart in the figure above is an example of a bar chart.

Answer 3

False

Question 4

The chart shown in the figure above is being edited.

Question 5

The Stacked layout is most often used in reports.

Question 6

Which of the following is NOT a formatting property available for many report controls?

A) Text Align
B) Width
C) Format
D) Data Type

Question 7

Layout in Access forms and reports means ____.

A) Sorting records in a report under a group header
B) Connecting controls as a set
C) Changing fonts and colors
D) Chart selection and placement

Question 8

Each type of control on a report has formatting properties.

Question 9

The Stacked layout positions labels to the left of their respective text boxes.

Question 10

In the figure above, which property is being modified?

A) Force New Page
B) New Row or Col
C) Department Header
D) DeptSummary

Question 11

A hashed border of a chart placeholder control indicates that the chart is displaying the most current data.

Question 12

If a chart only has one set of values that represent 100% of something, it is a good candidate for a pie chart.

Question 13

You can view margins on a report in Print Preview.

Question 14

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

A) Formula
B) Stacked
C) Tabular
D) Datasheet

Question 15

The chart in the figure above is an example of a 3-D chart.

Question 16

Three-dimensional charts are always more effective than two-dimensional charts.

Question 17

Numbers on a report can be displayed in Currency, Percent, or Standard formats.

Question 18

This property makes sure that controls in the page section repeat at the top of every page.

A) Force New Page
B) Repeat Section
C) Force Every Page
D) Repeat Every Page

Question 19

In the figure above, item 4 refers to the legend.

Question 20

In the figure above, item 3 refers to the datasheet.

Question 21

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

A) Area
B) Pie
C) Line
D) Column

Question 22

In the figure above, item 6 points to the ____.

A) Chart Standard toolbar
B) Chart Formatting toolbar
C) Datasheet toolbar
D) Editing toolbar

Question 23

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

A) Column
B) Bar
C) Line
D) Area

Question 24

What is the first argument in the DLookup function?

A) the domain
B) the criteria
C) true or false
D) the field that is used for the calculation

Question 25

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

A) Area
B) Pie
C) Line
D) Column

Question 26

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

A) Column
B) Bar
C) Line
D) Area

Question 27

Which chart type would best illustrate the contribution of three products to total company sales for a given year?

A) Area
B) Pie
C) Line
D) Column

Question 28

What are the two required arguments for a domain function?

A) Criteria and calculation
B) Criteria and domain name
C) Field used in the calculation and domain name
D) Field used in the calculation and criteria

Question 29

The chart type that shows comparisons of values in horizontal bars is a(n) ____ chart.

A) Column
B) Bar
C) Line
D) Progress

Question 30

In the figure above, item 2 is the ____.

A) Title
B) Datasheet
C) Chart Standard toolbar
D) Placeholder

Question 31

The first step in creating a chart is to ____.

A) select the data that the chart will graph
B) format the chart
C) resize the chart to fit the page
D) test different 3D chart options

Question 32

Where do you specify the number of columns for a report?

A) Print Preview toolbar
B) Page Setup dialog box
C) Form Design property sheet
D) Tab Set properties

Question 33

Which chart type would best show sales trends by connecting several points over time?

A) Column
B) Bar
C) Line
D) Area

Question 34

Which function would help you return a value from a specified table or query?

A) Seek
B) Disclaimer
C) DLookup
D) Domain

Question 35

The chart in the figure above is a(n) ____ chart.

A) Area
B) Column
C) Line
D) Pie

Question 36

The domain in a domain aggregate function is the ____ that contains the field used in the calculation.

A) table or query
B) form or report
C) text box or label
D) property or control

Question 37

When charts are displayed in Layout View, you will see which of the following?

A) Actual data
B) A chart placeholder
C) A pie chart
D) A data table

Question 38

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

A) Column
B) Bar
C) Line
D) Area

Question 39

What is the third optional argument for a domain function?

A) Criteria to select given records in the calculation
B) Domain name
C) Field used in the calculation
D) Standard disclaimer

Question 40

What is the second argument in the DLookup function?

A) the domain
B) the criteria
C) true or false
D) the field that is used for the calculation

Question 41

In the figure above, which chart would you most likely use to show comparisons of values, such as annual sales for a different product for several sales representatives?

A) Column
B) Pie
C) Doughnut
D) Scatter

Question 42

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

Question 43

This chart area determines what field the bars on the chart represent.

A) Axis
B) Series
C) Legend
D) Data

Question 44

In the figure above, which chart would you most likely use to show trends over time?

A) Surface
B) Pie
C) Radar
D) Line

Question 45

In the figure above, which chart would you most likely use to show cumulative totals in a stacked arrangement?

A) Scatter
B) Area
C) Bubble
D) Stock

Question 46

In the figure above, item 5 points to the ____.

A) Chart Standard toolbar
B) Chart Formatting toolbar
C) Datasheet toolbar
D) Editing toolbar

Question 47

Access provides a(n) ____________________ Wizard that steps you through the process of creating charts within forms and reports.

Question 48

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

Question 49

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

Question 50

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

A) Data
B) Axis
C) Series
D) None of the above

Question 51

In the figure above, item 4 is the ____.

A) Title
B) Legend
C) Chart Standard toolbar
D) Placeholder

Question 52

The x-axis is also called the ____ axis.

A) y-
B) vertical
C) horizontal
D) legend

Question 53

This chart area determines the legend on the chart.

A) X-Axis
B) Series
C) Datasheet
D) Y-Axis

Question 54

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

Question 55

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

Question 56

In the figure above, which chart would you most likely use to show parts of a whole, such as the contribution of three sales divisions to the entire company's profits for the year?

A) Column
B) Line
C) Pie
D) Area

Question 57

The chart type that shows parts of a whole with slices is a(n) ____________________ Chart.

Question 58

This chart area determines the x-axis on the chart.

A) Axis
B) Series
C) Legend
D) Data

Question 59

Which of the following is NOT a common Access chart type?

A) Line
B) Progress
C) Pie
D) Area

Question 60

The chart type that shows trends over time by connecting points is a(n) ____________________ Chart.

Question 61

In a report, the Narrow margin option sets all four margins to 0.25". _________________________

Question 62

Match the report problems with the probable solution.
a.The report contains no title or page numbers
c.Numbers do not appear with $
b.An #Error message appears where a calculation should appear in Print Preview
d.Names appear in two columns with big gaps of white space between the first and last names
Numbers should be formatted with a Currency format.

Question 63

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

Question 64

The Remove Layout button is provided for a report only in Report Design View. _________________________

Question 65

Match each kind of chart with the best example.
a.Bar
c.Pie
b.Line
d.Area
Each wedge represents total quarterly sales for a company.

Question 66

You can open and close the Group Header and Group Footer sections in the Group, Sort, and Total pane. _________________________

Question 67

Explain the purpose of grouping controls together in a report table layout.

Question 68

A date formatted as 19-Apr-16 has a Short Date format. _________________________

Question 69

Match the report problems with the probable solution.
a.The report contains no title or page numbers
c.Numbers do not appear with $
b.An #Error message appears where a calculation should appear in Print Preview
d.Names appear in two columns with big gaps of white space between the first and last names
An expression wasn't entered correctly in a text box in Design View

Question 70

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.

Question 71

The Page Numbers button is found on the VIEW tab of the ribbon. _________________________

Question 72

Match the report problems with the probable solution.
a.The report contains no title or page numbers
c.Numbers do not appear with $
b.An #Error message appears where a calculation should appear in Print Preview
d.Names appear in two columns with big gaps of white space between the first and last names
Create an expression in a text box to combine the first and last names, needs to be entered in one text box.

Question 73

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

Question 74

The text in a form or report tab is determined by the form or report's Title property. _________________________

Question 75

All charts are modified in the ____________________ View of the form or report where the chart exists.

Question 76

The chart type that shows cumulative totals using stacked sections is a(n) ____________________ Chart.

Question 77

Match each kind of chart with the best example.
a.Bar
c.Pie
b.Line
d.Area
Each section represents monthly sales by representative, stacked to show cumulative total sales.

Question 78

Match the report problems with the probable solution.
a.The report contains no title or page numbers
c.Numbers do not appear with $
b.An #Error message appears where a calculation should appear in Print Preview
d.Names appear in two columns with big gaps of white space between the first and last names
Switch to Report Design View to open more report sections and add controls.

Question 79

Charts can be added to forms or queries. _________________________

Question 80

To format a number with a $ such as $50.99, use the Standard format. _________________________