Database Processing, 13e (Kroenke/Auer)
Appendix A: Microsoft Access 2013
1) Microsoft Access is a personal database that combines a DBMS with an application
generator.
Answer: TRUE
Diff: 1 Page Ref: A-4
2) The Microsoft Access application generator provides the ability to create and store
forms, reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: A-4
3) Microsoft Access databases are stored using the file extension .accdb.
Answer: TRUE
Diff: 3 Page Ref: A-7
4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format
for database files.
Answer: FALSE
Diff: 2 Page Ref: A-7
5) Microsoft Access uses the AutoNumber data type to create surrogate keys.
Answer: TRUE
Diff: 2 Page Ref: A-14-A-16
,6) To start Microsoft Access 2013, use the Start | All Programs | Microsoft Office |
Microsoft Access 2013 command.
Answer: FALSE
Diff: 1 Page Ref: A-6
7) Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
Answer: TRUE
Diff: 1 Page Ref: A-8
8) Most Microsoft Access 2013 commands and tools are available on the tabbed Ribbon.
Answer: TRUE
Diff: 1 Page Ref: A-10
9) The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.
Answer: FALSE
Diff: 1 Page Ref: A-10
10) Each Microsoft Access 2013 command tab contains a set of tools grouped into sets of
related commands.
Answer: TRUE
Diff: 1 Page Ref: A-10
11) The default Microsoft Access 2013 command tabs are HOME, CREATE,
INTERNAL DATA and DATABASE TOOLS.
Answer: FALSE
Diff: 1 Page Ref: A-10
,12) In addition to the basic command tabs, Microsoft Access 2013 also has additional
contextual command tabs.
Answer: TRUE
Diff: 1 Page Ref: A-10
13) Microsoft uses the term object as a general name for various parts of a Microsoft
Access 2013 database.
Answer: TRUE
Diff: 1 Page Ref: A-11
14) Microsoft Access database objects are displayed in the Browser Pane.
Answer: FALSE
Diff: 2 Page Ref: A-11
15) The Microsoft Access window Close button is actually a close-and-exit button.
Answer: TRUE
Diff: 2 Page Ref: A-11
16) In Microsoft Access, relationships between tables are created in the Relationships
window.
Answer: TRUE
Diff: 1 Page Ref: A-27
17) In Microsoft Access, foreign keys are designated by using the Foreign Key button in
the toolbar.
Answer: FALSE
Diff: 2 Page Ref: A-27-A-30
, 18) In Microsoft Access, a relationship is created by dragging a foreign key column and
dropping it on top of the corresponding primary key.
Answer: FALSE
Diff: 2 Page Ref: A-27-A-30
19) Microsoft Access SQL commands are run within the SQL View of a Query window.
Answer: TRUE
Diff: 1 Page Ref: Ch02: 47-50
20) Microsoft Access can run QBE queries, but not SQL queries.
Answer: FALSE
Diff: 1 Page Ref: Ch02: 47-50
Appendix A: Microsoft Access 2013
1) Microsoft Access is a personal database that combines a DBMS with an application
generator.
Answer: TRUE
Diff: 1 Page Ref: A-4
2) The Microsoft Access application generator provides the ability to create and store
forms, reports, and queries.
Answer: TRUE
Diff: 2 Page Ref: A-4
3) Microsoft Access databases are stored using the file extension .accdb.
Answer: TRUE
Diff: 3 Page Ref: A-7
4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format
for database files.
Answer: FALSE
Diff: 2 Page Ref: A-7
5) Microsoft Access uses the AutoNumber data type to create surrogate keys.
Answer: TRUE
Diff: 2 Page Ref: A-14-A-16
,6) To start Microsoft Access 2013, use the Start | All Programs | Microsoft Office |
Microsoft Access 2013 command.
Answer: FALSE
Diff: 1 Page Ref: A-6
7) Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
Answer: TRUE
Diff: 1 Page Ref: A-8
8) Most Microsoft Access 2013 commands and tools are available on the tabbed Ribbon.
Answer: TRUE
Diff: 1 Page Ref: A-10
9) The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.
Answer: FALSE
Diff: 1 Page Ref: A-10
10) Each Microsoft Access 2013 command tab contains a set of tools grouped into sets of
related commands.
Answer: TRUE
Diff: 1 Page Ref: A-10
11) The default Microsoft Access 2013 command tabs are HOME, CREATE,
INTERNAL DATA and DATABASE TOOLS.
Answer: FALSE
Diff: 1 Page Ref: A-10
,12) In addition to the basic command tabs, Microsoft Access 2013 also has additional
contextual command tabs.
Answer: TRUE
Diff: 1 Page Ref: A-10
13) Microsoft uses the term object as a general name for various parts of a Microsoft
Access 2013 database.
Answer: TRUE
Diff: 1 Page Ref: A-11
14) Microsoft Access database objects are displayed in the Browser Pane.
Answer: FALSE
Diff: 2 Page Ref: A-11
15) The Microsoft Access window Close button is actually a close-and-exit button.
Answer: TRUE
Diff: 2 Page Ref: A-11
16) In Microsoft Access, relationships between tables are created in the Relationships
window.
Answer: TRUE
Diff: 1 Page Ref: A-27
17) In Microsoft Access, foreign keys are designated by using the Foreign Key button in
the toolbar.
Answer: FALSE
Diff: 2 Page Ref: A-27-A-30
, 18) In Microsoft Access, a relationship is created by dragging a foreign key column and
dropping it on top of the corresponding primary key.
Answer: FALSE
Diff: 2 Page Ref: A-27-A-30
19) Microsoft Access SQL commands are run within the SQL View of a Query window.
Answer: TRUE
Diff: 1 Page Ref: Ch02: 47-50
20) Microsoft Access can run QBE queries, but not SQL queries.
Answer: FALSE
Diff: 1 Page Ref: Ch02: 47-50
