Exam Prep Ch8 Advanced Forms And Reports

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 8 Advanced Forms and Reports

1) Which of the following is not true about what restrictions can be set for a form?

A) A user cannot delete a record.

B) A user cannot view a record.

C) A user cannot add a record.

D) A user cannot change a record.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

2) What is one way the user can tell that records cannot be deleted in a form?

A) The Delete command is not visible.

B) The Delete command has a line through it.

C) The Delete command is grayed out.

D) There is no way to tell if records cannot be deleted.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

3) Which of the following is not a reason to restrict who can edit data in a form?

A) Data can become unreliable.

B) Data can become hard to maintain.

C) The wrong people might be able to delete the records.

D) The file will get too large.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

4) Which of the following are not customizations you can make to a form?

A) Change the tab order

B) Convert a form to a report

C) Convert a text box to a menu

D) Make a form read-only

Diff: 2

Objective: A7.01 Restrict Edits in a Form

5) What is one way the user can tell that new records cannot be created in a form?

A) The New command is grayed out.

B) The New command is removed.

C) The New command has a line through it.

D) There is no way to tell that new records cannot be created.

Diff: 3

Objective: A7.01 Restrict Edits in a Form

6) How does Access let you know that a form is set as read-only?

A) A notice will appear on the Status Bar while the form is open.

B) A pop-up message will appear when the form is opened.

C) The form fields will be grayed out.

D) No indication is given that a form is read-only.

Diff: 3

Objective: A7.01 Restrict Edits in a Form

7) A form that enables users to view but not change data is what type of form?

A) Restrict-only

B) DataView-only

C) Read-only

D) DataView

Diff: 2

Objective: A7.01 Restrict Edits in a Form

8) Which of the following is a recommended way of informing users that a form is read-only?

A) Include a note in the form title.

B) Have a message box appear any time the form is opened.

C) There is no need to inform the user.

D) There is never a need to make a form read-only.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

9) Which of the following is not true about Combo Boxes?

A) They are not good for repetitive data.

B) They should not be used if the menu would become too long.

C) They can reference data in other tables.

D) They can make data entry more reliable.

Diff: 2

Objective: A7.02 Understand Combo Boxes

10) To make sure that a user can only pick from an item on the list in a Combo Box, what property must be enabled?

A) Limit to List

B) Restrict to List

C) Limit to Menu

D) Restrict to Menu

Diff: 2

Objective: A7.02 Understand Combo Boxes

11) What type of control is created if you create a form based on a table with a lookup field?

A) Check Box

B) Option button

C) Combo Box

D) Lookup Box

Diff: 2

Objective: A7.02 Understand Combo Boxes

12) Which of the following is not true about making a table the source data for a Combo Box?

A) It is quicker for Access to index the data.

B) The data is then in an easy-to-edit location.

C) The user can be forced to choose from only those records in the table.

D) New records can be added or existing records deleted very easily.

Diff: 1

Objective: A7.02 Understand Combo Boxes

13) When setting up a Combo Box, what property is used to pick the field in the table which will be used to generate the menu?

A) Row Source

B) Column Source

C) Field Source

D) Record Source

Diff: 3

Objective: A7.02 Understand Combo Boxes

14) Creating a Combo Box is perfect when data ________.

A) repeats often

B) is always unique

C) entry requires more than one answer

D) will not be deleted

Diff: 2

Objective: A7.02 Understand Combo Boxes

15) How does a Combo Box control appear to a user?

A) Menu of options

B) Option button

C) Check Box

D) Legacy control

Diff: 2

Objective: A7.02 Understand Combo Boxes

16) When might you not want to skip a tab stop?

A) Calculated field

B) AutoNumber field

C) Combo Box field

D) Any time the field requires no data entry

Diff: 3

Objective: A7.03 Set the Tab Order

17) What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it sees fit?

A) Tab Order

B) Custom Order

C) Auto Order

D) Auto Tabs

Diff: 3

Objective: A7.03 Set the Tab Order

18) What key is often used in a form to advance from one field to another?

A) Right Arrow key

B) Shift Tab

C) Space bar

D) Tab

Diff: 2

Objective: A7.03 Set the Tab Order

19) Subforms are often laid out in what type of fashion?

A) Grid

B) Tabular

C) Form

D) Nested

Diff: 3

Objective: A7.04 Understand Subforms

20) When editing a subform, it is almost always easier to do it in what view because you can see the data as it appears in the subform?

