Access 2016 Advanced

Access 2016

Lesson 9 - Using Access Database Security

3. On the info screen, select the Encrypt with Password button . 4. Type a password for the encrypted database in the Password box. 5. Press [Tab] . 6. Type the same password in the Verify box.

7. Select

.



Step-by-Step

From the Student Data directory, open ENCRYPT.ACCDB . Encrypt a database with a password.

The database must be opened in Exclusive mode. In Access, slick the File Tab then click Open . On the Open screen, click Browse, locate the folder and file you need and click the file to select it. Click the arrow on the right side of the Open button and select Open Exclusive .

Steps

Practice Data

1. Select the File tab.

Click

The Backstage view appear.

2. On the Info screen, select the Encrypt with Password button. The Set Database Password dialog box opens. 3. Type a password for the encrypted database in the Password field. Asterisks appear in the Password field, one for each character in the password.

Click

Type securenc

4. Press [Tab] .

Press [Tab]

The cursor moves to the Verify field.

5. Type the same password in the Verify field. Asterisks appear in the Verify field, one for each character in the password.

Type securenc

OFFICEPRO, Inc.

Page 97