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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller evileye251. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £20.49. You're not tied to anything after your purchase.
