Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
57. You can use the Find button on the HOME tab to search for records in datasheets, forms, query results, and reports.
a.
True
b.
False
58. The Unfilter button toggles between filtered and unfiltered displays of the records in a table.
a.
True
b.
False
59. The Remove Filter command on the Advanced menu clears all filters.
a.
True
b.
False
60. Filter By Query allows you to filter based on multiple criteria, for example, to find only those customers whose returns
are $0.00 and whose book rep number is 42.
a.
True
b.
False
61. You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.
a.
True
b.
False
62. You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.
a.
True
b.
False
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
63. A lookup field allows the user to select from a list of values when updating the contents of a field.
a.
True
b.
False
64. When you create a calculated field, users can update the field.
a.
True
b.
False
65. You cannot preview the data to be updated in an update query before actually performing the update.
a.
True
b.
False
66. Validation rules are rules that a user must follow when entering the data.
a.
True
b.
False
67. You can use a make-table query to create an archive table.
a.
True
b.
False
68. In the Bavant Publishing database, a one-to-many relationship exists between the Book Rep table and the Customer
table.
a.
True
b.
False
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
69. Normally, Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.
a.
True
b.
False
70. To sort the data that appears in a datasheet on multiple fields, the major and minor keys must be next to each other in
the datasheet with the major key on the right.
a.
True
b.
False
71. A multilookup field is a field that contains more than one value. ____________________
72. A default value is a value that Access will display on the screen in a particular field before the user begins adding a
record. ____________________
73. To display the Total row in a datasheet, tap or click the Sum button on the ribbon. ____________________
74. A secondary key is a field in one table whose values are required to match the primary key of another table.
____________________
75. When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep
when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book
rep in a split form. ____________________
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
76. Maintenance of a database can involve the need to _________________________ periodically; that is, to change the
database structure.
77. A(n) ____________________ is a form that allows you to simultaneously view both simple form and datasheet views
of the data.
78. When you have created a filter using Advanced Filter/Sort, you can save the filter settings as a query by using the
____________________ command on the Advanced menu.
79. You can restore filter settings that you previously saved in a query by using the ____________________ command on
the Advanced menu.
80. If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the
field, tap or click the ____________________ for the field and then drag the field to the new location.
81. To create a lookup field, select ____________________ from the menu of available data types.
82. If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.
83. To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values
check box.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
84. A(n) ____________________ query adds, deletes, or changes data in a table.
85. When an update query is created, a(n) _________________________ row displays in the design grid.
86. To change gridlines in a datasheet, open the table in Datasheet view, select the entire datasheet, and tap or click the
____________________ button on the HOME tab.
87. The property that the value in a foreign key must match another table’s primary key is called
_________________________.
88. A(n) _________________________ is a field in one table whose values are required to match a primary key in
another table.
89. When specifying referential integrity, one way to handle deletions is to _________________________; that is, have
Access allow the deletion but then automatically delete any related records in other tables.
90. When specifying referential integrity, one way to handle the update of a primary key is to
_________________________; that is, have Access allow the update but then automatically make the corresponding
change in any related records in other tables.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
91. To open the Relationships window in the accompanying figure, tap or click the _________________________ button
on the DATABASE TOOLS tab.
92. To add the Book Rep and Customer tables to the Relationships window shown in the accompanying figure, tap or
click the Add button in the ___________________ dialog box.
93. The relationship in the accompanying figure was created by tapping or clicking the ____________________ check
box in the Edit Relationships dialog box.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
94. In the type of relationship between the Book Rep and Customer tables illustrated in the accompanying figure, the
infinity symbol indicates that one book rep is related to _________________________ customers.
95. To print a copy of a relationship, tap or click the _____________________ button shown on the accompanying figure.
96. You can use a make-table query to create an archive table. What is an archive table?
97. When you specify referential integrity, you need to decide how to handle the update of the primary key. What
decisions do you need to make?
98. Seven guidelines are available for you to use when determining database maintenance tasks. What are these seven
guidelines?
Critical Thinking Questions
Case 3-1
Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the
accompanying figure. They have asked you to create these validation rules.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
99. Because many of the customers that Bavant Publishing services are located in Pennsylvania, management would like
to minimize any data entry in this field. What property do you need to change and what would you enter in the property
box?
100. Bavant would like to make sure that if an employee enters the letters pa in the State field that it displays in the
database as PA. What property do you need to change and what would you enter in the property box?
Critical Thinking Questions
Case 3-2
Bavant has just realized that they need to make some additional changes to the Customer table shown in Design view in
the accompanying figure. They have asked you to make these changes.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
101. Bavant would like to move the Customer Type field in the Customer table. The field should appear before the Book
Rep Number field. What do you need to do to move the field?
102. Because Bavant may move the database to SQL Server, they have decided to delete the Resources Needed field.
How do you delete the field?
Identify the letter of the choice that best matches the phrase or definition.
a.
append query
b.
delete query
c.
make-table query
d.
update query
e.
validation rules
f.
validation text
g.
required field
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
h.
default value
i.
calculated field
j.
<
REFERENCES:
AC 158
AC 162
AC 160
AC 165
AC 160
AC 162
AC 162
AC 160
AC 162-AC 163
AC 160
103. Field that can be computed from other fields.
104. The message that will appear if a user violates the validation rule.
105. Allows you to add the results of a query to an existing table.
106. A format symbol.
107. Allows you to delete all the records satisfying some criterion.
108. Rules that a user must follow when entering data.
109. A field in which the user actually must enter data.
110. Allows you to add the results of a query to a new table.
111. A value that Access will display on the screen in a particular field before the user begins adding a record.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
112. Allows you to make the same change to all records.
