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

Question 1

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

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

Answer 1

A

Question 2

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

Answer 2

A

Question 3

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

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

Answer 3

A

Question 4

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

Question 5

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

Question 6

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 7

Which view do you use to modify lines or rectangles?

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

Question 8

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 9

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 10

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 11

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 12

Calculated controls begin with a(n):

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

Question 13

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 14

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 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

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 17

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 18

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 19

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 20

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 21

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 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

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 24

How would you add grouping to a report?

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

Question 25

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 26

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 27

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 28

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 29

A ________ describes the data associated with a text box.

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

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

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 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

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

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

Question 34

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 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 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 37

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 38

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 39

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 40

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 41

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

Question 42

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

Question 43

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 44

Subforms have to be created using the Form Wizard.

Question 45

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 46

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 47

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

Question 48

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

Question 49

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 50

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

Question 51

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

Question 52

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 53

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 54

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

Question 55

The Tab order of a form cannot be changed.

Question 56

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

Question 57

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

Question 58

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 59

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 60

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 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 72

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

Question 73

Unbound controls are controls that are tied to specific fields.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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