Course Description
Delegates looking to advance their database skills to a high level, covering formatting existing data and maintenance as well as advanced reports and queries.
Target Student:
Delegates taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.
Prerequisites:
You've covered many of the basic functions of Microsoft Office Access and now you're ready to learn advanced Access features such as, database maintenance, writing more advanced queries and reports, and structuring exiting data. Knowledge of these features separate database professionals from the casual database users or occasional designers.
Delegates should have attended the Microsoft Access Level 2 2013 course or have equivalent intermediate knowledge covering areas such as database structure, querying and reporting.
Performance-Based Objectives
Restructure data into appropriate tables to ensure data dependency and minimise redundancy
Write advanced queries to analyse and summarise data
Create and revise Access 2013 macros
Customise reports by using various Access 2013 features
Maintain their databases using tools provided by Access 2013
Course Content
Module 1: Structuring Existing Data
Module 2: Writing Advanced Queries
Module 3: Simplifying Tasks with Macros
Module 4: Creating Effective Reports
Module 5: Maintaining an Access Database
Topic 5E: Analyse the Performance of a Database
