Access 2003 Mastering Security
| Date |
Location |
Duration |
Cost |
10 May 2011 (Tue)
11 May 2011 (Wed) | Washington | 2 | £ 595 |
11 Aug 2011 (Thu)
12 Aug 2011 (Fri) | Washington | 2 | £ 595 |
Please contact us to discuss private course dates and locations |
Course Overview
Anyone who needs a good understanding in using Security within an Access application and is required to either setup a secure application or administer an already created secure application will benefit from this course.
Prerequisites
- Delegates should have a thorough knowledge of Access and have preferably attended the Intermediate and/or Advanced Access Course or have equivalent knowledge.
Objectives
Related Courses
Training Options
- Scheduled public courses at one of our training venues
- Private course at your company office throughout the UK, at one of our training venues (Durham, Newcastle or Washington) or at an independent location, convenient to you
- Bespoke course written to your specific needs, at your company office throughout the UK, at our training venue or at an independent location, convenient to you
- For further information please contact us on 0191 377 8377
What's Included
- 1 delegate per computer
- Telephone and email support
- Relaxed refreshment area at our training venues
- Lunch and refreshments when training is delivered at our training venue
- Comprehensive course manual and exercises
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
Print