ENHANCED MICROSOFT ACCESS 2013 COMPREHENSIVE 1ST EDITION BY PRATT - TEST BANK

ENHANCED MICROSOFT ACCESS 2013 COMPREHENSIVE 1ST EDITION BY PRATT - TEST BANK   Instant Download - Complete Test Bank With Answers     Sample Questions Are Posted Below   1. The ____ data type can store up to a gigabyte of text.   a. Variable b. Attachment   c. VarChar d. Long Text   ANSWER:   d …

$19.99

ENHANCED MICROSOFT ACCESS 2013 COMPREHENSIVE 1ST EDITION BY PRATT – TEST BANK

 

Instant Download – Complete Test Bank With Answers

 

 

Sample Questions Are Posted Below

 

1. The ____ data type can store up to a gigabyte of text.

  a. Variable b. Attachment
  c. VarChar d. Long Text

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 269

 

2. To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

  a. Modify Table b. Change Table
  c. Design View d. Modify View

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 269-AC 270

 

3. To use the Input Mask Wizard, select the Input Mask property in the field’s property sheet and then select the ____ button.

  a. Wizard b. Build
  c. Input Mask d. Expression

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 270

 

 

4. In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.

  a. field selector b. horizontal scroll bar
  c. vertical scroll bar d. datasheet

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 277

 

5. In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the ____ to the desired size.

  a. horizontal scroll bar b. vertical scroll bar
  c. datasheet d. record selector

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 277

 

6. In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the column size.

  a. Field Width b. Field Size
  c. Width d. Size

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 277

 

7. In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the record selector, and tap or click ____ to change the row spacing.

  a. Height b. Row Spacing
  c. Row Height d. Size

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 277

 

8. To undo changes to the row height, press and hold or right-click the row selector, click Row Height on the shortcut menu, and then tap or click the ____ check box in the Row Height dialog box.

  a. Default b. Undo
  c. Standard Height d. Reverse

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 278

 

9. To undo changes to the column width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.

  a. Default b. Standard Width
  c. Reverse d. Undo

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 278

 

10. To insert data into an OLE Object field, use ____ command on the OLE’s shortcut menu.

  a. Insert Object b. Create
  c. Create my Picture d. Insert Picture

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 278

 

11. To insert data into an Attachment field, use the ____ command on the Attachment field’s shortcut menu.

  a. Insert Attachments b. Insert Objects
  c. Manage Objects d. Manage Attachments

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 280

 

12. To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

  a. Object b. Picture Object
  c. Convert Object d. Bitmap Image Object

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 282

 

13. To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.

  a. Insert Hyperlink b. Insert Object
  c. Edit Hyperlink d. Attach Hyperlink

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 282

 

14. To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

  a. View b. Picture
  c. Display d. Open

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 282

 

15. To view attachments in a field, press and hold or right-click the field, and then tap or click ____ on the shortcut menu.

  a. View Attachments b. Open
  c. Manage Attachments d. View

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 282

 

16. A form that is contained within another form is called a(n) ____.

  a. subform b. inner form
  c. dependent form d. hyperform

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 283

 

17. To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

  a. Design View b. Form Design
  c. Blank Form d. New Form

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 283-AC 284

 

18. To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

  a. Show Table b. Display Fields
  c. Field List d. Add Existing Fields

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 284

 

19. To save a form and assign it a name, tap or click the Save button on the ____.

  a. FORM DESIGN TOOLS DESIGN tab b. Quick Access Toolbar
  c. HOME tab d. CREATE tab

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 285

 

20. To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment button on the ____ tab.

  a. CREATE b. FORM DESIGN TOOLS DESIGN
  c. HOME d. FORM DESIGN TOOLS ARRANGE

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 286

 

21. To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

  a. Background Color b. Color
  c. Fill d. Format

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 290

 

22. To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

  a. Background b. Format
  c. Back Color d. Fill/Back Color

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 290-AC 291

 

23. To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

  a. Form Title b. Name
  c. Title d. Text Box

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 291

 

24. To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

  a. Add Section b. Form Header/Footer
  c. Insert Header d. Arrange

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 291

 

25. To place a subform on a form, use the Subform/Subreport tool on the ____ tab.

  a. FORM DESIGN TOOLS DESIGN b. CREATE
  c. HOME d. FORM DESIGN TOOLS ARRANGE

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 292

 

26. To switch from Design view to Form view to display the form, tap or click the ____ button.

  a. Display b. Open
  c. Window d. View

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 295

 

27. To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.

  a. Open b. Modify
  c. Change Columns d. Resize

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 296

 

28. To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

  a. Picture b. Size Mode
  c. Cropping d. Alignment

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 299

 

29. To change the font color of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a color palette.

  a. Color b. Label Color
  c. Font Color d. Text Color

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 300

 

30. To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

  a. Property Sheet b. Special Effect
  c. Properties d. Labels

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 300-AC 301

 

31. To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

  a. Tab b. Order
  c. Arrangement d. Property Sheet

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 304

 

32. To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.

  a. HOME b. FORM DESIGN TOOLS ARRANGE
  c. CREATE d. FORM DESIGN TOOLS DESIGN

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 304

 

33. To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

  a. View b. Form
  c. Mode d. Open

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 305

 

34. To go to a specific record in the main form, enter the record number in the ____ box for the main form.

  a. Go to Record b. Current Record
  c. Next Record d. Find Record

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 307

 

35. To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

  a. HOME b. CREATE
  c. DATABASE TOOLS d. DESIGN

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 308

 

36. To test for the current date in a query, type ____ in the Criteria row of the appropriate column.

  a. Current() b. CurrentDate()
  c. Today() d. Date()

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 309

 

37. The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.

  a. *education b. ?education
  c. *education* d. ?education?

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 310

 

38. To create a simple form with a datasheet, select the table that is the “one” part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

  a. Simple Form b. Datasheet Form
  c. Form Design d. Form

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 312

 

39. To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

  a. Layout Form b. Layout View
  c. Blank Form d. Datasheet Form

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 314

 

40. To create a multiple-table form based on the “many” table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

  a. Multitable Form b. Blank Form
  c. Many Form d. Layout Form

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 315

 

Modified Multiple Choice

 

41. A field with the Attachment data type can contain ____.

  a. Word documents b. Excel spreadsheets
  c. Pictures d. Boolean operators

 

ANSWER:   a, b, c
POINTS:   1
REFERENCES:   AC 269

 

42. You can use the ____ data type for a Picture field.

  a. OLE Object b. Short Text
  c. Long Text d. Attachment

 

ANSWER:   a, d
POINTS:   1
REFERENCES:   AC 269

 

43. An OLE Object field can store ____.

  a. video clips b. Access tables
  c. sound d. pictures

 

ANSWER:   a, c, d
POINTS:   1
REFERENCES:   AC 269

 

44. A field with the Hyperlink data type can contain links to ____.

  a. web pages b. Office documents
  c. email addresses d. fields in a table

 

ANSWER:   a, b, c
POINTS:   1
REFERENCES:   AC 273

 

45. The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

  a. Default b. Clip
  c. Stretch d. Zoom

 

ANSWER:   b, c, d
POINTS:   1
REFERENCES:   AC 299

 

46. You can use the OLE Object data type or the Attachment data type to store a picture.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

47. In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

48. When you add an input mask to a field, the data type for the field changes to Input Mask.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 272

 

49. When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 274

 

50. When you enter data in a long text field, Access automatically expands the row and column to display all the data in the field.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 276

 

51. Rows in a datasheet may be different sizes.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 277

 

52. When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 278

 

53. Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 278

 

54. When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 278

 

55. Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 282

 

56. To select more than one control at a time on a form, press and hold down the ALT key as you select additional controls.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 286

 

57. You can use the ruler to select multiple controls.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 286

 

58. To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment buttons on the ALIGN tab.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 286

 

59. When you add a title to a form using the Title button, Access places the title in the Detail section.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 291

 

60. When a form includes a subform, the subform is a separate object in the database.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 296

 

 

61. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Stretch size mode is the best option for photographs.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

62. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The three possible size modes are: Clip, Stretch, and Zoom.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

63. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Cut size mode displays only the portion of the picture that will fit in the space allocated to it.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

64. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned correctly.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

65. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. To change the size mode, use the property sheet.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

66. Access only allows you to change the font and font size for a label on a form.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

67. You cannot change the size of the property sheet.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 300

 

68. Once the tab order for fields is determined, it cannot be changed.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 304

 

69. A form that contains a subform includes navigation buttons for both the form and subform.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 305

 

70. To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 307

 

71. An input mask specifies how data is to be entered and how it will appear. ____________________

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

72. To change the size of a row, you use a record’s record selector. ____________________

ANSWER:   True
POINTS:   1
REFERENCES:   AC 276

 

73. To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View. ____________________

ANSWER:   False – Open
POINTS:   1
REFERENCES:   AC 282

 

74. Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed. ____________________

ANSWER:   False – Stop, stop
POINTS:   1
REFERENCES:   AC 304

 

75. If you create a form with the Form button for a table that is the “one” table in a one-to-many relationship, Access automatically includes the “many” table in a subform. ____________________

