Question 1

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 2

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, the source code and design elements cannot be directly accessed or modified. The .accde file is a compiled version of the Access database that does not allow changes to the source code, only the data can be updated. Therefore, it cannot be converted back to its original source format (accdb) from the .accde file.

Question 3

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 4

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

Accepted Answer

A timestamp records the date and time of a specific event, in this case, the application of a signature to a database. By comparing the timestamp of the signature to the timestamp of the database, it can be determined whether or not the database has been modified since the signature was applied.

Question 5

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 allows easy access to the different objects in a database, thereby making it more user-friendly.

Question 6

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

Accepted Answer

To set a password on a database, it needs to be opened in exclusive mode. This is because the process of setting a password involves modifying the database's internal structures, which cannot be done when other users or applications have the database open.

Question 7

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 8

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 9

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

Accepted Answer

This is true. To enable this setting, go to the Options window and choose the current database option. Under the "Application Options" section, select "Display Form" and choose the Navigation form as the default form to open when the database starts up.

Question 10

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 11

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

Accepted Answer

Creating an ACCDE file compiles all VBA code into byte code, which cannot be viewed or edited, effectively removing the original source code from the database. This is done to protect the intellectual property of the database developer and prevent unauthorized access or modification of the code.

Question 12

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

Accepted Answer

The Database Splitter is not identified by name on the Access Ribbon, but can be accessed by clicking on the "Database Tools" tab, and then clicking on the "Access Database" button within the "Move Data" group.

Question 13

Access 2013 incorporates encryption methods to keep databases secure.

Accepted Answer

Access 2013 does incorporate encryption methods to keep databases secure.

Question 14

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

Accepted Answer

This is true. In order to create an ACCDE file in Microsoft Access, you must first enable the content in the database to ensure that any underlying VBA code or macros can be compiled and embedded within the ACCDE file.

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

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, ensuring the authenticity and integrity of your data. This feature can be accessed through the "Publish to Access Services" option in the "File" menu.

Question 18

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 combination of uppercase and lowercase letters, numbers, and symbols to make it more difficult for others to guess. It is recommended to have a minimum of eight characters in a password.

Question 19

________ mode guarantees that you are the only one currently using the database.

Accepted Answer

The answer of ________ mode guarantees that you are the...

Question 20

A(n)________ database contains only the tables of a database.

Accepted Answer

The answer of A(n)________ database contains only the tables of...

Quiz 38: Access: Fine-Tuning the Database: Analyzing and Improving Database Performance