Book a Free Video Consultation!
If you have any questions or would like to speak to one of our team before enrolling feel free to book a free video call with us by clicking the button below, we will be delighted to meet you on Google Meet!
Access 2016 Advanced
Individual Licence (EUR 40)
Rs.6,400.00
Skip to product information
Unit Contents:
Access 2016 Advanced
Rs.6,400.00
Reliable shipping
Flexible returns
Buying for a team?
Choose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.
Develop practical knowledge and confidence in 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.
Why this course matters
This course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.
What you will gain
- Use the key features and workflows covered in Access 2016 Advanced with greater confidence.
- Apply the tools and techniques to practical business tasks.
- Recognise common mistakes and work more efficiently in day-to-day use.
Who is this course for?
This course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.
Course at a glance
- Format: self-paced online learning.
- Professional development: CPD course.
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
Continue your learning
Part of this learning pathway: Microsoft Office & Windows
Next course: Access 2016 Expert
Course pathway: eBSI SME Academy > Microsoft Office & Windows > Access 2016 Advanced
Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.