Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
1. If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.
a.
Customize
b.
Enable Content
c.
Security
d.
Unlock
2. To create a split form, select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the ____
button on the CREATE tab to display a menu, and then tap or click Split Form on the menu.
a.
All Forms
b.
More Forms
c.
Tabular Forms
d.
Forms View
3. To move from Layout view to Form view, tap or click the ____ button on the Access status bar.
a.
Open Form
b.
Edit View
c.
Data View
d.
Form View
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
4. To move to the first record using the form shown in the accompanying figure, tap or click the ____ button on the
Navigation bar.
a.
Beginning record
b.
Start record
c.
First record
d.
Goto record
AC 142
5. To add a record using the form shown in the accompanying figure, tap or click the ____ button on the Navigation bar.
a.
Last record
b.
New (blank) record
c.
Insert record
d.
Blank record
AC 142
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
6. To search for a specific record tap or click the ____ button on the HOME tab to display the Find and Replace dialog
box shown in the accompanying figure.
a.
Search
b.
Filter
c.
Search and Edit
d.
Find
7. As an alternate to using the Find button, you can press ____ to search for a specific record and display the Search and
Replace dialog box shown in the accompanying figure.
a.
CTRL+S
b.
CTRL+F
c.
CTRL+R
d.
CTRL+L
8. To delete record PLI22 shown in the accompanying figure, tap or click the record selector in the datasheet for the
record on which the client number is PLI22 and then press ____.
a.
CTRL+D
b.
DELETE
c.
CTRL+DELETE
d.
CTRL+Y
9. To use Filter By Selection to find all customers located in Greer, tap or click the City field for any record where the city
is Greer and then tap or click the ____ button on the HOME tab.
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
a.
Selection
b.
Filter By Selection
c.
Find
d.
Replace
a
10. When a filter is in effect, you can redisplay all records by tapping or clicking the ____ button on the HOME tab.
a.
Remove Filter
b.
Filter
c.
All
d.
Toggle Filter
11. To clear a filter, tap or click the ____ button on the HOME tab and then tap or click Clear All Filters.
a.
Filter
b.
Remove
c.
Advanced
d.
Select
c
12. To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of the
field name and point to the ____ command to display the custom text filters.
a.
Text Filters
b.
Character Filters
c.
Common Filters
d.
Common Character Filters
a
13. To use Filter By Form to filter records, tap or click the ____ button on the HOME tab and then click Filter By Form.
a.
Advanced
b.
Filter
c.
Selection
d.
Find
a
14. When you use Filter By Form to restrict records that appear, you create the filter and then tap or click the ____ button
to apply the filter.
a.
Apply Filter
b.
Filter
c.
Toggle Filter
d.
Select
c
15. To filter records using complex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
Filter/Sort on the menu that appears.
a.
Filter
b.
Find
c.
Selection
d.
Advanced
16. When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then tap or click the
____ button on the HOME tab to view the results.
a.
Filter
b.
Selection
c.
Advanced
d.
Toggle Filter
17. To delete a field from a table, open the table in ____ view, tap or click the row selector for the field to be deleted, and
then press the DELETE key.
a.
Change
b.
Edit
c.
Design
d.
Datasheet
c
18. A ___ field allows the user to select from a list of values.
a.
list
b.
lookup
c.
combo
d.
value
19. To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.
a.
list
b.
value
c.
combo
d.
lookup
20. To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to
be modified, and tap or click the ____ tab in the Field Properties pane.
a.
Modify
b.
Change
c.
Edit
d.
Lookup
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
21. A(n) ____ field is a field that can be computed from other fields.
a.
aggregate
b.
combined
c.
total
d.
calculated
22. To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.
a.
Query Type
b.
Action
c.
Update
d.
Data Definition
c
23. To use the shortcut menu to create an update query, press and hold or right-click any open area in the upper pane,
point to ____ on the shortcut menu, and then tap or click Update Query on the submenu that appears.
a.
Action
b.
Query Type
c.
Action Query
d.
Run Query
24. To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion,
and then tap or click the ____ button to update the records.
a.
Run
b.
View
c.
Execute
d.
Update
a
25. A(n) ____ query adds a group of records from one table to the end of another table.
a.
insert
b.
append
c.
add
d.
supplement
26. A(n) ____ query adds records from an existing table to a new table, that is, a table that has not yet been created.
a.
insert-table
b.
new-table
c.
add-table
d.
make-table
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
27. To specify that a field is to be required, change the value for the _____ property from No to Yes.
a.
Required
b.
No Blanks
c.
Necessary
d.
Completed
a
AC 163
28. To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property
box.
a.
T*
b.
T%
c.
T>
d.
T?
AC 163
29. To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule
property box.
a.
>=0, <=30,000
b.
>=$0, <=$30,000
c.
>=0 and <=30000
d.
>=$0 and <=$30,000
c
AC 164
30. To indicate that the only allowable values for the Customer Type field are HS, COM, and UNI, enter ____ in the
Validation Rule property box.
a.
=HS or =COM or =UNI
b.
HS, COM, UNI
c.
must be HS, COM, or UNI
d.
=HS, =COM, =UNI
a
AC 165
31. If the Customer Number field in a record always should display the three characters in the customer number in
uppercase, then the correct format for this field is ____.
a.
<
b.
&
c.
%
d.
>
AC 165
32. To save validation rules, default values, and formats, tap or click the Save button on the ____ to save the changes.
a.
HOME tab
b.
status bar
c.
Quick Access Toolbar
d.
DESIGN tab
c
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
33. To include totals and other statistics at the bottom of a datasheet, tap or click the ____ button on the HOME tab to
include the Total row in the datasheet.
a.
Statistics
b.
Add Total
c.
Insert Total
d.
Totals
AC 175
34. To remove a total row that appears in a datasheet, tap or click the ____ button on the HOME tab.
a.
Toggle
b.
Remove
c.
Statistics
d.
Totals
AC 176
35. To change a query so that each item in a multivalued field occurs on a different row, use the ____ property.
a.
Field
b.
Value
c.
Unique
d.
Distinct
AC 180
36. To find duplicate records in a table, use the _____ Query Wizard.
a.
Duplicate Records
b.
Same Records
c.
Duplicate Primary Key
d.
Find Duplicates
AC 187
37. To find records in one table that have no matching records in another table, use the _____ Query Wizard.
a.
No Matches
b.
No Records
c.
Find Unmatched
d.
Find Records
c
AC 187
38. To order the records in the Customer table by city in alphabetical order, use the ____ button.
a.
Order Ascending
b.
Sort
c.
Sort Ascending
d.
Ascending
AC 166
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
39. To order the records in the Customer table in reverse alphabetical order by City, click the ____ button.
a.
Order Descending
b.
Descending
c.
Sort Descending
d.
Sort
40. To exit Access, click the ____ button on the right side of the Access title bar.
a.
Quit
b.
Exit
c.
Close
d.
Done
c
Modified Multiple Choice
41. Maintaining a database can include ____.
a.
filtering records
b.
changing the appearance of a datasheet
c.
adding new records
d.
changing the data for existing records
a, b, c, d
42. You can add a record to a table by ____.
a.
tapping or clicking the New (blank) record button on the Navigation bar
b.
pressing CTRL+PLUS SIGN (+)
c.
tapping or clicking the New button
d.
pressing the INSERT key
a, b, c
43. The wildcard symbols for use with filters are ____.
a.
asterisk (*)
b.
dollar sign ($)
c.
question mark (?)
d.
caret symbol (^)
a, c
44. Validation rules can indicate a ____.
a.
required field
b.
default value
c.
lookup field
d.
range of values
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
a, b, d
45. Computations available for the Total row in a column that contains currency include ____.
a.
Sum
b.
Square Root
c.
Average
d.
Count
a, c, d
46. Restructuring the database includes adding new fields to a table, changing the characteristics of existing fields, and
removing existing fields.
a.
True
b.
False
True
47. Validation rules ensure validity of the data in the database, while entity integrity ensures the validity of the
relationships.
a.
True
b.
False
False
48. When you use a split form, you only can add records using the simple form.
a.
True
b.
False
False
49. The button on the Access status bar that displays a form in Form view is Form View.
a.
True
b.
False
True
50. To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.
a.
True
b.
False
Name:
Class:
Date:
Access 2013 Chapter 03: Maintaining a Database
True
51. Looking for the customer whose number is PLI22 is an example of searching.
a.
True
b.
False
True
52. You can search for a record in Form view but not in Datasheet view.
a.
True
b.
False
False
53. To open a form in Form view from the Navigation Pane, press and hold or right-click the form and tap or click Form
View on the shortcut menu.
a.
True
b.
False
54. If the TAB key is used to move from field to field in a record, press F2 to produce an insertion point in a field.
a.
True
b.
False
True
55. Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced
Filter/Sort.
a.
True
b.
False
True
56. You can use a filter in either Datasheet view or Form view.
a.
True
b.
False