Chapter_5

  1. The Picture field shown in the accompanying figure is an OLE field. The term OLE means ______.
  2. Object Linking and Encoding
  3. Object Linking and Embedding
  4. Object Locking and Encoding
  5. Object Locking and Embedding
  6. The Comment field shown in the accompanying figure is a(n) ______field that can contain text that is variable in length, and the amount of text stored in the field is virtually unlimited.
  7. Memo
  8. Note
  9. Text
  10. Character
  11. The Web Page field shown in the accompanying figure is a(n) ______field that can contain links to other office documents or to Web pages.
  12. URL
  13. Web Page
  14. Hyperlink
  15. OLE
  16. To modify the design of a table, click Tables on the Objects bar, right-click the table, and then click ______on the shortcut menu.
  17. Modify
  18. Change
  19. Layout View
  20. Design View
  21. To enter data into an OLE field, use the ______command on the OLE field's shortcut menu.
  22. Insert Object
  23. Insert Picture
  24. Insert Graphic
  25. Insert OLE
  26. To enter data into a Hyperlink field, use the ______command on the Hyperlink field's shortcut menu.
  27. URL
  28. Hyperlink
  29. Web Page
  30. WWW
  31. To view data such as a picture in an OLE field, right-click the field, click Bitmap Image Object on the shortcut menu, and then click ______.
  32. View Picture
  33. Browse
  34. Open
  35. Link
  36. An advisor may advise many students but a student has only one advisor. This is a(n) ______relationship.
  37. one-to-one
  38. many-to-many
  39. many-to-one
  40. one-to-many
  41. To change the appearance of a subform, right-click the form selector for the subform, click Properties, and then change the ______property.
  42. Default View
  43. Subform View
  44. Layout View
  45. Design View
  46. The amount of a picture that displays on a form, as well as the way that the picture displays is determined by the ______mode.
  47. size
  48. magnification
  49. enlargement
  50. picture
  51. The ______size mode only displays the portion of the picture that will fit in the space allocated to it.
  52. Zoom
  53. Crop
  54. Clip
  55. Stretch
  56. The ______size mode expands or contracts the picture to fit the precise space allocated on the screen.
  57. Zoom
  58. Crop
  59. Clip
  60. Stretch
  61. The best size mode to use for photographs is ______size mode.
  62. Zoom
  63. Crop
  64. Clip
  65. Stretch
  66. The ______size mode does the best job of fitting the picture to the allocated space without changing the look of the picture.
  67. Clip
  68. Crop
  69. Zoom
  70. Stretch
  71. To change the size mode of a picture, right-click the picture, click Properties from the shortcut menu, and then click the ______property box.
  72. Picture Mode
  73. Size Mode
  74. Object Mode
  75. Graphic Mode
  76. To change the color of the letters that appear in a label, change the ______property for the label.
  77. Back Color
  78. Text Color
  79. Fore Color
  80. Label Color
  81. To add a title to a form, use the ______tool in the toolbox.
  82. Text
  83. Title
  84. Unbound
  85. Label
  86. To give a label a chiseled appearance, change the ______property for the label.
  87. Chiseled
  88. Border
  89. Special Effects
  90. Frame
  91. To add a picture to a form header, use the ______tool in the toolbox.
  92. Picture
  93. Image
  94. Special Effects
  95. Frame
  96. To use a form to view data, right-click the form in the Database window and then click ______on the shortcut menu.
  97. View
  98. Display
  99. Edit
  100. Open
  101. To bold text in a label, change the ______property.
  102. Format
  103. Special Effects
  104. Font Weight
  105. Font Style
  106. A form that includes a subform has Navigation buttons for ______.
  107. the main form only
  108. the subform only
  109. neither the main form nor the subform
  110. both the main form and the subform
  111. The condition, ______, entered in the Criteria: row of the Start Date column on a select query window would retrieve all records with a date prior to 2003.
  112. 1/1/2003
  113. >'1/1/2003'
  114. 1/1/2003
  115. <'1/1/2003'
  116. The condition, ______, entered in the Criteria: row of a memo field on a query window would retrieve all records where the memo field had any mention of machine.
  117. like ?machine
  118. like *machine
  119. like ?machine?
  120. like *machine*
  121. The two wildcards for use with memo fields in a query are ______.
  122. asterisk (*) and question mark (?)
  123. asterisk (*) and double period (..)
  124. double period (..) and at symbol (@)
  125. double period (..) and ampersand (&)
