Deck 7: Advanced Forms and Reports: Moving Beyond the Basics

Question 1

A ________ is a form that enables users to view but not change data.

A) read-only form
B) data entry form
C) sub form
D) split form

Answer 1

A

Question 2

Which view do you use to modify lines or rectangles?

A) Design view
B) Layout view
C) Datasheet view
D) Form or Report view

Answer 2

A

Question 3

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?

A) Combo box
B) Calculated
C) Unbound
D) Bound

Answer 3

A

Question 4

When are subforms created?

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 created

Question 5

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

A) bound control
B) unbound control
C) calculated control
D) combo box control

Question 6

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

A) Add a data validation rule
B) Key in the field
C) Set a tab order
D) Make it a required field

Question 7

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

A) Aggregate functions
B) Constant functions
C) Control functions
D) Bound functions

Question 8

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

A) Unbound
B) Bound
C) Calculated
D) Rectangle and line

Question 9

When would a calculated field need to be added to a form or report?

A) When a formula is needed in the form or report
B) When you want to add some explanatory text to the form or report
C) When using an unbound control in the form or report
D) When using a bound control in the form or report

Question 10

Calculated controls begin with a(n):

A) equal sign (=).
B) plus sign (+).
C) pound sign (#).
D) bracket ([ ]).

Question 11

Which view gives a designer a higher level of control when creating forms and/or reports?

A) Design view
B) Layout view
C) Datasheet view
D) Form or Report view

Question 12

Which of the following is NOT used when laying out forms and reports?

A) Changing the Allow Edits property to No
B) Controls not bound to specific fields
C) Controls that change each time a new record is displayed
D) Lines, pictures, and other non-data-related elements

Question 13

Which of the following fields is an example of a field that would not require a tab stop?

A) Calculated field
B) Last Name field
C) Address field
D) State field

Question 14

What should be done before converting a text box to a combo box?

A) Create a new table and enter the values for the option list
B) Set a default value to appear on the form
C) Check the tab order of the form
D) Switch to Form view and attempt to change the data in the first record

Question 15

What are two options for adding emphasis to your form or report?

A) Line or rectangle control
B) Rectangle or calculated control
C) Unbound or rectangle control
D) Bound or unbound control

Question 16

A(n) ________ is text not tied to a specific field.

A) label
B) text box
C) calculated control
D) control box

Question 17

Which type of control does a lookup field become in a form?

A) Combo box control
B) Bound control
C) Calculated control
D) Unbound control

Question 18

The ________ is the sequential advancing in a form from one field to the next.

A) tab order
B) bound control
C) unbound control
D) calculated control

Question 19

Where would you go to change tab order in a form?

A) Design view - Tab order in Tools group
B) Property sheet
C) Datasheet view - Tab order in Tools group
D) Detail section

Question 20

A(n) ________ contains an expression that generates a calculated result.

A) calculated control
B) rectangle control
C) bound control
D) unbound control

Question 21

Which of the following generally refers to decorative elements such as the title of a report?

A) Unbound control
B) Bound control
C) Calculated control
D) Text box

Question 22

Where is a Group Header located?

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 group

Question 23

A ________ describes the data associated with a text box.

A) Label control
B) Text control
C) Design control
D) Form control

Question 24

Which of the following appears once at the top of each page in a form or report?

A) Form or Report Page Header
B) Form or Report Page Footer
C) Form or Report Header
D) Form or Report Footer

Question 25

What is the reason for making a form read-only?

A) Users can lookup information but not modify the data
B) Users can lookup and edit forms as needed
C) Users can use the form instead of the table to edit data
D) Users can add and delete data from the form

Question 26

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

A) Form or Report Header
B) Form or Report Footer
C) Form or Report Page Header
D) Form or Report Page Footer

Question 27

Where does a Group Footer appear?

A) Just below the Detail section
B) Just below the Page Footer
C) Just below the Form Footer
D) Just above the Page Header

Question 28

What appears below the Page Footer section in a report or form?

A) Form Footer or Report Footer
B) Form Footer or Grouping Group
C) Report Footer or Grouping Group
D) Form footer or Detail section

Question 29

What must you do once a text box has been converted to a combo box?

A) Set a source for the combo box
B) Set a default value
C) Create a validation rule
D) Create an input mask

Question 30

Which two views make it easy to edit the design of a form?

A) Layout view and Design view
B) Design view and Datasheet view
C) Datasheet view and Design view
D) Form view and Layout view

Question 31

Which sections display on forms and reports by default?

A) Detail and form/report header and footer
B) Detail and form/report page header and footer
C) Form/report page header and footer
D) Form/report header and footer

Question 32

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

A) Form or Report Footer
B) Form or Report Page Footer
C) Form or Report Header
D) Form or Report Page Header

Question 33

What type of break is used to cause each group to print on a separate page?

