Access 2003 Mastering Security

Course Content

Security overview
What does secure really mean?
The differing levels of security
A way in can always be found
Review the Access alternatives
Simple password
Password protect your database
Changing the password
Removing the password
Front end back end
Splitting your Database into two
Why have a data and a business tier
Advantages of a split system
Disadvantages of a two tier system
Further enhancements by use of the MDE format
Start Up Options
Controlling what happens when the database opens
Adding your own toolbars and menus
Hiding objects and disabling Access shortcuts
Introducing the AutoExec macro
All your hardwork wasted by the Shift Key
Disabling the Shift Key By Pass
Using the AutoKeys macro
Toolbars and menus
Customising existing menus and toolbars
Building your own toolbars and own menu bars
Building your own shortcut menus
Assigning your new bars to Reports and assigning your bars to Forms
Encryption
Why encrypt?
Prevent other programs from accessing your database.
Trade off performance against encryption
User-level security
About user-level security
About workgroups and workgroup information files
About how permissions work and who can assign them
About organizing security accounts
Considerations when organizing security accounts
Remove user-level security
Creating, joining and fixing workgroup information files
Create and join a workgroup information file
Create a new Microsoft Access workgroup information file
Join a Microsoft Access workgroup by using the Workgroup Administrator
Log on to a Microsoft Access workgroup
Turn off the Logon dialog box
Restore or rebuild a workgroup information file
Restore a damaged or deleted Microsoft Access workgroup information file
Rebuild a workgroup information file from user and group names and IDs
Managing user and group accounts
Create accounts, add users, and print information
Create a security administrator account, a security user account and security group account
Add users to security groups
Print information about security users and groups
Delete accounts and remove users
Remove users from security groups
Delete a security user account and delete a security group account
View or transfer ownership
Transfer ownership of an entire database to another administrator
Use user level security with the Front End Back End scenario
Types of permissions
Exploring the different types of permissions for user level security
The developer workgroup file solution
The Developer workgroup Solution overview
Make use of a Developer workgroup file
Safeguarding the Developer workgroup file
Security without usernames and passwords on rollout