Securing and Sharing Information

Your goal as a database developer is to provide adequate protection without imposing

unnecessary restrictions on the people who should have access to your database.

• True

• False

If your database will be opened by more

than one person at a time, you must worry about ...

• You don't have to worry about the potential for corruption

• The potential for data corruption

• You must use Excel to open de database.

To create a secure password in Access 2007,

keep the following in mind:

• A good password includes uppercase letters, lowercase letters, and symbols or

  numbers, and isn't a word found in a dictionary.

• Is not a good idea to include symbols, and numbers in a password.

• You can not include , accented characters, or numbers.

A benefit of assigning a password to your database is that will automatically be

• Encrypted each time you close it.

• The database will be saved in the cloud.

• Anyone can access the database using Excel.

Decrypting a file prevents people who don't have a copy of Access from being able

to read and perhaps make sense of the data in your file.

• False

• True

To assign a password to a access database you must open the file with the _________option.

• Open

• Open Read-Only

• Open Exclusive

• Open Exclusive Read-Only

Encrypt with Password option is located in the ...

• Database Tools Tab

• External Data Tab

• Create Tab

• Home Tab

The Visual Basic Editor launch option is located within the ____ Group in the Database Tools Tab.

• Macro

• Show/Hide

• Analyze

• Move Data

An Access Database Executable (ACCDE) file is...

• A type of file for secure distribution.

• A type of file that allows to be edited

• A Type of file that allows to modify VBA code.

• User can add, delete, or change reference to to the

In Access 2007 ,if you set a password for the code, it remains available

for editing by anyone who knows the password.

• True

• False