Access 2016 - The Complete Microsoft Access Beginners Course | Steve McDonald | Skillshare

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 31m)
    • Welcome to Access for Beginners

    • Take a Tour of the Access Dashboard and Ribbon

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

    • Create Your First Table in Access

    • Appending Data from Excel into Access

    • Importing Data from Excel into Access

    • Importing Data from a CSV Text File into Access

    • Database Design and Table Relationship Basics in Access

    • More Complex Database Design Scenarios

    • Primary Keys and Foreign Keys in Relationships

    • Introduction to Field Properties in Access Tables

    • Size, Format & Input Mask Field Properties

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

    • Introduction to Access Forms

    • Create and Format a Form Using the Form Wizard

    • Add Controls to Your Form for Better Usability

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

    • Introduction to Queries, Sorting and Filtering

    • Create a Query Using a Single Criteria

    • Criteria in Queries - Many Examples

    • Introduction to Reports - Create Your First Report

    • Create Two More Reports

    • Options - General and Current Database Option Tabs

    • Options - Datasheet and Other Option Tabs

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

    • Course Summary

25 students are watching this class

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.





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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

See full profile

Report class