Chapter_1.

  1. A(n) ______is a collection of data organized in a manner that allows access, retrieval, and use of that data.
  2. file management system
  3. database management system
  4. integrated system
  5. database
  6. In Access, a database consists of a collection of ______.
  7. columns
  8. tables
  9. worksheets
  10. rows
  11. Access is a ______.
  12. word processing software package
  13. database
  14. database management system
  15. worksheet management system
  16. A(n) ______contains information about a given person, product, or event.
  17. attribute
  18. column
  19. field
  20. record
  21. A(n) ______contains a specific piece of information within a record.
  22. field
  23. entity
  24. row
  25. database
  26. A field that uniquely identifies a particular record in a table is called a ______key.
  27. secondary
  28. primary
  29. principal
  30. foreign
  31. If a width is not assigned to a text field, Access assumes the width is ______.
  32. 30
  33. 40
  34. 50
  35. 60
  36. Field names can be a maximum of ______characters in length.
  37. 64
  38. 32
  39. 16
  40. 8
  41. To move from the upper pane, the one where fields are defined, in the Table window to the lower pane, the one where field properties are defined, press the ______key.
  42. f8
  43. f7
  44. f6
  45. f5
  46. If a key appears in front of a field in the Table window, such as that shown in the accompanying figure, it means the field is the ______for the table.
  47. primary key
  48. row selector
  49. page header
  50. foreign key
  51. To make a field the primary key for a table, such as that shown in the accompanying figure, select the field and then click the ______button on the toolbar.
  52. Unique Key
  53. Single Key
  54. Principal Key
  55. Primary Key
  56. Table names can be no more than ______characters in length and can contain letters, numbers, and spaces.
  57. 32
  58. 64
  59. 128
  60. 256
  61. If the Customer table is represented as a collection of rows and columns, as shown in the accompanying figure, then the table is displaying in ______view.
  62. Table
  63. Tablesheet
  64. Datasheet
  65. Worksheet
  66. If the value 1505.5 is entered in a field that has been defined as Currency data type, then the value will display as ______.
  67. 1505.5
  68. 1505.50
  69. $1505.50
  70. $1,505.50
  71. To delete a record from a table, select the record and then press the ______key(s).
  72. delete
  73. ctrl+d
  74. ctrl+delete
  75. ctrl+y
  76. To change to landscape orientation to print a table, right-click the report in the Print Preview window and then click ______on the shortcut menu.
  77. Page Setup
  78. Print Settings
  79. Print Orientation
  80. Page Format
  81. ______view displays a single record at a time.
  82. Datasheet
  83. Screen
  84. Form
  85. Record
  86. To create a form, select the table for the form in the Database window, click the New Object: AutoForm button arrow on the toolbar, and then click ______in the list that displays.
  87. AutoForm
  88. FormView
  89. AutoScreen
  90. ScreenView
  91. To move from Form view to Datasheet view, click the View button arrow on the Form View toolbar and then click ______in the list that displays.
  92. Table View
  93. Datasheet View
  94. Multirecord View
  95. Worksheet View
  96. To preview a report from the Database window, click Reports on the Objects bar to display the report, right-click the report, and then click ______on the shortcut menu.
  97. View Report
  98. Open
  99. Display
  100. Print Preview
  101. In the Access Help system, the ______is similar to the Office Assistant in that it answers questions that you type in your own words.
  102. Contents sheet
  103. Ask a Question box
  104. Index sheet
  105. Locate sheet
  106. ______refers to the arrangement of data into tables and fields.
  107. File management
  108. Database structure
  109. Database design
  110. Normalization
  111. ______means storing the same fact in more than one place.
  112. Normalization
  113. Consistency
  114. Reference
  115. Redundancy
  116. ______is a special technique for identifying and eliminating redundancy.
  117. Consistency
  118. Replication
  119. Iteration
  120. Normalization
  121. All of the following are benefits of controlling redundancy except ______.
  122. greater consistency is maintained
  123. less space is occupied
  124. update is easier
  125. all of the above are benefits
True/False
TF /
  1. A database management system is an application software package that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in a database.

TF /
  1. In Access, a database consists of a collection of tables.

TF /
  1. A field contains information about a given person, product, or event.

TF /
  1. A record contains a specific piece of information within a field.

TF /
  1. The rows in a table are called fields, and the columns are called records.

TF /
  1. In Access, all the tables, report, forms, and queries are stored in separate files. Collectively, these files are called a database.

TF /
  1. Every record in a table must have a primary key.

TF /
  1. The speech recognition feature of Access does not allow a user to dictate field entries.

TF /
  1. By default, Access creates a new database in Access 2002 format.

TF /
  1. If no width is assigned to a text field, Access assumes the width is 20.

TF /
  1. The same field name cannot be used for two different fields in the same table.

TF /
  1. Field names can contain periods but not square brackets ([ ]).

TF /
  1. Number fields can contain positive or negative numbers.

TF /
  1. Access assigns a size to currency fields automatically.

TF /
  1. To change the field size for a text field, use the Field Size property box in the lower pane of the Table window.

TF /
  1. To move from the upper pane, the one where fields are defined, in the Table window to the lower pane, the one where field properties are defined, press the f7 key.

TF /
  1. If a key appears in front of a field on the Table window, it means the field is the primary key for the table.

TF /
  1. To delete a field in a table structure, select the field by clicking the leftmost column on the row that contains the field to be deleted, and then press ctrl+delete.

TF /
  1. If the wrong field has been made the primary key, click the correct primary key entry for the field and then click the Primary Key button on the Table Design toolbar.

