Deck 11: Creating Advanced Reports

Question 1

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

Answer 1

True

Question 2

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

Answer 2

A

Question 3

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

Answer 3

B

Question 4

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 5

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

Question 6

Each type of control on a report has formatting properties.

Question 7

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

Question 8

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

Question 9

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 10

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 11

The Stacked layout is most often used in reports.

Question 12

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 13

The ____ layout is most often used in forms.

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

Question 14

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

Question 15

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 16

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 17

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

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

Question 18

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

Question 19

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 20

You can view margins on a report in Print Preview.

Question 21

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 22

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 23

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 24

Which chart would you most likely use to show trends over time?

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

Question 25

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 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 use horizontal bars to show annual sales for different sales representatives?

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

Question 28

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

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

Question 29

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

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

Question 30

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 31

Which chart would you most likely use to show cumulative totals in a stacked arrangement?

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

Question 32

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

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

Question 33

This chart area determines the legend on the chart.

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

Question 34

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

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

Question 35

The x-axis is also called the ____ axis.

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

Question 36

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

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

Question 37

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 38

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 39

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

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

Question 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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 54

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

Question 55

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

Question 56

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

A date formatted as 19-Jun-17 has a Short Date format. _________________________

Question 58

Identify four common chart types and what they are most commonly used for.

Question 59

Charts can be added to forms or queries . _________________________

Question 60

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

Question 63

Sara works at the local animal shelter. Her boss wants her to use the shelter's database of animals to graph the number of dogs adopted per month for the past 12 months and emphasize whether the trend is increasing or decreasing. What kind of graph would be the best choice? Why?

Question 64

Aaron has created a report that tracks the animals going in and out of the animal shelter where he works.  Each animal's record has been set up to print on a separate page.  He wants to print the records for just the first 10 animals in the report. How would he do this?

Question 65

Jennifer works at the local animal shelter.  Her boss wants her to use the shelter's database of animals to categorize the total number of cats, dogs, and other types of animals brought into the shelter this year. Her boss wants these categories: cats, dogs, and other. What kind of graph would be the best choice? Why?

Question 66

Ben works at the local animal shelter. His boss wants him to use the shelter's database of animals to graph the monthly adoptions of cats vs. dogs for the past 12 months. What kind of graph would be the best choice? Why?

Question 67

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

Question 68

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?

Question 69

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