Best Microsoft Access Courses

Find the best online Microsoft Access Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Microsoft Access Courses.

FREE Microsoft Dynamics 365 For Beginners (Updated for 2021)

Learn the basics to become an Expert of Microsoft Dynamics 365 (CRM) Enterprise Solution and Boost Your Career Growth.

Created by Online CRM Training (3E Consulting Private Limited) - The Best &Most Affordable Microsoft Dynamics Training Online

"]

Students: 89230, Price: Free

Students: 89230, Price:  Free

***Updated the entire course to the latest version of Microsoft Dynamics 365 Customer Engagement (CRM)***

This Microsoft Dynamics 365 course has the highest numbers of students and positive reviews IN THE WORLD!
(Seriously, thank you so much for your Love :) )

If you are a Programmer or Business Analyst or Existing non-Microsoft Solutions Consultant or want to be a Dynamics 365 Consultant, this is the best course to start your learning journey to earn more.

***************************************************

HERE'S WHAT STUDENTS ARE SAYING:

"Overall, this course has been very helpful. I went from not even knowing what Microsoft CRM was to having a good basic understanding of the interface and features of the software. This course has definitely been worth doing and the instructor is great!" - Tyler Martin

"Before starting this course I never heard about Microsoft Dynamic 365 (CRM), one of my friend suggested me to just dirty your hands with MS Dynamic 365 (CRM). Actually I am coming development background so initially its look boring for me but after understanding about Dynamic 365 (CRM), I enjoyed this course very much. Looking forward to join another course. Thanks a lot Abhay. Great work." - Ram Thakkar

"As a complete beginner in this Software this has been very helpful and informative so far. Thank you!" - Aleksander Penev

"It is a very sweet lecture, despite being free. He took his time to explain every details you need to know about MS Dynamics. I am SugarCRM certified developer and willing to dive into MS Dynamics. I will Surely register for more of your courses in future. Thanks Abhay Sharma." - Aremu Habibullahi

"This was a very good course, I am just starting to use Dynamics CRM and this course was very helpful." - Orlando Sanders

"With no experiences in CRM, attending this course was really huge benefits. It guide you trough everything and I like the bonus in end of this course. I will recommended this course to anyone who would like to get into CRM." - Ahmad Hassan

"Thank you so much for creating the course. I enjoyed the learning about the CRM platform. I hope to take more courses in the future to further my career in ICT. Much appreciated" - Seraz Khan

And thousands of positive reviews...

***************************************************

Microsoft Dynamics 365 (CRM) is a Enterprise Business Solution by Microsoft.

It includes:

  • Microsoft Dynamics 365 For Sales to help companies improve Sales.

  • Microsoft Dynamics 365 For Customer Service to help companies improve their customer support & experience.'

  • Microsoft Dynamics 365 For Project Service Automation for managing end to end projects and

  • Microsoft Dynamics 365 For Field Service to manage Mobile workforce of the companies.

By the end of this course, you will have complete understanding of all four apps and much more... plus, this is a complete practical course.

Microsoft Dynamics 365 is one of the hottest and fastest growing business solution in the market.

The average salary of the Dynamics 365 Consultant is $85,000 - $100,000 Per Annum which will continue to grow...

***************************************************

HERE'S WHAT YOU WILL LEARN:

Module 1: Get Started With Microsoft Dynamics 365

  • What Is Microsoft Dynamics 365?

  • Microsoft Dynamics 365 Deployment Types

  • Microsoft Dynamics 365 Sign Up Process

  • Microsoft Dynamics 365 Application Navigation

Module 2: Microsoft Dynamics 365 For Sales Overview

  • Dynamics 365 For Sales Important Terms

  • Dynamics 365 For Sales Demo

Module 3: Microsoft Dynamics 365 For Customer Service Overview

  • Dynamics 365 For Customer Service Important Terms

  • Dynamics 365 For Customer Service Demo

Module 4: Microsoft Dynamics 365 For Project Service Automation (PSA) Overview

  • Dynamics 365 For Project Service Automation Important Terms

  • Dynamics 365 For Project Service Automation Demo

Module 5: Microsoft Dynamics 365 For Field Service Overview

  • Dynamics 365 For Field Service Important Terms

  • Dynamics 365 For Field Service Demo

Module 6: Microsoft Dynamics 365 Other Important Features

  • Dynamics 365 Records And Activities Creation

  • Dynamics 365 User Creation And Security Model

  • Dynamics 365 Settings And Administration

  • Dynamics 365 Customization

  • Dynamics 365 Reporting Overview

Quick Recap :)

  • Course Quick Recap

I look forward to teaching you this amazing technology.

To Your Success,
Abhay Sharma

#1 Udemy Best-Selling Instructor for Microsoft Dynamics | Microsoft Certified Trainer (MCT)

Microsoft Access 2016 Master Class: Beginner to Advanced

Quickly learn how Microsoft Access 2016 can make your life easier and more productive!

Created by Joe Parys - Top-Rated Instructor, 800,000+ Students

"]

Students: 48034, Price: $109.99

Students: 48034, Price:  Paid

Have you always wanted to learn Microsoft Access but you just don't know where to start?

Or maybe you have started but you just don't know how to use some of the more advanced features.

Then our complete Microsoft Access 2016 Master Class: Beginner to Advanced is for You!

_________________________________________________________________________

Welcome To the “Microsoft Access 2016 Master Class: Beginner to Advanced.”

⇉ Join 800,000+ Students Who Have Enrolled in our Udemy Courses!

⇉ 10,000+ Five Star Reviews Show Students Who Enroll in our Courses get Results!

⇉ You Get Over 75 Lectures and 7+ hours of premium content

⇉ Watch the Promo Video to see how you can Get Started Today!

_________________________________________________________________________

What do you get with this course?

  • Hours of easy-to-watch video lessons

  • Downloadable Resources

  • Practical activities

  • Instructor support if you have any questions

  • Community of students ready to help

What will you learn in this “Microsoft Access 2016 Master Class: Beginner to Advanced.”

In short, you'll learn it all! Seriously, our goal is to make the most comprehensive Microsoft Access course out there - not filled with fluff, but filled with only the most actionable and latest tips and strategies. We'll be updating this course periodically to make sure we're covering any change with Microsoft Access.

You'll start by an overview of the course and learn how to get started with Microsoft Access.

You'll then learn three major data problems that Access completely resolves.

Once you understand how to resolves these three major data problems, you will learn about the parts of the Access screen, table and report objects, query objects and properties, form objects and advanced tables, advanced queries and reports, advanced forms and automating things in your forms, more form automations like buttons and macros, and how to create a multi page invoice.

By the end of our course you will:

  • Understand how Access is constructed and how to use the major objects within it.

  • Discover THREE Major Data Problems That Access Completely Resolves

  • Learn the parts of the Access screen

  • Learn table, report and query objects

  • Master PROPERTIES to make thousands of choices manageable

  • Learn the basics of form objects

  • Fully understand tables, queries, reports and forms

  • Use automation in your forms with buttons and Macros

  • Create a multi page invoice

  • And more...

Ready to get started?

Once you enroll, we recommend students install Microsoft Access on their computers to follow along.

_____

See What Current Students Are Saying About Our Course:

It did take me a while to get thru this course due to other commitments, but I did find the course to be very informative as I'm a newbie to using Access and wanted to get up and running with as much knowledge as I could. Some sections were "over my head", but that is all part of learning something new. Thanks for taking the time to put this course together.”
-Todd Atkinson

"Great course to learn a new skill. And it go from zero to Hero. Now i need to apply this knowledge to create my own database. Thank you very much and wish you a lot of satisfied students like I am. :)"
-Tibor Molnar

"What makes this an amazing course. Easy to follow instructions. The audio, visuals and the transcripts were extremely helpful. Great response when asking a question. The course allows you to review the course or parts of thereof. This was a new experience (for a retired person), never took an online course. Just signed up for your VBA course. Thank you for making this a valuable and interesting course."
-Donna

_____

Who are your instructors?

We are Joe Parys and Bruce Myron, creatives who have taught over 800,000+ students around the world with our online courses, tutorials and other content. Bruce Myron is the lead instructor for this course, bringing his wealth of knowledge in working with Microsoft Access. Joe Parys is the Bestselling Online Instructor, Digital Marketing Expert and Leader in the eLearning industry. He is the CEO of the Joe Parys Academy serving more than 1,000,000+ students in more than 100+ co-authored courses from 190 countries all around the world.

