Question 1

When saving a backup database file, the date is added after the filename.

Accepted Answer

This is a common convention when saving backup database files, as it allows for easy identification of when the backup was created.

Question 2

If you click the Encrypt with Password button and the database is not opened in the Exclusive mode, ____.
A) the button goes dim
B) the Set Database Password dialog box opens
C) you will receive an error message
D) you will be given a chance to open the database in Exclusive mode

Accepted Answer

If the database is not opened in Exclusive mode, clicking the Encrypt with Password button will result in an error message.

Question 3

To remove the password and encryption from a database, you first need to open the database in the Open Read-Only mode.

Accepted Answer

To remove the password and encryption from a database, you need to open it in the Exclusive mode, not Read-Only mode.

Question 4

____ mode allows several users to open and use the database at the same time.
A) Open
B) Read-Only
C) Open Exclusive Read-Only
D) Open Exclusive

Accepted Answer

The "Open" mode allows multiple users to access and use the database simultaneously, unlike "Open Exclusive" modes which restrict access to a single user.

Question 5

If a password is needed to open a database, the ____ dialog box appears.
A) Password
B) Password Required
C) Password Needed
D) Password Necessary

Accepted Answer

The answer of If a password is needed to open...

Question 6

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?
A) Encrypting a database with row level locking turned off.
B) Encrypting a database with row level locking turned on.
C) Encrypting a database with block cipher locking turned off.
D) Encrypting a database with block cipher locking turned on.

Accepted Answer

The answer of Which of the following causes a message...

Question 7

If you click the File tab and notice that the Encrypt with Password option is ____, this indicates that the password and encryption are removed.
A) grayed out
B) crossed out
C) displayed
D) hidden

Accepted Answer

The answer of If you click the File tab and...

Question 8

You can remove the database encryption by using the ____ button.
A) Decrypt Database
B) Release Encryption
C) Relinquish Encryption
D) Unset Encryption

Accepted Answer

The correct option is to click on the "Decrypt Database" button to remove the encryption from the database. This option is generally available in the database management tools or software that have encryption features. Choosing options B, C, or D will not remove the encryption from the database.

Question 9

You select the database open options using the ____ dialog box.
A) Database
B) Open
C) Open Database Mode
D) Open Database

Accepted Answer

The Open dialog box is where you can select the database and set the open options.

Question 10

A backup copy of a database is created when you ____ the file using the Back Up Database option.
A) close
B) save
C) open
D) create

Accepted Answer

The Back Up Database option is used to save a copy of the database, creating a backup file.

Question 11

To remove database encryption, you must enter the password in the ____ Database Password dialog box.
A) Remove
B) Unset
C) Relinquish
D) Reverse

Accepted Answer

To remove database encryption, you need to unset the password. Therefore, the correct choice is "Unset" which is option B.

Question 12

The message " Block cipher is incompatible with row level locking and so row level locking will be ignored" ensures that ____ will be encrypted.
A) the selected column
B) a block
C) the entire database
D) the entire field

Accepted Answer

The answer of The message " Block cipher is incompatible...

Question 13

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

Accepted Answer

This is because when you open a database, you usually intend to retrieve or modify the data stored within it. Therefore, you need to open the database in Open mode, which allows for these operations.

Question 14

Which of the following events may cause data loss requiring a database restore from a backup?
A) power failure
B) hard disk crash
C) accidental deletion of database objects
D) all of the above

Accepted Answer

All of the mentioned events may cause data loss and require a database restore from a backup. A power failure or hard disk crash can corrupt the data, while accidental deletion of database objects can result in the loss of critical data. Therefore, it is crucial to have regular backups to protect against such events.

Question 15

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. To ease Ron's concerns, you start by explaining that Access 2010 combines two tools for database security: ____.
A) login IDs and database passwords
B) login IDs and row-level locking
C) database passwords and encryption
D) system passwords and encryption

Accepted Answer

Access 2010 combines database passwords and encryption for database security.

Question 16

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.

Accepted Answer

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

Question 17

An encrypted database cannot be viewed or understood unless it is ____ with the correct password.
A) created
B) secured
C) closed
D) opened

Accepted Answer

An encrypted database is already created and secured, but it cannot be accessed unless it is opened with the correct password. Therefore, the correct answer is D) opened.

Question 18

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.
A) Read
B) Read-Only
C) Open Read-Only
D) Open Exclusive Read-Only

Accepted Answer

Open Read-Only mode allows multiple users to access the database without making changes to records or creating new objects.

Question 19

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.
A) blocked
B) personal
C) row level locked
D) encrypted

Accepted Answer

The best choice is D, encrypted. Encryption is the process of converting data into a coded language to prevent unauthorized access. Access 2010 allows Ron to encrypt his database with a password, making it much more secure. When Ron opens the encrypted database, Access will prompt him to enter the password before allowing access to the data. This ensures that sensitive customer information is protected from unauthorized access, even if Ron's laptop is stolen or hacked. Choices A, B, and C do not apply to password protection in Access databases.

Question 20

In Access, the Object Documenter produces a report of selected objects or every object in a database.

Accepted Answer

The answer of In Access, the Object Documenter produces a...

Quiz 1: Microsoft Access Basics

When saving a backup database file, the date is added after the filename.

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

To remove the password and encryption from a database, you first need to open the database in the Open Read-Only mode.

____ mode allows several users to open and use the database at the same time.

If a password is needed to open a database, the ____ dialog box appears.

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

If you click the File tab and notice that the Encrypt with Password option is ____, this indicates that the password and encryption are removed.

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

You select the database open options using the ____ dialog box.

A backup copy of a database is created when you ____ the file using the Back Up Database option.

To remove database encryption, you must enter the password in the ____ Database Password dialog box.

The message " Block cipher is incompatible with row level locking and so row level locking will be ignored" ensures that ____ will be encrypted.

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

Which of the following events may cause data loss requiring a database restore from a backup?

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.

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

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.

In Access, the Object Documenter produces a report of selected objects or every object in a database.