Database Processing Fundamentals, Design, and Implementation, Kroenke - Exam Preparation Test Bank (Downloadable Doc)

Database Processing, 14e (Kroenke)
Appendix A: Getting Started with Microsoft Access 2013

1) Microsoft Access is a personal database that combines a DBMS with an application generator.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

2) The Microsoft Access application generator provides the ability to create and store forms,
reports, and queries.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To create databases in Microsoft Access 2013
Classification: Concept

3) Microsoft Access 2013 databases are stored using the file extension .accdb.
Answer: TRUE
AACSB: Information Technology
Difficulty: Difficult
LO: To create databases in Microsoft Access 2013
Classification: Concept

4) Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format for
database files.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
LO: To create databases in Microsoft Access 2013
Classification: Concept

5) Microsoft Access uses the AutoNumber data type to create surrogate keys.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand Microsoft Access 2013 data types
Classification: Concept

6) To start Microsoft Access 2013 in Windows 8, use the Start | All Programs | Microsoft Office |
Microsoft Access 2013 command.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept
1
Copyright © 2016 Pearson Education, Inc.

,7) Microsoft Access 2013 uses the Microsoft Office Fluent User Interface.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

8) Most Microsoft Access 2013 commands and tools are available on the tabbed Ribbon.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

9) The Microsoft Access 2013 tabbed Ribbon contains a set of control tabs.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

10) Each Microsoft Access 2013 command tab contains a set of tools grouped into sets of related
commands.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

11) The default Microsoft Access 2013 command tabs are HOME, CREATE, INTERNAL
DATA and DATABASE TOOLS.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

12) In addition to the basic command tabs, Microsoft Access 2013 also has additional contextual
command tabs.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept



2
Copyright © 2016 Pearson Education, Inc.

,13) Microsoft uses the term object as a general name for various parts of a Microsoft Access
2013 database.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

14) Microsoft Access database objects are displayed in the Browser Pane.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To create databases in Microsoft Access 2013
Classification: Concept

15) The Microsoft Access window Close button is actually a close-and-exit button.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To create databases in Microsoft Access 2013
Classification: Concept

16) In Microsoft Access, relationships between tables are created in the Relationships window.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create relationships between tables in Microsoft Access 2013
Classification: Concept

17) In Microsoft Access, foreign keys are designated by using the Foreign Key button in the
toolbar.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
LO: To create relationships between tables in Microsoft Access 2013
Classification: Concept

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
AACSB: Information Technology
Difficulty: Moderate
LO: To create relationships between tables in Microsoft Access 2013
Classification: Concept




3
Copyright © 2016 Pearson Education, Inc.

, 19) Microsoft Access SQL commands are run within the SQL View of a Query window.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create Query-by-Example (QBE) queries in Microsoft Access 2013
Classification: Concept

20) Microsoft Access can run QBE queries, but not SQL queries.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
LO: To create Query-by-Example (QBE) queries in Microsoft Access 2013
Classification: Concept

21) To open a new Microsoft Access Query window, click the Query Design button on the
Create command.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
LO: To create Query-by-Example (QBE) queries in Microsoft Access 2013
Classification: Concept

22) In Microsoft Access, the primary key must be set as a field property while the table is in
Design View.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
LO: To create tables in Microsoft Access 2013
Classification: Concept

23) Microsoft Access wizards allow easy building of forms and reports.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
LO: To understand the use of the Report Wizard in Microsoft Access 2013
Classification: Concept




4
Copyright © 2016 Pearson Education, Inc.