A) Page
B) Section
C) Footer
D) Report

Question 34

How do you hide details in a report?

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 Options

Question 35

Where is the Page Header located?

A) Top of each page
B) Top of form/report
C) At the end of each group
D) Bottom of each page

Question 36

Which of the following appears once at the bottom of each page in a form or report?

A) Form or Report Page Footer
B) Form or Report Footer
C) Form or Report Page Header
D) Form or Report Header

Question 37

How often does a Form/Report Header appear?

A) Once
B) Once per page
C) At the start of each group
D) Once per record in the record source

Question 38

How would you add grouping to a report?

A) Group & Sort button
B) Form footer
C) Page footer
D) Form header

Question 39

What is the group footer used for?

A) Totaling the data at the end of each group
B) Totaling the data at the end of each page
C) Totaling the data at the end of each section
D) Totaling the data at the end of the form

Question 40

The ________ appears after adding a grouping to a form or report.

A) Group Header
B) Group Footer
C) Page Header
D) Page Footer

Question 41

To move a text box label, what action must you take?

A) Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected.
B) Click the Tabular Layout in the Arrange group when the label is selected.
C) Click the Tabular Layout in the Arrange group when the text box is selected.
D) Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected.

Question 42

Tab order cannot be changed in a form once it has been created.

Question 43

If you create a form based on a table with a lookup field, the lookup field becomes a combo box control on the new form.

Question 44

When a form has been created as read-only, it should be renamed to indicate it is read-only.

Question 45

Which of the following is NOT a correct way to Add a calculated control to a form or report?

A) Use the Expression Builder
B) Create a formula in an unbound control
C) Create a formula beginning with the equal sign (=) in a text box
D) Create a formula in a bound control

Question 46

How do you switch on or off sections of a report or form?

A) Right-click a blank area
B) Go to the property sheet
C) Hide the detail section
D) Grey out a section

Question 47

Subforms have to be created using the Form Wizard.

Question 48

When creating a subform, Access automatically names the subform for you or you can create your own name.

Question 49

To remove a tab stop, click the Other tab in the Property sheet and change the Tab Stop setting to No.

Question 50

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

Question 51

Which of the following displays when you insert a text box?

A) Label control
B) Text box control
C) Design view control
D) Section control

Question 52

Simple forms created with a Form tool will handle most basic database solution needs.

Question 53

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

Question 54

The Tab order of a form cannot be changed.

Question 55

Which of the following displays one time at the bottom of a report?

A) Report footer
B) Report header
C) Form footer
D) Form header

Question 56

Which of the following controls can you use to add emphasis to your form or report?

A) Line control and rectangle control
B) Line control and unbound control
C) Rectangle control and calculated control
D) Line control and bound control

Question 57

After adding grouping, a ________ appears just above the Detail section in Design view, along with the name of the field by which you are grouping.

A) Group header
B) Group footer
C) Page header
D) Form header

Question 58

When choosing fields from two different tables using the Form Wizard, Access automatically assumes you want a form with a subform.

Question 59

Which of the following marks the top boundary of a section in a form or report?

A) Section bar
B) Tab bar
C) Bound control
D) Unbound control

Question 60

A read-only form is a form that enables users to view but not change data.

Question 61

Match the following terms with their meanings:
I. calculated control
II. tab order
III. bound control
IV. read-only form
V. unbound control
A. the sequential advancing in a form from one field or control to the next
B. a control not tied to a specific field
C. a control containing an expression that generates a calculated result
D. a control that is connected to a field in a table or query
E. a form that enables users to view but not change data

Question 62

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

Question 63

An explanatory note added to a form or report is considered a label because it is not tied to a specific field.

Question 64

If no caption has been set for a field, the label will default to the field name.

Question 65

A form or report header appears one time at the top of each form or report.

Question 66

Page breaks can be added at specific locations in forms or reports.

Question 67

A page footer appears at the bottom of the last page of a form or report.

Question 68

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

Question 69

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

Question 70

Both forms and reports have a text box control, which displays the data found in the record source.

Question 71

Match the following terms with their meanings:
I. combo box control
II. subform
III. detail section
IV. section bar
V. section
A. part of a form or report that can be manipulated separately from other parts of the form or report
B. displays the records in the record source
C. provides a drop-down menu displaying a list of options from which the user can chose a single value
D. displays records that are related to records in a main form
E. marks the top boundary of a section in a form or report

Question 72

Forms and reports based on a query can display calculated fields like any other field.

Question 73

Unbound controls are controls that are tied to specific fields.

Question 74

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

Question 75

Both label controls and text box controls are known as bound controls.

Question 76

When creating a form or report, you can insert an image file containing the company logo.

Question 77

After inserting a line into a form or report, you can modify the color, thickness and line type.

Question 78

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

Question 79

The skill used to create a form can be used to create a report as well.

Question 80

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