fbpx

Learn Microsoft Access 2016 Tutorial

A Fast Paced MS Outlook Tutorial to Boost Your Productivity
You need an Outlook tutorial that teaches you nuances of Outlook shortcuts and helps you increase your efficiency and speed.

  • Video Lessons = 53+ (2.5 Hrs)
  • Lifetime Access
  • Lifetime Support
  • 4.8/5 Rating

Watch Free Lessons on Microsoft Access 2016

What do TOP Excel Bloggers think about my course…

Big Peoples Reviews

Learner Testimonials

I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

peter-kuluberg-excel
Peter Klugsberger
ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies

Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!

barbara
Barbara Jones
Finance Professional

I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course

Placeholder
Peter Thomas
Accounting Professional

I’ve helped these COMPANIES

I-have-helped-this-company

GET ACCESS TO THE MICROSOFT ACCESS COURSE

About the Instructor

Instructor-Rishabh-PugaliaRishabh Pugalia | Linkedin Profile
 4.8 Average Rating | ? 839 Reviews |
? 12,589 Classroom Students |? 40,000 Students Online

ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years

I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)

After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.

If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!

Course Curriculum

Introduction to Access (7 minutes)

  • Why MS-Access
  • Starting with MS-Access (Interface)
  • Data Types and Purpose

Table Objects: Basics (40 minutes)

  • Introduction
  • Creating a Sample Table
  • Adding, Editing and Deleting Records
  • Use of Autonumbers – Datasheet View
  • Table Properties and Custom Formatting
  • Set Field Validations
  • Other Field Properties
  • Import Data from Excel into a New Table
  • Append Data From Excel into an existing table
  • Table Sorting
  • Table Filtering
  • Exporting to Excel

QUERY Objects: Basics (38 minutes)

  • Introduction
  • Basic Queries
  • Query Criteria
  • Date Criteria
  • Using AND in Criteria
  • Using Or in Criteria
  • Using AND-OR in Criteria
  • Multiple AND and OR Example 2
  • Parameter Queries
  • Wild Card Operators
  • Like and Not Like Operator
  • And Operator
  • Or Operator
  • In and Not In Operator
  • Basic Calculated field
  • Using Date in Operators in calculation

REPORT Objects: Basics (9 minutes)

  • Introduction
  • Modifying the Report
  • Working with Controls, Report and Layout Views
  • Report Using Parameter Query in combination

FORM Objects: Basics (9 minutes)

  • Introduction
  • Creating a Form with the Form Table
  • Creating a Form with the Wizard From Table
  • Basic Formatting and Editing of layout

TABLE Objects: Advanced (35 minutes)

  • Using the Lookup Wizard
  • Setup Lookups Without the Wizard
  • Lookup Wizard Example 2
  • Advanced Sorting
  • Advanced Filter_Filter by Form
  • RDBMS between multiple Table a
  • RDBMS between multiple Table b
  • Printing RDBMS between multiple Tables
  • Create Linking table in different access as backhand data

QUERY Objects: Advanced (1 hours 13 minutes)

  • RDBMS Between tables
  • Primary Key
  • Join Types in RDBMS
  • Temporary Relationship between Tables
  • Permanent Relationship between Tables
  • Unmatch Query Wizard
  • Unmatch Query Using Query
  • IIF Calculated fields
  • Using TOP queries
  • Using TOTAL Queries (GroupBy)
  • Cross Tab Action Query
  • Make Table Action Query
  • Update Table Action Query
  • Delete Action Query
  • Append Table Action Query
  • Summary of all action Query in one process
  • RDBMS used for calculative field
  • Yearly Report using RDBMS with Parameter query
  • Unmatch Query Wizard
  • Unmatch Query Design

Report Objects: Advanced (7 minutes)

  • Add a Combo Box to Our Orders form
  • Setting the TAB Order and Using TAB Controls
  • Add a Subform
  • Change a Textbox into a ComboBox
  • Creating and Using Button Controls

Macros (16 minutes)

  • Introduction to Macro
  • Creating Simple Macro
  • Assigning Macro To Button
  • Building Macro Under Event
  • Macro to Open Report for Printing
  • Change tab Setting of MS Access

Start Learning Today

No Frills

Free Course Lessons

$FREE
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
WATCH NOW
No Frills

Lifetime Access

83+ Course Lessons
$48
  • 83+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now
Office Training Bundle Package

All Courses

Unlimited Learning [All YL Courses]
$297
  • 177+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Looking for subscription plan? Get All Courses in $39/mo: Enroll Now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

Personal Guaranteed

How does it work?

The process is really smooth. After enrolling for the Course, you’ll get a link. With the given link you can register for the course. Enjoy lifetime access and support with the course. Watch the video courses 24×7 as per your interest.

how-it-works

Frequently Ask Questions

How do I pay to enroll for Microsoft Access 2016 Tutorial?

Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

What do you get in Microsoft Access 2016 tutorial?

  • A Fast Paced Practical approached program to teach you
  • Access to all videos 24 x 7 – learn online from anywhere
  • A 30-day money-back guarantee (we want you to be 100% satisfied)

How much time to complete Microsoft Access 2016 tutorial ?

This is a fast-paced, lean program of about 5.5 hours with videos from basics to advance. Watch the preview video to get a flavor the program’s uniqueness and relevance.

What if I’m unhappy with this Microsoft Access 2016 tutorial? Do I get a refund?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund. To know more please go through our Refund Policy.

Contact Me

Still confused on which Course to take?

 Email [email protected]

 Call Now! +91 80800 42523 / +1-203-349-9909