Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell -Test Bank

<< Microeconomics Student Value Edition 8th Edition by Robert Pindyck -Test Bank Modern Systems Analysis And Design 6th Edition By Jeffry E.Hoofer -Test Bank >>
Product Code: 222
Availability: In Stock
Price: $24.99
Qty:     - OR -   Add to Wish List
Add to Compare

Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell -Test Bank

Description

WITH ANSWERS

Microsoft Office Access 2013 Complete In Practice 1st Edition By Annette Easton and Randy Nordell -Test Bank

Access Chapter 04

Creating and Using Forms and Reports

 

True / False Questions

1. A bound form contains a link to the data source.

True    False

 

2. When working with forms, Form view allows you to make changes to the form.

True    False

 

3. The Form Wizard steps you through the process of quickly creating a form.

True    False

 

4. After you create a form, you can edit the form in Layout view or Design view.

True    False

 

5. A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

True    False

 

6. When modifying a form, Design view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

True    False

 

7. In Access, fields, labels, and buttons are called objects.

True    False

 

8. Some form controls are unbound, which means that they are not linked to a data source.

True    False

 

9. A text box that gets its value from an expression is a calculated control.

True    False

 

10. To organize controls vertically on a form, use a tabular layout.

True    False

 

11. When a new blank form is created, there are no controls initially placed on the form.

True    False

 

12. When adding fields to a form, press Ctrl+F8 to show or hide the Field List.

True    False

 

13. In a stacked form layout, all of the fields have the same width.

True    False

 

14. It is a good design practice to add a title to a form.

True    False

 

15. Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

True    False

 

16. The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

True    False

 

17. A check box is a database object that allows you to write and attach code to different objects and controls in your database.

True    False

 

18. The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

True    False

 

19. Like forms, reports allow you to modify the underlying data source.

True    False

 

20. A stepped report layout displays the fields in a horizontal, justified layout.

True    False

 

21. After you create a report using the Report Wizard, its possible to modify the layout of the report in Design view.

True    False

 

22. When viewing a report, Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

True    False

 

23. It is possible to click and drag a field into the report window to add it into the control layout.

True    False

 

24. On the Design tab, selecting the Title button adds a title into the header section of the report.

True    False

 

25. An ascending sort for a date field is from oldest to newest.

True    False

 

26. Access allows you to sort on multiple fields only if each field is sorted in ascending order.

True    False

 

27. When defining multiple conditional formatting rules, the order in which the rules are listed is not important.

True    False

 

28. When working with multiple conditional formatting rules, Access stops evaluating when a match is found.

True    False

 

29. You can have a maximum of one conditional formatting rule in a report.

True    False

 

30. The Conditional Formatting Rules Manager only displays rules for one field at a time.

True    False

 

 

Multiple Choice Questions

31. What does Access call a form that is directly connected to a table or query, the source of the data?

A. bound form

 

B. connected form

 

C. unbound form

 

D. split form

 

32. What does Access call a form that doesnt have a connection to a data source?

A. bound form

 

B. connected form

 

C. unbound form

 

D. disconnected form

 

33. When working with forms, which of the following views would you use if you want to alter the design of a form and see the effects of the changes in real time?

A. Form view

 

B. Design view

 

C. Layout view

 

D. Datasheet view

 

34. When working with forms, which of the following views would you use if you want to enter and view data?

A. Form view

 

B. Design view

 

C. Layout view

 

D. Datasheet view

 

35. When working with forms, which of the following views would you use if you want to view the completed structure of the form so you can modify any aspect of the form?

A. Form view

 

B. Design view

 

C. Layout view

 

D. Datasheet view

 

36. When creating a form using the Form Wizard, which of the following layout options would you use to display the fields in a table (row and column) format?

A. Columnar

 

B. Tabular

 

C. Datasheet

 

D. Justified

 

37. When creating a form using the Form Wizard, which of the following layout options would you use to display just one record at a time?