A) Design

B) Layout

C) Form

D) Report

Diff: 1

Objective: A7.04 Understand Subforms

21) Which of the following views is not used with forms or reports?

A) Form

B) Design

C) Layout

D) SQL

Diff: 1

Objective: A7.05 Understand Controls

22) A section ________ marks the top boundary of a section.

A) bar

B) line

C) area

D) row

Diff: 2

Objective: A7.06 Understand Sections

23) Which of the following would not be an example of an unbound control?

A) Title of the report

B) Lastname field

C) Graphic line

D) Rectangle

Diff: 1

Objective: A7.05 Understand Controls

24) A common control which displays the values in a field is called what type of control?

A) Label

B) Field

C) Value

D) Text Box

Diff: 1

Objective: A7.05 Understand Controls

25) What does the Label control display as a default when used in a form or report?

A) Caption set for a field if there is one

B) Label name

C) Default value for the field if there is one

D) "Label"

Diff: 3

Objective: A7.05 Understand Controls

26) Which of the following would you typically not find in a calculated control?

A) Aggregate function

B) Simple math

C) Function using the Expression Builder

D) Image

Diff: 1

Objective: A7.05 Understand Controls

27) Which of the following is not a control that can be added to a form or report?

A) Select

B) Page Break

C) Label

D) Image

Diff: 2

Objective: A7.05 Understand Controls

28) Adding which control will insure that your reports are paginated correctly?

A) Line Break

B) Page Break

C) Pagination

D) Section Break

Diff: 2

Objective: A7.05 Understand Controls

29) Where does a form header appear?

A) At the top of each page

B) At the left of each page

C) Once, at the left of the form

D) Once, at the top of the form

Diff: 1

Objective: A7.05 Understand Controls

30) What word would not describe an unbound control?

A) Static

B) Unchanging

C) Dynamic

D) Decorative

Diff: 2

Objective: A7.05 Understand Controls

31) Which view gives the database designer more control over the look of the form or report?

A) Design

B) Layout

C) Form

D) Report

Diff: 1

Objective: A7.05 Understand Controls

32) What is the name of the section that displays the data in a form or report?

A) Footer

B) Header

C) Detail

D) Content

Diff: 3

Objective: A7.06 Understand Sections

33) If you had a five-page report, which of the following statements is true?

A) The form header and/or footer would display twice; one on the first page and one on the last page.

B) The page header and/or footer would display twice; one on the first page and one on the last page.

C) The form header and/or footer would display five times.

D) The page header and/or footer would display five times.

Diff: 1

Objective: A7.06 Understand Sections

34) Which of the following statements is not true about sections?

A) Forms and reports display the Detail section by default.

B) The Detail section cannot be turned off.

C) Reports display the page header/footer by default.

D) Forms hide the footer section by default.

Diff: 3

Objective: A7.06 Understand Sections

35) What happens to the controls in a section if you turn off the section?

A) All controls in that section are minimized.

B) All controls in that section are moved to the next higher section.

C) All controls in that section are deleted.

D) All controls in that section are hidden.

Diff: 3

Objective: A7.06 Understand Sections

36) Which of the following statements is true about changing the width of sections?

A) All sections must have the same width.

B) Each section can have its own width.

C) Each section can have its own width within the limits of the width of the form/report.

D) You cannot change the width of sections.

Diff: 3

Objective: A7.06 Understand Sections

37) Which of the following marks the top of a section?

A) Section divider

B) Section line

C) Section bar

D) Section break

Diff: 2

Objective: A7.06 Understand Sections

38) Which of the following statements is not true about group headers and footers?

A) They cannot be added to forms.

B) You need to use caution when adding them to forms.

C) They appear once for each unique value in the group.

D) They are named after the field on which the group is based.

Diff: 3

Objective: A7.06 Understand Sections

39) Where do you typically put a page break?

A) Page footer

B) Group footer

C) Group header

D) Section footer

Diff: 2

Objective: A7.06 Understand Sections

40) In what section is the field which calculates the total number of pages in the document, normally put?

A) Report header

B) Report footer

C) Page header

D) Page footer

Diff: 3

Objective: A7.06 Understand Sections

41) When the Allow Edits property of a form is set to No, no records can be deleted.

Diff: 3

Objective: A7.01 Restrict Edits in a Form

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

Diff: 2

Objective: A7.01 Restrict Edits in a Form

