Access 2016 Advanced

Lesson 9 – Using Access Database Security

Access 2016

Steps

Practice Data

6. Select OK .

Click

The Set Database Password dialog box closes, and the database is encrypted with the password.

O PENING AND D ECRYPTING A D ATABASE



Discussion

When you click to open an encrypted database, Access prompts you to enter a password. If you type the correct password, the database opens and the encryption is removed. If you type an incorrect password, the database remains closed and encrypted.



Procedures

1. Open the desired encrypted database. 2. Type the password in the Enter database password: field.

3. Select

.



Step-by-Step

Open and decrypt an encrypted database.

Steps

Practice Data

1. Type the password in the Enter database password: field. Asterisks appear in the Enter

Type securenc

database password: field, one for each character in the password.

2. Select OK .

Click

The Password Required dialog box closes, the desired database opens, and the encryption is removed.

Page 98

OFFICEPRO, Inc.