Question 1

Which of the following is NOT a way to display the objects in the Navigation Pane?

Accepted Answer

The Navigation Pane in database applications like Microsoft Access typically allows you to display objects by Object Type, Created Date, or Custom Groups, but not by Ownership.

Question 2

Which of the following Access options provides a way to modify the buttons and tabs on the Ribbon?

Accepted Answer

The option that provides a way to modify the buttons and tabs on the Ribbon in Access is the "Customize Ribbon" option. With this option, users can add, remove, or rearrange commands on the Ribbon to suit their preferences and workflow. The Trust Center is where users can manage Access security settings, the Quick Access Toolbar is a customizable toolbar that contains frequently used commands, and Client Settings refer to settings related to the Access client application.

Question 3

3.5-inch disks with roughly 1 MB of storage capacity are a common portable storage device today.

Accepted Answer

3.5-inch disks with 1 MB of storage capacity were commonly used in the 1980s and early 1990s, but they are not commonly used as portable storage devices today. A more common portable storage device today would be a USB flash drive or an external hard drive with much larger storage capacities.

Question 4

You can recover a forgotten database password by opening the database in exclusive mode.

Accepted Answer

Opening a database in exclusive mode does not allow you to recover a forgotten password; password recovery typically requires specific tools or procedures depending on the database system.

Question 5

One of the reasons to split a database is to improve performance.

Accepted Answer

Splitting a database can improve performance by reducing the amount of data that needs to be processed at any given time and allowing for more efficient queries and updates. It also allows for better scalability and the possibility of distributing the database across multiple servers.

Question 6

-The figure shows a form with Horizontal Tabs.

Accepted Answer

The figure shows a form with Horizontal Tabs.

Question 7

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Accepted Answer

The back-end database only contains the tables and relationships. The queries, forms, and reports are usually stored in the front-end database.

Question 8

The .laccdb file is a temporary file.

Accepted Answer

The .laccdb file is a temporary file created by Access when a database is opened by a user for editing. It is used to lock the database to prevent other users from editing the same data at the same time. This file is deleted when the user closes the database.

Question 9

-The form in the figure displays the frmEmployees form on the first tab.

Accepted Answer

The question states that the frmEmployees form is displayed on the first tab, which is true.

Question 10

-The dialog box in the figure is accessed from which tab on the Ribbon?

Accepted Answer

The dialog box in the figure is accessed from the FILE tab on the Ribbon.

Question 11

Navigation forms can be used with any Access 2013 database, even if you don't publish it to a SharePoint server.

Accepted Answer

Navigation forms are a built-in feature of Access 2013 and can be used with any Access database, without the requirement of publishing it to a SharePoint server.

Question 12

External hard drives typically have more storage capacity than USB drives.

Accepted Answer

External hard drives can have terabytes of storage capacity, while USB drives usually max out at a few hundred gigabytes.

Question 13

Access to queries, forms, and reports may all be added to a navigation form.

Accepted Answer

Navigation forms in Microsoft Access can include links to queries, forms, and reports for easy access and organization.

Question 14

-In the figure above, the Compact on Close option is checked. This helps you ____.

Accepted Answer

The Compact on Close option in database management systems like Microsoft Access helps reduce the size of the database and improve its efficiency by compacting and repairing the database each time it is closed.

Question 15

The Workgroup Administrator tool is used to recover forgotten passwords.

Accepted Answer

The Workgroup Administrator tool is used to manage user accounts and group memberships in a workgroup environment, but it cannot be used to recover forgotten passwords.

Question 16

Closing all applications that you don't currently need to free up memory is a relatively easy way to improve performance.

Accepted Answer

Closing unnecessary applications frees up system resources, such as RAM and CPU, which can improve overall system performance.

Question 17

Database passwords are case sensitive which means that IOWA and iowa are different passwords.

Accepted Answer

Passwords in databases are usually case sensitive, meaning that uppercase and lowercase letters are considered different characters, so IOWA and iowa would be two different passwords.

Question 18

Default database options are stored in the Access Options dialog box.

Accepted Answer

Default database options can be set and modified in the Access Options dialog box.

Question 19

The Performance Analyzer makes a variety of recommendations on how you can improve database performance.

Accepted Answer

The Performance Analyzer analyzes database performance and suggests ways to improve it.

Question 20

More than one person can work with the data in an Access database at the same time.

Accepted Answer

Access has the capability to allow multiple users to work with the same database at the same time, known as multi-user access. However, it is important to properly set up and manage the database to ensure data integrity and avoid conflicts between multiple users.

Quiz 16: Administering the Database