Question 1

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

Accepted Answer

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

Question 2

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 3

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 4

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

Accepted Answer

This is generally true. However, some certification authorities may not be commercial companies, such as government-run certification authorities. Additionally, while they do charge a fee for their services, this is not the only way that they generate revenue (for example, they may also sell other security-related services).

Question 5

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 is...

Question 6

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 converted back to its original source format (accdb). This is because the .accde file is a compiled version of the database that doesn't contain the original source code.

Question 7

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

Accepted Answer

ACCDE files are compiled versions of Access databases and they remove the original source code, including VBA code, from the database to prevent users from viewing or modifying it. However, the database will still have the functionality provided by the compiled code.

Question 8

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 helps users access and navigate through the various objects in the database. This makes it easier for users to interact with the database and perform tasks such as data entry, editing, and reporting.

Question 9

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

Accepted Answer

In Access 2013, you can use a digital signature to confirm the authenticity of a database, and then publish it to a SharePoint server or to an Office 365 site directly from within Access.

Question 10

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

Accepted Answer

A back-end database typically stores the data itself, while queries, forms, and reports are part of the front-end application that interacts with the database.

Question 11

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

Accepted Answer

When setting a password for a database, it must be opened in exclusive mode to ensure that the password is properly set and secured. In exclusive mode, the database can only be accessed by one user at a time, preventing any unauthorized access or modifications.

Question 12

Match between columns
                        Premises: non-key field
encryption
composite key
anomaly

Accepted Answer

The Answer of an error or inconsistency that occurs when is...

Question 13

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

Accepted Answer

This is true. When a file is saved as an Access Database Executable file, VBA code can still be executed, but it cannot be modified. This is a security feature that ensures the integrity of the code.

Question 14

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 15

Access 2013 incorporates encryption methods to keep databases secure.

Accepted Answer

Access 2013 does indeed incorporate encryption methods to keep databases secure. This helps to protect sensitive data from unauthorized access or theft.

Question 16

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 be at least eight characters which combines uppercase and lowercase letters,numbers,and symbols to make the password more difficult for others to guess.

Question 17

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

Accepted Answer

The Database Splitter is a tool in Microsoft Access used to separate a database into a front-end and back-end but it is not directly identified by name on the Access Ribbon. Instead, it is accessed through the Database Tools tab by using the "Access Database" option for splitting a database.

Question 18

Match between columns
                        Premises: Table Analyzer
Database Splitter
transitive dependencies
functional dependency
Performance Analyzer

Accepted Answer

The Answer of evaluates a database and then makes recommendations is...

Question 19

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

Accepted Answer

The answer of You cannot create an ACCDE file unless...

Question 20

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

Accepted Answer

The answer of A timestamp can prove that your database...

Quiz 35: Fine Tuning the Database: Analyzing and Improving Database Performance

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

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

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

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

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

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

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

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

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

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

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

Match the following terms with their meanings:

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

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

Access 2013 incorporates encryption methods to keep databases secure.

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.

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

Match the following terms with their meanings:

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

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