Question 1

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

Accepted Answer

You group controls together in a report table layout in order to more productively format and resize them. Resizing one control in a layout resizes the entire group.

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

Layout in Access forms and reports means ____.

Accepted Answer

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 
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 B

Question 4

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

Accepted Answer

The answer of The chart type that shows trends over...

Question 5

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

Accepted Answer

The answer of ____________________, also called graphs, are visual representations...

Question 6

The Stacked layout is most often used in reports.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

In the figure above, item 4 is the ____.

Accepted Answer

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

Question 10

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?

Accepted Answer

In Design View, open the property sheet

Question 11

In the figure above, item 2 is the ____.

Accepted Answer

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

Question 12

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?

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

The first step in creating a chart is to ____.

Accepted Answer

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 
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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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?

Accepted Answer

A line gra

Question 20

What are the two required arguments for a domain function?

Accepted Answer

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

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

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

Layout in Access forms and reports means ____.

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

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

The Stacked layout is most often used in reports.

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

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

In the figure above, item 4 is the ____.

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?

In the figure above, item 2 is the ____.

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?

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

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

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

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

The first step in creating a chart is to ____.

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

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?

What are the two required arguments for a domain function?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 12: Creating Advanced Reports

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

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

Layout in Access forms and reports means ____.

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

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

The Stacked layout is most often used in reports.

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

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

In the figure above, item 4 is the ____.

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?

In the figure above, item 2 is the ____.

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?

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

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

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

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

The first step in creating a chart is to ____.

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

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?

What are the two required arguments for a domain function?

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters