Access 2003 Mastering Security
Course Type
Scheduled:
| Date |
Location |
Duration |
Cost |
09 Aug 2012 (Thu)
10 Aug 2012 (Fri) | Washington | 2 | £ 595 |
| All prices exclude VAT |
|
Private
:
| This outline is available as a private course. Please contact us to arrange this course at a venue and date of your choice. |
Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.
You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.
We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.
Please contact us to discuss this further on 0191 377 8377.
Course Overview
Anyone who wants to understand how to use Security within a Microsoft Access application and is required either to setup a secure application or administer an already created secure application will benefit from this course.
Prerequisites
- Delegates should have a thorough knowledge of Microsoft Access and have preferably attended the intermediate and/or advanced Microsoft Access course or have equivalent knowledge.
Objectives
Other courses in this series Course Content
Security overview
What does secure really mean?
The differing levels of security
A way in can always be found
Review the Microsoft 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 Microsoft 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
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
Microsoft and Microsoft Access are Registered Trademarks
Access 2003 Mastering Security training courses in North East England , Durham, Washington, Newcastle . Building a secure application. Using passwords with databases, front end, back end, toolbars, menus, encription, encript, encripting database security, work groups, ids, user level group accounts. Access Mastering Security training courses Sunderland . Access training courses security London . Advanced Access courses London. Access training Middlesbrough . Microsoft Access training courses Sunderland .
Accessibility: 
Enquire Online 
Special Offers 
| Join us on Facebook or
| 
FAQs
