Question 1

Preventing a table from being opened directly requires hiding the ________.

Accepted Answer

The answer of Preventing a table from being opened directly...

Question 2

Suggestions are actions that Access believes will improve your database performance but may have consequences that should be considered first.

Accepted Answer

A) True 
 B)False

Question 3

After you run the ________,it provides three types of analysis results.

Accepted Answer

The answer of After you run the ________,it provides three...

Question 4

Information is ________ using a key.In Access,the key will be a password.In other applications,the key can be a separate file.

Accepted Answer

A) encrypted 
B) decrypted 
C) secured 
D) shared

Question 5

In ________ implementations,small groups of a company start using the new database.Gradually,more groups come on board as the system is perfected,until the entire organization is using the new system.

Accepted Answer

The answer of In ________ implementations,small groups of a company...

Question 6

The keyboard shortcut of ________ shows or hides the Navigation Pane

Accepted Answer

A) Alt + F11 
B) Ctrl + G 
C) Ctrl + Break 
D) F11

Question 7

Which of the following is NOT true regarding linked tables and the Linked Table Manager?

Accepted Answer

A) When a linked table is opened,Access refreshes the data contained in the linked object. 
B) Linked tables are dependent on the location of the object,not the database that contains the link. 
C) If a linked object is moved,the Linked Table Manager can be used to refresh the link. 
D) Access will search for the data if the linked object has been moved.

Question 8

To ensure the ________ of the database,access to several features must be eliminated.

Accepted Answer

A) usability 
B) security 
C) integrity 
D) functionality

Question 9

Special keys are a set of four keyboard shortcuts that can be disabled when securing a database.

Accepted Answer

A) True 
 B)False

Question 10

The back-end database is deployed directly to users and contains nondata objects such as queries,reports,forms,macros,and VBA modules.

Accepted Answer

A) True 
 B)False

Question 11

The back-end database can be stored in a(n)________ where a company's technical support can ensure the data are protected and backed up regularly.

Accepted Answer

The answer of The back-end database can be stored in...

Question 12

The Performance Analyzer can only review individual Access objects.

Accepted Answer

A) True 
 B)False

Question 13

The ________ implementation approach involves implementing your database in its entirety and replacing the legacy system all at once.

Accepted Answer

The answer of The ________ implementation approach involves implementing your...

Question 14

When establishing security in a database for implementation,Access routinely requires opening the file in Exclusive Access mode.

Accepted Answer

A) True 
 B)False

Question 15

To properly secure a database,special keys should be disabled,because special keys allow users access to the Navigation Pane and the Visual Basic Editor even if these items are hidden from view initially in the database.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following common features of Access 2013 is NOT compatible with Access 2003?

Accepted Answer

A) Fields with the Hyperlink data type 
B) Calculated fields in tables 
C) Data macros 
D) Multivalued lookup fields

Question 17

The ________ of a database creates a front-end and back-end system.

Accepted Answer

A) encrypting 
B) splitting 
C) decrypting 
D) securing

Question 18

Ultimately,to protect a database and its information,passwords and decryption can be implemented.

Accepted Answer

A) True 
 B)False

Question 19

The ________ is deployed directly to users and contains nondata objects such as queries,reports,forms,macros,and VBA modules.

Accepted Answer

A) front-end database 
B) back-end database 
C) linked table 
D) database splitter

Question 20

In a ________ implementation,the legacy system and new system are used concurrently.

Accepted Answer

A) cold turkey 
B) phased 
C) parallel 
D) piloted

Exam 14: Workshop 14: Implement Your Database

Preventing a table from being opened directly requires hiding the ________.

Suggestions are actions that Access believes will improve your database performance but may have consequences that should be considered first.

After you run the ________,it provides three types of analysis results.

Information is ________ using a key.In Access,the key will be a password.In other applications,the key can be a separate file.

In ________ implementations,small groups of a company start using the new database.Gradually,more groups come on board as the system is perfected,until the entire organization is using the new system.

The keyboard shortcut of ________ shows or hides the Navigation Pane

Which of the following is NOT true regarding linked tables and the Linked Table Manager?

To ensure the ________ of the database,access to several features must be eliminated.

Special keys are a set of four keyboard shortcuts that can be disabled when securing a database.

The back-end database is deployed directly to users and contains nondata objects such as queries,reports,forms,macros,and VBA modules.

The back-end database can be stored in a(n)________ where a company's technical support can ensure the data are protected and backed up regularly.

The Performance Analyzer can only review individual Access objects.

The ________ implementation approach involves implementing your database in its entirety and replacing the legacy system all at once.

When establishing security in a database for implementation,Access routinely requires opening the file in Exclusive Access mode.

To properly secure a database,special keys should be disabled,because special keys allow users access to the Navigation Pane and the Visual Basic Editor even if these items are hidden from view initially in the database.

Which of the following common features of Access 2013 is NOT compatible with Access 2003?

The ________ of a database creates a front-end and back-end system.

Ultimately,to protect a database and its information,passwords and decryption can be implemented.

The ________ is deployed directly to users and contains nondata objects such as queries,reports,forms,macros,and VBA modules.

In a ________ implementation,the legacy system and new system are used concurrently.