
Course Outline
Access Level 3
This is a 1 day, instructor-led course.
This course will build on a reasonable level of database design experience that we recommend be gained from our Microsoft Access Level 1 & Microsoft Access Level 2 courses.
People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases.
This course assumes a reasonable level of database design principles. We recommend students first attend our Microsoft Access Level 1 & Microsoft Access Level 2 courses.
Access Level 3
This is a 1 day, instructor-led course.
This course will build on a reasonable level of database design experience that we recommend be gained from our Microsoft Access Level 1 & Microsoft Access Level 2 courses.
People who intend to design databases at an advanced level or improve existing Access databases. Also advanced conversion of databases made in other applications and spreadsheet (flat file) databases.
This course assumes a reasonable level of database design principles. We recommend students first attend our Microsoft Access Level 1 & Microsoft Access Level 2 courses.
Course Contents
Managing Relational Databases
Database Concepts.
Database Design
Normalisation
Database Integrity
Types of Relationship
Creating Table Links
Referential Integrity
Advanced Forms Customising
List And Combo Boxes
Check Boxes, Option & Toggle Buttons.
Option Groups
Command Buttons
Calculated Fields.
Using Form’s Input Values
Create A Form With Multiple Pages Or Tabs
Tab Order
Inserting Graphics in Forms or Reports
AutoFormat
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
Price per delegate
£350
Scheduled Classes
Indicia Training, Glasgow:
Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com