ANSWER:   False – datasheet
POINTS:   1
REFERENCES:   AC 312

 

 

76. The accompanying figure shows the Book Rep table. The Phone Number field in this table uses a(n) ____________________, which specifies how data is to be entered and how it will appear.

ANSWER:   input mask
POINTS:   1
REFERENCES:   AC 269

 

77. In the accompanying figure, the paper clip indicates that the field is a(n) ____________________ field.

ANSWER:   Attachment
attachment
POINTS:   1
REFERENCES:   AC 269

 

78. In the accompanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

ANSWER:   Object Linking and Embedding
object linking and embedding
POINTS:   1
REFERENCES:   AC 273

 

79. In the accompanying figure, the data type of ___________________ is used for the Comment field because the field contains text that is variable in length and potentially very long.

ANSWER:   Long Text
long text
POINTS:   1
REFERENCES:   AC 273

 

80. In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________, which is the bar containing the field name.

ANSWER:   field selector
POINTS:   1
REFERENCES:   AC 276

 

81. You can enter data in a long text field using the ____________________ dialog box.

ANSWER:   Zoom
POINTS:   1
REFERENCES:   AC 278

 

82. To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field’s shortcut menu.

ANSWER:   Insert Object
insert object
POINTS:   1
REFERENCES:   AC 278

 

83. To insert data into an Attachment field, use the ____________________ command on the Attachment field’s shortcut menu.

ANSWER:   Manage Attachments
manage attachments
POINTS:   1
REFERENCES:   AC 280

 

84. To insert data into a Hyperlink field, use the ____________________ command on the Hyperlink field’s shortcut menu.

ANSWER:   Edit Hyperlink
edit hyperlink
POINTS:   1
REFERENCES:   AC 282

 

85. To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click ____________________ on the shortcut menu, and then tap or click Open.

ANSWER:   Bitmap Image Object
bitmap image object
POINTS:   1
REFERENCES:   AC 282

 

86. If one book rep can represent many customers, the relationship between book rep and customers is called a(n) ____________________ relationship.

ANSWER:   one-to-many
one to many
POINTS:   1
REFERENCES:   AC 283

 

87. A(n) ____________________ is a form that is contained within another form.

ANSWER:   subform
POINTS:   1
REFERENCES:   AC 283

 

88. The form in which the subform is contained is called the ____________________.

ANSWER:   main form
POINTS:   1
REFERENCES:   AC 283

 

89. When a form includes a subform, the ___________________ contains data from the many table in a one-to-many relationship.

ANSWER:   subform
POINTS:   1
REFERENCES:   AC 283

 

90. To select more than one control at a time, press and hold down the ____________________ key(s) as you select additional controls.

ANSWER:   SHIFT
shift
POINTS:   1
REFERENCES:   AC 286

 

91. To add a title to a form, tap or click the ____________________ button on the FORM DESIGN TOOLS DESIGN tab.

ANSWER:   Title
title
POINTS:   1
REFERENCES:   AC 291

 

92. To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____________________ on the shortcut menu.

ANSWER:   Form Header/Footer
form header/footer
POINTS:   1
REFERENCES:   AC 291

 

93. The best size mode to use for photographs is ____________________ size mode.

ANSWER:   Zoom
zoom
POINTS:   1
REFERENCES:   AC 299

 

94. To give a label an etched appearance, change the ________________________ property for the label.

ANSWER:   Special Effect
special effect
POINTS:   1
REFERENCES:   AC 301

 

95. To have the TAB key bypass a control, change the ___________________ property.

ANSWER:   Tab Stop
tab stop
POINTS:   1
REFERENCES:   AC 304

 

96. The portion of a picture that appears as well as the way it appears is determined by the size mode. What are the three possible size modes and how do they affect a picture?

ANSWER:   1. Clip — Displays only the portion of the picture that will fit in the space allocated to it.
2. Stretch — Expands or shrinks the picture to fit the precise space allocated on the screen.
3. Zoom — Does the best job of fitting the picture to the allocated space without changing the look of the picture.
POINTS:   1
REFERENCES:   AC 299
TOPICS:   Critical Thinking

 

97. What is the difference between the Tab Stop property and Tab Order?

ANSWER:   The Tab Stop property determines whether users bypass a control on a form when they press the TAB key. If the Tab Stop property for a control is set to No, the control is bypassed when the TAB key is pressed.

Tab Order determines the order in which fields are encountered when the TAB key is pressed. You can change the order by tapping or clicking the Tab Order button on the FORM DESIGN TOOLS DESIGN tab.

POINTS:   1
REFERENCES:   AC 304
TOPICS:   Critical Thinking

 

