Test Bank Enhanced Microsoft Access 2013 Comprehensive 1St Edition By Pratt

,Name Clas Dat
: s: e:

Access 2013 Chapter 01: Databases and Database Objects
1. Access is a ____.
a. word processing software tool b. file management system
c. workbook management system d. database management system
ANSWER: d
POINTS: 1
REFERENCES: AC 2

2. In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which
contains information on a specific subject.
a. tabular b. record
c. attribute d. relational
ANSWER: d
POINTS: 1
REFERENCES: AC 2

3. A(n) ____ contains information about a given person, product, or event.
a. attribute b. record
c. field d. column
ANSWER: b
POINTS: 1
REFERENCES: AC 3

4. ____ words are words that have a special meaning to Access and cannot be used for the names of fields.
a. Reserved b. Restricted
c. Significant d. Tagged
ANSWER: a
POINTS: 1
REFERENCES: AC 4

5. In Access, table and field names can be up to ____ characters in length.
a. 256 b. 128
c. 64 d. 32
ANSWER: c
POINTS: 1
REFERENCES: AC 8

6. A field whose data type is ____ can contain any characters.
a. Alpha b. Character
c. Normal d. Short Text
ANSWER: d
POINTS: 1
REFERENCES: AC 9

Cengage Learning Testing, Powered by Cognero Page 1

,Name Clas Dat
: s: e:

Access 2013 Chapter 01: Databases and Database Objects
7. A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of
characters may exceed 255.
a. Memo b. Long Text
c. Variable d. Character
ANSWER: b
POINTS: 1
REFERENCES: AC 9

8. A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will
increment the number by 1 as each new record is added.
a. Sequential b. ValueIncrement
c. Incremental d. AutoNumber
ANSWER: d
POINTS: 1
REFERENCES: AC 9

9. A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
a. Attachment b. File
c. Document d. Extend
ANSWER: a
POINTS: 1
REFERENCES: AC 9

10. A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
a. Illustration b. Image
c. Bitmap d. OLE object
ANSWER: d
POINTS: 1
REFERENCES: AC 9

11. A field whose data type is ____ can store text that can be used as a hyperlink address.
a. URL b. Web
c. Placeholder d. Hyperlink
ANSWER: d
POINTS: 1
REFERENCES: AC 9

12. When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in
datasheets and in forms.
a. alternate b. caption
c. abbreviation d. tag
ANSWER: b
POINTS: 1

Cengage Learning Testing, Powered by Cognero Page 2

, Name Clas Dat
: s: e:

Access 2013 Chapter 01: Databases and Database Objects
REFERENCES: AC 10

13. When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.
a. AutoNumber b. AutoFill
c. ID d. PrimaryID
ANSWER: c
POINTS: 1
REFERENCES: AC 11

14. To define an additional field in Datasheet view, tap or click the ____ column heading.
a. New Field b. Add Field
c. Click to Add d. Insert Field
ANSWER: c
POINTS: 1
REFERENCES: AC 14

15. To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.
a. Cancel b. Reverse
c. Back d. Undo
ANSWER: d
POINTS: 1
REFERENCES: AC 15

16. To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on
the shortcut menu.
a. Remove Field b. Delete Field
c. Delete Column d. Remove Column
ANSWER: b
POINTS: 1
REFERENCES: AC 15

17. To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the
shortcut menu, and then type the desired field name.
a. Change Column b. Rename Column
c. Change Field d. Rename Field
ANSWER: d
POINTS: 1
REFERENCES: AC 15

18. To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is
Currency.
a. Field Size b. Format
c. Caption d. Description

Cengage Learning Testing, Powered by Cognero Page 3