• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

MS Access 2016 Intermediate

MS Access 2016 Intermediate

By John Academy

4.3(43)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 2 hours 7 minutes

  • All levels

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

About The Provider

Tags

Reviews