ITLU052 Access 2016 Advanced
Objectives: This course will show learners how to build on some existing database design and management techniques that may have been gained from the Access 2016 Essentials course. It will teach about Action Queries, Forms management, reports and web publishing procedures. Protecting and backing up / restoring databases will also be covered in a step by step manner.
Completing this course will confer 2 CPD Credits towards internationally recognised Continuous Professional Development Requirements within organisations operating this kind of staff development methodology.
Unit Contents:
1. Getting Started
In this topic you will cover a basic introduction to the course unit and its objectives.
2. Action Queries
In this topic you will cover:
Action Queries
Types Of Query
The Crosstab Query
The Make Table Query
The Append Query
The Delete Query
The Update Query
Self-test Quiz
3. Forms
In this topic you will cover:
Forms
Manipulating Data in the Form
Creating A New Form
Using the Form Wizard
Creating a Form With a Subform
Modifying and Redesigning the Form
Self-test Quiz
4. Reports and Web Publishing
In this topic you will cover:
Reports and Web Publishing
The Report Wizard
Creating a Report With Summary Totals
Using the Label Wizard
Modifying and Redesigning the Report.
Publishing Access Data on the Web
Self-test Quiz
5. Protecting Desktop Database with Backup and Restore Processes
In this topic you will cover:
Protecting Desktop Database with Backup and Restore Processes
Why do I need a backup?
Creating a database backup
Creating a Split Database
Backing up back-end database and front-end database
Restoring a database
Self-test Quiz
6. Additional Features in Access 2016
In this topic you will cover:
Additional Features in Access 2016
Backwards Compatibility
E-mailing Database Information
Self-test Quiz
7. Wrapping Up / Assessment Result
In this topic you will cover:
Course Conclusion
Wrapping up
Test Results Summary
Book a Consultation