98. There are at least two reasons for viewing information on dependencies between database objects. What are these reasons?

ANSWER:   1. Viewing a list of objects that use a specific object helps in the maintenance of a database and avoids errors when changes are made to the objects involved in the dependency.
2. If you are unfamiliar with a database, viewing object dependencies can help you better understand the structure of the database.
POINTS:   1
REFERENCES:   AC 307-AC 308
TOPICS:   Critical Thinking

 

Critical Thinking Questions
Case 5-1

An employee at Bavant Publishing would like to add some additional fields to the Customer table. He needs to add fields that will store the web page for a customer, as well as whether or not the customer participates in a preferred customer program.

 

99. What data type should the employee assign to the field that will contain the web page?

ANSWER:   Hyperlink
POINTS:   1
REFERENCES:   AC 273
TOPICS:   Critical Thinking

 

100. What data type is appropriate for a field that indicates whether the customer participates in the preferred customer program?

ANSWER:   Yes/No
POINTS:   1
REFERENCES:   AC 273
TOPICS:   Critical Thinking

 

Critical Thinking Questions
Case 5-2

An employee at Bavant Publishing would like to query the Book Rep table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria.

 

101. What would the employee enter in the Criteria row of the Start Date field to find all book reps who started before January 1, 2013?

ANSWER:   <1/1/2013
POINTS:   1
REFERENCES:   AC 310
TOPICS:   Critical Thinking

 

102. What would the employee enter in the Criteria row for the Comment field to find all book reps who understand or speak the Spanish language?

ANSWER:   *spanish*
POINTS:   1
REFERENCES:   AC 310
TOPICS:   Critical Thinking

 

Identify the letter of the choice that best matches the phrase or definition.

a. Form
b. CTRL+TAB
c. Add Existing Fields
d. SHIFT
e. INSERT
f. Object Dependencies
g. TAB
h. Property Sheet
i. CTRL+SHIFT+TAB
j. Form Design

 

REFERENCES:   AC 271
AC 312
AC 286
AC 308
AC 307
AC 284
AC 300
AC 307
AC 284
AC 307

 

103. Key or key combination that will insert a blank row in a table in Design view.

ANSWER:   e
POINTS:   1

 

104. Button on the CREATE tab that creates a simple form with a datasheet.

ANSWER:   a
POINTS:   1

 

105. Key or key combination that will select multiple controls.

ANSWER:   d
POINTS:   1

 

106. Button on the DATABASE TOOLS tab that will display dependencies between database objects.

ANSWER:   f
POINTS:   1

 

107. Key or key combination that will move from the last field in the main form to the first field in the subform.

ANSWER:   g
POINTS:   1

 

108. Button on the FORM DESIGN TOOLS DESIGN tab that displays a field list.

ANSWER:   c
POINTS:   1

 

109. Button on the FORM DESIGN TOOLS DESIGN tab that allows you to change the special effect for a label.

ANSWER:   h
POINTS:   1

 

110. Key or key combination that will move from the subform back to the last field in the main form.

ANSWER:   i
POINTS:   1

 

111. Button on the CREATE tab that creates a new form in Design view.

ANSWER:   j
POINTS:   1

 

112. Key or key combination that will move from the last field in the subform to the first field in the next record’s main form.

ANSWER:   b
POINTS:   1

 

113. The ____ data type can store up to a gigabyte of text.

  a. Variable b. Attachment
  c. VarChar d. Long Text

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 269

 

114. To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.

  a. Modify Table b. Change Table
  c. Design View d. Modify View

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 269-AC 270

 

115. To use the Input Mask Wizard, select the Input Mask property in the field’s property sheet and then select the ____ button.

  a. Wizard b. Build
  c. Input Mask d. Expression

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 270

 

 

116. In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, drag the right edge of the ____ to the desired size.

  a. field selector b. horizontal scroll bar
  c. vertical scroll bar d. datasheet

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 277

 

117. In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, drag the lower edge of the ____ to the desired size.

  a. horizontal scroll bar b. vertical scroll bar
  c. datasheet d. record selector

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 277

 

118. In the accompanying figure, the Comment field has been resized. To resize a field so that a larger portion of the text will appear, press and hold or right-click the field selector, and tap or click ____ to change the column size.

  a. Field Width b. Field Size
  c. Width d. Size

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 277

 

119. In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the record selector, and tap or click ____ to change the row spacing.

  a. Height b. Row Spacing
  c. Row Height d. Size

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 277

 

120. To undo changes to the row height, press and hold or right-click the row selector, click Row Height on the shortcut menu, and then tap or click the ____ check box in the Row Height dialog box.

  a. Default b. Undo
  c. Standard Height d. Reverse

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 278

 

121. To undo changes to the column width, press and hold or right-click the field selector, tap or click Field Width on the shortcut menu, and then tap or click the ____ check box in the dialog box.

  a. Default b. Standard Width
  c. Reverse d. Undo

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 278

 

122. To insert data into an OLE Object field, use ____ command on the OLE’s shortcut menu.

  a. Insert Object b. Create
  c. Create my Picture d. Insert Picture

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 278

 

123. To insert data into an Attachment field, use the ____ command on the Attachment field’s shortcut menu.

  a. Insert Attachments b. Insert Objects
  c. Manage Objects d. Manage Attachments

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 280

 

124. To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click Convert, and then select Picture (Device Independent Bitmap) in the Convert dialog box.

  a. Object b. Picture Object
  c. Convert Object d. Bitmap Image Object

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 282

 

125. To enter data into a Hyperlink field, press and hold or right-click the Hyperlink field, tap or click Hyperlink on the shortcut menu, and then tap or click ____ on the Hyperlink submenu.

  a. Insert Hyperlink b. Insert Object
  c. Edit Hyperlink d. Attach Hyperlink

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 282

 

126. To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click ____.

  a. View b. Picture
  c. Display d. Open

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 282

 

127. To view attachments in a field, press and hold or right-click the field, and then tap or click ____ on the shortcut menu.

  a. View Attachments b. Open
  c. Manage Attachments d. View

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 282

 

128. A form that is contained within another form is called a(n) ____.

  a. subform b. inner form
  c. dependent form d. hyperform

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 283

 

129. To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.

  a. Design View b. Form Design
  c. Blank Form d. New Form

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 283-AC 284

 

130. To display a field list in Design view, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

  a. Show Table b. Display Fields
  c. Field List d. Add Existing Fields

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 284

 

131. To save a form and assign it a name, tap or click the Save button on the ____.

  a. FORM DESIGN TOOLS DESIGN tab b. Quick Access Toolbar
  c. HOME tab d. CREATE tab

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 285

 

132. To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment button on the ____ tab.

  a. CREATE b. FORM DESIGN TOOLS DESIGN
  c. HOME d. FORM DESIGN TOOLS ARRANGE

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 286

 

133. To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.

  a. Background Color b. Color
  c. Fill d. Format

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 290

 

134. To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.

  a. Background b. Format
  c. Back Color d. Fill/Back Color

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 290-AC 291

 

135. To add a title to a form, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab.

  a. Form Title b. Name
  c. Title d. Text Box

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 291

 

136. To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____ on the shortcut menu.

  a. Add Section b. Form Header/Footer
  c. Insert Header d. Arrange

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 291

 

137. To place a subform on a form, use the Subform/Subreport tool on the ____ tab.

  a. FORM DESIGN TOOLS DESIGN b. CREATE
  c. HOME d. FORM DESIGN TOOLS ARRANGE

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 292

 

138. To switch from Design view to Form view to display the form, tap or click the ____ button.

  a. Display b. Open
  c. Window d. View

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 295

 

139. To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.

  a. Open b. Modify
  c. Change Columns d. Resize

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 296

 

140. To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the ____ property arrow.

  a. Picture b. Size Mode
  c. Cropping d. Alignment

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 299

 

141. To change the font color of a label, select the label, and tap or click the ____ arrow on the FORM DESIGN TOOLS FORMAT tab to display a color palette.

  a. Color b. Label Color
  c. Font Color d. Text Color

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 300

 

142. To change the special effect of a label, select the label, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and then tap or click the Special Effect property arrow.

  a. Property Sheet b. Special Effect
  c. Properties d. Labels

 

ANSWER:   a
POINTS:   1
REFERENCES:   AC 300-AC 301

 

143. To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.

  a. Tab b. Order
  c. Arrangement d. Property Sheet

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 304

 

144. To change the tab order in which fields are encountered on a form, tap or click the Tab Order button on the ____ tab.

  a. HOME b. FORM DESIGN TOOLS ARRANGE
  c. CREATE d. FORM DESIGN TOOLS DESIGN

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 304

 

145. To use a form to view data, press and hold or right-click the form in the Navigation Pane, and then click ____ on the shortcut menu.

  a. View b. Form
  c. Mode d. Open

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 305

 

146. To go to a specific record in the main form, enter the record number in the ____ box for the main form.

  a. Go to Record b. Current Record
  c. Next Record d. Find Record

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 307

 

