Question 1

To change the text displayed on the report tab,use the report's Caption property.

Accepted Answer

A) True 
 B)False

Question 2

If you create a blank form,you must set the _____ property to display data on the form.

Accepted Answer

A)  Control Data 
B)  Record Source 
C)  Row Values 
D)  Hyperlink Address 
A)  Control Data 
B)  Record Source 
C)  Row Values 
D)  Hyperlink Address

Question 3

Where does a background image appear in a report?

Accepted Answer

A)  behind the other controls 
B)  in front of the other controls 
C)  to the right of the other controls 
D)  to the left of the other controls 
A)  behind the other controls 
B)  in front of the other controls 
C)  to the right of the other controls 
D)  to the left of the other controls

Question 4

If you want Access to create a top-to-bottom and left-to-right tab order,click _____ in the Tab Order dialog box.

Accepted Answer

A)  Top/Left 
B)  Detail 
C)  Custom Order 
D)  Auto Order 
A)  Top/Left 
B)  Detail 
C)  Custom Order 
D)  Auto Order

Question 5

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

Accepted Answer

A)  You can print the Database Documenter reports. 
B)  You can save the Database Documenter reports in the database. 
C)  You can set an option to include table relationships in the reports. 
D)  You can set an option to include field property values in the reports. 
A)  You can print the Database Documenter reports. 
B)  You can save the Database Documenter reports in the database. 
C)  You can set an option to include table relationships in the reports. 
D)  You can set an option to include field property values in the reports.

Question 6

To repeat an action in Design view or Layout view,use the _____ button.

Accepted Answer

A)  Repeat 
B)  Redo 
C)  Undo 
D)  Copy 
A)  Repeat 
B)  Redo 
C)  Undo 
D)  Copy

Question 7

Tab order refers to the order you added tabbed pages to a tab control.

Accepted Answer

A) True 
 B)False

Question 8

For a table,the _____ produces a report listing the field names,property values for each field,and table relationships.

Accepted Answer

A)  Linked Table Manager 
B)  Database Documenter 
C)  Performance Analyzer 
D)  Object Dependencies pane 
A)  Linked Table Manager 
B)  Database Documenter 
C)  Performance Analyzer 
D)  Object Dependencies pane

Question 9

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

Accepted Answer

A) True 
 B)False

Question 10

A form ____ is the general way that the data and controls are arranged on the form.

Accepted Answer

A)  group 
B)  control 
C)  layout 
D)  view 
A)  group 
B)  control 
C)  layout 
D)  view

Question 11

In which one of the following views can you edit the text in a label?

Accepted Answer

A)  Print Preview 
B)  Report Layout view 
C)  Report view 
D)  SQL view 
A)  Print Preview 
B)  Report Layout view 
C)  Report view 
D)  SQL view

Question 12

You could use "Madison" as the criterion for a Yes/No field.

Accepted Answer

A) True 
 B)False

Question 13

In Table Datasheet view,you can press CTRL+A to select all the table's records.

Accepted Answer

A) True 
 B)False

Question 14

Each item on a form is called a _____.

Accepted Answer

A)  property 
B)  layout 
C)  control 
D)  text box 
A)  property 
B)  layout 
C)  control 
D)  text box

Question 15

In a multicolumn report,you can set the column layout as "Across,then Down" or as _____.

Accepted Answer

A)  "Across,then Up" 
B)  "Down,then Up" 
C)  "Down,then Across" 
D)  "Left,then Right" 
A)  "Across,then Up" 
B)  "Down,then Up" 
C)  "Down,then Across" 
D)  "Left,then Right"

Question 16

A report with _____ is a good candidate for a multicolumn report.

Accepted Answer

A)  a header and a footer 
B)  many fields 
C)  wide margins 
D)  only a few fields 
A)  a header and a footer 
B)  many fields 
C)  wide margins 
D)  only a few fields

Question 17

To close a report in Report Design view while keeping the database open,you _____.

Accepted Answer

A)  click the Close button on the Page Setup tab 
B)  click the Close button on the Access title bar 
C)  right-click the report tab and then click Close 
D)  right-click the status bar and then click Close 
A)  click the Close button on the Page Setup tab 
B)  click the Close button on the Access title bar 
C)  right-click the report tab and then click Close 
D)  right-click the status bar and then click Close

Question 18

If you choose fields from two related tables in the Form Wizard,you can create a main form with a subform.

Accepted Answer

A) True 
 B)False

Question 19

Which control allows you to type an entry or choose an entry from a list?

Accepted Answer

A)  combo box 
B)  list box 
C)  label 
D)  text box 
A)  combo box 
B)  list box 
C)  label 
D)  text box

Question 20

What do you change when you drag the right border of a form in Form Design view?

Accepted Answer

A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form 
A)  the width of all the form controls 
B)  the margins of the form 
C)  the layout of the form 
D)  the width of the form

To change the text displayed on the report tab,use the report's Caption property.

If you create a blank form,you must set the _____ property to display data on the form.

Where does a background image appear in a report?

If you want Access to create a top-to-bottom and left-to-right tab order,click _____ in the Tab Order dialog box.

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

To repeat an action in Design view or Layout view,use the _____ button.

Tab order refers to the order you added tabbed pages to a tab control.

For a table,the _____ produces a report listing the field names,property values for each field,and table relationships.

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

A form ____ is the general way that the data and controls are arranged on the form.

In which one of the following views can you edit the text in a label?

You could use "Madison" as the criterion for a Yes/No field.

In Table Datasheet view,you can press CTRL+A to select all the table's records.

Each item on a form is called a _____.

In a multicolumn report,you can set the column layout as "Across,then Down" or as _____.

A report with _____ is a good candidate for a multicolumn report.

To close a report in Report Design view while keeping the database open,you _____.

If you choose fields from two related tables in the Form Wizard,you can create a main form with a subform.

Which control allows you to type an entry or choose an entry from a list?

What do you change when you drag the right border of a form in Form Design view?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters

Exam 6: Managing Data With Data Tools

To change the text displayed on the report tab,use the report's Caption property.

If you create a blank form,you must set the _____ property to display data on the form.

Where does a background image appear in a report?

If you want Access to create a top-to-bottom and left-to-right tab order,click _____ in the Tab Order dialog box.

Which of the following describe the reports created by the Database Documenter? Select all the options that apply.

To repeat an action in Design view or Layout view,use the _____ button.

Tab order refers to the order you added tabbed pages to a tab control.

For a table,the _____ produces a report listing the field names,property values for each field,and table relationships.

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

A form ____ is the general way that the data and controls are arranged on the form.

In which one of the following views can you edit the text in a label?

You could use "Madison" as the criterion for a Yes/No field.

In Table Datasheet view,you can press CTRL+A to select all the table's records.

Each item on a form is called a _____.

In a multicolumn report,you can set the column layout as "Across,then Down" or as _____.

A report with _____ is a good candidate for a multicolumn report.

To close a report in Report Design view while keeping the database open,you _____.

If you choose fields from two related tables in the Form Wizard,you can create a main form with a subform.

Which control allows you to type an entry or choose an entry from a list?

What do you change when you drag the right border of a form in Form Design view?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Filters