Access 2016 - The Complete Microsoft Access Beginners Course

Steve McDonald, Author, Instructor, Digital Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Videos (4h 20m)
    • Welcome to Access for Beginners

      9:52
    • Take a Tour of the Access Dashboard and Ribbon

      10:08
    • Learn About Access Objects: Tables, Queries, Forms and Reports

      11:57
    • Create Your First Table in Access

      17:53
    • Appending Data from Excel into Access

      7:50
    • Importing Data from Excel into Access

      6:48
    • Importing Data from a CSV Text File into Access

      7:35
    • Database Design and Table Relationship Basics in Access

      7:18
    • More Complex Database Design Scenarios

      3:53
    • Primary Keys and Foreign Keys in Relationships

      14:07
    • Introduction to Field Properties in Access Tables

      3:38
    • Size, Format & Input Mask Field Properties

      16:04
    • Default Value, Validation Rules & Indexed Field Properties in Access

      15:59
    • Introduction to Access Forms

      8:35
    • Create and Format a Form Using the Form Wizard

      14:04
    • Add Controls to Your Form for Better Usability

      15:15
    • Add Navigation Buttons and Drop Down (Combo) Boxes to Your Form

      16:08
    • Introduction to Queries, Sorting and Filtering

      10:42
    • Create a Query Using a Single Criteria

      7:53
    • Criteria in Queries - Many Examples

      16:14
    • Introduction to Reports - Create Your First Report

      6:10
    • Create Two More Reports

      12:57
    • Options - General and Current Database Option Tabs

      10:12
    • Options - Datasheet and Other Option Tabs

      9:41
    • Exporting Tables, Queries & Reports to Text, PDF and Excel

      5:03
    • Course Summary

      5:14

About This Class

Welcome to the Access 2016 course. 

Thank you so much for joining us. 

  • Do you need to learn Microsoft Access, but feel intimidated or
    overwhelmed by the thought of it?
  • Are you ready to learn a ton of practical, hands on Access skills?

If so, you found the right course!

This course is designed to get you feeling comfortable and confident using Access. It's designed to get you started with the skills you need to organize your data in tables, mine your data using queries, and create clean, professional reports to impress your boss.

Is it the Right Fit?

You might be wondering if this course will be a good fit for you. Well, I designed this course for the beginner who needs to add this course to their list of important job skills. This course is also a good fit for you if you have a little bit of experience with access already, and you're ready to fine tune and expand your skills in an easy, stress-free way.

Skills to Impress Your Boss

While its ultimately up to you, my goal is to give you the skills to impress your boss and hopefully get that raise, promotion, or new job that you deserve.

Start at the Very Beginning

We'll start out with a complete tour of Access and it's tools. Then, I'll show you how to open an Access Database and how to use pre-formatted Access templates provided by Microsoft so you can start right away.  

Create a Database from Scratch

  • I'll walk you through creating a complete Access database from scratch. 
  • I'll show you how to create tables and connect those tables to each other using relationships. 
  • I'll show you how to mine your data using queries, how to create forms so users can enter data into your database, and how to create custom reports so you can impress your boss. 
  • I'll also share insights and productivity tips along the way.

Let's Get Started!

Are you ready to take your productivity and hopefully even your job prospects to the next level? Let's get started with Access 2016.

Click on the Buy Now button or watch one of the Free Preview Lectures and start learning Access today.

15

Students

--

Projects

Steve McDonald

Author, Instructor, Digital Entrepreneur

I believe that learning can be easy if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.

Whether I am teaching How I Retired Early Publishing Kindle eBooks or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.

For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life.

I have tested many different strategies including:

  • Investing in rental real estate
  • Building niche websites about my hobbies (like my pottery-on-the-wheel website) and
  • Publishing Kindle eBooks.

I have studied what works and what doesn't work and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life.

Each of my courses is designed to share with you these secrets. I hold nothing back. And I won't bore you with all of the strategies that don't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate it.

Of course, it's no secret that one of my favorite way to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five.

Once I figured out the Kindle publishing system, some formatting secrets that for some reason are not easy to find, and learned how to use some simple SEO skills that I learned while testing out website building, publishing eBooks became remarkably simple.

Even hiring writers, which would seem scary at first, is really easy and even fun, when you follow my system. I even have it set up so you can publish one or two books and then roll the profits from them into hiring writers so you aren't taking any money out of your pocket.

It starts out as a little income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income.

I retired in 2014 thanks to my eBook publishing success. Now, when I'm not skiing or kayaking or hiking with my 7 year old son I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you.

I'm here to guide you on your way to success.

I'm glad you found me and I'm excited to have the opportunity to share my experience with you! 

Welcome to the course.

Steve