Enhanced Microsoft Access 2013: Comprehensive 1st Edition Test Bank

Name: Enhanced Microsoft Access 2013: Comprehensive 1st Edition Test Bank
Brand: Academic Documents Platform
Price: 20 USD
Availability: InStock
Author: Ethan Wilson

With Enhanced Microsoft Access 2013: Comprehensive 1st Edition Test Bank, you'll have everything you need to boost your confidence and ace your test.

Ethan Wilson

Contributor

4.7

2 days ago

Preview (16 of 556)

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 1
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
7. A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 2
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
REFERENCES: AC 10

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 3
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
ANSWER: b
POINTS: 1
REFERENCES: AC 15

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 4
19. To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow
the new field, and then tap or click ____ on the shortcut menu.
a. Insert Column b. Insert Field
c. Add Column d. Add Field
ANSWER: b
POINTS: 1
REFERENCES: AC 15-AC 16
20. To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click
____ on the shortcut menu
a. Table Design b. Layout View
c. Structure View d. Design View
ANSWER: d
POINTS: 1
REFERENCES: AC 17
21. In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates
that Book Rep Number is the ____ for the table.
a. principal key b. foreign key
c. main key d. primary key
ANSWER: d

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 5
POINTS: 1
REFERENCES: AC 17
22. In the accompanying figure, the Book Rep table displays in ____.
a. Structure view b. Design view
c. Layout view d. Table view
ANSWER: b
POINTS: 1
REFERENCES: AC 17
23. In the accompanying figure, the small box or bar to the left of each field is called the ____.
a. row selector b. field selector
c. field bar d. current field bar
ANSWER: a
POINTS: 1
REFERENCES: AC 18
24. To add a record to a table, tap or click the ____ record button.
a. Add New b. New (blank)
c. Last d. Insert (New)
ANSWER: b
POINTS: 1
REFERENCES: AC 23
25. You can place an insertion point by tapping or clicking in the field or by pressing ____.
a. F2 b. F3
c. F4 d. F5
ANSWER: a
POINTS: 1
REFERENCES: AC 23
26. To delete a record, tap or click the record selector for the record, and then press the ____ key(s).
a. CTRL+DELETE b. CTRL+Y
c. DELETE d. CTRL+K
ANSWER: c
POINTS: 1
REFERENCES: AC 23
27. To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click
____ , and then tap or click Proofing in the dialog box that displays.
a. Customize b. Manage
c. Options d. Grammar
ANSWER: c
POINTS: 1

Loading page 6...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 6
REFERENCES: AC 23
28. To save the changes to the layout of a table, tap or click the Save button on the ____.
a. status bar b. TABLE TOOLS tab
c. Navigation Pane d. Quick Access Toolbar
ANSWER: d
POINTS: 1
REFERENCES: AC 28
29. To change the print orientation from portrait to landscape, tap or click the ____ button on the PRINT PREVIEW tab.
a. Portrait/Landscape b. Orientation
c. Switch Orientation d. Landscape
ANSWER: d
POINTS: 1
REFERENCES: AC 31
30. To import data to a table, tap or click the ____ tab on the ribbon.
a. DATABASE TOOLS b. FILE
c. EXTERNAL DATA d. IMPORT
ANSWER: c
POINTS: 1
REFERENCES: AC 33
31. To open the Navigation Pane, tap or click the ____ Button.
a. Open Navigation Pane b. Open Pane
c. Shutter Bar Open/Close d. Navigation Bar Show/Hide
ANSWER: c
POINTS: 1
REFERENCES: AC 40
32. To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.
a. CREATE b. INSERT
c. NEW OBJECT d. REPORT
ANSWER: a
POINTS: 1
REFERENCES: AC 40
33. To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click
____ on the shortcut menu.
a. Datasheet View b. Open
c. Results View d. Run
ANSWER: b
POINTS: 1
REFERENCES: AC 42-AC 43

Loading page 7...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 7
34. To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click
____ on the shortcut menu.
a. Open b. SQL
c. Query Window d. Design View
ANSWER: d
POINTS: 1
REFERENCES: AC 42
35. To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.
a. Layout b. Report Layout
c. Report d. Simple Report
ANSWER: c
POINTS: 1
REFERENCES: AC 49
36. To exit Access, tap or click the ____ button on the right side of the title bar.
a. Quit b. Stop
c. End d. Close
ANSWER: d
POINTS: 1
REFERENCES: AC 56
37. To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
a. Close and Back Up b. Back Up Current
c. Save As Back Up d. Back Up Database
ANSWER: d
POINTS: 1
REFERENCES: AC 56
38. To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
a. Restore b. Fix
c. Compaction d. Compact & Repair
ANSWER: d
POINTS: 1
REFERENCES: AC 57
39. To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____
on the shortcut menu.
a. Erase b. Trash
c. Delete d. Remove
ANSWER: c
POINTS: 1
REFERENCES: AC 58

Loading page 8...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 8
40. To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____
on the shortcut menu.
a. New Name b. Redefine
c. Rename d. Save Name
ANSWER: c
POINTS: 1
REFERENCES: AC 58
Modified Multiple Choice
41. File names cannot contain a(n) ____.
a. question mark (?) b. colon (:)
c. space d. underscore (_)
ANSWER: a, b
POINTS: 1
REFERENCES: AC 7
42. Field names cannot contain ____.
a. square brackets ([ ]) b. periods (.)
c. hyphens (-) d. accent graves (‘)
ANSWER: a, b, d
POINTS: 1
REFERENCES: AC 8
43. The Access window consists of a variety of components. These include the ____.
a. Navigation Pane b. Content pane
c. Object tabs d. Quick Access Toolbar
ANSWER: a, c, d
POINTS: 1
REFERENCES: AC 8
44. A field with a Yes/No data type can store only one of two values. The choices are ____.
a. True/False b. One/Zero
c. Yes/No d. On/Off
ANSWER: a, c, d
POINTS: 1
REFERENCES: AC 9
45. You can create a table in ____.
a. Design view b. Blank view
c. Layout view d. Datasheet view
ANSWER: a, d
POINTS: 1