A. Columnar

 

B. Tabular

 

C. Datasheet

 

D. Justified

 

38. Which of the following allows you to view data in two different ways at the same time, with the top section showing one record in a columnar mode and the bottom section displaying in Datasheet view?

A. bound form

 

B. connected form

 

C. unbound form

 

D. split form

 

39. When modifying a form, which of the following views is best when you want to resize a field or label, change colors or text alignment, or apply different formats?

A. Form view

 

B. Design view

 

C. Layout view

 

D. Datasheet view

 

40. In Access, what are the fields, labels, and buttons called?

A. objects

 

B. controls

 

C. commands

 

D. layouts

 

41. What is a text box that gets its value from a field in a table?

A. bound control

 

B. unbound control

 

C. calculated control

 

D. stacked control

 

42. What is a text box that gets its value from an expression?

A. bound control

 

B. unbound control

 

C. calculated control

 

D. stacked control

 

43. Which of the following is used to display or accept data for a field with a Yes/No data type?

A. text box

 

B. label

 

C. command button

 

D. check boxes

 

44. Which of the following is used to perform an action such as Close Form, Open Form, Delete Record, and so on?

A. text box

 

B. label

 

C. command button

 

D. check box

 

45. What is the main advantage of using one of Accesss control layouts when designing a form?

A. Control layouts provide structure.

 

B. Control layouts let you easily insert all of the fields in your data source into your form.

 

C. Control layouts provide visual appeal with varied themes.

 

D. Control layouts are compatible with other software applications.

 

46. When adding fields to a form, which of the following keyboard shortcuts lets you show or hide the Field List?

A. Shift+F8

 

B. Ctrl+F8

 

C. Alt+F8

 

D. Shift+F9

 

47. Which of the following control layouts organizes data vertically?

A. tabular layout

 

B. datasheet layout

 

C. stacked layout

 

D. vertical layout

 

48. To select multiple controls at once, what must you press and hold down while selecting controls?

A. F3

 

B. Alt

 

C. Ctrl

 

D. Shift

 

49. Which of the following can you use to select the desired settings to limit actions available in a form?

A. Conditional Formatting Rules Manager

 

B. control layouts

 

C. Property Sheet

 

D. Command Button Wizard

 

50. Which of the following can you use to print the current form, close the current form, navigate to the next record, or open another form?

A. text box

 

B. label

 

C. command button

 

D. check box

 

51. Which of the following creates a button and attaches all of the necessary functionality to the button?

A. Conditional Formatting Rules Manager

 

B. control layouts

 

C. Property Sheet

 

D. Command Button Wizard

 

52. If you are displaying a form in Design view, what can you press to display the form in Form view?

A. F3

 

B. F5

 

C. F7

 

D. F8

 

53. Which of the following should you use to restrict a form to only allow data entry when you dont want the user to be able to view data already in the database?

A. Allow Edits property

 

B. Allow Deletions property

 

C. Data Entry property

 

D. Tabular control layout

 

54. Which of the following can you add to a form to automate user tasks?

A. text box

 

B. label

 

C. command button

 

D. check box

 

55. Which of the following report layouts displays fields in one column?

A. columnar

 

B. tabular

 

C. justified

 

D. stepped

 

56. Which of the following report layouts displays fields in a horizontal layout?

A. columnar

 

B. tabular

 

C. justified

 

D. stepped

 

57. Which of the following report layouts displays fields in a row and column format?

A. columnar

 

B. tabular

 

C. justified

 

D. stepped

 

58. Which of the following views is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time?

A. Report view

 

B. Print Preview view

 

C. Design view

 

D. Layout view

 

59. Which of the following views lets you see how the report will look in print and also allows you to make modifications to the print settings?

A. Report view

 

B. Print Preview view

 

C. Design view

 

D. Layout view

 

60. Which of the following views divides a report into the following three sections: Page Header, the Detail, and the Page Footer?

