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 Expert
Individual Licence (EUR 40)
€40.00
Skip to product information
Access 2016 Expert
€40.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 Expert.
Access 2016 Expert Objectives: This two hour course will help learners to design databases at an expert level or improve existing Access databases. Also, advanced conversion of databases made in other applications and spreadsheet (flat file) databases.
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 Expert 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.
Access 2016 Expert
Objectives: This two hour course will help learners to design databases at an expert level or improve existing Access databases. Also, advanced conversion of databases made in other applications and spreadsheet (flat file) databases.
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. Managing Relational Databases
In this topic you will cover:
Managing Relational Databases
Database Concepts
Database Design
Normalisation
Database Integrity
Types of Relationship
Creating Table Links
Referential Integrity
Self-test Quiz
3. Customising Forms
In this topic you will cover:
Customising Forms
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
Self-test Quiz
4. Optimise and Administer Access
In this topic you will cover:
Optimise and Administer 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
Self-test Quiz
5. Introduction to SQL
In this topic you will cover:
Introduction to SQL
Introduction
Data Definition Language
Data Manipulation Language
Self-test Quiz
6. 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
Learners also take: Access 2016 Advanced
Course pathway: eBSI SME Academy > Microsoft Office & Windows > Access 2016 Expert
Explore more Microsoft Office & Windows training or return to the eBSI SME Academy.