Question 1

The three views in Access are Form or Report view,Layout view,and Design view.

Accepted Answer

A) True 
 B)False

Question 2

Changes to a subform are easier to make in Layout view.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following appears at the bottom or each form or report?

Accepted Answer

A)  Form or Report Footer
B)  Form or Report Page Footer
C)  Form or Report Header
D)  Form or Report Page HeaderE) A) and B)
F) A) and C)

Question 4

What are group headers and footers used for?

Accepted Answer

The group header appears once each time ...

Question 5

To add emphasis to a form or report,use the Line control or the Rectangle control.

Accepted Answer

A) True 
 B)False

Question 6

How do you hide details in a report?

Accepted Answer

A)  Click Hide details in the Grouping & Totals group on the Design tab
B)  Close the detail section in Design view
C)  Click Hide details in the Header/Footer Options
D)  Click Hide details in Page OptionsE) B) and C)
F) A) and B)

Question 7

Sum,Min,Max,and Average are examples of which kind of functions?

Accepted Answer

A)  Aggregate functions
B)  Constant functions
C)  Control functions
D)  Bound functionsE) B) and D)
F) B) and C)

Question 8

How often does a Form/Report Header appear?

Accepted Answer

A)  Once
B)  Once per page
C)  At the start of each group
D)  Once per record in the record sourceE) None of the above
F) All of the above

Question 9

On a form,what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Accepted Answer

A)  Combo box
B)  Calculated
C)  Unbound
D)  BoundE) B) and D)
F) A) and B)

Question 10

When are subforms created?

Accepted Answer

A)  When the main form displays records from a related table
B)  When two fields are next to each other in a table
C)  When you have an autonumber field as the primary key
D)  It can only be created when the form is createdE) A) and B)
F) None of the above

Question 11

Where is a Group Header located?

Accepted Answer

A)  At the start of each new group
B)  Top of the form/report
C)  Middle of form/report
D)  At the end of each groupE) C) and D)
F) A) and C)

Question 12

Unbound controls do not require data entry so a tab stop can be removed.

Accepted Answer

A) True 
 B)False

Question 13

How would you add grouping to a report?

Accepted Answer

A)  Group & Sort button
B)  Form footer
C)  Page footer
D)  Form headerE) B) and C)
F) All of the above

Question 14

A calculated control contains an expression that generates a calculated result.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ________ is a control that is connected to a field in a table or query.

Accepted Answer

A)  bound control
B)  unbound control
C)  calculated control
D)  combo box controlE) A) and B)
F) C) and D)

Question 16

The detail section of a form or report displays in between the headers and footers sections.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is an alternative to a combo box?

Accepted Answer

A)  Add a data validation rule
B)  Key in the field
C)  Set a tab order
D)  Make it a required fieldE) B) and C)
F) None of the above

Question 18

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

Accepted Answer

A) True 
 B)False

Question 19

A ________ describes the data associated with a text box.

Accepted Answer

A)  Label control
B)  Text control
C)  Design control
D)  Form controlE) A) and B)
F) A) and C)

Question 20

Which of the following controls contains to decorative elements,such as the title of the report?

Accepted Answer

A)  Unbound
B)  Bound
C)  Calculated
D)  Rectangle and lineE) All of the above
F) None of the above

Exam 22: Advanced Forms and Reports: Moving Beyond the Basics

How would you add grouping to a report?

Correct AnswerverifiedShow Answer

On a form,what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Correct AnswerverifiedShow Answer

Which of the following controls contains to decorative elements,such as the title of the report?

Correct AnswerverifiedShow Answer

How do you hide details in a report?

Correct AnswerverifiedShow Answer

The detail section of a form or report displays in between the headers and footers sections.

Correct AnswerverifiedShow Answer

What are group headers and footers used for?

Correct AnswerverifiedThe group header appears once each time ...View AnswerShow Answer

Unbound controls do not require data entry so a tab stop can be removed.

Correct AnswerverifiedShow Answer

A calculated control contains an expression that generates a calculated result.

Correct AnswerverifiedShow Answer

To add emphasis to a form or report,use the Line control or the Rectangle control.

Correct AnswerverifiedShow Answer

The three views in Access are Form or Report view,Layout view,and Design view.

Correct AnswerverifiedShow Answer

Changes to a subform are easier to make in Layout view.

Correct AnswerverifiedShow Answer

Which of the following is an alternative to a combo box?

Correct AnswerverifiedShow Answer

Where is a Group Header located?

Correct AnswerverifiedShow Answer

Bound,unbound,and calculated controls are not found on the Controls group on the Design tab.

Correct AnswerverifiedShow Answer

When are subforms created?

Correct AnswerverifiedShow Answer

How often does a Form/Report Header appear?

Correct AnswerverifiedShow Answer

A ________ describes the data associated with a text box.

Correct AnswerverifiedShow Answer

Sum,Min,Max,and Average are examples of which kind of functions?

Correct AnswerverifiedShow Answer

A(n) ________ is a control that is connected to a field in a table or query.

Correct AnswerverifiedShow Answer

Which of the following appears at the bottom or each form or report?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The group header appears once each time ...
View 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