Access 2013 - Advanced

Request more details:

Description:
Your training in and use of Microsoft Office Access 2013 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access 2013. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
Prerequisites:
This course assumes a reasonable level of database design principles
COURSE OBJECTIVES:
To build on a reasonable level of database design experience that may have been gained from the Introduction and/or Intermediate course
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