Access Databases – set a database password

Step 1:

• Open the Access program.

• Click on More

• Find the file and click on Open.

• Choose Open Exclusive (see figure 1).

Figure 1: Open Exclusive

The database is now ready for a password to be set. Think about a good password for the database that has been opened.

Vocabulary Check

1. What does the word encrypt mean?

2. What does the word verify mean?

Step 2: Click on Database Tools. Choose ‘Encrypt with Password’

Step 3: Type in the password and verify the password by typing it again.

TO REMOVE THE PASSWORD IN AN ACCESS DATABASE

NB: The password will have to be removed before the database can be used for mail merge. Follow the steps below:

Step 1: Open the database again using Open Exclusive (see Step 1 on first page).

Step 2: Click on Database Tools tab. Click on Decrypt Database. Type the password again in the Unset Database Password box. Click on OK.