Microsoft Access 2003 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 Analyser
- 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 and Toggle Buttons
- Option Groups
- Command Buttons
- Calculated Fields
- Using Forms’ Input Values
- Create a Form with Multiple Pages/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 enhance your intermediate skills of building a database.
Target Audience
People who intend to design databases to an advanced level and improve existing Access databases. Sharing and security is also covered.
Pre Requisites
Microsoft Access 2003 Level 2 or intermediate knowledge of Access 2003.
Location of Course
Camberley
Course Trainer
Sue Parsons
Click here to view trainer's portfolio.
