Overview
The Microsoft Access 2016 Beginner to Advanced course is the ultimate online training program for mastering Excel, ideal for those who want to improve their proficiency and confidence in managing data-based tasks. Through step-by-step guidance, it covers Excel 2016’s most important features and functions, taking you through key topics such as conditional formatting, data validation, action queries, and data normalisation.
Through video material and expert tuition, you will also learn how to prepare reports for print, create a mail merge and automate specific data management tasks using macros to speed up everyday administrative duties. Gain in-demand transferable skills required for any office role and add valuable credentials to your CV with an internationally-recognised, accredited certificate of achievement.
Highlights of the Microsoft Access 2016 Beginner to Advanced:
- Learn how to modify table data, create lookups, perform calculations in a query, and much more
- Enhance the appearance of your reports and add controls to your report
- Know how to create a relational database design and relate data within a table
- Understand how data normalisation works and why it is important in data management
- Get step-by-step guidance on how to create a mail merge and mailing label report
- Learn how to apply data validation to cells or a range, including how to form and record validation
- Apply conditional formatting to multiple cells and automate tasks using macros
- Develop your proficiency in data management to improve your career prospects
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Online study materials
Who is this Course for?
This course is for anyone who wants to familiarise with the tools and features of Microsoft Excel 2016, designed for learners of all levels. It is ideal for professionals in office-based roles who have data management responsibilities. To provide you with ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 20/30 hours, with the freedom to study at your own pace.
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why Choose this Microsoft Access 2016 Beginner to Advanced:
- 24/7 access to the course for an extensive period of 12 months
- CPD accredited certification on successful completion
- Ease of access to the course material from any device of your choice
- No hidden fees or exam charges
- Full tutor support on weekdays (Monday – Friday)
- Efficient exam system, assessment and instant results
- Develop professional skills and advance your career, thus increasing your potential to earn more
Requirements
The Microsoft Access 2016 Beginner to Advanced is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Career Path
Once you have successfully completed the course, you will have excellent proficiency in Microsoft Excel, with the skills and credentials to manage day-to-day data-based tasks confidently and efficiently. This qualification can be added to your CV to improve your job prospects for the following roles:
- Data Entry Clerk (average annual salary of £17,096 in the UK)
- Office Administrator (average annual salary of £19,037 in the UK)
- Data Analyst (average annual salary of £33,852 in the UK)
- Accountant (average annual salary of £33,631 in the UK)
Course Curriculum
Module - 1 | |||
Orientation to Microsoft Access | 01:00:00 | ||
Create a Simple Access Database | 01:00:00 | ||
Get Help in Microsoft Access | 00:30:00 | ||
Modify Table Data | 00:30:00 | ||
Work with Records | 01:00:00 | ||
Sort and Filter Records | 00:30:00 | ||
Create Lookups | 01:00:00 | ||
Join Data from Different Tables in a Query | 01:00:00 | ||
Sort and Filter Data in a Query | 01:00:00 | ||
Perform Calculations in a Query | 00:30:00 | ||
Create Parameter Queries | 00:30:00 | ||
Create Action Queries | 00:30:00 | ||
Create Find Duplicate and Find Unmatched Queries | 00:30:00 | ||
Summarize Data | 00:30:00 | ||
Create a Report | 01:00:00 | ||
Add Controls to a Report | 00:30:00 | ||
Enhance the Appearance of a Report | 00:30:00 | ||
Prepare a Report for Print | 00:30:00 | ||
The Access Options Dialog Box | 01:00:00 | ||
Relational Database Design | 00:30:00 | ||
Create a Table | 01:00:00 | ||
Modify a Table and Fields | 00:30:00 | ||
Create Table Relationships | 00:30:00 | ||
Create Query Joins | 00:30:00 | ||
Join Tables That Have No Common Fields | 00:30:00 | ||
Relate Data within a Table | 00:30:00 | ||
Work with Subdatasheets | 00:30:00 | ||
Create Subqueries | 00:30:00 | ||
Data Normalization | 01:00:00 | ||
Create a Junction Table | 00:30:00 | ||
Import Data into Access | 00:30:00 | ||
Export Data to Text File Formats | 00:30:00 | ||
Export Access Data to Excel | 00:30:00 | ||
Create a Mail Merge | 00:30:00 | ||
Organize Report Information | 00:30:00 | ||
Format Reports | 00:30:00 | ||
Include Charts in a Report | 00:30:00 | ||
Add a Calculated Field to a Report | 00:30:00 | ||
Add a Subreport to an Existing Report | 00:30:00 | ||
Create a Mailing Label Report | 00:30:00 | ||
Publish a Report as PDF | 00:30:00 | ||
Activities – Microsoft Access 2016 for Beginners | 00:00:00 | ||
Module - 2 | |||
Add Controls to Forms | 01:00:00 | ||
Set Form Controls | 01:00:00 | ||
Create Subforms | 00:30:00 | ||
Organize Information with Tab Pages | 00:30:00 | ||
Enhance Navigation with Forms | 00:30:00 | ||
Format a Form | 01:00:00 | ||
Apply Conditional Formatting | 00:30:00 | ||
Field Validation | 00:30:00 | ||
Form and Record Validation | 00:30:00 | ||
Create a Macro | 01:00:00 | ||
Restrict Records Using a Condition | 00:30:00 | ||
Validate Data Using a Macro | 00:30:00 | ||
Automate Data Entry Using a Macro | 00:30:00 | ||
Convert a Macro to VBA | 00:30:00 | ||
Link Tables to External Data Sources | 00:30:00 | ||
Manage a Database | 00:30:00 | ||
Determine Object Dependency | 00:30:00 | ||
Document a Database | 00:30:00 | ||
Analyze the Performance of a Database | 00:30:00 | ||
Split a Database for Multiple User Access | 00:30:00 | ||
Implement Security | 00:30:00 | ||
Set Passwords | 00:30:00 | ||
Convert an Access Database to an ACCDE File | 00:30:00 | ||
Package a Database with a Digital Signature | 00:30:00 | ||
Create a Database Switchboard | 01:00:00 | ||
Modify a Database Switchboard | 00:30:00 | ||
Set Startup Options | 00:30:00 | ||
Activities – Microsoft Access 2016 Advanced | 00:00:00 | ||
Mock Exam | |||
Mock Exam- Microsoft Access 2016 Beginner to Advanced | 00:30:00 | ||
Final Exam | |||
Final Exam- Microsoft Access 2016 Beginner to Advanced | 00:30:00 |
Training 10 or more people?
Get your team access to 3,000+ top courses anytime, anywhere.
Try One Education BusinessCourse Reviews
No Reviews found for this course.