• LOGIN
  • No products in the cart.

MS Access 2016 Intermediate

4.7( 9 REVIEWS )
353 STUDENTS

Description

You have 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 in reaching 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.

Benefits you will get?

  • Affordable, engaging & premium-quality e-learning study materials
  • Assessment through Tests and Quizzes and instant result
  • Internationally recognized accredited qualification
  • Access to course content on mobile, tablet or desktop from anywhere anytime
  • Personalized learning – Learn at your own pace, time and place
  • A vast array of fascinating subjects
  • Regularly updated contents
  • Dedicated support team working 24/7

Requirements:

  • Anyone with any academic background can enroll into this course.
  • A device with an active internet connection

Assessment:

We assess our learners through quizzes or multiple choice test. This test will be assessed automatically and immediately to give you an instant result.

Certification:

The PDF copy of Certificate of Completion can be claimed at the free of cost. If you need a hardcopy of this certificate, you have to pay an additional payment. The time for PDF certificate turnaround is 24 hours, and for the hardcopy, it is 3-7 working days.

Course Curriculum

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

Course Reviews

4.7

4.7
9 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE

Instructors

353 STUDENTS ENROLLED

30 DAYS MONEY BACK Guarantee

Buy For Your team

Get your team access to john’s top 1540+ courses anytime anywhere

try john academy for business

Our Course Awarding Bodies

ACCREDITED BY

 

OUR COURSE PARTNERS

Have you any inquiry?

  • By submitting your information, you agree to the terms and conditions stated in our Privacy Policy

© 2021 John Academy All Rights Reserved.