Microsoft Access 2007 Level 3
Managing Relational Databases
- Database Concepts.
- Database Design
- Normalisation
- Database Integrity
- Types of Relationship
- Creating Table Links
- Referential Integrity
Optimising and Administering Access
- Optimising Performance
- The Performance Analyzer
- The Add-in Manager
- Compacting your Database
- The Database Documentor
- The Database Splitter
- Recovering Damaged Databases
- Importing and Linking Tables
Advanced Forms Customising
- List and Combo Boxes
- Check Boxes, Option & Toggle Buttons
- Option Groups
- Command Buttons
- Calculated Fields
- Using Forms’ Input Values
- Create a Form With Multiple Pages or Tabs
- Tab Order
- Inserting Graphics in Forms or Reports
- AutoFormat
Database Security
- Securing a Database
- Adding a Database Password
- Setting User Level Security
- Workgroups
- Activating the Logon Procedure
- Creating and Managing Security Accounts
- Creating a Security Group Account
- The Security Wizard
- Changing Ownership
- Assigning and Removing Permissions
- Encrypting and Decrypting a Database
Course Benefits
To further build database design skills to an advanced level. Sharing and security is also covered.
Target Audience
Those who intend to design databases at an advanced level or improve existing Access databases. Also those wanting to convert advanced databases made in other applications and spreadsheet (flat file) databases.
Pre Requisites
This course assumes a good level of database design principles.
Location of Course
Camberley
Course Trainer
Sue Parsons
Click here to view trainer's portfolio.