147. To view object dependencies, tap or click the object of interest in the Navigation Pane, tap or click the ____ tab on the ribbon, and then tap or click the Object Dependencies button.

  a. HOME b. CREATE
  c. DATABASE TOOLS d. DESIGN

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 308

 

148. To test for the current date in a query, type ____ in the Criteria row of the appropriate column.

  a. Current() b. CurrentDate()
  c. Today() d. Date()

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 309

 

149. The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.

  a. *education b. ?education
  c. *education* d. ?education?

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 310

 

150. To create a simple form with a datasheet, select the table that is the “one” part of a one-to-many relationship in the Navigation Pane, tap or click CREATE on the ribbon, and then tap or click the ____ button on the CREATE tab.

  a. Simple Form b. Datasheet Form
  c. Form Design d. Form

 

ANSWER:   d
POINTS:   1
REFERENCES:   AC 312

 

151. To create a form with a datasheet in Layout view, tap or click the ____ button on the CREATE tab to create a form in Layout view.

  a. Layout Form b. Layout View
  c. Blank Form d. Datasheet Form

 

ANSWER:   c
POINTS:   1
REFERENCES:   AC 314

 

152. To create a multiple-table form based on the “many” table, tap or click the ____ button on the CREATE tab to create a form in Layout view.

  a. Multitable Form b. Blank Form
  c. Many Form d. Layout Form

 

ANSWER:   b
POINTS:   1
REFERENCES:   AC 315

 

Modified Multiple Choice

 

153. A field with the Attachment data type can contain ____.

  a. Word documents b. Excel spreadsheets
  c. Pictures d. Boolean operators

 

ANSWER:   a, b, c
POINTS:   1
REFERENCES:   AC 269

 

154. You can use the ____ data type for a Picture field.

  a. OLE Object b. Short Text
  c. Long Text d. Attachment

 

ANSWER:   a, d
POINTS:   1
REFERENCES:   AC 269

 

155. An OLE Object field can store ____.

  a. video clips b. Access tables
  c. sound d. pictures

 

ANSWER:   a, c, d
POINTS:   1
REFERENCES:   AC 269

 

156. A field with the Hyperlink data type can contain links to ____.

  a. web pages b. Office documents
  c. email addresses d. fields in a table

 

ANSWER:   a, b, c
POINTS:   1
REFERENCES:   AC 273

 

157. The portion of a picture that appears, as well as the way it appears, is determined by the size mode. The possible size modes are ____.

  a. Default b. Clip
  c. Stretch d. Zoom

 

ANSWER:   b, c, d
POINTS:   1
REFERENCES:   AC 299

 

158. You can use the OLE Object data type or the Attachment data type to store a picture.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

159. In Datasheet view, an Attachment field appears as a paper clip rather than the field name.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

160. When you add an input mask to a field, the data type for the field changes to Input Mask.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 272

 

161. When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 274

 

162. When you enter data in a long text field, Access automatically expands the row and column to display all the data in the field.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 276

 

163. Rows in a datasheet may be different sizes.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 277

 

164. When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 278

 

165. Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 278

 

166. When data, such as a picture, is inserted into an OLE field, Access does not immediately display the picture.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 278

 

167. Any row and column spacing changes made to a datasheet are saved automatically when you close the table.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 282

 

168. To select more than one control at a time on a form, press and hold down the ALT key as you select additional controls.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 286

 

169. You can use the ruler to select multiple controls.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 286

 

170. To ensure that a collection of controls is aligned properly with each other, select all of the affected controls, and then use the appropriate alignment buttons on the ALIGN tab.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 286

 

171. When you add a title to a form using the Title button, Access places the title in the Detail section.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 291

 

172. When a form includes a subform, the subform is a separate object in the database.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 296

 

 

173. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Stretch size mode is the best option for photographs.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

174. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The three possible size modes are: Clip, Stretch, and Zoom.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

175. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. The Cut size mode displays only the portion of the picture that will fit in the space allocated to it.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

176. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. With the Zoom size mode, the entire picture will appear and be proportioned correctly.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

177. In the accompanying figure, the portion of the picture that appears, as well as the way it appears, is determined by the size mode. To change the size mode, use the property sheet.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 299

 

178. Access only allows you to change the font and font size for a label on a form.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 299

 

179. You cannot change the size of the property sheet.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 300

 

180. Once the tab order for fields is determined, it cannot be changed.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 304

 

181. A form that contains a subform includes navigation buttons for both the form and subform.

  a. True
  b. False

 

ANSWER:   True
POINTS:   1
REFERENCES:   AC 305

 

182. To move from the last field in the main form to the first field in the subform, press the CTRL+SHIFT+TAB keys.

  a. True
  b. False

 