A. Report view

 

B. Print Preview view

 

C. Design view

 

D. Layout view

 

61. Which of the following views is good for resizing fields or labels, changing colors or text alignment, or applying different formats?

A. Report view

 

B. Print Preview view

 

C. Design view

 

D. Layout view

 

62. Which of the following should you use to create a report if you are short on time?

A. Report view

 

B. Report Wizard

 

C. Form Wizard

 

D. Command Button Wizard

 

63. Which of the following is true about blank reports?

A. They use the tabular layout.

 

B. They use the stacked layout.

 

C. They dont contain any controls.

 

D. The header area contains a default title.

 

64. Which of the following layouts places labels to the left of the data control?

A. tabular layout

 

B. stacked layout

 

C. justified layout

 

D. grouped layout

 

65. Which of the following layouts places labels above the data values?

A. tabular layout

 

B. stacked layout

 

C. justified layout

 

D. grouped layout

 

66. In a report, which of the following controls gets its value from an expression?

A. bound control

 

B. unbound control

 

C. calculated control

 

D. stacked control

 

67. Which of the following indicates that a control has been selected?

A. an orange border

 

B. a green border

 

C. a red border

 

D. a red dashed border

 

68. Where are a reports title, the current date, and page numbers typically placed in a report?

A. Detail area

 

B. Page Header area

 

C. Page Footer area

 

D. Page Header and Page Footer areas

 

69. Which of the following buttons adds two controls into the header section, an Auto_Header control which contains the title and an Auto_Logo control which can contain a logo?

A. Date and Time button

 

B. Logo button

 

C. Page Numbers button

 

D. Title button

 

70. Which of the following is useful when you want to organize and summarize you data?

A. sorting

 

B. conditional formatting

 

C. a split form

 

D. grouping

 

71. Which of the following would you want to use in a report to include all properties from the same city together in a real estate database?

A. sorting

 

B. conditional formatting

 

C. a split form

 

D. grouping

 

72. Which of the following can be added to a report independent of grouping or sorting being used?

A. unbound form

 

B. bound form

 

C. totals

 

D. control layout

 

73. For date fields, what is the default sort order?

A. newest to oldest

 

B. oldest to newest

 

C. largest to smallest

 

D. smallest to largest

 

74. For number fields, what is the default sort order?

A. newest to oldest

 

B. oldest to newest

 

C. largest to smallest

 

D. smallest to largest

 

75. Which of the following options in the Group, Sort, and Total pane calculates overall totals for all records?

A. Select the field and type of calculation

 

B. Show grand totals

 

C. Show group totals as percent of grand total

 

D. Show in header or footer section

 

76. Which of the following options in the Group, Sort, and Total pane determines which section displays the totals?

A. Select the field and type of calculation

 

B. Show grand totals

 

C. Show group totals as percent of grand total

 

D. Show in header or footer section

 

77. Which of the following grouping options would you want to use to group records by the first character of a field?

A. By entire value

 

B. By partial value

 

C. Custom

 

D. Ascending or descending sort

 

78. Which of the following grouping options would you want to use to group records based on a specific number of characters that you provide?

A. By entire value

 

B. By partial value

 

C. Custom

 

D. Ascending or descending sort

 

79. Which of the following grouping options would you want to use to group records based on the entire value in a selected field?

A. By entire value

 

B. By partial value

 

C. Custom

 

D. Ascending or descending sort

 

80. Which of the following allows you to format only values that meet a specified condition?

A. Rules Manager

 

B. conditional formatting

 

C. split form

 

D. Report Wizard

 

81. In addition to selecting the rule type and conditions, what else must you select when building a rule?

A. command buttons

 

B. bound controls

 

C. a control layout

 

D. desired formatting

 

82. When using multiple conditional formatting rules, which of the following statements is true?

A. The order of the rules is unimportant.

 

B. The order of the rules is important.

 

C. Access continues to evaluate rules after a match is found.

 

