Exam 14: Creating Database Security and Documentation

Explore all topics

If a database file gets damaged or corrupted, you should be able to look at the documentation produced by the Back Up Database Command and fix the database or re-create it.

Free

(True/False)

4.8/5

(32)

Question 1

Correct Answer:

Verified

False

In Open Exclusive mode, only the person who opened the database can use and make changes to it; all other users are locked out from opening and using the database.

Free

(True/False)

4.9/5

(33)

Question 2

Correct Answer:

Verified

True

Typically when you open a database, you use the Open mode.

Free

(True/False)

4.7/5

(21)

Question 3

Correct Answer:

Verified

True

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. Ron questions how a password can be used with an Access database. You explain that when opening a(n) ____ database, Access 2010 will prompt Ron for a password.

(Multiple Choice)

4.8/5

(34)

Question 4

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. One of Ted's junior database designers questions the usefulness of the auditor's request. Ted explains that documenting the database design is considered a(n) ____ feature.

(Multiple Choice)

4.8/5

(40)

Question 5

If you click the Encrypt with Password button and the database is not opened in the Exclusive mode, ____.

(Multiple Choice)

4.9/5

(32)

Question 6

You can remove the database encryption by using the ____ button.

(Multiple Choice)

4.8/5

(34)

Question 7

You should document the database design in case the file gets ____.

(Multiple Choice)

4.9/5

(32)

Question 8

When you encrypt a database, data within the database is made unusable.

(True/False)

4.8/5

(34)

Question 9

FIGURE AC 14-11 In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

(Multiple Choice)

4.8/5

(35)

Question 10

Until the correct password is entered, no objects in an encrypted database can be viewed.

(True/False)

4.9/5

(39)

Question 11

Identify the letter of the choice that best matches the phrase or definition.

Collection of characters that a user types to gain access to a file.

Open Exclusive mode

Allows the current user to only view the data in the database.

encryption

Option typically used when you want to encrypt a database with a password.

Open Exclusive Read-Only mode

Correct Answer:

Verified

Collection of characters that a user types to gain access to a file.

Allows the current user to only view the data in the database.

Option typically used when you want to encrypt a database with a password.

Means that when you change values in a record in an encrypted database, only the changed record will be encrypted.

Places the database in an unintelligible format.

(Matching)

4.9/5

(33)

Question 12

To avoid losing database information, you can open a database in the Open Exclusive mode.

(True/False)

4.8/5

(28)

Question 13

An encrypted database cannot be viewed or understood unless it is ____ with the correct password.

(Multiple Choice)

4.8/5

(22)

Question 14

The database ____________________ refers to the objects in the database and the relationship between these objects.

(Short Answer)

4.7/5

(35)

Question 15

An Access Database backup file uses ____ for the file extension.

(Multiple Choice)

4.9/5

(33)

Question 16

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

(True/False)

4.9/5

(35)

Question 17

The Back Up Database option is accessed by clicking the ____ option within the File tab.

(Multiple Choice)

4.9/5

(34)

Question 18

A social security number is considered sensitive information.

(True/False)

4.8/5

(34)

Question 19

A(n) ____________________ is a duplicate copy of the database.

(Short Answer)

4.8/5

(30)

Question 20

Showing 1 - 20 of 46

Exam 14: Creating Database Security and Documentation

If a database file gets damaged or corrupted, you should be able to look at the documentation produced by the Back Up Database Command and fix the database or re-create it.

In Open Exclusive mode, only the person who opened the database can use and make changes to it; all other users are locked out from opening and using the database.

Typically when you open a database, you use the Open mode.

If you click the Encrypt with Password button and the database is not opened in the Exclusive mode, ____.

You can remove the database encryption by using the ____ button.

You should document the database design in case the file gets ____.

When you encrypt a database, data within the database is made unusable.

FIGURE AC 14-11 In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

Until the correct password is entered, no objects in an encrypted database can be viewed.

To avoid losing database information, you can open a database in the Open Exclusive mode.

An encrypted database cannot be viewed or understood unless it is ____ with the correct password.

The database ____________________ refers to the objects in the database and the relationship between these objects.

An Access Database backup file uses ____ for the file extension.

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

The Back Up Database option is accessed by clicking the ____ option within the File tab.

A social security number is considered sensitive information.

A(n) ____________________ is a duplicate copy of the database.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters