Microsoft Access 2016 Beginner to Advanced
Course
Online
Description
-
Type
Course
-
Level
Beginner
-
Methodology
Online
-
Duration
1 Year
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
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.
Facilities
Location
Start date
Start date
About this course
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
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.
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.
Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
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
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 5 years
Subjects
- Excel
- Access
- Database
- Database training
- MS Excel
- Microsoft Access
- Calculations
- Records
- Orientation
- Filter
- Parameter
Course programme
Module - 1
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help in Microsoft Access
- Modify Table Data
- Work with Records
- Sort and Filter Records
- Create Lookups
- Join Data from Different Tables in a Query
- Sort and Filter Data in a Query
- Perform Calculations in a Query
- Create Parameter Queries
- Create Action Queries
- Create Find Duplicate and Find Unmatched Queries
- Summarize Data
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- The Access Options Dialog Box
- Relational Database Design
- Create a Table
- Modify a Table and Fields
- Create Table Relationships
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
- Data Normalization
- Create a Junction Table
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
- Organize Report Information
- Format Reports
- Include Charts in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
- Publish a Report as PDF
- Activities – Microsoft Access 2016 for Beginners
- Add Controls to Forms
- Set Form Controls
- Create Subforms
- Organize Information with Tab Pages
- Enhance Navigation with Forms
- Format a Form
- Apply Conditional Formatting
- Field Validation
- Form and Record Validation
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Convert a Macro to VBA
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
- Split a Database for Multiple User Access
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options
- Activities – Microsoft Access 2016 Advanced
- Mock Exam- Microsoft Access 2016 Beginner to Advanced
- Final Exam- Microsoft Access 2016 Beginner to Advanced
Microsoft Access 2016 Beginner to Advanced