D. all of the above

 

83. Which of the following is true of the Conditional Formatting Rules Manager?

A. It displays a single rule for a single field at a time.

 

B. It displays one or more rules for a single field at a time.

 

C. You cannot edit a rule using the Conditional Formatting Rules Manager.

 

D. You cannot delete a rule using the Conditional Formatting Rules Manager.

 

84. Which of the following is true of adding conditional formatting to a report?

A. The order of rules is not important.

 

B. Access continues evaluating rules even when a match is found.

 

C. You can only set rules one field at a time.

 

D. You can select multiple fields and apply the same rule to all selected fields.

 

85. Which of the following allows you to add, modify, and delete rules?

A. Conditional Formatting Rules Manager

 

B. Report Wizard

 

C. Design tab

 

D. Format tab

 

86. When adding totals to a report, which of the following calculation options tracks the highest value in a field?

A. Sum

 

B. Count Values

 

C. Max

 

D. Standard Deviation

 

87. When adding totals to a report, which of the following calculation options counts up the number of records that meet a certain condition?

A. Sum

 

B. Count Values

 

C. Max

 

D. Standard Deviation

 

88. When adding totals to a report, which of the following calculation options totals up the values in a particular field?

A. Sum

 

B. Count Values

 

C. Max

 

D. Standard Deviation

 

89. What can you use to ensure that your report prints as desired?

A. Normal view

 

B. Layout view

 

C. Design view

 

D. Print Preview view

 

90. Which of the following would you change in order to view a report using a landscape orientation?

A. page size

 

B. margins

 

C. page orientation

 

D. headers and footers

 

 

Essay Questions

91. What are forms used for? What is the difference between a bound form and an unbound form?

 

 

 

 

92. When using the Form Wizard to create a form based on one table, what four layout options can you choose from?

 

 

 

 

93. What is a split form and why is it useful?

 

 

 

 

94. What is a control and how are they used on forms? Describe what bound, unbound, and calculated controls are and provide an example of each.

 

 

 

 

95. What are control layouts? What are the two primary control layout options?

 

 

 

 

96. Once created, why is it important to test a form? What is involved with testing a form?

 

 

 

 

97. When would you want to use Accesss grouping options? What are the three layout choices for a grouped report?

 

 

 

 

98. What are some of the tasks you might perform when customizing a report in Layout view?

 

 

 

 

99. What does it mean to group, sort, and add totals to a report?

 

 

 

 

100. What is conditional formatting and why is it useful? How do you apply conditional formatting to a report?

 

 

 

 

Access Chapter 04 Creating and Using Forms and Reports Answer Key
 

True / False Questions

1.
(p. A4-214)
A bound form contains a link to the data source.

TRUE

Bound forms are linked to the data source.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: Creating a Simple Form from a Table
 

 

2.
(p. A4-214)
When working with forms, Form view allows you to make changes to the form.

FALSE

When working with forms, Form view is used to enter and view data.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: Creating a Simple Form from a Table
 

 

3.
(p. A4-214)
The Form Wizard steps you through the process of quickly creating a form.

TRUE

The Form Wizard steps you through the process of quickly creating a form.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: Creating a Simple Form from a Table
 

 

4.
(p. A4-216)
After you create a form, you can edit the form in Layout view or Design view.

TRUE

After you create a form, you can edit the form in Layout view or Design view.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: The Form Button
 

 

5.
(p. A4-217)
A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

TRUE

A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: The Split Form Button
 

 

6.
(p. A4-218)
When modifying a form, Design view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

FALSE

When modifying a form, Layout view allows you to make changes to the design of a form while seeing how the form looks with data displaying.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-01
Skill: Modify a Form
 

 

7.
(p. A4-222)
In Access, fields, labels, and buttons are called objects.

FALSE

In Access, fields, labels, and buttons are called controls.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Controls
 

 

8.
(p. A4-223)
Some form controls are unbound, which means that they are not linked to a data source.

