In focus

How To Protect Data In Microsoft Access 2016

In this article we will learn how to protect data in Microsoft Access 2016.

Author Mar 28, 2016

Microsoft Access is a part of Microsoft Office Suite. It is a unique tool developed by Microsoft that provides both functionality and programming capabilities.
 
The Microsoft Access database is made up of seven major components
  • Tables
  • Relationships
  • Queries
  • Forms
  • Reports
  • Macros
  • Modules
Follow the below given steps to secure your database contents
 
Step 1- Open Microsoft Access 2016.
 
ms access1 
 
Step 2- Open your database.
 
ms access2 
 
Step 3- When the database opens, go to the file tab and click to the Info button.
 
ms access3 
 
Step 4- Click the Encrypt with password button.
 
ms access4 
 
Step 5- Choose a strong password for your database and enter it in both the password and verify boxes in the set Database password dialog box.
 
ms access5 
 
Password is set.

database macros

COMMENT USING