ANSWER:   False
POINTS:   1
REFERENCES:   AC 307

 

183. An input mask specifies how data is to be entered and how it will appear. ____________________

ANSWER:   True
POINTS:   1
REFERENCES:   AC 269

 

184. To change the size of a row, you use a record’s record selector. ____________________

ANSWER:   True
POINTS:   1
REFERENCES:   AC 276

 

185. To view a picture in Datasheet view, press and hold or right-click the picture field, tap or click Bitmap Image Object on the shortcut menu, and then tap or click View. ____________________

ANSWER:   False – Open
POINTS:   1
REFERENCES:   AC 282

 

186. Changing the value of the Tab Order property for a control to No will bypass the control when the TAB key is pressed. ____________________

ANSWER:   False – Stop, stop
POINTS:   1
REFERENCES:   AC 304

 

187. If you create a form with the Form button for a table that is the “one” table in a one-to-many relationship, Access automatically includes the “many” table in a subform. ____________________

ANSWER:   False – datasheet
POINTS:   1
REFERENCES:   AC 312

 

 

188. The accompanying figure shows the Book Rep table. The Phone Number field in this table uses a(n) ____________________, which specifies how data is to be entered and how it will appear.

ANSWER:   input mask
POINTS:   1
REFERENCES:   AC 269

 

189. In the accompanying figure, the paper clip indicates that the field is a(n) ____________________ field.

ANSWER:   Attachment
attachment
POINTS:   1
REFERENCES:   AC 269

 

190. In the accompanying figure, the Picture field has an OLE Object data type. OLE is an abbreviation for ____________________.

ANSWER:   Object Linking and Embedding
object linking and embedding
POINTS:   1
REFERENCES:   AC 273

 

191. In the accompanying figure, the data type of ___________________ is used for the Comment field because the field contains text that is variable in length and potentially very long.

ANSWER:   Long Text
long text
POINTS:   1
REFERENCES:   AC 273

 

192. In the accompanying figure, the Comment field has been resized. You can change the size of a column by using the ___________________, which is the bar containing the field name.

ANSWER:   field selector
POINTS:   1
REFERENCES:   AC 276

 

193. You can enter data in a long text field using the ____________________ dialog box.

ANSWER:   Zoom
POINTS:   1
REFERENCES:   AC 278

 

194. To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field’s shortcut menu.

ANSWER:   Insert Object
insert object
POINTS:   1
REFERENCES:   AC 278

 

195. To insert data into an Attachment field, use the ____________________ command on the Attachment field’s shortcut menu.

ANSWER:   Manage Attachments
manage attachments
POINTS:   1
REFERENCES:   AC 280

 

196. To insert data into a Hyperlink field, use the ____________________ command on the Hyperlink field’s shortcut menu.

ANSWER:   Edit Hyperlink
edit hyperlink
POINTS:   1
REFERENCES:   AC 282

 

197. To view data, such as a picture, in an OLE field, press and hold or right-click the field, tap or click ____________________ on the shortcut menu, and then tap or click Open.

ANSWER:   Bitmap Image Object
bitmap image object
POINTS:   1
REFERENCES:   AC 282

 

198. If one book rep can represent many customers, the relationship between book rep and customers is called a(n) ____________________ relationship.

ANSWER:   one-to-many
one to many
POINTS:   1
REFERENCES:   AC 283

 

199. A(n) ____________________ is a form that is contained within another form.

ANSWER:   subform
POINTS:   1
REFERENCES:   AC 283

 

200. The form in which the subform is contained is called the ____________________.

ANSWER:   main form
POINTS:   1
REFERENCES:   AC 283

 

201. When a form includes a subform, the ___________________ contains data from the many table in a one-to-many relationship.

ANSWER:   subform
POINTS:   1
REFERENCES:   AC 283

 

202. To select more than one control at a time, press and hold down the ____________________ key(s) as you select additional controls.

ANSWER:   SHIFT
shift
POINTS:   1
REFERENCES:   AC 286

 

203. To add a title to a form, tap or click the ____________________ button on the FORM DESIGN TOOLS DESIGN tab.

ANSWER:   Title
title
POINTS:   1
REFERENCES:   AC 291

 

204. To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____________________ on the shortcut menu.

ANSWER:   Form Header/Footer
form header/footer
POINTS:   1
REFERENCES:   AC 291

 

205. The best size mode to use for photographs is ____________________ size mode.

ANSWER:   Zoom
zoom
POINTS:   1
REFERENCES:   AC 299

 

206. To give a label an etched appearance, change the ________________________ property for the label.

ANSWER:   Special Effect
special effect
POINTS:   1
REFERENCES:   AC 301

 

