CIS 145: Access Chapter 07: Creating Advanced Forms

CIS 145: Access Chapter 07: Creating Advanced Forms

Multiple Choice Questions

31.After you create a form, which of the following tasks can you perform in Design view?
A. / add fields
B. / add labels
C. / add other controls
D. / all of the above
/ 32.Which of the following form sections displays information when a form is printed, and is only visible in Design or Print Preview view?
A. / Detail
B. / Form Header
C. / Page Header
D. / Page Footer
33.Which of the following form sections appears once at the top of the screen in Form view and at the top of the first page when the form is printed?
A. / Detail
B. / Form Header
C. / Page Header
D. / Page Footer
/ 34.Which of the following form sections displays totals or other information at the bottom of the form, and often contains other controls such as buttons?
A. / Detail
B. / Form Header
C. / Page Header
D. / Form Footer
35. Which of the following form sections displays the fields from each record and can also contain buttons and other controls?
A. Detail
B. Form Header
C. Page Header
D. Page Footer / 36. / Which of the following form sections appears at the top of every page when printed?
A. / Detail
B. / Form Header
C. / Page Header
D. / Page Footer
37. / Which of the following statements is true about changing the size of form sections?
A. / As you add controls or modify the size of controls in a section, you may need to adjust the height or width of a section.
B. / You should pay attention to the size of the Detail section since that section shows the data about records in the database.
C. / The control layout influences the size required for the Detail section.
D. / all of the above
38. / When using a form, which key moves the insertion point from one control to another?
A. / Enter
B. / Tab
C. / Shift
D. / both A and B
39. / Which of the following determines the order that Access navigates from one control to another?
A. / Tab Index property
B. / Tab Stop property
C. / Cycle property
D. / focus
40. / Which of the following refers to the ability of a control to receive input from the mouse or keyboard action?
A. / Tab Index property
B. / Tab Stop property
C. / Cycle property
D. / focus
41. / Which of the following determines whether the cursor stops at a control when the user pressed Tab or Enter?
A. / Tab Index property
B. / Tab Stop property
C. / Cycle property
D. / focus
42. / Which of the following properties controls what happens when the user tabs out of the last field in a record?
A. / Tab Index property
B. / Tab Stop property
C. / Cycle property
D. / focus
43. / Which of the following Cycle property settings causes Access to move to the first field of the current record when the user tabs out of the last field?
A. / All Records
B. / Current Record
C. / Current Page
D. / none of the above
44. / Which of the following properties determines whether a user can change the contents in a field?
A. / Locked property
B. / Enabled property
C. / Cycle property
D. / Border Color property
45. / Which of the following properties determines whether a control can have the focus?
A. / Locked property
B. / Enabled property
C. / Cycle property
D. / Border Color property
46. / Which of the following statements is true of the Locked property?
A. / If the Locked property is set to Yes, a user can tab into that field and also change the field.
B. / If the Locked property is set to Yes, a user can still tab into that field, but not change the field.
C. / If the Locked property is set to Yes, a user can't tab into that field.
D. / none of the above
47. / Which of the following properties should you do to prevent a user from accessing a form field?
A. / Locked property
B. / Enabled property
C. / Cycle property
D. / both A and B
48. / Which of the following choices in the Scroll Bars property prevents a scroll bar from ever appearing on a form?
A. / Both
B. / Neither
C. / Horizontal Only
D. / Vertical Only
49. / Which of the following choices in the Scroll Bars property displays a vertical scroll bar as needed on a form?
A. / Both
B. / Neither
C. / Horizontal Only
D. / Vertical Only
50. / Which of the following choices in the Scroll Bars property displays both horizontal and vertical scroll bars as needed on a form?
A. / Both
B. / Neither
C. / Horizontal Only
D. / Vertical Only
51. / Which of the following lets you add a subform into a main form?
A. / SubformWizard
B. / SubreportWizard
C. / Subform/SubreportWizard
D. / MainformWizard
52. / When linking a subform to a main form, which of the following statements is true?
A. / The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.
B. / The linking fields are typically the foreign key in the "one" table and the primary key in the "many" table.
C. / The linking fields are typically the primary key in the "one" table and the primary key in the "many" table.
D. / The linking fields are typically the foreign key in the "one" table and the foreign key in the "many" table.
53. / Which of the following statements is true about working with main forms and subforms?
A. / When you open a main form, the subform opens automatically.
B. / You can open the subform separately and edit just that object.
C. / After you add the subform to the main form, you will want to customize the overall form so that it has a professional appearance.
D. / all of the above
54. / Which of the following views will you use the most when editing a form?
A. / Design view
B. / Layout view
C. / Print Preview view
D. / both A and B
55. / Which of the following is a common modification that users need to make to forms?
A. / adjust the size and spacing of the text box and label controls
B. / modify the font characteristics of the text boxes
C. / change the border property
D. / all of the above
56. / Which of the following statements about subforms is true?
A. / The subform uses a datasheet layout.
B. / It is not possible to customize the font characteristics of individual fields on the subform.
C. / All fields on the subform use the same font characteristics.
D. / all of the above
57. / In which of the following views can you change the width of the labels on the subform?
A. / Design view
B. / Layout view
C. / Print Preview view
D. / both A and B
58. / In which of the following views can you change the captions in the labels on the subform?
A. / Design view
B. / Layout view
C. / Print Preview view
D. / both A and B
59. / Which of the following statements is true about a form's navigation buttons?
A. / Navigation buttons can be removed from a form.
B. / Navigation buttons can't be removed from a form.
C. / Navigation buttons can sometimes be removed from a form.
D. / Navigation buttons are only included on a form is there are more than three records in a table.
60. / In which of the following do users most commonly insert calculated controls?
A. / text box
B. / main form
C. / subform
D. / form header
61. / Which of the following must you use at the beginning of each calculated expression?
A. / +
B. / (
C. / =
D. / [
62. / Which of the following must you use to enclose fields used in an expression?
A. / +
B. / (
C. / =
D. / [
63. / Which of the following rules should you consider when adding a calculated control to a form?
A. / Enter the expression directly into the Control Source property.
B. / If you need more space to enter the expression, you can open the Expression Builder or Zoom window.
C. / Assign a name to the control in the Name property.
D. / all of the above
64. / In which of the following can you see the expression inside of a control?
A. / Design view
B. / Layout view
C. / Print Preview view
D. / both A and B
65. / Which of the following must you use to see an entire expression when it is longer than the size of the control?
A. / Design view
B. / Expression Builder
C. / Zoom window
D. / both B and C
66. / When aggregating over a group of records on the subform, where must you place the aggregate function?
A. / Form Header section
B. / Form Footer section
C. / Page Header section
D. / either A or B
67. / Which of the following must be true about expressions that refer to controls on another form?
A. / Inside the first set of brackets, substitute the name of the subform.
B. / Include the .Form! part of the expression exactly as written.
C. / The expression must have the following format: =[Subform Name].Form![Control Name]
D. / all of the above
68. / Which of the following is an error message that means that you have used an invalid name for a field, control, form, or function?
A. / #Name?
B. / #Error
C. / #Wrong
D. / #Change
69. / Which of the following is an error message that indicates that Access can't evaluate the expression that provides the control's value?
A. / #Name?
B. / #Error
C. / #Wrong
D. / #Change
70. / Which of the following should you do to correct either the #Name? error or the #Error error?
A. / Verify that names are spelled the same as they are in the actual form.
B. / Verify that names are spelled the same as controls in the database.
C. / Verify that the function name is spelled correctly.
D. / all of the above
71. / Which of the following should you do if the formula doesn't provide the correct answer?
A. / Review the structure of the formula.
B. / Make sure that you have used the correct fields in the formula.
C. / Make sure that you have used the correct aggregate function.
D. / all of the above
72. / Why might you want to enhance the design of a basic form?
A. / to make the form more visually appealing
B. / to make the form easier to use
C. / to make the form more helpful for users
D. / all of the above
73. / Which of the following do lines and rectangles help with on forms?
A. / separating controls
B. / providing a logical grouping around multiple controls
C. / differentiate areas in a form
D. / all of the above
74. / Which of the following does the Image button insert?
A. / embedded image
B. / shared image
C. / conditional formatting
D. / tab control
75. / Which of the following statements is true about images inserted using the Insert Image button?
A. / The image file is not stored as part of each form or report to which it is added.
B. / By using the Insert Image button instead of the Image button, the overall size of your database is reduced.
C. / The image file is stored once in the Image Gallery of the database.
D. / all of the above
76. / Which of the following statements is true about using the Insert Image button?
A. / Using images that are added to the Image Gallery conserves file space in the database.
B. / Using images that are added to the Image Gallery makes it easier to update shared images.
C. / Making a single change updates the image in all forms or reports where the image is used.
D. / all of the above
77. / Which of the following color properties sets a different background color for alternating rows in form layouts that show multiple records?
A. / Back Color
B. / Alternate Back Color
C. / Border Color
D. / Fore Color
78. / Which of the following color properties changes the font color of text that displays in a control?
A. / Back Color
B. / Alternate Back Color
C. / Border Color
D. / Fore Color
79. / Which of the following is not a design consideration when changing colors or fonts in a form?
A. / Use many colors.
B. / Avoid using too many fonts.
C. / Select fonts that create a professional, polished look.
D. / Verify that there is adequate contrast between the colors of the text and background on the form.
80. / Which of the following colors implies "stop" or "danger"?
A. / red
B. / green
C. / yellow
D. / black
81. / Which of the following colors implies "go" or "continue"?
A. / red
B. / green
C. / yellow
D. / black
82. / Which of the following keystroke combinations opens the Zoom window?
A. / F2
B. / Alt+F2
C. / Ctrl+F2
D. / Shift+F2
83. / Which of the following is a special type of form that contains tabs?
A. / tab control
B. / page
C. / navigation form
D. / parameter
84. / Which of the following creates a layered area on a form?
A. / tab control
B. / page
C. / navigation form
D. / parameter
85. / Which of the following contains its own controls and is the name given to each layered area on a form?
A. / tab control
B. / page
C. / navigation form
D. / parameter
86. / Which of the following statements is true about modifying a navigation form?
A. / When a navigation form is created, it includes an Auto_Header() label added into the Form Header section.
B. / Edit the contents of the Caption property to change the wording of the label at the top of the navigation form.
C. / By default, the navigation tab displays as a rectangle.
D. / all of the above
87. / When this property is set to NO, the navigation buttons do not appear at the bottom of the form.
A. / Pop Up property
B. / Modal property
C. / Record Selectors property
D. / Navigation Buttons property
88. / When this property is set to YES, the form opens as a pop up box instead of a full size form.
A. / Pop Up property
B. / Modal property
C. / Record Selectors property
D. / Navigation Buttons property
89. / When this property is set to NO, the record selector does not appear to the left of the form.
A. / Pop Up property
B. / Modal property
C. / Record Selectors property
D. / Navigation Buttons property
90. / When this property is set to YES, users are required to do something with the form before they can do anything else, like click the Ribbon.
A. / Pop Up property
B. / Modal property
C. / Record Selectors property
D. / Navigation Buttons property

7-1