TRUE

Some form controls are unbound, which means that they are not linked to a data source.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Controls
 

 

9.
(p. A4-223)
A text box that gets its value from an expression is a calculated control.

TRUE

A text box that gets its value from an expression is a calculated control.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Controls
 

 

10.
(p. A4-223)
To organize controls vertically on a form, use a tabular layout.

FALSE

To organize controls vertically on a form, use a stacked layout.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Control Layouts
 

 

11.
(p. A4-223)
When a new blank form is created, there are no controls initially placed on the form.

TRUE

When a new blank form is created, there are no controls initially placed on the form.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Add Fields to a Control Layout
 

 

12.
(p. A4-224)
When adding fields to a form, press Ctrl+F8 to show or hide the Field List.

FALSE

When adding fields to a form, press Alt+F8 to show or hide the Field List.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Add Fields to a Control Layout
 

 

13.
(p. A4-225)
In a stacked form layout, all of the fields have the same width.

TRUE

In a stacked form layout, all of the fields have the same width.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Adjust Column Widths
 

 

14.
(p. A4-227)
It is a good design practice to add a title to a form.

TRUE

It is a good design practice to add a title to a form.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-02
Skill: Add a Title, Date, and Logo to a Form
 

 

15.
(p. A4-228)
Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

TRUE

Use the Property Sheet of the form to select the desired settings to limit actions available in a form.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-03
Skill: Facilitating Data Input with a Form
 

 

16.
(p. A4-230)
The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

TRUE

The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-03
Skill: Add a Command Button
 

 

17.
(p. A4-230)
A check box is a database object that allows you to write and attach code to different objects and controls in your database.

FALSE

A macro is a database object that allows you to write and attach code to different objects and controls in your database.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-03
Skill: Add a Command Button
 

 

18.
(p. A4-230)
The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

TRUE

The Control Wizards tool directs Access to launch an available wizard when adding controls to an object.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-03
Skill: Add a Command Button
 

 

19.
(p. A4-235)
Like forms, reports allow you to modify the underlying data source.

FALSE

Unlike forms, reports do not allow you to modify the underlying data.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-04
Skill: Creating a Simple Report
 

 

20.
(p. A4-236)
A stepped report layout displays the fields in a horizontal, justified layout.

FALSE

A stepped report layout displays the fields in a table layout.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-04
Skill: The Report Wizard
 

 

21.
(p. A4-237)
After you create a report using the Report Wizard, its possible to modify the layout of the report in Design view.

TRUE

After you create a report using the Report Wizard, its possible to modify the layout of the report in Design view.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-04
Skill: The Report Wizard
 

 

22.
(p. A4-240)
When viewing a report, Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

FALSE

When viewing a report, Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-04
Skill: View or Modify a Report
 

 

23.
(p. A4-243)
It is possible to click and drag a field into the report window to add it into the control layout.

TRUE

It is possible to click and drag a field into the report window to add it into the control layout.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-05
Skill: Add and Delete Fields in a Control Layout
 

 

24.
(p. A4-247)
On the Design tab, selecting the Title button adds a title into the header section of the report.

TRUE

On the Design tab, selecting the Title button adds a title into the header section of the report.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-05
Skill: Add a Title, a Date, or Page Numbers to a Report
 

 

25.
(p. A4-252)
An ascending sort for a date field is from oldest to newest.

TRUE

An ascending sort for a date field is from oldest to newest.

 

Blooms: Remember
Difficulty: 1 Easy
SLO: 04-06
Skill: Group and Sort Options
 

 

26.
(p. A4-250)
Access allows you to sort on multiple fields only if each field is sorted in ascending order.

FALSE

Access allows you to sort on multiple fields, with each field having its own sort order.

 

Blooms: Remember
Diffic

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below:



 

Once the order is placed, the order will be delivered to your email less than 24 hours, mostly within 4 hours. 

If you have questions, you can contact us here