43) It is possible to set up restrictions which allow records to be added, but not deleted using a form.

Diff: 1

Objective: A7.01 Restrict Edits in a Form

44) Access makes it obvious to a data entry user if a form is read-only.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

45) Forms can be customized so that users can only view the data.

Diff: 1

Objective: A7.01 Restrict Edits in a Form

46) It is possible to set up restrictions which allow records to be deleted, but not added using a form.

Diff: 1

Objective: A7.01 Restrict Edits in a Form

47) When the Allow Edit property of a form is set to No, no new records can be added.

Diff: 3

Objective: A7.01 Restrict Edits in a Form

48) As long as you have created the table relationships correctly, after you convert a text box to a Combo Box Access will make the appropriate connections in the Combo Box.

Diff: 3

Objective: A7.02 Understand Combo Boxes

49) A Combo Box allows a user to pick a combination of correct options.

Diff: 2

Objective: A7.02 Understand Combo Boxes

50) Combo Boxes must be created at the same time the source table is created.

Diff: 1

Objective: A7.02 Understand Combo Boxes

51) A form footer displays at the bottom of every page in a form.

Diff: 2

Objective: A7.06 Understand Sections

52) 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.

Diff: 2

Objective: A7.02 Understand Combo Boxes

53) Sometimes tables are created for no other purpose than to hold the values that will be used in a Combo Box.

Diff: 2

Objective: A7.02 Understand Combo Boxes

54) Setting the tab order helps prevent errors and simplifies data entry.

Diff: 1

Objective: A7.03 Set the Tab Order

55) The tab order can be set manually if necessary.

Diff: 1

Objective: A7.03 Set the Tab Order

56) Group headers and footers cannot be added to a form.

Diff: 2

Objective: A7.06 Understand Sections

57) A tab stop should always be set for AutoNumber fields.

Diff: 2

Objective: A7.03 Set the Tab Order

58) Because tables are often related in Access, one result is that forms can get more complex.

Diff: 1

Objective: A7.04 Understand Subforms

59) If two tables are related and you use the Form Wizard, a subform will automatically be created in the main form.

Diff: 1

Objective: A7.04 Understand Subforms

60) Subforms always display all the fields from the underlying table.

Diff: 3

Objective: A7.04 Understand Subforms

61) A graphic line can be considered a form control.

Diff: 1

Objective: A7.05 Understand Controls

62) The reason the value displayed in fields on a form change when the data in the table changes is that the fields on a form are bound controls.

Diff: 1

Objective: A7.05 Understand Controls

63) The controls toolbar will tell you if a control is a bound or unbound control.

Diff: 3

Objective: A7.05 Understand Controls

64) Text box controls cannot display numeric data, currency, or dates.

Diff: 3

Objective: A7.05 Understand Controls

65) Unbound controls are connected to specific fields in a table or query.

Diff: 1

Objective: A7.05 Understand Controls

66) Page headers and footers are turned off by default in forms.

Diff: 2

Objective: A7.06 Understand Sections

67) A form that enables users to view but not change data is a(n) ________ form.

Diff: 2

Objective: A7.01 Restrict Edits in a Form

68) To make sure that a user can only pick from an item on the list in a Combo Box, the ________ to List property must be enabled.

Diff: 2

Objective: A7.02 Understand Combo Boxes

69) If a user attempts to enter a value in a Combo Box that is not present in the table, and the Limit to List property is enabled, Access will generate a(n) ________ message.

Diff: 2

Objective: A7.02 Understand Combo Boxes

70) If you create a form based on a table with a lookup field, the lookup field becomes a(n) ________ Box control on the new form.

Diff: 2

Objective: A7.02 Understand Combo Boxes

71) The ________ order is the sequential advancing in a form from one field or control to the next.

Diff: 1

Objective: A7.03 Set the Tab Order

72) The ________ key is often used in a form to advance from one field to another.

Diff: 1

Objective: A7.03 Set the Tab Order

73) To display information from more than one table, forms often have ________.

Diff: 1

Objective: A7.04 Understand Subforms

74) A form contained inside of another form is called a(n) ________.

Diff: 1

Objective: A7.04 Understand Subforms

75) When you are creating a subform, you can use existing tables and queries or you can use an existing ________.

Diff: 3

Objective: A7.04 Understand Subforms

76) Often information such as report totals (averages, sums, etc.) are displayed in a report ________.

Diff: 1

Objective: A7.06 Understand Sections