Our goal is to show you the real world and practical ways to start using Microsoft Access with confidence today!

_________________________________________________________________________

With the right mindset, understanding, and application, you will instantly begin learning how to build databases with Microsoft Access.

When I 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.

What I can't do in this Course..

I can't guarantee your success – this course does take work on your part. But it can be done!

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

_________________________________________________________________________

It's time to take action!

Our happiness guarantee

This course includes a money back guarantee, so there is no risk to try it out.

Sign up today, see if it's the right one for you.

Enroll now.

Sincerely,

Joe Parys and Bruce Myron.

Introduction to Microsoft Excel 2010

Learn the basics of using Microsoft Excel 2010

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 34335, Price: Free

Students: 34335, Price:  Free

During this introductory course on using Microsoft Excel 2010, we'll teach the basics of using Microsoft Excel 2010.

Your professional instructor will talk you through Excel 2010's features, starting with the basics, from creating files to editing existing documents. You'll start with creating a new workbook and entering text and numbers, moving onto saving and printing your documents.


The course is designed for individuals and office professionals who need to learn the basics of Microsoft Excel 2010.

Intro to Access – Microsoft Access Basics for Beginners

Intimidated by Access? Microsoft Access Basics walks you through creating your first simple database from scratch.

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 33814, Price: Free

Students: 33814, Price:  Free

When you think about learning Microsoft Access do you feel overwhelmed or intimidated?

If so, you're in the right place. 

Microsoft Access Basics for Beginners is designed to get you started in Access by creating a very simple database from scratch. 

This is a very hands-on course where I'll walk you through it step-by-step. The lessons are short and easy to follow, and all of the steps are explained in plain English.

With this course, anyone can get started learning Access. It isn't going to make you pro, but after you finish this short course, if your boss starts talking about Queries, Forms or Reports, you'll know exactly what they're talking about. And you'll understand how to create one.

Click on into the course. I promise it'll be easier than you thought.

Microsoft Access Complete Beginner to Advanced

Ultimate Microsoft Access Training - Create & Maintain Access Tables, Access Queries, Access Forms, Access Reports

Created by Kyle Pew - Microsoft Certified Trainer

"]

Students: 26959, Price: $109.99

Students: 26959, Price:  Paid

Microsoft Access all in One Package

This Microsoft Access course combines 4 different courses.

  • Microsoft Access 101 - An Introduction to Access and Table Design

  • Microsoft Access 102 - Access Queries

  • Microsoft Access 103 - Form and Reports

  • Automate Microsoft Access Tasks with Macros and VBA

Each Section, (Intro/Tables, Queries, Forms, Reports and Macros/VBA), will start at the basic level and progress to an advanced level with the section.

Material recorded with Access 2016 but works in 2007, 2010, 2013, and 2016

Enroll now to go through a deep dive of the popular end-user relational database tool, Microsoft Access. As your instructor I will use my 15+ years of Access training to guide you step by step through the beginner to advanced level and beyond.

As you participate in each of the 4 courses you will master Access tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Access tools and come out with confidence to complete any Access tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating Effective Database Tables

  • Understanding Table Relationships

  • Building Dynamic User Data Forms

  • Effectively Retrieve Data Using Access Queries

  • Build Effective Reports

  • Automate Access Database Tasks with Macros and VBA

So, what are you waiting for, enroll now and take the next step in mastering Access and go from Access Newb to Access Guru!

Microsoft Access VBA for Non Programmers – YOU Can Do This!

Microsoft Access VBA can be learned quickly even if you've never done programming! Make complex jobs easy with VBA!

Created by Bruce Myron - Productivity Specialist

"]

Students: 16759, Price: $94.99

Students: 16759, Price:  Paid

Learn all the Access VBA programming concepts, tools and functions that you will need while you build a fully functional system! More than 85 Lectures and 8 Hours of content on Microsoft Access Visual Basic!

Some Student Reviews:
Microsoft Access VBA for Non Programmers-Learn VBA. Thanks to the course my knowledge of VBA has increased to a workplace skill level. I am further confident in reading and writing code. Without a programmers background, I have been successfully able to follow the lectures and replicate the database structures as outlined. An excellent resource in code writing and application for database development. - Fleur Pepper


"This is the best class I've taken on Udemy. There isn't a wasted minute in these videos. Thanks, Bruce!" - William Vicars

"I used to think I was an expert at Access until I took this course. Bruce has a way of presenting material that makes you learn it on the first view. He goes into all nooks and crannies of the subject presented. I highly recommend this course for beginners and experts alike.." - Rafal Krolik

"Bruce has created a really extensive course about Access. This course is built in bite size bits and every section teaches you an additional function in Access. The best thing about this course is that it is very low key and is really designed to help out the non-programmer. VBA might be very intimidating but this course shows you everything. The pace is good and every part is being explained in an excellent manner. I highly recommend this course especially if you want to learn and while learning create a wonderful tool that truly is useful." - Nicky Wong

Build a strong foundation in Access Visual Basic with this tutorial for Non-Programmers!

  • Create VBA Subroutines for Forms and Control the Keyboard

  • Extensive Training on Handling Errors

  • Control Record Sorting and Searching for Specific Records

  • Learn How to Move and Pass Data Between Forms

  • Create Interactive Pull Down Filters for Form Data

  • Build a Complex Report Entirely with VBA

  • Introduction to SQL and How to Use SQL in VBA

  • Turn the Ribbon and Nav Pane On and Off

  • Prevent Form Closure or Resizing

  • Learn How to Close Access with VBA

Powerful Skills That Increase Your Value in the Marketplace

Learning VBA programming enables you to use ALL the power of Access to easily create systems that will be in high demand with your current employer or other businesses.  The practical skills taught in this class will give you a solid foundation in creating systems that people can really use!

There is a HUGE need in the marketplace for people who can create systems like this in Access.  This is your opportunity to break away from the pack of people who struggle to create effective Access databases, and learn to easily automate tasks!  This could be your shortest path to increasing your income!

Content and Overview

All you need to do the course is some basic experience with Access components: tables, queries, forms and reports. This course does not require any programming experience or knowledge of macros.

Even though there are 80+ lectures and over 7.5 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 the previous one as you build a complete system, step by step.

By the time you have finished the course you will have done so much with VBA and it will be so familiar that you will be ready to tackle your own project immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

The course is complete with working files and finished code samples 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 2010.

Excel to Access: Intro to Microsoft Access for Excel Users

Learn Access quickly and understand how it works with Excel. Master the basics of tables, queries, forms and reports.

Created by Bruce Myron - Productivity Specialist

"]

Students: 16748, Price: $94.99

Students: 16748, Price:  Paid

Learn more than the basic structures in Access. Learn the concepts underneath and how they relate to and work wth Excel. Learn Access from an instructor with years of experience teaching Access and creating custom databases for businesses.

From a recent Student Review:

5 Stars - I finally have a grasp of Access and relational databases!

Thanks to Bruce's course, I can confidently say I have a good grasp of what Microsoft Access is, how to use it effectively and how it differs from Microsoft Excel.

Bruce is clear and concise in his lectures. I enjoyed the hands-on/real world example style of teaching with downloadable Access & Excel files. - Joey Sullivan

You will build a strong foundation in Access by understanding the logic behind its structure:

  • Create tables and learn how to properly structure them.
  • Extensive Training on ALL types of queries.
  • Create reports from scratch instead of relying on wizards.
  • Learn how to create advanced reports based on queries.
  • Learn everything you need to know to build powerful and attractive forms.
  • Build subforms and learn how to move in and out of them.
  • Learn about simple macros.
  • Make basic command buttons in forms.
  • Learn a simple way to make multi value lookups on forms.

Another Student Review:

5 Stars - Fantastic Course!

I have been trying to come to grips with Access for some time now, but each time I became frustrated and eventually gave up. This course is structured in a way that gripped my interest and motivated me to complete it. Bruce has extensive knowledge and the way that he presents the material, makes it easy to follow and understand and it is a very valuable resource. - John Ovens

These Powerful Skills Will Skyrocket Your Value in the Marketplace!

By learning how to use Access WITH Excel, you will rise to a level of skill that few others have. Learning Access gives you incredible power over your data, no matter how large your data files are. Nightmare editing tasks will no longer bother you as you use your knowledge of queries to update thousands of records in minutes! Employers are waking up to the power of Access and those who have this knowledge will be in high demand with your current employer or other businesses. The practical skills taught in this class will give you the capability to double or triple your productivity!

There is a HUGE need in the marketplace for people with these skills! This is your opportunity to break away from the pack of people who try and do everything with Excel, instead of learning that for many tasks, Access is the proper tool. This could be your shortest path to increasing your income!

From a Student Review:

"This is an amazing class/series. Bruce does a fantastic job explaining each concept and does so with such concern for the student. Just in presentation one can identify that this is a passion for Bruce and not just read from a script. I cannot wait to put this education to use within my career!! Thank you for creating this material!" - Rick WIlliams

Content and Overview

All you need to do the course is basic experience with Windows programs. If you have or are using Excel, that is even better. Much of the course is presented as a comparison to Excel and explains what tasks each program is best suited for.

Even though there are many lectures and several 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 the previous one as you build your understanding of Access, one step at a time.

By the time you have finished the course you will have done so much with Access and it will be so familiar that you will be ready to tackle your own data tasks immediately, putting your new learned skills into practical use and impressing your boss and coworkers.

The course is complete with working files and finished samples 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.

Click the Take This Course button to take your first step 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!

From Another Student Review:

5 Stars - Absolutely the Best Course I Have Taken

I am not one to write many reviews, but when a course has reached beyond my expectations, I had no choice but to give compliments to the author Mr. Bruce Myron.

The content of the course was extremely comprehensive and informative in which every student will walk away having the best foundation of MS Access one can get. The clarity and tone of each video had me eager to learn more and has already assisted me with applications I had at work. With the knowledge I have gained, not only will it help separate myself from my co-workers, but allow me to increase my income over time.

The greatest treat one will get in this course is the interaction from Mr. Myron. He is absolutely the difference maker from any other course I had taken and made me feel that I was not alone while taking this course. I cannot wait to begin the other courses to get to the next level of my career.

Trust me, when it comes to learning MS Access from the ground up through Mr. Myron's courses, starting with Excel To Access: Intro to Access for Excel Users, one will be ecstatic with the results. - David Richardson

Another Student Review:

5 Stars - Brilliant piece of work!

Thanks Bruce for making these lectures. They are very well done, relevant and clear. I have literally copied line for line of many of these lectures into a project i am working on. Highly recommended also are the other videos which also contain golden nuggets: Access to Excel to Outlook, Access to Excel-Instant Reports and pivot tables, Microsoft Access vba for non programmers. And as a bonus, Bruce has been very helpful in answering, guiding and explaining content from his lecture when i asked for clarification.

Brilliant Bruce, thanks again - Steven Kawuma

Required Software

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

Ultimate Microsoft Office; Excel, Word, PowerPoint & Access

Learn basic to advanced Microsoft Office skills in this 8-course bundle for Office 365 or Office 2019

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 16390, Price: $169.99

Students: 16390, Price:  Paid

**This course includes practice exercises and LIFETIME access**

Learn Excel, PowerPoint, Access, Outlook, Teams, and Word 2019 with this tremendous value 8-course bundle from Simon Sez IT.

The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.

But you know all that because you’re on this page.

Instead, you’re probably wondering whether we’re the right team to teach you Office.

Simon Sez IT has been teaching MS Office for over ten years, and we’ve got pretty good at it. Just take a look at our Udemy ratings if you don’t believe us.

For this Ultimate Microsoft Office 2019 course, we’ve bundled together 8 of our best-selling titles into one huge value offering.

You don’t just get access to beginner courses either. You get advanced training in Microsoft Excel and Microsoft Access and a comprehensive grounding in Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams, and Microsoft Word.

***UPDATED APRIL 2020 - Outlook 2019 Added***

***UPDATED May 2020 - Microsoft Teams Added***

What's covered in each course?

Microsoft Excel 2019

  • What's new in Excel 2019

  • Creating workbooks

  • Entering text, numbers and working with dates

  • Navigating workbooks

  • Page setup and print options

  • Working with rows, columns, and cells

  • Cut, Copy and Paste

  • Introduction to Functions and Formulas

  • Formatting in Excel, including formatting cells and numbers

  • Creating charts and graphs

  • Sorting and Filtering

  • Introduction to PivotTables

  • Logical and lookup formulas - the basics

Advanced Microsoft Excel 2019

  • What's new/different in Excel 2019

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Financial functions including calculating interest and depreciation

  • Statistical functions

  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

  • How to create awesome visualizations using sparklines and data bars

  • Mastery of PivotTables and Pivot Charts

  • Scenario Manager, Goal Seek and Solver

  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Microsoft PowerPoint 2019

  • How to navigate around PowerPoint

  • Presentation dos and don'ts

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Using SmartArt

  • Working with Charts and Graphs

  • How to utilize Master Slides and just how much time this could save you

  • How to add audio and video to a presentation

  • All about transitions between slides

  • Animation, the animation pane and motion paths

  • Setting your slideshow options

  • Presentation preparation and delivery

  • The backstage area of PowerPoint including printing a presentation

Microsoft Word 2019

  • How to get started with Word 2019

  • Word 2019 basics including navigation, editing and saving

  • Character formatting in Word including Format Painter and AutoCorrect

  • How to properly work with bullets and numbering in Microsoft Word

  • All about formatting paragraphs and managing lists

  • Working with Tables in Word including formatting, converting data and formulas

  • Page appearance including page-breaks, watermarks and styles

  • All about Sectioning a document

  • Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)

  • How to work with envelopes and labels

  • All about mail-merge and operating Word at scale

  • How to create an Index or Contents page

  • Reviewing and Printing in Word and Page Setup

  • Protecting a Word document and basic macros in Word

Microsoft Access 2019

  • Where to start in Microsoft Access and whether to use a template or not

  • How to modify Access to suit your needs

  • All about importing data and the datasheet view

  • How tables work in Access and how to create relationships between them

  • Creating forms and sub-forms that feed data into your tables

  • How to run queries in Access

  • Setting up validations and calculations using expressions in Access

  • Printing from Access

  • To start to use macros and Modal Dialog

  • The basics of the Access web app

  • Exporting and reporting in Access

Advanced Microsoft Access 2019

  • About Primary Keys and Indexes in Access

  • About customizing and filtering on the Datasheet View

  • How to link to other databases

  • All about using ODBC and SQL Server

  • How to split an Access database into front and back-end

  • All about Macros in Access including AutoExec

  • How to do basic VBA in Access including code and error handling

  • More advanced techniques around creating forms in Access

  • Advanced queries including “multiple where” criteria

Microsoft Outlook 2019

  • How to get set up in Outlook

  • Some useful Outlook keyboard shortcuts

  • All about sending and receiving emails

  • How to customize your mailbox and view

  • How to search in Outlook

  • How to organize and manage your mail including ignoring, flagging and conditional formatting

  • How to effectively deal with Junk Mail

  • Attaching files, photos, and graphics in Outlook

  • About recalling a message

  • How to use signatures and voting buttons

  • How to best use, add to, and manage contacts

  • Working with the Outlook Calendar, including creating meetings and appointments

  • How to share Calendars with colleagues

  • How to use Tasks in Outlook

  • How to create Notes and link Outlook to OneNote

  • How to print the right thing in Outlook

Microsoft Teams

  • How to access, download and set up Teams

  • How to create your first team and manage members and channels

  • All about posting and receiving public and private messages

  • How to do user announcements, tags, and message extensions

  • How to schedule an audio or video call

  • How to use the audio and video calling options including recording calls

  • How to use the meeting notes function

  • How to create a wiki

  • All about using apps, bots, and connectors

  • How to adjust admin and user settings

  • How to use Teams on your mobile device

***Exercise and demo files included***

This bundle includes:

  1. 63+ hours of video tutorials

  2. 480+ individual video lectures

  3. Exercise files to practice what you learned

  4. Certificate of completion

  5. EIGHT full-length Microsoft courses

These courses were all recorded in the 2019 versions of MS Office but are still applicable if you’re working with Office 2013, 2016, or Office 365. Microsoft Teams was recorded using Office 365.

Here’s what our students are saying…

"I'm finding this course very helpful and the instructor is very easy to understand. I am learning so much more than I did from another course I tried to take and lost interest in. This course has really kept my interest."
- Dianne Munizza

"Loving the lessons. Easy to understand and can replay the lesson if I did not catch something the first time.."
- Monica Yvette Disbrow

"It's still early on in the course, but I love it. He's so very clear with each tiny thing he's teaching you. He sounds quite like a gentle and patient friend or mentor walking you through step by step. He also repeats things (not monotonously) which helps you retain what you're learning. When I first registered for this course, I thought 'oh my goodness, what have I done'... when you look at the 'your progress' dropdown at the upper right corner of your dashboard and see that you're on #21 of 518(!), it can seem a bit intimidating. But, no -- I think with this particular instructor's gift of friendly teaching, we'll all do fantastically well!"
- Celine Barton

Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Microsoft Access: Complete MS Access Mastery for Beginners

Beginning Microsoft Access mastery. Design Access databases from scratch. For Access 2010, Access 2013, and Access 2016.

Created by Steve McDonald - Dedicated Instructor Will Help You Excel | 300K+ Students

"]

Students: 16317, Price: $109.99

Students: 16317, Price:  Paid

Welcome to the Access 2016 course. 

Thank you so much for joining me. 

  • 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?

Will this course 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.

The Beginning Guide to Microsoft Access 2013

Another Computer Mama Guide

Created by Elizabeth Nofs - The Computer Mama

"]

Students: 14913, Price: Free

Students: 14913, Price:  Free

Microsoft Access 2013 Beginning

Another Computer Mama Guide: www.thecomputermama.com 

If you wish to prepare for Certification Exam 77-424:  Microsoft Office Access 2013 this course will help you build the skills and knowledge you need.

  • Step-by-step video demonstrations
  • Companion eBook with detailed instructions
  • Sample databases
  • Practice, Quizzes and Skill Test

 All materials for this program are available online.

The following resources are available to download throughout the lessons:

  • Beginning Guide to Microsoft® Access 2013 
  • Microsoft Access 2013 Beginning Sample files

In Microsoft Access, you’ll cover basic through advanced topics, including:

  • Learn how to navigate the online course and submit your assignments
  • Understand the purpose of Tables and how they are used in a database
  • Edit the Form Properties to help Users navigate the Form Fields and enter data
  • Learn how to design Queries and use Queries to lookup records in the Tables
  • Use Query Criteria and Parameter Queries to select specific records in the Tables
  • Learn how to design and modify Reports in Layout and Design Views
  • Learn how to manage Database files: Save and Save As

The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. 

Students who wish to prepare for Microsoft Certification Exam 77-424:  Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

 This course teaches the objectives for the following certification tests:

Expert Certification:

Access® 2013: Exam 77-424

The Ultimate Microsoft Access 2013 Training Bundle 19 Hours

The Most Convenient Way to Boost Your Confidence And Learn MS Access 2013 Inside And Out—Quickly, No Travel or Classes.

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 8695, Price: $99.99

Students: 8695, Price:  Paid

Get An Advanced Understanding of the Many Access 2013 Features That Will Enable You to Gather and Interpret Data Faster.

  • Sorting Information and Running Queries
  • Creating Tables and Relationships
  • Designing Forms (+ Advanced Form Options)
  • Generating Reports
  • Splitting the Frontend and Backend
  • Macros
  • Visual Basic for Applications (VBA)

Learn to Capture and Synthesize Information, Becoming a Data Management Guru.

Being a data rock star is more important than ever. To stand out in the workplace, it's essential to be able to find information fast and to identify game-changing insights.

The Microsoft Access 2013 database can help you store and track a variety of information, such as inventory, contacts, or business processes. Logistically, it combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools, and is a member of the Microsoft Office suite of applications, included in the Professional and higher editions, or sold separately.

It is a tool that spans across many fields and is helpful to anyone needing to tightly organize varied data: office managers, project managers, executive assistants, scientists, and busy families to list a few.

Contents and Overview

Through 96 lectures, 19 hours of quality content, and 2 quizzes, this 19-hour class starts with the basics, teaching students to add and delete records to their database. Students then learn to create desktop databases and apps for multiple users before diving into importing data from other sources.

Budding Access 2013 users will be taught how to build forms to capture information online, and implement pre-designed templates that track projects, employees, issues, or task details. Students are then lead through protecting their databases with permissions, and learn - in detail - important safeguards and restrictions. The focus then turns to running reports that provide valuable business intelligence.

Practice files are built right into the curriculum, giving the student working knowledge of the program and building confidence for real-life application.

This course is appropriate for both those brand new to Microsoft Access or database technology, and for those who have been using Access for their entire career wanting to improve their data management skills.

Students completing the course will learn all the functions needed to become a data rockstar, and will have the tools to potentially boost their team's efficiency and output immediately.

** Updated June 2017. Course transcripts now available.

Introduction to Microsoft Access Tables

This course teaches the basics of working with databases by teaching how to use Microsoft Access tables.

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 8507, Price: $19.99

Students: 8507, Price:  Paid

During this introductory course on using Microsoft Access tables, we'll teach you the basics for working with them – in both Microsoft Access 2010 and Access 2013.

We’ll start with some basic concepts to help you understand how a table organizes information into rows and columns. Then we’ll provide an easy to follow example using some fairly straightforward data. We’ll then move into some of the more advanced aspects of database tables including creating relationships between tables, one of the fundamentals concepts of database design and management.

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Microsoft Access SQL: SQL for Non-Programmers

Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Best-Selling Course.

Created by IsáBel . - Microsoft Certified IT Professional. Trainer of 21 Years

"]

Students: 6234, Price: $119.99

Students: 6234, Price:  Paid

SQL Is One Of The Most Sought-After Skills By Employers.

If there was an easy, step-by-step method for learning a little bit of SQL EVERY SINGLE DAY without the confusion, tech

overwhelm , or "What the heck do I do next?" syndrome, would you finally feel confident enough to make learning SQL your priority?

You Can Quickly Learning How To Query Your Microsoft Access Databases with SQL

If you are already familiar with Microsoft Access databases, and would like to:

  •  Have more employable skills

  •   Learn an in-demand programming language

  •   Get the answers that you want, when you want them from your database

  •   Break free of the Query Design window, or Query Wizards

Then this course will enable you to discover how you can use SQL to query your Access databases. There is enormous value in knowing the basics and being efficient in SQL.

You can start using SQL today.
Here's your first example,

SELECT [SQL Course]
FROM Udemy
WHERE Instructor = 'IsáBel.'

               

The Tools You Need to Tell the Query Design Window "Good-bye",

Microsoft Access VBA, Design and Advanced Methods Workshop 1

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created by Bruce Myron - Productivity Specialist

"]

Students: 5118, Price: $69.99

Students: 5118, Price:  Paid

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific design challenge from a student and go over the details of how I would create the database.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

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 me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

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...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Microsoft Access 365: Link Data to Excel with Macros and VBA

Create perfectly formatted, ready to distribute Excel files in seconds from inside Microsoft Access!

Created by Bruce Myron - Productivity Specialist

"]

Students: 4823, Price: $74.99

Students: 4823, Price:  Paid

Learn How to Link Microsoft Access Tables to Excel Spreadsheets, then Update the Data Instantly!

This course shows you how to link Access to Excel so you can run a query for any time period and have it instantly update when you refresh ALL of your linked data in multiple Excel sheets.  Using the techniques from this course will save you hours of time every time you create your reports!

From a Student -

"I was looking for a course that jumps right into examples and walks through the methodology in Access and Excel. This class does that perfectly. Plus, you get to see Bruce's thought process, which I believe will help in future Access/Excel projects." - Jonathan Sanborn

From another Student -

"This course is very detailed and deals with real world solutions to everyday tasks. I have used the techniques for several of my daily and weekly reports and it's amazing with a click of a button I can process the reports instantly where it took hours a week before.

The course is a fantastic step by step tutorial. Bruce breaks it down and simplifies the process and procedures so you can quickly master them and implement them in your project.!" - Stephen Davanzo

The method starts out using queries and macros and then adds an introduction to VBA PROGRAMMING. If you have never used Microsoft Access VBA, this is an excellent introduction and a very practical example of how VBA can you life easier!  Anyone with just a very basic knowledge of Access and Excel can easily accomplish all the tasks in this course!

* Videos show you every step from the initial Access tables to finished Excel report!

* There is no fluff and you can go through the entire course in about 2.5 hours

From another Student -

"This is an excellent course. Easy to follow with great explanations of what to do and why. I have learned so much and will refer back to this course. I can see this course and the information it teaches being very, very helpful in real world situations where you need to access database data in excel and use excel functionality to manipulate the data further. Awesome!" - Bronwyn Wilson

Think of how much time this will save you!  Any time you need to prepare Excel files for distribution, it will only take seconds!  Using these techniques can save many hours every month!

And remember - you don't have to know anything more than the bare basics of Access and Excel to learn how to instantly send data from Access to Excel.  Click the Take This Course button and start learning right now!

Another Student -

"I have taken several of Bruce's courses and they all are the same, Simply Excellent! I would take this course 2nd in his series after the Intro to Access for Excel Users. The material is for real world users that need to know how Access projects work in the real world situations. This instructor is very easy to understand and follow with a vast amount of practical experience to draw from. Enjoy!" - Rodney

Required Software

You should have a subscription to Microsoft 365 and have the full Office suite installed.

Ultimate Microsoft Access 2016 Course – Beginner to Expert

The Most Convenient Way to Boost Your Confidence And Learn MS Access 2016 Inside and Out—Quickly, No Travel or Classes.

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 4502, Price: $124.99

Students: 4502, Price:  Paid

Get An Advanced Understanding of the Many Access 2016 Features That Will Enable You to Gather and Interpret Data Faster.

  • Sorting Information and Running Queries
  • Creating Tables and Relationships
  • Designing Forms (and Advanced Form Options)
  • Generating Reports
  • Splitting the Frontend and Backend of a database
  • Macros
  • Visual Basic for Applications (VBA)

Contents and Overview

Through 118 lectures, 18 hours of quality content, and quizzes, this
18-hour class starts with the basics, teaching students to add and
delete records to their database. Students then learn to create desktop
databases and apps for multiple users before diving into importing data
from other sources.

Budding Access 2016 users will be taught how to build forms to
capture information online, and implement pre-designed templates that
track projects, employees, issues, or task details. Students are then
lead through protecting their databases with permissions, and learn - in
detail - important safeguards and restrictions. The focus then turns to
running reports that provide valuable business intelligence.

Exercise files are built right into the curriculum, giving the
student working knowledge of the program and building confidence for
real-life application.

This course is appropriate for both those brand new to Microsoft
Access or database technology, and for those who have been using Access
for their entire career wanting to improve their data management skills.

Students completing the course will learn all the functions
needed to become a data rockstar, and will have the tools to
potentially boost their team's efficiency and output immediately.

Plus, when you sign up for this course, you’ll also get these extras:

  1. Exercise files – to help you become proficient with the material.
  2. Instructor demo files – use the same database files used by your instructor.
  3. Online quizzes  - to test what you've learned.
  4. A certificate of completion - to tell everyone you've aced the course.

Contents and Overview for the 10-Hour Access 2016 Beginner Course

Microsoft Access 2016 for Beginners: Master the Essentials
starts at the very beginning, showing you where to get your copy of MS
Access and how to install it on your computer. Before going further,
you'll get a quick tour of all of the new features and improvements in
2016.

You will learn how to get started easily with database templates that
make the entire process faster. Then you'll see how to create, save and
open databases.

After a tour of the Access Workspace and Backstage, you'll get a
complete explanation of the toolbars and ribbons. Next, you'll gain a
strong grasp of keyboard shortcuts that will greatly increase your speed
and efficiency.

You'll progress to creating your own working database with
step-by-step video instruction that takes you through the entire
process, helping you master details while understanding the big picture.

Later the course goes into importing data from Excel and creating and
working with forms and sub-forms. As you become more advanced, you'll
learn how to use queries and validations, create reports and print your
projects.

This course contains comprehensive instructions through 70
professionally produced videos within ten chapters. You'll supercharge
your database projects and learn valuable new skills for complex data
projects at work. Get started with this course now and easily become an
expert at MS Access 2016.

Contents and Overview for the 8-Hour Access 2016 Advanced Course

Your Microsoft certified professional trainer will show you how to
use macros, advanced forms and queries, and other tools to create a
professional, working database. Follow along as you learn to create and
maintain macros, then see how to effectively link to other data sources.

Get helpful techniques that allow you to link, report, and package
your data quickly, and discover how to split a database by splitting the
frontend and backend.

With this informative course, you’ll learn the skills you need to
make an impact with sleek, high-performing databases that help you do
your job efficiently and competently.

If you’re ready to master Microsoft Access 2016 and sign up for the
course, go ahead and hit that Enroll button, or try some of the free
videos by using the Free Preview feature. We look forward to seeing you
in the course!

Master Microsoft Access – Access from Beginner to Advanced

Develop dynamic Access databases fast in this easy to learn Microsoft Access Course (2010, 2013, 2016, 2019 & 365)

Created by Kirt Kershaw - Microsoft Certified Trainer - Training Microsoft Since 2000!

"]

Students: 4478, Price: $109.99

Students: 4478, Price:  Paid

Microsoft Access All-In-One Training   

This Microsoft Access course includes all three Levels from Beginner to Advanced   

  • Microsoft Access Level 1 – Beginner   

  • Microsoft Access Level 2 – Intermediate   

  • Microsoft Access Level 3 – Advanced   

Material recorded with Access 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Access, the interface will be bit different.

As your instructor I will use my 18+ years of Access training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Access.    

At completion of this course you will master Access skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass the Access 2016 (77-730) Exam and become certified, like me.  Below are just a few of the topics that you will master:   

  • Create powerful, effective Access Databases   

  • Enter, edit, update, search, sort and filter Table records   

  • Set defaults and validate data for more accurate data entry   

  • How to quickly edit, filter and search records in a Form   

  • Add option controls, command buttons and drop-down lists for faster data entry and accuracy in Forms   

  • Add custom fields to perform calculations: Sum, Count, Average and more   

  • Add, sort and filter groups as well as keeping them from splitting across pages in your Reports   

  • Use criteria in a Query to dramatically refine your search   

  • View unique records and use Actions Queries to Update, Add and Delete records fast   

  • Automate data entry and accuracy dramatically by creating Macros and much more…   

Microsoft Access: Beyond the Basics of Access Bundle

Don't Miss This Info Packed Three-Course Bundle: (1) Customizing Your Database (2) Automate w/Macros (3) SQL Scripting

Created by IsáBel . - Microsoft Certified IT Professional. Trainer of 21 Years

"]

Students: 4271, Price: $119.99

Students: 4271, Price:  Paid

Microsoft Access Three Course Bundle:

→ Access: Customizing Tables, Forms, Reports & Action Queries

→ Microsoft Access Macros: Automate Your Access Database

→ Microsoft Access SQL: SQL for Non-Programmers

So, what's in this course for you?


:: Access Customizing Skills & Strategies ::

↳ Learning Microsoft Access tips will absolutely make your workday easier.

From importing and exporting data with Microsoft Excel, to restricting data that is entered into your tables.

Create cascading combo boxes that display information based off of data in another combo box.

You'll also find pro tips on using reports, and queries, documenting your database, and simplifying navigation.

:: Creating Macros for Saving Time ::

↳ Learn to create Macros for more control over the database, get work done faster, and feel efficient.

You don't need to know any VBA code, you just need a willingness to want to save time with macros, to upgrade your skills, and to invest a few hours of time in the process.

:: Learning How SQL Can Interact with Your Database ::

↳ This week you can start learning SQL, step by step, and improve your skills.

Learn to use SQL in your Access databases from the beginning. Select data, as well as filter, and sort.  Learn to create table, and about joins. No prior SQL experience required.

This bundled course can be completed in hours, but the information can last a lifetime.

So if you are beyond the basic beginner stage in Access, and want a convenient way to learn, I invite you to enroll.

This is not an advanced Access course, though advanced users are welcome, and might benefit from lectures within the course.

Take a look at the course curriculum to help decide if this informative, easy-to-follow course is for you.

You only have MICROSOFT ACCESS DATABASE SKILLS to gain.

So Click The Take
This Course Button On The Right
and become a better Microsoft Access User.

Microsoft Access: Networking Made Simple

How to Setup and Easily Maintain Access Databases on a Windows Network

Created by Bruce Myron - Productivity Specialist

"]

Students: 4210, Price: $74.99

Students: 4210, Price:  Paid

If you have used Access but wonder what the best way is to setup Access on a network, this course is for you! Every step starting from a single database to a complete front end/back end network environment is shown in detail. I have spent many years working with businesses with multi-user networks and these are the methods I have developed to help me get the most done in a minimum of time! Why suffer through network headaches? I will show you how to avoid them completely!

From a Student Review -

With this course on networking, Bruce has hit it out of the park! This course is a great addition to the Access series taught by Bruce. He easily explains how to work with Access on a small network system with real world solutions to real world issues. This is a must take course to round out your Access training!" - Rodney

Although knowledge of VBA is not required, this course shows you how to create several programs in VBA. You don't need to understand VBA to just follow along and create the subroutines and functions for the course. Plus databases with finished VBA programs are provided for download.

Most of the employees in my client businesses have small networks staffed with people who know nothing about Access and the ribbon and navigator are always hidden, yet these people usually get more work done faster than experienced Access users! Right now there is a huge and growing need for people who can setup shared database networks like these and there just aren't enough people who know how to do it right.

Another Student Review -

"An excellent course. Bruce gives you the benefit of his extensive experience and is always prompt to reply to any query that you may have. I would rate this course at least 10 out of 5!" - Ray McConaghy

None of this is theory and you won't find these techniques in any book. The content of this course is a breakdown of the methods I successfully use to administer dozens of networks for my client businesses. I learned a long time ago that you have to automate every routine job that you can, but also you must eliminate downtime for your client and yourself by making silly mistakes. These methods of creating and maintaining small, shared folder networks remove many of the potential pitfalls and the wasted time taken up by periodically updating the network database.

Take a look at the demo video and watch as I update a network with a modified database in under 30 seconds!

A Student Review -

"Absolutely Amazing, like all courses from Bruce. Thank you for all the effort to make this stuff. It's invaluable for me!" - Grzegorz Kania

Follow along as I take you step by step through the creation of a network database and tools that let you update it easily. This course will show you :

  1. Why a front end/back end arrangement is best for network usage.
  2. How to split a database into front and back ends.
  3. How to link the front end to the back end..
  4. How to create a test so that the front end will know when an update has been added.
  5. How to force the network users to do the database update themselves with a couple mouse clicks, so you don't have to update each computer.
  6. How to create a work environment on your local machine, but then update the network easily.
  7. How to remove the menus and ribbons and secure your database.
  8. How to create a "back door" that lets you work on the database from any network computer and easily do updates.
  9. How to implement your changes on the network in seconds, with no worries that you forgot to do anything.

If you take the time to learn these techniques you will save MANY HOURS of time and not have problems caused by improper updating of your network!

Another Student Review -

"Clear, easy to understand, easy to follow along with, Just exactly what I need for deploying my database next week." - Tonie Salzano

If you want to become the Network Database Guru, click the Take This Course button to get started on this journey to increased productivity and higher value for you in the marketplace. Think of it! In just a few HOURS you know more about implementing and updating Access on a network than almost everyone else!

Learn Microsoft Access 2013 the Easy Way – 10 Hours

Upgrading your Microsoft Access skills is a smart move for any professional.

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 4106, Price: $94.99

Students: 4106, Price:  Paid

Being a data rock star is more important than ever. That’s because to stand out in the workplace, you’ve got to be able to find information fast and to identify game-changing insights.

During our Learn Microsoft Access 2013 course, you’ll explore how to do this and more. In this 10-hour class, you’ll become a data management guru as you learn to capture and synthesize information with custom web apps and desktop databases. Whether you’ve been using Access your entire career or database technology is new to you, this Microsoft Access 2013 Tutorial will give you an advanced understanding of the many Access 2013 features that will enable you to gather and interpret data faster than everyone else.

Starting with the basics, our certified instructor will teach you to add and delete records to your database. Then, learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training.

Plus, when you sign up for our class, you’ll also get these 4 BONUSES in addition to the 40+ online course videos:

  1. An online quiz (40 questions) - to test what you've learned.
  2. Exercise files – to help you become proficient with the material.
  3. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  4. A certificate of completion to tell everyone you've aced the course.
  5. Printable course transcriptions to follow along and take notes

What people are saying:

“Really good explanations, pleasant to follow, great course for beginners!” - Arnaud D'Arcizas

“I have a little bit of experience with Access, having already built a six table MS Access DB for work before starting this course. However, there is nothing like seeing it put into practice by a master of the tool, which this instructor clearly seems to be. I'm halfway through the course but picking up a lot of additional info and beginning to refine my DB based on just the info the instructor has covered so far. I can't wait to start the advanced course. Great job by the instructor!”
Jim Pursley

“Starts very slow, but quickens eventually. After finishing the course you'll have a broad view of how to operate Microsoft Access. The course is good! Even introduces notions of SQL, so the course will start with you "knowing nothing” to "intermediate level". Everything is well explained (sometimes too much) and is well structured.” -Valeria Echeverria

** Updated June 2017. Course transcripts now available.

Microsoft Access 2013 Advanced Course

Get ready to take your Microsoft Access 2013 skills to the next level with this advanced Access 2013 course.

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 3707, Price: $94.99

Students: 3707, Price:  Paid

“This was an excellent course. Toby uncovered many of the hidden aspects of Access that I had been trying to learn on my own. He covered a lot of practical information in this course in an interesting manner. I really liked his easy informal manner.” -Earl Hatt

 

“This was a nice find. The price is reasonable and content is excellent - a real value. The presentation is clear and easy to follow. Thanks.” -Patricia Avery

“This was an excellent course. Toby uncovered many of the hidden aspects of Access that I had been trying to learn on my own. He covered a lot of practical information in this course in an interesting manner. I really liked his easy informal manner.” -Earl Hatt

 

“This was a nice find. The price is reasonable and content is excellent - a real value. The presentation is clear and easy to follow. Thanks.” -Patricia Avery

In this day and age, data management is absolutely crucial, and there’s not much room for error. If you’ve already taken our basic Microsoft Access 2013 course, or know your way around the program already, you’re ready for our Microsoft Access 2013 Advanced course. Get ready to become a data management expert as this 9.25 hour class takes your skills to the next level.

In the Microsoft Access 2013 Advanced video training course, you’ll take your knowledge up a notch as you get acquainted with Microsoft Access 2013’s most sophisticated features. If you think you know all you need to know about Access 2013, think again, as this course goes way beyond the basics, leaving you with knowledge of all of the best Access tips and tricks out there.

Your professional trainer will show you how to use macros, tables, forms, queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend.

With this informative course, you’ll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job better.

Plus, when you sign up for our class, you’ll also get these 4 BONUSES:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. Exercise files – to help you become proficient with the material.
  3. An online quiz (45 questions) - to test what you've learned.
  4. A certificate of completion to tell everyone you've aced the course.

Where else can you find so many extra tools to help you master Access 2013?

What people are saying:

“This was an excellent course. Toby uncovered many of the hidden aspects of Access that I had been trying to learn on my own. He covered a lot of practical information in this course in an interesting manner. I really liked his easy informal manner.” -Earl Hatt

 “This was a nice find. The price is reasonable and content is excellent - a real value. The presentation is clear and easy to follow. Thanks.” -Patricia Avery

“This course covers many of the advanced functionality of Access.” -Patrick Neis

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

Microsoft Access VBA, Design and Advanced Methods Workshop 2

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created by Bruce Myron - Productivity Specialist

"]

Students: 3658, Price: $69.99

Students: 3658, Price:  Paid

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific design challenge from a student and then go over the details of how I would handle it.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

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 me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

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...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Microsoft Access VBA: Automating Import of Excel Files

Learn how to completely automate the periodic import of Excel files!

Created by Bruce Myron - Productivity Specialist

"]

Students: 3344, Price: $99.99

Students: 3344, Price:  Paid

Many students have contacted me with requests on how to handle the periodic import of Excel files.  Typically an Excel file is received weekly or monthly and needs to be imported and used to update and/or add to a main data table.  This course will show you how to reduce this process to nothing more than selecting the import file.  The rest of the steps are handled automatically in seconds! 

Even if you never need to import Excel files, there are several VBA techniques in this course that have not been covered in any of my other courses!  Topics like using the Immediate Window, using the Office File Dialog box to select files and how to use "Late Binding" to make sure your VBA code works with any version of Access! 

The program we will build together doesn't only import the Excel file, it also analyzes the data for errors and creates a report showing the details of what needs to be corrected!  If you are willing to take the time to go through this course you could completely eliminate the headache of having to periodically import Excel files!

This course is "hands on" and we completely build the database step by step in the course lectures.  The course is built so that you can watch the steps then pause the lecture and do them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to do Microsoft Access projects like this one.  This is your opportunity to break away from the pack of people who struggle to create effective systems and demonstrate that you have the skill to save huge amounts of time!  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

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 me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

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...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Microsoft Access VBA, Design and Advanced Methods Workshop 4

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created by Bruce Myron - Productivity Specialist

"]

Students: 3042, Price: $69.99

Students: 3042, Price:  Paid

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific database design challenge from a student and then go over the details of how I would handle it.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

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 me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

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...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 


Microsoft Access Networking 2: Maximum Security

Control what users can and can't do in your networked database.

Created by Bruce Myron - Productivity Specialist

"]

Students: 2772, Price: $74.99

Students: 2772, Price:  Paid

If you are concerned that network users can, intentionally or by accident, alter or modify settings or code in your networked database, you have come to the right place!  Every single step is covered for maximizing the security of the front end/back end databases from the Network 1 course!   Having installed Access on dozens of networks, I have had to develop methods to prevent users from being anywhere in the system that I don't want them to be.  So why suffer through another phone call for errors that could be completely avoided? I will show you how to eliminate the possibility of them ever happening!

This course shows you how to many techniques for using VBA to control how users log in to and use the database. If you have no familiarity with VBA, you may get frustrated, but every step is illustrated and you are provided with beginning and ending versions of the databases.  For some this could be a quick intro into the incredible power of VBA that will convince them that they really should take the Intro to VBA course.  For others who have already done all or part of that course, 90% these techniques are totally new and will extend the students knowledge of VBA quite a bit.

Most of the employees in my client businesses have small networks staffed with people who know nothing about Access and they don't want to have to figure out how the ribbon and navigator work, that is why they are always hidden.  The systems I build using these techniques let people with zero knowledge of Access get productive on the network quickly.  Believe me, there is a huge and growing need for people who can setup easy to use shared database networks like these and there just aren't enough people who know how to do it right! 

None of this is theory and you won't find these techniques in any book. The content of this course is a breakdown of the methods I successfully use to administer dozens of networks for my client businesses. I learned a long time ago that you have to automate every routine job that you can, but also you must eliminate downtime for your client and yourself by making silly mistakes. These methods of keeping the network users from even seeing anything they do not need to know about just increase productivity and reduce downtime.  

Just take a look at the demo video and see what logging into the finished database looks like.  It doesn't look much like Access!  Many of the employees in my client businesses do not even know they are using Access (and they really don't care).  All they know is it is way easier to get their job done than it used to be! 

Follow along as I take you step by step through the modification of the front and back end databases from the Networking Made Simple course and show you tools that you will be using for years to come! This course will show you :

  1. How to "Encrypt" an Access database.
  2. How to link to encrypted backend databases from the frontend.
  3. The basics of creating a User Login table.
  4. How to create a simple, yet powerful login form.
  5. How to validate passwords and determine the employee security level.
  6. How to develop a secure database without locking yourself out.
  7. How to create a "dialog" login form that cannot be bypassed.
  8. How to hide or unhide the menus and Navigation Pane.
  9. How to set database security properties.
  10. How to create a custom BLANK ribbon!
  11. How to build in a backdoor for Administrators.
  12. How to Password Protect all your VBA Code.
  13. How to Deploy the Updated Database

If you take the time to learn these techniques you will save MANY HOURS of time and avoid wasting time on problems caused by users being where they should not be in the database!

If you want to become the Network Database Guru, click the Take This Course button to get started on this journey to increased productivity and higher value for you in the marketplace. Think of it! In just a few HOURS you know more about securing databases and controlling users on an Access network than almost everyone else!

Microsoft Access VBA, Design and Advanced Methods Workshop 5

Learn new secrets to creating awesome Microsoft Access databases and VBA coding not covered in any of my other courses!

Created by Bruce Myron - Productivity Specialist

"]

Students: 2584, Price: $69.99

Students: 2584, Price:  Paid

After creating more than a dozen courses on Microsoft Access databases and programming in VBA, many students have contacted me with discussions on specific problems and scenarios.  From these discussions, I have created videos reviewing the details of the most useful techniques that everyone will eventually need.  I have made sure that every detail of these techniques is recorded in the videos!  BUT you should be somewhat familiar with VBA since there are lots of coding examples in the course.

There are MANY tips and tricks in this course that you will not find an ANY of my other courses!

I also include a specific database design challenge from a student and then go over the details of how I would handle it.

If you are willing to take the time to go through this course you could easily be much more productive with Microsoft Access in just a few hours!

This course is "hands on" and has exercise files for every section.  This is not a course you just watch - you learn new techniques by watching each lecture step, then doing them yourself!

There is a HUGE need in the marketplace for people who REALLY know how to create Microsoft Access databases and use VBA. This is your opportunity to break away from the pack of people who struggle to create effective systems.  Stop being like everyone else and and learn how to use Access MUCH more effectively than just about anyone else!

__________________________________________________________________________

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 me directly and I will do my best to get back to you as soon as possible!

__________________________________________________________________________

What I am NOT able to do for you in this Course..

I can't guarantee your success – learning the concepts in this course and then applying them WILL take work on your part. But You Can Do It!  AND it will be well worth it!

________________________________________________________________________

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...you could become the goto person for Microsoft Access VBA!

See you in the course!

Sincerely,

Bruce Myron 

Microsoft Access 365: Access VBA & Automating Outlook Email

Learn more about Microsoft Access VBA and using VBA to send Outlook emails from within Microsoft Access!

Created by Bruce Myron - Productivity Specialist

"]

Students: 2425, Price: $124.99

Students: 2425, Price:  Paid

This review says it all:

"This is the best Udemy class I've taken so far. The only thing better than learning by doing is to learn to do something USEFUL. This class teaches you a useful skill (email Excel reports) but it also shows you how easy and powerful VBA can be. It only took about 3 hours to gain useful knowledge of Excel, Access and VBA. Good audio/video quality plus example files and detailed PDF instructions. We need more like this!!" - Russ Cannizzo

This is an INTERMEDIATE Microsoft Access VBA Course and you should take the "VBA for Non-Programmers" course, or the equivalent, before taking this one.  This course builds on the Macro and VBA code created in the course "Microsoft Access 365: Link Data to Excel with Macros and VBA" so it is recommended that you also take that course before this one.  In the course I assume you already know how to create Access VBA functions and subroutines and I move more quickly when creating VBA Code.  

This shows you several ways to use Access VBA to automate the distribution of Excel files by sending them as email attachments.  We learn how to send Access objects as attachments with a one line command, then we replace the multiple query update macro created in the previous course with VBA Code.  We then learn how to control Outlook and send emails to multiple recipients.  We conclude by examining the VBA techniques used in a simple, yet powerful, Emailing database.

From a Student -

"This course is amazing, I thought that was more difficult to create a program to send emails from Access, but not really! Bruce's explanation makes the things easier to understand, he is an extremely good teacher, an expert in this topic. I have taken several of his courses and when I finished I have the feeling of wanting to learn more, I've definitely will continue my learning of Access with his courses, I recommend his courses a lot, very useful and interesting." - Roberto Carlos Huerta Gomez

In short, to the point videos, you will learn MANY new Access VBA techniques that you will use for years to come!  This course is a great followup to the first VBA course in that it shows you the best way to use VBA to automate many common tasks, not just emailing.

* Videos show you every step of each process!

* There is no fluff and you can go through the entire course in a few hours!

From another Student -

"I'm little rusty on VBA skills yet the instructor has explained the needed commands in a way I would listen to him for hours. And files are downloadable too so I know where to return when my business clients need this great automation." - Matt S Rinc

Anyone with a solid understanding of the basics of Access VBA can easily accomplish all the tasks in the course, since every click and keystroke is shown and a finished copy of the database is provided.  This is a great way to expand your VBA skills and discover more of the incredible power available with Access programming.

Think of how much time this will save you!  Emailing from Access will be SIMPLE for you and you can save many hours each month!  You will be able to control data in subforms in ways you did not know possible!

Another Student -

"Excellent teaching style with easy to understand explanations. Bruce is excellent when it comes to responding to queries, and is happy to hear any ideas you may have to improve (and expand) the course. Buy it!!!" - Ray McConaghy

This course could greatly increase your productivity and help you develop skills that are in very high demand in the workplace.

Click the Take This Course button and start learning right now!

NOTE: The course files were created using the latest version of Microsoft 365 Office so versions prior to  2013 may not function properly.  If you have one of these earlier version, I strongly urge you to setup a subscription to Microsoft 365.  It is low cost and you can update multiple computers with the entire Office suite with a single subscription.

Advanced Microsoft Access 2010 Tutorial

Take your Microsoft Access skills to the next level with this Advance Access Tutorial.

Created by Infinite Skills - High Quality Training

"]

Students: 1819, Price: $49.99

Students: 1819, Price:  Paid

A Verifiable Certificate of Completion is presented to all students who undertake this course.

This Advanced Microsoft Access 2010 Tutorial Video picks up where the InfiniteSkills beginner course leaves off and shows how to work with some of the program's more robust database creation and management features. Presented by a professional IT trainer, the video lessons go point by point through advanced query options and form design, as well as a number of shortcuts and productivity options that can simplify and shift the way you work. Given the advanced subject matter, the order of the Access course is logical and easy to follow. The earliest lessons focus on advanced table design with indexing and input masks. The course shows how to create advanced queries using joins, unions, and sub queries, going step by step where things get complex. Lessons on advanced form design and reporting will allow you to better manage and display your data, and the course's full chapter on Macros make it easy to manage and access data in Access 2010. Project files are included to match the examples onscreen.


What You Will Learn

- How to perform advanced data manipulation across multiple databases and sources.
- How to create complex user forms that will improve the quality and quantity of data collected.
- How to perform crucial management and maintenance functions using Access utilities and commands.
- How to enhance and develop secure, compatible databases that can be accessed by users working with Office products and common industry standards such as SQL.


Who Should Take This Course

- Anyone with a basic understanding of Microsoft Access who wants to unlock the program's power user capabilities and security features.
- Anyone who wants to implement Access solutions within SQL-based and mixed environments.
- Access administrators looking to work faster and smart through shortcuts and macros that automate repetitive tasks.


What People Are Saying

"I was told we'd have to move everything over to MySQL to get the security we needed, but these tutorials helped me prove otherwise. The lessons on encryption were perfect."
- Hank Mascis

"I am genuinely impressed with what is capable with Access now. It's improved greatly over the years, and this training and the VBA course has helped me see the light."
- V Spinotto

Microsoft ACCESS Beginners Hands-on Training with Exercises

Quick Learn MS ACCESS for beginners from scratch to design and develop real-world Database applications.

Created by Mazhar Hussain - Computer Science Lecturer and Programmer

"]

Students: 1754, Price: Free

Students: 1754, Price:  Free

Microsoft ACCESS is an information management tool, or relational database, that helps you store data that can easily be accessed, managed, modified, updated, controlled, and analyzed.

ACCESS can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.

ACCESS Components: You will be able to learn Microsoft ACCESS Components: Tables, Forms, Queries, and Reports. Each has its own special function to allow the user to manage information in MS ACCESS.

  • A Table allows the user to store a collection of data about a specific topic like Customers or Orders. Relationships can be established among the tables to access and manage the data easily.

  • A Form allows a user to enter/change/update data to tables.

  • A Query allows the user to view, change, manipulate, and analyze data in different ways like combining data from two different tables (Customers and Orders) to create a user’s own custom view (London Orders for April).

  • A Report is an effective way to output your data in a printed format in the way you want it .

This Course is specifically designed for beginners with

  • Hands-on training

  • Real-world applications

  • Exercises

  • Final project

At the end of this Course, you will be able to create a real-world DATABASE Applications in MS ACCESS from scratch.

Microsoft Access 2016 for Beginners: Master the Essentials

Fast, easy way to learn this important database application inside and out

Created by Simon Sez IT - 490,000+ Students | Wordwide Use 180 Countries |150+ Courses

"]

Students: 1719, Price: $94.99

Students: 1719, Price:  Paid

Everyone will rely on you as a superstar user of Access 2016 with this comprehensive 10-hour course comprising more than 70 video tutorials.

  • No Microsoft Access experience needed as it starts from the very beginning
  • 70 expertly produced videos with a full 10 hours of instruction
  • Work at your own pace in your spare time
  • Makes all aspects of Access easy to master while covering exciting features new in 2016
  • Benefit from learning to use the full program, not just the basics
  • Get up and running quickly and immediately learn things you can use at work
  • Supercharge your personal projects
  • Practice what you learned with helpful exercise files
  • Become the MS Access expert everyone appreciates

Microsoft Access 2016 for Beginners: Master the Essentials is the ultimate video instruction course for those who have no previous experience with this powerful software. Now you can get the full picture of how Microsoft Access works with clear, easy to understand instruction in this impressive 10-hour course spread across 70 professionally produced videos.

Microsoft Access is the leading database application that has become a standard in businesses and organizations around the world. These days, having the ability to work with a database is key to running an efficient and capable operation. Bosses everywhere appreciate any employee who is well trained in MS Access. Now that person can be you!

Increase your value in the workplace by mastering one of the most important but little understood options in MS Office. You'll see how it gives you major advantages with your personal and social projects. Also great for people who are already familiar with MS Access, our courses are designed to allow you to skip ahead to more advanced processes and explore all that's new in version 2016.

 Contents and Overview

Microsoft Access 2016 for Beginners: Master the Essentials starts at the very beginning, showing you where to get your copy of MS Access and how to install it on your computer. Before going further, you'll get a quick tour of all of the new features and improvements in 2016.

You will learn how to get started easily with database templates that make the entire process faster. Then you'll see how to create, save and open databases.

After a tour of the Access Workspace and Backstage, you'll get a complete explanation of the toolbars and ribbons. Next, you'll gain a strong grasp of keyboard shortcuts that will greatly increase your speed and efficiency.

You'll progress to creating your own working database with step-by-step video instruction that takes you through the entire process, helping you master details while understanding the big picture.

Later the course goes into importing data from Excel and creating and working with forms and sub-forms. As you become more advanced, you'll learn how to use queries and validations, create reports and print your projects.

This course contains comprehensive instructions through 70 professionally produced videos within ten chapters. You'll supercharge your database projects and learn valuable new skills for complex data projects at work. Get started with this course now and easily become an expert at MS Access 2016.

What people are saying:

★★★★★ “Provides simple examples of processes and procedures by using a single database developed throughout the course. Complete school solutions are provided to each of the topics as well as the exercises.” –John Kieffer

 ★★★★★ So far, and I am just getting started, the instructor is thorough and precise with his explanations. Being brand new to Access, this is helpful.” –Brandon Scott Beecher

★★★★★ “The instructions are very clear, lessons build logically and give a very solid induction into Access Database with a few more advanced items added into it. Instructor talks clearly and is easy to understand and follow.” -Othmar Roos

★★★★★ “Because the instructor is very, very, very specific and thorough. He is easy to understand and follow. This is necessary for beginners like myself. I simply feel confident after each course.” -Robert Bozgoz

★★★★★ “I would like to take the time to thank you for making such a brilliant course. With this course, I have the skills and the abilities to handle many Access issues while I am with my clients. I came into your course with very little information and thanks to you, I am up to speed. Thanks so much.” -Tony Reid

** Updated July 2017. Course transcripts now available.