Access 2016 Advanced Training Courses – Online or Face to Face |
|
|
|
|
|
Duration: 1 Day
Course Objective:
To build on a reasonable level of database design experience that may have been
gained from the Introduction and/or Intermediate course.
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
What our attendees have said about us:
Excellent tutor, flexible and willing to offer additional help. Highly knowledgeable in Access.
Homes for Haringey
Tutor was great! Let everybody in room catch up before moving on to next item. He was very helpful.
IMO
Very easy to understand, the tutor has excellent subject knowledge.
LSH
Very good, explained things well, gave good tips and clear examples.
Kenmont Primary School
Excellent tutor made the session fun and easy to understand. Very helpful, need more courses like this.
E.C.S
Approachable, interesting, keen on subject.
Maples Children Centre