207. To have the TAB key bypass a control, change the ___________________ property.

ANSWER:   Tab Stop
tab stop
POINTS:   1
REFERENCES:   AC 304

 

208. The portion of a picture that appears as well as the way it appears is determined by the size mode. What are the three possible size modes and how do they affect a picture?

ANSWER:   1. Clip — Displays only the portion of the picture that will fit in the space allocated to it.
2. Stretch — Expands or shrinks the picture to fit the precise space allocated on the screen.
3. Zoom — Does the best job of fitting the picture to the allocated space without changing the look of the picture.
POINTS:   1
REFERENCES:   AC 299
TOPICS:   Critical Thinking

 

209. What is the difference between the Tab Stop property and Tab Order?

ANSWER:   The Tab Stop property determines whether users bypass a control on a form when they press the TAB key. If the Tab Stop property for a control is set to No, the control is bypassed when the TAB key is pressed.

Tab Order determines the order in which fields are encountered when the TAB key is pressed. You can change the order by tapping or clicking the Tab Order button on the FORM DESIGN TOOLS DESIGN tab.

POINTS:   1
REFERENCES:   AC 304
TOPICS:   Critical Thinking

 

210. There are at least two reasons for viewing information on dependencies between database objects. What are these reasons?

ANSWER:   1. Viewing a list of objects that use a specific object helps in the maintenance of a database and avoids errors when changes are made to the objects involved in the dependency.
2. If you are unfamiliar with a database, viewing object dependencies can help you better understand the structure of the database.
POINTS:   1
REFERENCES:   AC 307-AC 308
TOPICS:   Critical Thinking

 

Critical Thinking Questions
Case 5-1

An employee at Bavant Publishing would like to add some additional fields to the Customer table. He needs to add fields that will store the web page for a customer, as well as whether or not the customer participates in a preferred customer program.

 

211. What data type should the employee assign to the field that will contain the web page?

ANSWER:   Hyperlink
POINTS:   1
REFERENCES:   AC 273
TOPICS:   Critical Thinking

 

212. What data type is appropriate for a field that indicates whether the customer participates in the preferred customer program?

ANSWER:   Yes/No
POINTS:   1
REFERENCES:   AC 273
TOPICS:   Critical Thinking

 

Critical Thinking Questions
Case 5-2

An employee at Bavant Publishing would like to query the Book Rep table. She has created a query and entered the fields she wants to display in the result in the design grid. Now, she enters the criteria.

 

213. What would the employee enter in the Criteria row of the Start Date field to find all book reps who started before January 1, 2013?

ANSWER:   <1/1/2013
POINTS:   1
REFERENCES:   AC 310
TOPICS:   Critical Thinking

 

214. What would the employee enter in the Criteria row for the Comment field to find all book reps who understand or speak the Spanish language?

ANSWER:   *spanish*
POINTS:   1
REFERENCES:   AC 310
TOPICS:   Critical Thinking

 

Identify the letter of the choice that best matches the phrase or definition.

a. Form
b. CTRL+TAB
c. Add Existing Fields
d. SHIFT
e. INSERT
f. Object Dependencies
g. TAB
h. Property Sheet
i. CTRL+SHIFT+TAB
j. Form Design

 

REFERENCES:   AC 271
AC 312
AC 286
AC 308
AC 307
AC 284
AC 300
AC 307
AC 284
AC 307

 

215. Key or key combination that will insert a blank row in a table in Design view.

ANSWER:   e
POINTS:   1

 

216. Button on the CREATE tab that creates a simple form with a datasheet.

ANSWER:   a
POINTS:   1

 

217. Key or key combination that will select multiple controls.

ANSWER:   d
POINTS:   1

 

218. Button on the DATABASE TOOLS tab that will display dependencies between database objects.

ANSWER:   f
POINTS:   1

 

219. Key or key combination that will move from the last field in the main form to the first field in the subform.

ANSWER:   g
POINTS:   1

 

220. Button on the FORM DESIGN TOOLS DESIGN tab that displays a field list.

ANSWER:   c
POINTS:   1

 

221. Button on the FORM DESIGN TOOLS DESIGN tab that allows you to change the special effect for a label.

ANSWER:   h
POINTS:   1

 

222. Key or key combination that will move from the subform back to the last field in the main form.

ANSWER:   i
POINTS:   1

 

223. Button on the CREATE tab that creates a new form in Design view.

ANSWER:   j
POINTS:   1

 

224. Key or key combination that will move from the last field in the subform to the first field in the next record’s main form.

ANSWER:   b
POINTS:   1

 

 

Additional information

Add Review

Your email address will not be published. Required fields are marked *