True/False
TF /
  1. A memo field can contain text that is variable in length and the amount of text stored in the field is virtually unlimited.

TF /
  1. If 2/30/2003 is entered in the Start Date field of the Driver table, Access would consider the date invalid.

TF /
  1. A Hyperlink field only can contain links to Web pages.

TF /
  1. To enter date fields, simply type the dates including slashes (/).

TF /
  1. To increase the height of a row, position the pointer on the lower boundary of any record’s record selector box and then drag the boundary upward.

TF /
  1. To increase the width of a column, position the pointer on the right boundary of the column in the field selector bar and then drag the boundary to the right.

TF /
  1. The Undo command can be used to reverse (undo) changes to the row and column size.

TF /
  1. To insert data into an OLE field, use the Insert Object command on the OLE field’s shortcut menu.

TF /
  1. Only pictures that have been created in Microsoft Draw can be inserted into OLE fields in Access.

TF /
  1. To insert data into a Hyperlink field, use the Hyperlink command on the Hyperlink’s field shortcut menu.

TF /
  1. When changing any table properties, the changes only apply as long as the table is active unless they are saved.

TF /
  1. Row and column spacing are properties associated with a table.

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

TF /
  1. To view data, such as a picture, in an OLE field, right-click the field, click View Object on the shortcut menu, and then click Open.

TF /
  1. If a relationship is one-to-many, every occurrence of A is related to many occurrences of B and every occurrence of B is related to many occurrences of A.

TF /
  1. An advisor may advise many students but a student has only one advisor. If a form displays information about the advisor and lists all the students that the advisor advises, the student data will display in a subform.

TF /
  1. In order to create a subform, the tables for the main form and the subform must be related.

TF /
  1. When a form includes a subform, the subform contains data from the one table in a one-to-many relationship.

TF /
  1. When a form includes a subform, the main form contains data from the one table in a one-to-many relationship.

TF /
  1. To create a form with a subform, use the Form Wizard.

TF /
  1. When a form includes a subform, a name is assigned to both the main form and the subform.

TF /
  1. To modify the design of a subform, right-click the subform in the Database window and then click Design View on the shortcut menu.

TF /
  1. To modify the form design, right-click the form in the Database window and then click Modify Layout on the shortcut menu.

TF /
  1. On a form, you can move a label without moving its associated field.

TF /
  1. To select more than one control at a time on a form, press and hold down the alt key as you select additional controls.

TF /
  1. To change the alignment of a label, right-click the label, click Properties on the shortcut menu, and then change the Text Align property.

TF /
  1. To resize a label to optimum size, select the label, and then double-click an appropriate sizing handle.

TF /
  1. The amount of a picture that displays on a form, as well as the way that the picture displays is determined by the size mode.

TF /
  1. Access has only two possible size modes — Stretch and Clip.

TF /
  1. The Clip size mode only displays the portion of the picture that will fit in the space allocated to it.

TF /
  1. The Stretch size mode expands or contracts the picture to fit the precise space allocated on the screen.

TF /
  1. The best size mode to use for photographs is Zoom size mode.

TF /
  1. The Stretch size mode does the best job of fitting the picture to the allocated space without changing the look of the picture.

TF /
  1. To give a label an etched appearance, change the Special Effects property for the label.

TF /
  1. To change the color of the letters that appear in a label, change the Back Color property.

TF /
  1. To select all the controls in a row, click the vertical ruler to the left of the row.

TF /
  1. To add a title to a form, click the Title tool in the toolbox.

TF /
  1. To bold text in a label, change the Font Style property.

TF /
  1. To add a picture such as a company logo to a form header, click the Image tool in the toolbox.

TF /
  1. To use a form to view data, right-click the form in the Database window and then click View on the shortcut menu.

TF /
  1. A form that contains a subform includes Navigation buttons for both the form and subform.

TF /
  1. To move from the last field in the main form to the first field in the subform, press ctrl+shift+tab.

TF /
  1. Clicking a hyperlink on a form moves to the corresponding document or Web page.

TF /
  1. To use a mouse to switch from the main form to the subform, click anywhere in the subform.

TF /
  1. To use a mouse to switch from the subform to the main form, click the background of the main form.

TF /
  1. To test for the current date in a query, type Date() in the criteria row of the appropriate column.

TF /
  1. The condition, >1/1/2003, entered in the Criteria: row of the Start Date column in a Select Query window would retrieve all records with a date prior to 2003.

TF /
  1. The condition, Like *machine*, entered in the Criteria: row of a memo field on a Select Query window would retrieve all records where the memo field had any mention of machine.

TF /
  1. You can use the asterisk (*) wildcard with memo fields in a query but not the question mark (?).

TF /
  1. To compact a database, close any open databases, click Tools on the menu bar, click Database Utilities, and then click Compact and Repair Database.

Short Answer
  1. A(n) ______field can contain text that is variable in length and the amount of text stored in the field is virtually unlimited.
  2. The term OLE means ______.
  3. A(n) ______field can store data such as Microsoft Word or Excel documents, pictures, sound, and other types of binary data created in other programs.
  4. A(n) ______field can contain links to other office documents or to Web pages.
  5. To modify the design of a table, click Tables on the Objects bar, right-click the table, and then click ______on the shortcut menu.
  6. The small box at the beginning of a record that you can click to select a record is called the ______.
  7. To insert data into an OLE field, use the ______command on the OLE field's shortcut menu.
  8. To insert data into a Hyperlink field, use the ______command on the Hyperlink field's shortcut menu.
  9. To view data such as a picture in an OLE field, right-click the field, click ______on the shortcut menu, and then click Open.
  10. An advisor may advise many students but a student has only one advisor. This is a(n) ______relationship.
  11. To create forms with subforms, the tables for the main form and the subform must be ______.
  12. When a form includes a subform, the ______contains data from the many table in a one-to-many relationship.
  13. When a form includes a subform, the ______contains data from the one table in a one-to-many relationship.
  14. To create a form with a subform, use the ______.
  15. To modify the design of a subform, right-click the subform in the Database window and then click ______on the shortcut menu.
  16. To modify the form design, right-click the form in the Database window and then click ______on the shortcut menu.
  17. To select more than one control at a time, press and hold down the ______key(s) as you select additional controls.
  18. In the accompanying figure, only a portion of the picture field displays. The amount of a picture that displays on a form, as well as the way that the picture displays is determined by the ______mode.
  19. In the accompanying figure, only a portion of the picture field displays. The ______size mode only displays the portion of the picture that will fit in the space allocated to it.
  20. The ______size mode expands or contracts the picture to fit the precise space allocated on the screen.
  21. The best size mode to use for photographs is ______size mode.
  22. The ______size mode does the best job of fitting the picture to the allocated space without changing the look of the picture.
  23. To change the size mode of a picture, change the ______property.
  24. Changing the ______property of a label, changes the color of the letters that appear in the label.
  25. Changing the ______property of a label, changes the color of the label itself.
  26. To give a label an etched appearance, change the ______property for the label.
  27. To add a title to a form, click the ______tool in the toolbox.
  28. To add a picture such as a company logo to the form header, click the ______tool in the toolbox.
  29. To bold text in a label, change the ______property.
  30. To move from the last field in the main form to the first field in the subform, press the ______key(s).
  31. The condition, ______, entered in the Criteria: row of the Start Date column in a query window would retrieve all records with a date after 2002.
  32. The condition, ______, entered in the Criteria: row of a memo field in a query window would retrieve all records where the memo field had any mention of machine.
  33. The two wildcards for use with memo fields in a query are the ______and the ______.
  34. The process of ______eliminates wasted space that can exist in a database.
  35. To compact a database, click Tools on the menu bar, click ______, and then click Compact and Repair Database.