TF /
  1. Table names must be from 1 to 64 characters in length and cannot contain spaces.

TF /
  1. To assign a name to a table, save the table structure and continue working in the Table Design window, or click the Save button on the Table Design toolbar.

TF /
  1. When adding records to a table, it is necessary to click the Save button on the toolbar after adding each new record.

TF /
  1. In Datasheet view, the table is represented as a collection of rows and columns called a tablesheet.

TF /
  1. If the value 1500.5 is entered in a field that has been defined as Currency data type, the value will display as $1,500.50.

TF /
  1. Access automatically adds dollar signs and commas to data entered into currency fields.

TF /
  1. To add records to a table that already contains data, click the Last Record Navigation button.

TF /
  1. To move to the last record in a table, click the Last Record Navigation button.

TF /
  1. To move to the first record in a table, click the Start Record Navigation button.

TF /
  1. To delete a record from a table, select the record and press the delete key.

TF /
  1. Portrait orientation means a printout is across the length of a page.

TF /
  1. Landscape orientation means a printout is across the length of a page.

TF /
  1. To preview what printed copy will look like, use Print Setup.

TF /
  1. To change to landscape orientation to print a table, right-click the report in the Print Preview window and then click Page Setup on the shortcut menu.

TF /
  1. Display view displays a single record at a time.

TF /
  1. The simplest way to create a form is to use the New Object: AutoForm button on the Database toolbar.

TF /
  1. Forms can include special types of data such as pictures and sound.

TF /
  1. Forms cannot incorporate data from multiple tables in the same form.

TF /
  1. To create a form, select the table for the form in the Database window, click the New Object: AutoForm button arrow on the toolbar, and then click AutoForm in the list that displays.

TF /
  1. To add new records or change existing records, use either Datasheet view or Form view.

TF /
  1. To open a form, select the form in the Database window, right-click the form and click Form View on the shortcut menu.

TF /
  1. To move from Form view to Datasheet view, click the View button down arrow on the Form View toolbar and then click Datasheet View in the list that displays.

TF /
  1. In a report, the detail lines are lines that print for each record and contain only specified fields.

TF /
  1. To create a report, select the table for the report in the Database window, click the New Object: AutoForm button arrow on the toolbar, and then click AutoReport in the list that displays.

TF /
  1. Reports can incorporate data from multiple tables.

TF /
  1. To print a report from the Database window, click the Reports object to display the report, right-click the report, and then click Print on the shortcut menu.

TF /
  1. The Question Mark button can be used to identify unfamiliar items in a dialog box.

TF /
  1. The Index sheet in the Access Help system groups topics by general categories.

TF /
  1. The Contents sheet in the Access Help system is used in the same manner as the index at the back of a textbook.

TF /
  1. Normalization is a special technique for identifying and eliminating redundancy.

TF /
  1. Redundancy makes updating the database more difficult.

Short Answer
  1. A(n) ______is an application software package that can be used to create a database; add, change, and delete data in the database; sort and retrieve data; and create forms and reports using the data in the database.
  2. In Access, a(n) ______consists of a collection of tables.
  3. A(n) ______contains information about a given person, product, or event.
  4. A(n) ______contains a specific piece of information within a record.
  5. Every record in a table has a unique identifier that also is called a(n) ______.
  6. If no width is assigned to a text field, Access assumes the width is ______.
  7. A field name can be up to ______characters in length.
  8. A field with a data type of ______can contain only dollar amounts.
  9. A field with a data type of ______can contain any characters.
  10. The ______is a small box or bar that, when clicked, selects the entire row.
  11. To move from the upper pane, the one where fields are defined, in the Table window to the lower pane, the one where field properties are defined, press the ______key(s).
  12. If a(n) ______symbol appears in front of a field in the Table window, it means the field is the primary key for the table.
  13. To delete a field in a table structure, select the field by clicking the leftmost column on the row that contains the field to be deleted and then press the ______key(s).
  14. If the wrong field has been made the primary key, click the correct primary key entry for the field and then click the ______button on the Table Design toolbar.
  15. Table names can be from 1 to ______characters in length and can contain letters, numbers, and spaces.
  16. In ______, the table is represented as a collection of rows and columns called a datasheet.
  17. To move to the first record in a table, click the ______Navigation button.
  18. To move to the end of the table to a position for entering a new record, click the ______Navigation button.
  19. ______orientation means a printout is across the width of a page.
  20. ______orientation means a printout is across the length of a page.
  21. To preview what printed copy will look like, use ______.
  22. Form view displays ______record(s) at a time.
  23. To create a form, select the table for the form in the Database window, click the New Object: AutoForm button arrow on the toolbar, and then click ______in the list that displays.
  24. To move from Form view to Datasheet view, click the View button down arrow on the Form View toolbar and then click ______in the list that displays.
  25. In a report, the contents of a(n) ______appear at the top of each page.
  26. In a report, the ______are lines that print for each record and contain only specified fields.
  27. To create a report, select the table for the report in the Database window, click the New Object: AutoForm button arrow on the toolbar, and then click ______in the list that displays.
  28. To print a report from the Database window, click the Reports object to display the report, right-click the report, and then click ______on the shortcut menu.
  29. The ______in the Access Help system is used to identify unfamiliar items in a dialog box.
  30. The ______sheet in the Access Help system offers assistance when the general category of the topic is known but not the specifics.
  31. The ______sheet in the Access Help system is used in the same manner as the index at the back of a textbook.
  32. ______refers to the arrangement of data into tables and fields.
  33. ______means storing the same fact in more than one place.
  34. ______is a special technique for identifying and eliminating redundancy.
  35. Always design a database to remove ______.