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

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