Question 1

Match the following terms with their meanings:
I. anomaly
II. composite key
III. encryption
IV. non-key field
A. the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key
B. an error or inconsistency that occurs when you add, edit, and delete data
C. a field that is not part of the primary key
D. a primary key that is made up of two or more fields

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 2

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee.

Accepted Answer

This is true. A certification authority (CA) is a commercial entity that issues digital certificates that verify the identity of the certificate holder. The CA uses digital signatures to ensure the authenticity of the certificate, and charges a fee for this service.

Question 3

The Database Splitter is not identified by name on the Access Ribbon.

Accepted Answer

The Database Splitter is not a feature that is identified by name on the Access Ribbon. It can be accessed through the Database Tools tab on the Ribbon by selecting the "Access Database" option and then choosing "Split Database".

Question 4

A method to encrypt a database is to assign a password to the file.

Accepted Answer

The answer of A method to encrypt a database is...

Question 5

A good password should be at least eight characters which combines uppercase and lowercase letters, numbers, and symbols to make the password more difficult for others to guess.

Accepted Answer

A good password should have a minimum of eight characters and should combine uppercase and lowercase letters, numbers, and symbols to make it more secure and difficult to guess.

Question 6

You cannot create an ACCDE file unless you have enabled the content in the database.

Accepted Answer

This is because ACCDE files contain compiled code, which can only be generated when the database content has been enabled.

Question 7

Access 2013 incorporates encryption methods to keep databases secure.

Accepted Answer

Access 2013 includes encryption methods such as password protection, user-level security, and encryption of database files to maintain security and privacy of databases.

Question 8

A(n) ________ is a primary key that is made up of two or more fields.

Accepted Answer

The answer of A(n) ________ is a primary key that...

Question 9

Any field that is not part of the primary key is called a(n) ________.

Accepted Answer

The answer of Any field that is not part of...

Question 10

Digital certificates are electronic, encryption-based, secure stamps of authentication.

Accepted Answer

The answer of Digital certificates are electronic, encryption-based, secure stamps...

Question 11

When a database has been converted to an .accde file, it can be converted back to its source format (accdb).

Accepted Answer

Once a database has been converted to an .accde file, it cannot be easily converted back to its source format (accdb). The .accde file is a compiled version of the database and does not contain the original source code or design elements. Converting back to accdb would require decompiling the .accde file, which may result in the loss of some information or functionality.

Question 12

Creating an Access Database Executable (ACCDE) file will remove all VBA source code from the database.

Accepted Answer

Creating an ACCDE file will remove all VBA source code from the database, making it more secure and preventing users from viewing or modifying the code.

Question 13

To set a password, the database has to be opened in exclusive mode.

Accepted Answer

To set a password on a database, it must be opened in exclusive mode. This ensures that no other users can access the database while the password is being set.

Question 14

To start a navigation form automatically on start up, change settings in the Options window.

Accepted Answer

To start a navigation form automatically on start up, you need to change settings in the Options window.

Question 15

A navigation form is a tabbed menu system that ties the objects in the database together so that the database is easy to use.

Accepted Answer

A navigation form is indeed a tabbed menu system that serves as a central hub for accessing different objects in the database such as tables, forms, reports, and queries. It provides a user-friendly interface that allows users to navigate and interact with the database easily.

Question 16

Match the following terms with their meanings:
I. Database Splitter
II. functional dependency
III. Table Analyzer
IV. transitive dependencies
V. Performance Analyzer
A. analyzes the tables in a database and normalizes them for you
B. evaluates a database and then makes recommendations for optimizing the database
C. occurs when the value of one non-key field is functionally dependent on the value of another non-key field
D. when the value of one field is determined by the value of another
E. enables you to split a database into two files: a back-end database, which contains the data tables, and a front-end database

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 17

When a file is saved as an Access Database Executable file, VBA code can be executed, but it cannot be modified.

Accepted Answer

An Access Database Executable file (.accde) allows VBA code to be executed, but it cannot be viewed or modified. This is because the code is compiled into a binary format that cannot be easily edited.

Question 18

A back-end database contains the queries, forms, and reports of the database.

Accepted Answer

A back-end database contains the actual data of the database, while the queries, forms, and reports are usually stored in a front-end application or interface that connects to the back-end database.

Question 19

A timestamp can prove that your database has or has not been modified since you applied your signature.

Accepted Answer

A timestamp can serve as a digital notarization, proving that the data was signed at a specific time and has not been altered since then.

Question 20

You can digitally sign and publish your database simultaneously from within Access 2013.

Accepted Answer

Access 2013 allows you to digitally sign and publish your database at the same time, which enhances security and ensures that only trusted sources can make changes to the database.

Quiz 9: Fine-Tuning the Database: Analyzing and Improving Database Performance