Question 1

In Report Design view,you remove a control layout from a report using the Control Padding button.

Accepted Answer

A) True 
 B)False

Question 2

To close a form in Form Design view and keep Access running,you _____.

Accepted Answer

A)   right-click the form tab,and then click Close on the shortcut menu.
B)   right-click the form in the Navigation Pane,and then click Close on the shortcut menu.
C)   click the Close button on the title bar
D)   drag the form tab to the Navigation PaneE) B) and C)
F) None of the above

Question 3

In Form view,how can you navigate to the previous record in the form?

Accepted Answer

A)   Click the Back button on the Home tab.
B)   Click the left arrow button on the left side of the form.
C)   Click the Previous record button on the navigation bar.
D)   Click the Previous button in the status bar.E) A) and D)
F) A) and C)

Question 4

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Accepted Answer

A)   Use conditional formatting.
B)   Bold the OrderAmt text box.
C)   Change the font color of the OrderAmt label.
D)   Change the background color of the OrderAmt text box.E) B) and D)
F) A) and D)

Question 5

When using the Form Wizard,you can select fields from tables and _____ in the database.

Accepted Answer

A)   other forms
B)   reports
C)   themes
D)   queriesE) A) and D)
F) A) and B)

Question 6

How is the font set for a table in Table Datasheet view?

Accepted Answer

A)   Access controls the font automatically.
B)   You use the Format box on the Table Tools Design tab.
C)   Access prompts you for the font when you create the table.
D)   You use the Font box on the Home tab.E) A) and D)
F) None of the above

Question 7

Using the Report Wizard,you can select the _____ for the report.

Accepted Answer

A)   font colors
B)   layout
C)   theme
D)   font stylesE) A) and D)
F) A) and C)

Question 8

When you click the Blank Report button on the Create tab,Access opens a blank report in _____.

Accepted Answer

A)   Report Design view
B)   Report view
C)   Print Preview
D)   Report Layout viewE) C) and D)
F) B) and C)

Question 9

In a form,how you can highlight the CustomerType text box only when it contains the value New?

Accepted Answer

A)   Apply conditional formatting to the CustomerType text box.
B)   Change the font color of the text "New" the first time it appears in the form.
C)   Move the CustomerType text box to the top of the form.
D)   Use the Format Painter to apply a highlight to the CustomerType text box.E) None of the above
F) B) and D)

Question 10

Besides changing the width of a report,what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Accepted Answer

A)   You can change the orientation of the report to landscape.
B)   You can change the theme colors in the report.
C)   You can switch to Report view.
D)   You can change the report to a different type of object.E) B) and D)
F) All of the above

Question 11

Which Access tool guides you through the steps of creating a report?

Accepted Answer

A)   Report Design view
B)   Control Wizard
C)   Report Wizard
D)   Report PreviewerE) A) and B)
F) A) and C)

Question 12

You switch to Report Layout view to display the entire report as it will appear when printed.

Accepted Answer

A) True 
 B)False

Question 13

How can you display the title of a report in green?

Accepted Answer

A)   Change the alternate row color in the Detail section.
B)   Change the font color of the text box in the Report Footer.
C)   Change the font color of the label in the Report Header.
D)   Change the style applied to the label in the Detail section.E) A) and B)
F) B) and C)

Question 14

After changing the _____ of a report control,you might also need to widen the control.

Accepted Answer

A)   font color
B)   background color
C)   shape outline
D)   font sizeE) A) and B)
F) A) and C)

Question 15

You can remove a control layout from a form in Form Design view or Form Layout view.

Accepted Answer

A) True 
 B)False

Question 16

When you create a report using the _____,Access includes all the fields in the selected table.

Accepted Answer

A)   Report tool
B)   Report Wizard
C)   Blank Report tool
D)   Report Design toolE) B) and D)
F) None of the above

Question 17

As you create a report,when might you want to work in Report Layout view?

Accepted Answer

A)   When you want to view the report as it will appear when printed.
B)   When you want to hide the data and concentrate on the report design.
C)   When you want to view the report without any formatting.
D)   When you want to view the data as you change the report.E) A) and B)
F) A) and C)

Exam 4: Analyzing and Charting Financial Data

When using the Form Wizard,you can select fields from tables and _____ in the database.

Correct Answer
verified

Using the Report Wizard,you can select the _____ for the report.

Correct Answer
verified

When you click the Blank Report button on the Create tab,Access opens a blank report in _____.

Correct Answer
verified

In a form,how you can highlight the CustomerType text box only when it contains the value New?

Correct Answer
verified

As you create a report,when might you want to work in Report Layout view?

Correct Answer
verified

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Correct Answer
verified

Besides changing the width of a report,what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Correct Answer
verified

You can remove a control layout from a form in Form Design view or Form Layout view.

Correct Answer
verified

How is the font set for a table in Table Datasheet view?

Correct Answer
verified

You switch to Report Layout view to display the entire report as it will appear when printed.

Correct Answer
verified

After changing the _____ of a report control,you might also need to widen the control.

Correct Answer
verified

How can you display the title of a report in green?

Correct Answer
verified

In Form view,how can you navigate to the previous record in the form?

Correct Answer
verified

To close a form in Form Design view and keep Access running,you _____.

Correct Answer
verified

Which Access tool guides you through the steps of creating a report?

Correct Answer
verified

In Report Design view,you remove a control layout from a report using the Control Padding button.

Correct Answer
verified

When you create a report using the _____,Access includes all the fields in the selected table.

Correct Answer
verified

Exam 4: Analyzing and Charting Financial Data

When using the Form Wizard,you can select fields from tables and _____ in the database.

Correct AnswerverifiedShow Answer

Using the Report Wizard,you can select the _____ for the report.

Correct AnswerverifiedShow Answer

When you click the Blank Report button on the Create tab,Access opens a blank report in _____.

Correct AnswerverifiedShow Answer

In a form,how you can highlight the CustomerType text box only when it contains the value New?

Correct AnswerverifiedShow Answer

As you create a report,when might you want to work in Report Layout view?

Correct AnswerverifiedShow Answer

How can you highlight report records that include values greater than $500 in the OrderAmt field?

Correct AnswerverifiedShow Answer

Besides changing the width of a report,what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

Correct AnswerverifiedShow Answer

You can remove a control layout from a form in Form Design view or Form Layout view.

Correct AnswerverifiedShow Answer

How is the font set for a table in Table Datasheet view?

Correct AnswerverifiedShow Answer

You switch to Report Layout view to display the entire report as it will appear when printed.

Correct AnswerverifiedShow Answer

After changing the _____ of a report control,you might also need to widen the control.

Correct AnswerverifiedShow Answer

How can you display the title of a report in green?

Correct AnswerverifiedShow Answer

In Form view,how can you navigate to the previous record in the form?

Correct AnswerverifiedShow Answer

To close a form in Form Design view and keep Access running,you _____.

Correct AnswerverifiedShow Answer

Which Access tool guides you through the steps of creating a report?

Correct AnswerverifiedShow Answer

In Report Design view,you remove a control layout from a report using the Control Padding button.

Correct AnswerverifiedShow Answer

When you create a report using the _____,Access includes all the fields in the selected table.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified