Microsoft Access 2016 Master Class: Beginner to Advanced
4.6 (1,437 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,792 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access 2016 Master Class: Beginner to Advanced to your Wishlist.

Add to Wishlist

Microsoft Access 2016 Master Class: Beginner to Advanced

Quickly learn how Access 2016 can make your life easier and more productive!
Bestselling
4.6 (1,437 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,792 students enrolled
Last updated 5/2017
English
English [Auto-generated]
Current price: $10 Original price: $195 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 2 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand how Access is constructed and how to use the major objects within it.
  • Be confident in moving around within Access and be able to build effective database solutions for their unique data needs.
View Curriculum
Requirements
  • Students just need to have a general knowledge of working with Windows and have Microsoft Office 2010 or later installed.
Description

Welcome To Microsoft Access 2016 Master Class: Beginner To Advanced

⇉ Watch the promo video to see How You Can Begin Mastering Microsoft Access 2016!

⇉ This Course is MASSIVE! You receive over 7+ hours of video content & 80+ lectures!

⇉ Join Over 275,000+ Students Who Have Enrolled In My Udemy Courses This Year!

⇉ 7,500+ Five Star Reviews on our courses prove Students Who Enrolling Are Getting Real Results!

Then this course is for you! Click "Take This Course Now" For Instant Life-Time Access!

__________________________________________________________________________

Every one of us, whether we know it or not, are surrounded by data.  Some of it we keep track of on paper or in spreadsheets.  Some of it is really important, like tasks that are part of our daily work.  BUT, unfortunately, very few of us use the one tool that was built to handle all of our data needs - the Microsoft Access database.

Should you take the time to learn Microsoft Access?  

Many people do not use the Microsoft Access database program for 2 reasons:
   1. They think it is too complex
   2. They do not realize how incredibly powerful it is.

This course is dedicated to resolving the complexity question by demonstrating the basics of HOW Access is constructed and why the structure makes sense.  Most courses just bury students in details, never starting with an overview and never showing students how the different parts can be used to increase productivity.  By the time you have finished the first sections of the course, you will understand WHY Access is built the way it is and feel comfortable moving around in the program.

Once you understand the basic structure, the course will show you many practical demonstrations of what Access can be used for.  By the end of the course you will have a very good idea EXACTLY how you could use Access to increase your productivity.

You will see demonstrations of many tasks that are easy to do with Access, but difficult or impossible to do with Excel. This is not to say that Excel is not an excellent program.  It is a wonderful program and we use it every day, but it is not a database. The best of both worlds is to use both programs together!

So, while this course will provide you with a lot of information on the parts of Access and how they work, the overall objective is to provide you with enough information to decide if Access is right for you and how you might use it.  At that point, the more detailed courses that are available will make much more sense and you will be able to go through them with a specific sense of purpose.

Learn about Access Objects and how they work together.  Learn how the screen is organized and become very comfortable with moving around inside the various parts of the program.  Understand how Access makes dealing with many settings and choices as easy as possible.   More than XX Lectures and XX Hours of content that will make you comfortable with Access!

Build a Strong Foundation in Microsoft Access!

  • Understand the structure of the database file and its advantages.
  • Become comfortable with how the menus and ribbons work.
  • Learn how you can save all your data in one place.
  • Learn how to extract only the information you want.
  • See how to relate tables together and resolve the "1 to Many" problem.
  • Discover how having separate report formats reduces report prep time.
  • Learn how to easily create subtotals and do calculations.
  • See how you can link data back to Excel sheets for distribution.
  • View demonstrations of how Macros can be used to automate tasks.
  • See examples of how the VBA Programming Language can be used.
  • Learn how Access can work with Other Microsoft Office programs.

Powerful Skills That Increase Your Value in the Marketplace

This course will move Microsoft Access into your "comfort zone" so you can plan what parts of the program you want to learn in detail and what you want to achieve.  This method makes much more sense than just starting a comprehensive course on Access without any clear idea of how the program works or what it could possible do for you.

You will find that people who know how to use the incredible power of Access are in high demand in the marketplace. The familiarity with Access that you gain in this course will give you a solid foundation in creating databases that will make your life easier and be in demand by others!

There is a HUGE need in the marketplace for people who know how to use Access. This is your opportunity to break away from the pack of people who struggle to get their work done using only Excel.  Stop being a slave to your spreadsheets and start learning how to create effective Access databases and easily automate tasks! This could be your shortest path to increasing your income!

Content and Overview

To take this course, you do not need any background with Access and this course does not require any programming experience or knowledge of macros.  Even if you do not currently use Excel, you should have no problem being successful with the course.

Even though there are 67 lectures and over SEVEN HOURS of content, each section focuses on one set of concepts so it is easy to do one section at a time, when your schedule allows.  You will find that each chapter builds on what you learned in the previous ones and your knowledge will grow, step by step, throughout the course.

By the time you have finished the course you will have moved around within Access so much and manipulated the objects in Access so many times, that the program will be very familiar to you and you will be ready to build a database for your tasks immediately, This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files that contain all the demonstrations and sample objects for everything that is covered. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

Clicking the Take This Course button could be the best step you could take towards quickly increasing your income! Also, remember that if you don't think the course is worth what you spent, you have a full 30 days to get a no questions asked refund!

Required Software

You should have Office 2010 or later. The course was created using Office 2016.

__________________________________________________________________________

With the right mindset, understanding, and application of the teachings in this course, you will instantly begin to move towards mastering Microsoft Access 2016 

When we learn something new, I add it to the course - at no additional cost to you! This is a course that will continue to add more and more to every aspect of your life.

In addition to the Udemy 30-day money back guarantee, you have my personal guarantee that you will love what you learn in this course. If you ever have any questions please feel free to message us directly and we will do our best to get back to you as soon as possible!

__________________________________________________________________________

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But You Can Do It!

I am also not responsible for your actions. You are responsible for 100% of the decisions and actions you make while using this course.

__________________________________________________________________________

This course will not remain this price forever! It's time to take action!

Click the "take this course" button at the top right now!

...every hour you delay is costing you money...

See you in the course!

Sincerely,

Bruce Myron & Joe Parys 

Who is the target audience?
  • This course is for students who are dissatisfied with how they are handling data now and know there must be a better way.
  • This course is also for those who have attempted to learn Access before and been confused with courses that don't seem to address real world problems, or explain the basics before burying the student in an avalanche of detail.
Curriculum For This Course
76 Lectures
07:27:50
+
Introduction: Welcome To The Complete Microsoft Access 2016 Master Class Course!
2 Lectures 05:15

Welcome to our course! Learn all of the benefits of Microsoft Access 2016 and get started right away! 

Preview 02:06

Learn all of the course benefits and how to use this course to gain maximum value! 

Preview 03:09
+
THREE Major Data Problems That Access Completely Resolves
5 Lectures 15:59
A Quick Note BEFORE Starting Section 2
00:15


Access Solves the SIZE and SPEED Problem
03:37

Access Solves the DATA SHARING Problem
03:40

Access Solves the ONE to MANY Problem
03:31
+
Learning the Parts of the Access Screen
3 Lectures 12:19

Direct Download of Database File
00:07

Working with the Navigation Pane, Menu, Ribbons and Objects
10:20

The Parts of the Access Screen
3 questions
+
TABLE Objects - the Basics
5 Lectures 36:13
Creating Our First Table and Data Type PDF
09:01

Adding, Editing and Deleting Records
08:05

Primary Keys: What They Are and Why They Are Important
03:48

Adding Autonumbers, Primary Keys and Restructuring Tables
06:54


Review of the TABLE Object
6 questions
+
REPORT Objects - the Basics
3 Lectures 19:25
What do reports do?
04:11

Modifying the Report
05:41

Working with Controls, Report and Layout Views
09:33

Review of the REPORT Objects
4 questions
+
QUERY Objects - the Basics
5 Lectures 26:39
Basic Queries
06:45

Query Criteria
05:12

Date Criteria and Between
05:32

Using OR in Criteria
04:17

Parameter Queries
04:53

Review of Basic Queries
5 questions
+
PROPERTIES: Making Thousands of Choices Manageable
4 Lectures 26:27
Viewing Table Properties and Custom Formatting PDF
09:51

Field Validation and Other Field Properties
05:32

Query Properties
04:53

Report Properties
06:11

Review of Properties
5 questions
+
FORM Objects - the Basics
4 Lectures 26:50
Creating a Form with the Wizard
04:14

Cleaning Up the Form - Working With Controls
07:41

More Form Cleanup - Moving Labels, Adding Rectangles, Font Color
10:20

Resize Header and Detail and Finish Form
04:35

Review of Basic Forms
7 questions
+
Advanced TABLES
4 Lectures 22:50
Using the Lookup Wizard
05:16

Setup Lookups Without the Wizard
05:45

Advanced Sorting and Filtering
05:48

Working with Related TABLES
06:01

Review of Advanced Tables
4 questions
+
Advanced QUERIES
8 Lectures 46:04
Using TOP queries
04:02

Using TOTAL Queries
09:10

ACTION queries - UPDATE
06:25

ACTION queries - APPEND
04:27

Multi Table and MAKE TABLE ACTION Queries
08:32

ACTION queries - DELETE
02:48

Calculations in Queries and Formatting Results
05:33

A Parameter Query Trick
05:07

Review of Advanced Queries
8 questions
7 More Sections
About the Instructor
Joe Parys
4.4 Average rating
16,510 Reviews
294,626 Students
66 Courses
Bestselling Instructor, 66 Courses, Serving 290,000 Students

Why are 290,000+ students enrolled in my online courses?

1) I teach with passion and purpose! Every course is delivered with my students in mind.

2) My courses will help you achieve real results and change your life today!

3) My dedication to Udemy and teaching online. Udemy has named me one of its top instructors.

► Try enrolling in a course with me and see for yourself! ◄

__________________________________________________________________________

Want to learn how to become A Professional Web Developer?

Would you like to Transform Your Confidence and Self-Esteem?

Or maybe how to earn thousands Teaching Online Video Courses Full Time?

Then Enroll in my Udemy Courses Today! You too can be doing this - and so much more!

__________________________________________________________________________

About Joe Parys: 

Joe is a certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach for USA Basketballs Pilot Program. His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

My CV:

Joe has his bachelor’s degree from Coe College in Cedar Rapids, IA. He was a four-year varsity letter winning college athlete in the sport of men's basketball. He is also a coach for USA basketball.

He is a Licensed Psychology, History and Government teacher for grades 5-12. He has been teaching High School for the past three years.

Joe is also a licensed and certified professional life coach and motivational speaker from the Fowler Institute.

Business:

Joe Parys is an entrepreneur running his own online academy, Joe Parys Academy. Joe has spoken and taught his courses in numerous high schools in the United States and continues to travel around the country inspiring students of all ages.

Mission Statement- Joe Parys Academy is committed to superior life coaching. Our products and services are created and marketed with the purpose of helping others worldwide prosper and improve their lives.

Vision Statement- Our vision at Joe Parys Academy is to help each client find their purpose in life, reach their goals and fulfill their lifelong dreams.

Bruce Myron
4.6 Average rating
4,041 Reviews
44,368 Students
17 Courses
Productivity Specialist

Hello, my name is Bruce Myron. I am a self employed Access programmer and general computer consultant to small and medium sized businesses. I got into programming because I was tired of all the jargon most programmers use and how they don't seem to care about business.

"Technology is great but I've always been more interested in how it can be used to make companies more profitable." - Bruce

I live in Portland, Oregon and have many long term relationships with local businesses. Many of the systems I have built for these companies are critical to the success of the business. My specialty is taking the needs of the business and translating them into a system that facilitates, rather than obstructs, what they are trying to do.

I have also spent time as a full time trainer providing group classes on the Microsoft Office programs.

In my opinion the computer industry as a whole is a colossal failure in helping businesses solve their problems. I listen carefully to the needs expressed by my clients and then deliver the simplest, most flexible solution possible.

Over the years I have found that many of the techniques I have used enabled me to survive and thrive when many others have tried the computer programming business and failed.

My goal is to show my students how to create systems that business will value and that will create long term income.

Joe Parys Academy
4.4 Average rating
16,510 Reviews
294,626 Students
66 Courses
Best-Selling Instructor & Founder of the Joe Parys Academy

Why are 200,000+ students enrolled in our Udemy courses?

1) Purpose: We teach with passion and purpose! Every course is delivered with our students in mind.

2) Quality: Our courses are life changing and help you achieve real results!

3) Commitment: My dedication to Udemy and teaching online. Udemy has named me one of its top instructors!

► Try enrolling in any of our courses today and experiecne us firsthand! ◄

 __________________________________________________________________________

Joe Parys Academy is a Leader in Online Education with more than 30+ Co-Authored Courses

The Founder of Joe Parys Academy, Joe Parys, is a Bestselling Udemy instructor with more than 200,000+ students from more than 200 countries around the world! 

Mission Statement:

Our Mission at Joe Parys Academy is to create the highest quality online courses available anywhere in the world. We are focused on producing competent professionals and supplying them with the knowledge and skills they need. 

Vision Statement: 

Our Vision at Joe Parys Academy is for our students to have the opportunity to learn about the subjects of their choosing, taught by our highly qualified teachers. 

 __________________________________________________________________________

Want to learn how to become A Professional Web Developer?

Do You Desire To Create Your Own Mobile Applications? 

Or Maybe Learn How To Run Your Own Microsoft Access Business? 

Then Enroll in our Co-Authored Udemy Courses Today! 

You Too Can Be Doing All of This and So Much More!  __________________________________________________________________________

About The Founder of Joe Parys Academy:

Joe Parys is a Bestselling Udemy instructor, certified life coach, professional motivational speaker, entrepreneur, licensed psychology teacher and head basketball coach! His main areas of expertise are teaching, coaching, public speaking, personal development, personal transformation, the human mind, maximizing human potential, motivation and goal setting.

Joe Parys' CV:

Joe has his bachelors degree from Coe College in Cedar Rapids, IA. He was a four year varsity letter winning college athlete in the sport of men's basketball. He is also a coach for USA basketballs pilot program.

He has been teaching Psychology, History and American Government for grades 5-12 the past three years. 

Joe is also a licensed and certified professional life coach and motivational speaker from the Fowler Institute of Life Coaching. 

Business:

Joe Parys is an entrepreneur running his own life coaching and motivational speaking business. Joe has spoken and taught his courses in numerous high schools in the United States and continues to travel around the country inspiring students of all ages.