Microsoft Access 2016 Beginner to Advanced

4.7( 7 REVIEWS )

610 STUDENTS

Course Overview

You’ll have an arsenal of skills to lock down your desired career after completing this Microsoft Access 2016 Beginner to Advanced course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.

With this comprehensive Microsoft Access 2016 Beginner to Advanced course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this Microsoft Access 2016 Beginner to Advanced course to the basket and take your expertise up a notch!

Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.

Why Choose Thames College?

Thames College offers you the benefit of —

Who Is This Course For?

Those who want to strengthen their professional skills while training for the desired job should take advantage of the Microsoft Access 2016 Beginner to Advanced training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Microsoft Access 2016 Beginner to Advanced course if you want the best training available.

Certificate of Achievement

CPD Certification

After successfully completing the assessment of this Microsoft Access 2016 Beginner to Advanced course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.

Requirements

No formal entry requirements! No prerequisites or relevant experience is required!

This course is accessible to anyone with an eagerness to learn. All you require is—

Career Path

Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.

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