77) Subforms can be created using ________, queries, or forms.

Diff: 2

Objective: A7.04 Understand Subforms

78) Subforms are generally laid out in a(n) ________ fashion.

Diff: 3

Objective: A7.04 Understand Subforms

79) ________ can be created from tables, queries, or existing forms.

Diff: 2

Objective: A7.04 Understand Subforms

80) An object on a form or report is called a(n) ________.

Diff: 2

Objective: A7.05 Understand Controls

81) ________ controls are dynamic.

Diff: 2

Objective: A7.05 Understand Controls

82) The title of a report would be an example of a(n) ________ control.

Diff: 2

Objective: A7.05 Understand Controls

83) A common control which displays the values in a field is called a(n) ________ Box control.

Diff: 2

Objective: A7.05 Understand Controls

84) A(n) ________ control displays the results of an expression in a form or report.

Diff: 2

Objective: A7.05 Understand Controls

85) If a control is considered non-data-related, then it is a(n) ________ control.

Diff: 1

Objective: A7.05 Understand Controls

86) Adding a(n) ________ Break control can insure that your report is paginated correctly.

Diff: 1

Objective: A7.05 Understand Controls

87) ________ controls are not connected to fields in a table or query.

Diff: 1

Objective: A7.05 Understand Controls

88) ________ controls are connected to a field on a query or table.

Diff: 1

Objective: A7.05 Understand Controls

89) ________ can display data, perform calculations, and add visual effects to a form or report.

Diff: 1

Objective: A7.05 Understand Controls

90) A(n) ________ is a part of a form or report that can be manipulated independently from other parts.

Diff: 2

Objective: A7.06 Understand Sections

91) Match the following terms with their descriptions:

I. Bound control

II. Unbound control

III. Calculated control

IV. Combo Box control

V. Control

A. Not connected to a field

B. Menu of options

C. Results of an expression

D. Connected to a field

E. Object on a form or report

Diff: 1

Objective: Multiple Objectives

92) Match the following terms with their descriptions:

I. Group footer

II. Group header

III. Page footer

IV. Page header

V. Section

A. Displays at the top of each unique group value

B. Displays at the top of each page

C. Can be manipulated independently of other areas

D. Displays at the bottom of each page

E. Displays at the bottom of each unique group value

Diff: 1

Objective: Multiple Objectives

93) Match the following terms with their descriptions:

I. Read-only form

II. Section bar

III. Subform

IV. Tab order

V. Control

A. Can be viewed, but not changed

B. Sequential order of fields

C. Marks top of a section

D. Object on a form or report

E. Usually displayed in tabular fashion

Diff: 1

Objective: Multiple Objectives

94) Match the following controls with the type of data they would contain:

I. Text box

II. Label

III. Image

IV. Calculated

V. Subform/Subreport

A. Form title

B. Picture

C. Field

D. Form or report inside of another form or report

E. Aggregated function

Diff: 1

Objective: Multiple Objectives

95) Match the following controls with how they would be used:

I. Page Break

II. Combo Box

III. Bound

IV. Unbound

V. Calculated

A. Simple math is one possibility

B. Is considered static

C. Is considered dynamic

D. Provide a menu of options

E. Aid in correct pagination

Diff: 1

Objective: Multiple Objectives

96) Match the following field properties with how they affect the form:

I. Row Source

II. Allow Additions

III. Allow Deletions

IV. Allow Edits

V. Tab Stop

A. Records can be deleted.

B. Records can be changed.

C. What table or query provides the data for the Combo Box.

D. Will pressing the tab key stop at this field.

E. New records can be created.

Diff: 1

Objective: Multiple Objectives

97) Match the following desired outcomes with the controls that would be used to produce that outcome:

I. Force new pages to start at the end of each group

II. Display a nice purple line after the data section

III. Allow the user to choose options from a list during data entry

IV. Decide how much a 10% raise would be for each employee

V. Add descriptive text to explain a field which displays travel pictures

A. Line

B. Calculated control in a Text box

C. Combo Box

D. Page Break

E. Label

Diff: 1

Objective: Multiple Objectives

98) Match the following terms with their descriptions:

I. Detail section

II. Form footer

III. Report footer

IV. Form header

V. Report header

A. Displays once at top of report

B. Where data is displayed

C. Displays once at bottom of form

D. Displays once at bottom of report

E. Displays once at top of report

Diff: 1

Objective: A7.06 Understand Sections