Question 1

What is the first argument in the DLookup function?

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The answer of The chart type that shows comparisons of...

Question 5

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

Accepted Answer

The answer of The  chart type that shows comparisons of values...

Question 6

In the figure above, item 5 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 7

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

Accepted Answer

The answer of The chart type that shows cumulative totals...

Question 8

The chart shown in the figure above is being edited.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The answer of All charts are modified in the ____________________...

What is the first argument in the DLookup function?

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

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

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

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

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

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

The chart shown in the figure above is being edited.

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

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

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

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

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

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

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

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

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

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

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

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

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

What is the first argument in the DLookup function?

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

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

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

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

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

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

The chart shown in the figure above is being edited.

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

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

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

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

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

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

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

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

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

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

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

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

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