Loading page 9...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 9
REFERENCES: AC 10
46. In Access, the columns in a table are called records.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 3
47. A unique identifier also is called a primary key.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 3
48. In Access, field names cannot contain digits.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 8
49. The Navigation Pane contains a list of all the objects in the database.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 8
50. In Datasheet view, a table is represented as a collection of rows and columns called a list.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 8
51. The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 9

Loading page 10...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 10
52. Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 9
53. The Currency data type is used for fields that contain only monetary data.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 9
54. The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers
where the total number of characters may exceed 255.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 9
55. When Access first creates a database, it automatically creates a table.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 11
56. One way to undo changes to a field is to click the Undo button on the status bar.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 15
57. The AutoError Correction feature of Access corrects common data entry errors.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 23

Loading page 11...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 11
58. As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by
clicking the Insert record Navigation button.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 26
59. As shown in the accompanying figure, you can use the Last record button to move to the last record in the table.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 26
60. As shown in the accompanying figure, you can move to the first record in a table by clicking the Start record
Navigation button.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 26
61. Changing the column width in a datasheet changes the structure of a table.
a. True
b. False

Loading page 12...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 12
ANSWER: False
POINTS: 1
REFERENCES: AC 28
62. Landscape orientation means the printout is across the length (height) of the page.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 29
63. To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 29
64. To preview and then print the contents of a table, use Table Preview.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 30
65. Form view displays a single record at a time.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 45
66. Layout view shows a report on the screen and allows the user to make changes to the report.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 50
67. Standard properties are associated with all Microsoft Office documents and include author, title, and subject.
a. True
b. False
ANSWER: True
POINTS: 1

Loading page 13...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 13
REFERENCES: AC 54
68. The DATABASE TOOLS tab provides commands to save a database with another name.
a. True
b. False
ANSWER: False
POINTS: 1
REFERENCES: AC 57
69. Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many
relationship.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 62
70. Redundancy means storing the same fact in more than one place.
a. True
b. False
ANSWER: True
POINTS: 1
REFERENCES: AC 62
71. The term list database describes a database that consists of a collection of tables, each of which contains information
on a specific subject. ____________________
ANSWER: False - relational
POINTS: 1
REFERENCES: AC 2
72. A field that has the Calculated data type can store a unique sequential number that Access assigns to a record.
____________________
ANSWER: False - AutoNumber
POINTS: 1
REFERENCES: AC 9
73. To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click
Rename Field on the shortcut menu. ____________________
ANSWER: True
POINTS: 1
REFERENCES: AC 15
74. To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow
the new field, and then tap or click Insert Column on the shortcut menu. ____________________
ANSWER: False - Field

Loading page 14...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 14
POINTS: 1
REFERENCES: AC 15-AC 16
75. To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on
the shortcut menu. ____________________
ANSWER: False - Delete
POINTS: 1
REFERENCES: AC 15
76. A(n)____________________ is software that can be used to create a database; add, change, and delete data in the
database; ask and answer questions concerning the data in the database; and create forms and reports using the data.
ANSWER: database management system
POINTS: 1
REFERENCES: AC 2
77. The rows in the tables are called ____________________.
ANSWER: records
POINTS: 1
REFERENCES: AC 3
78. A(n) ____________________ contains a specific piece of information within a record.
ANSWER: field
POINTS: 1
REFERENCES: AC 3
79. A unique identifier also is called a(n) ____________________.
ANSWER: primary key
POINTS: 1
REFERENCES: AC 3

Loading page 15...

Name: Class: Date:
Access 2013 Chapter 01: Databases and Database Objects
Cengage Learning Testing, Powered by Cognero Page 15
80. In the accompanying figure, the ____________________ Pane contains a list of all the objects in the database.
ANSWER: Navigation
POINTS: 1
REFERENCES: AC 7
81. In the accompanying figure, the words Datasheet View at the lower left of the screen appear on the
____________________.
ANSWER: status bar
POINTS: 1
REFERENCES: AC 7
82. In the accompanying figure, the entire area that displays on the screen is called the ____________________ work
area.
ANSWER: Access
POINTS: 1
REFERENCES: AC 7
83. In the accompanying figure, ____________________ for the open objects appear at the top of the work area.
ANSWER: object tabs
POINTS: 1
REFERENCES: AC 7
84. In the accompanying figure, the database name, Bavant Publishing appears on the ____________________.
ANSWER: title bar
POINTS: 1
REFERENCES: AC 7

Loading page 16...

13 more pages available. Scroll down to load them.

Preview Mode

100%

Study Now!

XY-Copilot AI

Unlimited Access

Secure Payment

Instant Access

24/7 Support

Document Chat

Document Details

Subject

Information Technology

Enhanced Microsoft Access 2013: Comprehensive 1st Edition Test Bank

Study Now!

Document Details

Related Documents

Trust Relationship Between Two Domains

Cloud Computing in Education Section

Best Use of MD5 or SHA1 Network Security

Data Breaches and Regulatory requirement

Week 5 iLab� Fireworks Stand Checkout

Computer Systems Security Foundations

HD DVD/Blu-ray Format

ERM and Database Management

Single Sign-On Access

Cloud Technology and Virtualization

Company

Explore

Study Tools