Setup Menus in Admin Panel

  • LOGIN
  • No products in the cart.

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:

Getting the certificate is easy. After Completion, get the PDF certificate within 24 hours at only $25.99. For the Hard copy, the amount is $40.99 and it will reach to you within 37 working day.

Curriculum

Introduction
Introduction 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


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.



community

Your learning doesn’t end after the course ends. Work on your plans, discuss with your classmates and get real-time feedback from qualified trainers.

What Is In For You:

What our STUDENT says

Based on 812 Reviews

4.7

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

No Reviews found for this course.



Quality assured

100% Money Back Guarantee

In case you’re hesitating, consider our 100% guarantee for this John Academy class. If you find that it hasn't met your expectations, simply drop us a note after you've participated through all the lessons in the class and we’ll refund your entire class fees.



FAQ’s

Your learning doesn’t end after the course ends. Work on your plans, discuss with your classmates and get real-time feedback from qualified trainers.

At John Academy we have prepared a range of frequently asked questions that our students ask prior to joining our courses. We hope you find these questions useful. However, if you have a specific question that is not covered, please contact us.

To enrol onto one of our online courses is very easy. On the course page of the course you are interested in just click on the ‘Add to Cart’ button which will add the course to your shopping cart.  This will then be followed by the checkout screen at which you can enter your payment details. Once your payment has successfully gone through, you will receive instant access to your online course. We will email you your course details and invoice straightaway to the email address you used to sign up.

Yes. With John Academy you will receive instant access to your course, meaning that you can study from anywhere in the world, as long as you have an internet connection. We have students taking our courses in over 80 countries worldwide.

Yes. You can purchase the course for someone else, whether it is a family member or friend. Just be sure to inform us after checkout so we can update the course details accordingly.

John Academy is not like a traditional college or institution where set dates for enrolment exist, we provide online training courses that are completely flexible. With our online training courses you can enrol and start your course at any time. You have complete control over your own learning.

All courses available at John Academy are studied online so you do not need to attend any training venue or classes.

You will receive instant access to your course once you have successfully completed the checkout. We send your login details for the course, along with a receipt for your payment straight away, to the email address used at checkout. Please make sure you therefore use the correct email address at checkout.

If you need help on the course just email our support team who will be able to guide and help you with whatever problem you are facing.

The PDF certificate’s turnaround time is 24 hours and for the hard copy certificate it is 3-9 working days, but it can be longer during busy periods.

At John Academy our courses are online and can be studied your own pace without any strict deadlines for completion throughout the duration of your course subscription.

Most of the courses available here at John Academy require little or no previous knowledge prior to enrolling. Our courses are ideal for beginners and those interested in the subject.

There is no age requirement to join the online training courses here at John Academy. Assuming that you can keep up with the learning material and study at your own pace, you shouldn’t have any problem learning.

Generally, you will receive access to the course for 12 months from the date of joining. Please check the individual course page for more details.

In the unlikely event that you should fail an exam, you will be given an opportunity to retake it.

The majority of our courses conform to the internationally accepted Centre for International Qualifications (CiQ) and Continuing Professional Development (CPD). CiQ and CPD are recognized nationally across the United States and internationally around the world, thus the CiQ & CPD Award should be recognized by academic institutions, public organizations and private companies. Your certificate will contain the John Academy CiQ & CPD Award.

Please use the Contact us page to contact us should you have a specific question which is not answered here.

USD $18

Original Price $199

2 days left at this price!

TAKE THIS COURSE

$ 199.00 $ 18.00Read more

100% Money Back Guarantee

© 2022 John Academy All Rights Reserved.