Microsoft Access 2000: Security

Course Overview

One of the most important features of Access is the ability to secure your application - both the data and the code. Access has a very sophisticated security model from a database password through to encryption and security groups.

Audience

This course is invaluable for every PC user, Network Manager, IT manager, IT Director etc, seeking to protect the Access systems for which he/she is responsible.

Skills Gained

You will learn how to design and apply the most appropriate security strategy for your applications

Course Outline

• What You Should Know About Protecting Sensitive Data
• Access Security Overview
• About Access User-Level Security
• Manually Set a Database Password
• Set a Database Password Programmatically
• Secure an Access Database with the Security Wizard
• Encrypting a database
• Programmatically Add and Remove Users and Groups
• Set Permissions Programmatically
• Creating a New workgroup
• Assigning rights to Users and Groups
• Database Object Permissions
• Connecting to a secure database
• MDE Files