Description

Description

You have a basic knowledge on MS Access 2016, besides you want to know more about it to use in your practical life, but you don't know how to work on it and which course is effective for your learning. Don't worry. To become better at MS Access, take a look at our MS Access 2016 Intermediate course. It will assist you to reach your need.

The course designs in such a way that will assist you to learn the fundamental issues of MS Access including information gathering, data analysis, and proper management of the relevant information system. The MS Access 2016 Intermediate course helps you to make table chart for justifying the accuracy of data entry, learn automation system, and insert charts and column. The course aims at the clear understanding and functioning of Word and Excel, adding and deleting table data, reviewing the advanced searching techniques; Parameter queries, Crosstab queries and working with total and other different techniques of report and form regarding Tab controls, sub-Forms, Combo Box controls, Sub-reports, and column.

Assessment:

This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

MS Access 2016 Intermediate is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our MS Access 2016 Intermediate is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Introduction
	Introduction	FREE	00:01:00
Designing Tables for Better Data Entry
	Reviewing Table Design Principles		00:04:00
	Setting Field Size, Formats and Captions		00:06:00
	Setting Default Value and Required Fields		00:03:00
	Restricting Data Entry Using Data Validation		00:02:00
	Restricting Data Entry Using Input Masks		00:06:00
Sharing Data with Other Applications
	Exporting Tables and Queries to Excel		00:03:00
	Importing Data from a TXT File		00:03:00
	Importing Data from Excel		00:02:00
	Exporting Data to a TXT File		00:02:00
	Linking External Data Sources		00:03:00
	Using Word Merge		00:02:00
Working with Action Queries
	What are Action Queries		00:00:00
	Creating an Update Query		00:02:00
	Creating an Append Query		00:03:00
	Creating a Delete Query		00:02:00
	Creating a Make Table Query		00:02:00
	Changing the Start Number of an Auto Number Field		00:03:00
Advanced Query Techniques
	Creating Query Joins		00:05:00
	Creating Find Unmatached and Find Duplicate Queries		00:03:00
	Creating Parameter Queries		00:08:00
	Using -Like- Keyword in Parameter Queries		00:02:00
	Creating a Top X Query		00:01:00
	Reviewing Calculated Query Fields		00:03:00
	Summarizing Query Data with Totals		00:02:00
	Inserting Where Statements in Summary Queries		00:01:00
	Creating a Crosstab Query		00:03:00
Automating Processes with Macros
	Understanding Macro Basics		00:06:00
	Creating Macros to Open Forms by Record		00:04:00
	Validating Data Entry with Macros		00:04:00
	Creating a Macro to Automate Data Entry		00:04:00
	Advanced Data Entry Using Macros and DLOOKUP Function		00:06:00
Advanced Form
	Using Conditional Formatting		00:02:00
	Organizing Form Fields with Tab Controls		00:03:00
	Creating a Combo Box Control		00:02:00
	Creating an Option Group Control		00:03:00
	Using a Subform to Show Data from a Related Table		00:03:00
Advanced Report Techniques
	Inserting a Chart on a Report		00:03:00
	Showing Data in Columns		00:02:00
	Inserting a Subreport		00:02:00
	Configuring Reports with Parameter Queries		00:04:00
	Sending Reports		00:02:00
Conclusion
	Course Recap		00:00:00
Resources
	Resources - MS Access 2016 Intermediate		00:00:00
Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

MS Access 2016 Intermediate

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews