• LOGIN
  • No products in the cart.

MS Access 2016 Introduction

4.7( 9 REVIEWS )
343 STUDENTS

Description

As a beginner, do you want to learn about MS Access? Are you interested to know its various function and use? Do you want to be an expert in this field? If so, take a look at our MS Access 2016 Introduction course. It will assist you in understanding all you need to learn about this course.
The course designs for the fresher who have a little or no basic knowledge of MS Access. It teaches you how to create, open, and save an Access database. It will acquaint you with the necessary equipment such as ribbons and toolbar so that you can get access it flexibly to create a table, and store data smoothly. It introduces you to numeric and index field with plenty of practical exercises so that you can learn the basics of MS Access 2016 effectively.

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
Getting Started
What is a Database? 00:03:00
Understanding Database terminology 00:05:00
Navigating the Access Interface 00:06:00
What is a flat file database 00:04:00
What is a relational database 00:09:00
Relating Tables 00:06:00
Reviewing the Access Ribbon 00:04:00
Working with Data
Working with Tables 00:04:00
Navigating Tables 00:02:00
Editing Data 00:03:00
Adding New Records 00:02:00
Using Subdatasheets 00:04:00
Creating Databases and Objects
Understanding Database and Table Design Principles 00:10:00
Using Table Data Sheet View 00:04:00
Working with Field Data Types 00:04:00
Using Table Design View 00:04:00
Using Calculated Fields 00:04:00
Calculating Numbers 00:03:00
Calculating Dates 00:01:00
Calculating Strings 00:02:00
Using the Lookup Wizard 00:05:00
Editing Lookups 00:04:00
Using Indexes 00:02:00
Working with Queries
What are Queries 00:03:00
Creating Simple Queries 00:05:00
Understanding the Dynaset 00:02:00
Entering Criteria: Exact Match and Range Operators 00:04:00
Understanding AND versus OR 00:03:00
Using Wild Cards 00:02:00
Using Keywords 00:30:00
Sorting and Hiding Fields 00:02:00
Creating Multi-Table Queries 00:03:00
Additional Tips 00:03:00
Working with Reports
What are Reports 00:03:00
Understanding Report Types 00:03:00
Building Effective Reports 00:02:00
Using AutoReport 00:04:00
Understanding the Report Wizard 00:04:00
Using the Report Design View 00:08:00
Creating Labels 00:02:00
Working with Forms
What are Forms 00:04:00
Understanding Form Types 00:02:00
Creating Forms 00:02:00
Navigating Forms 00:02:00
Editing Data in Forms 00:03:00
Understanding the Form Wizard 00:03:00
Using the Form Design View 00:04:00
Working with Controls 00:03:00
Using Form Layout View 00:02:00
Additional Tips 00:03:00
Conclusion
Course Recap 00:01: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

343 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.