All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
$29
$244
  • Practice what you learned with included exercise files
  • Sorting information and running queries
  • Creating tables and relationships
  • Navigating the Access 2016 interface
  • Design forms and generate reports
  • Learn valuable new skills for complex data projects at work
  • Supercharge your database projects
  • Discover how to into import data from Excel
  • Learn Queries, use validations, how to create and print reports
  • How to compact, repair and backup your database
  • How to create a linked table
  • Discover how to use the Query Wizard
  • Learn to use Model Dialog and Macros
  • Discover how to effectively link to other data sources.
  • Learn how to split a database by splitting the frontend and backend.
  • Explore the use of Visual Basic for Applications (VBA).
  • Discover advanced options for the use of forms.
  • Dive into options for packaging your application for distribution.
  • Practice with included Access 2016 exercises files.
  • Follow along with the instructor with included instructor demostration files.
  • Discover advanced options and tips for building and using queries.
  • Follow along as you learn to create and maintain macros.
  • Complete database projects at the advanced level.
  • Get helpful techniques that allow you to link, report, and package your data quickly.

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 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 starts at the very beginning, showing you were 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.

  • A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
  • Microsoft Access 2016
  • Anyone new to Microsoft Access
  • Users new to Microsoft Access 2016 and those upgrading from previous software versions
  • Anyone new to the data management role
  • Anyone who wants to learn data management and Microsoft Access
View More...
  • Section 1 : Chapter 1: Introduction 4 Lectures 00:19:56

    • Lecture 1 :
    • Introduction to Access 2016 Course Preview
    • Lecture 2 :
    • Acquiring Access 2016
    • Lecture 3 :
    • Structure of the Course
    • Lecture 4 :
    • What's New in Access 2016
  • Section 2 : Chapter 2: Using Touch 1 Lectures 00:07:06

    • Lecture 1 :
    • Using Access in a Touch Device
  • Section 3 : Chapter 3: Getting Started 3 Lectures 00:37:18

    • Lecture 1 :
    • Using Database Templates
    • Lecture 2 :
    • Creating, Saving, and Opening Databases
    • Lecture 3 :
    • The Access Workspace and Backstage
  • Section 4 : Chapter 4: Help 1 Lectures 00:09:18

    • Lecture 1 :
    • Online Help and Tell Me
  • Section 5 : Chapter 5: The Ribbon and Toolbars 4 Lectures 00:23:24

    • Lecture 1 :
    • The Quick Access Toolbar
    • Lecture 2 :
    • Contextual Menus
    • Lecture 3 :
    • The Status Bar
    • Lecture 4 :
    • The Ribbon
  • Section 6 : Chapter 6: Keyboard Shortcuts and Key Tips 2 Lectures 00:06:46

    • Lecture 1 :
    • Keyboard Shortcuts
    • Lecture 2 :
    • Key Tips
  • Section 7 : Chapter 7: Access Options 1 Lectures 00:12:04

    • Lecture 1 :
    • General, Current Databases, and Language Options
  • Section 8 : Chapter 8: Tables 5 Lectures 00:56:03

    • Lecture 1 :
    • Creating a Table and Fields
    • Lecture 2 :
    • Indexed Field
    • Lecture 3 :
    • Lookup Wizard
    • Lecture 4 :
    • Numeric Fields
    • Lecture 5 :
    • Exercise 01
  • Section 9 : Chapter 9: Importing Data 2 Lectures 00:20:20

    • Lecture 1 :
    • Importing Data from Excel
    • Lecture 2 :
    • Excercise 02
  • Section 10 : Chapter 10: Backup, Restore, and Repair 2 Lectures 00:14:06

    • Lecture 1 :
    • Backing up your Database
    • Lecture 2 :
    • Compact and Repair
  • Section 11 : Chapter 11: Datasheet View 3 Lectures 00:34:57

    • Lecture 1 :
    • Design in the Datasheet View
    • Lecture 2 :
    • Sorting and Filtering in Datasheet View
    • Lecture 3 :
    • Entering and Modifying Data in Datasheet View
  • Section 12 : Chapter 12: Relationships 3 Lectures 00:35:38

    • Lecture 1 :
    • Creating a Link Table
    • Lecture 2 :
    • Setting up Relationships
    • Lecture 3 :
    • Exercise 03
  • Section 13 : Chapter 13: Forms 7 Lectures 01:08:19

    • Lecture 1 :
    • Creating a Form
    • Lecture 2 :
    • Modifying a Form
    • Lecture 3 :
    • Exercise 04
    • Lecture 4 :
    • Forms in Layout View
    • Lecture 5 :
    • Forms in Design View
    • Lecture 6 :
    • Form Design
    • Lecture 7 :
    • Exercise 05
  • Section 14 : Chapter 14: Subforms 4 Lectures 00:41:53

    • Lecture 1 :
    • Setting up Subforms - Part 1
    • Lecture 2 :
    • Setting up Subforms - Part 2
    • Lecture 3 :
    • Setting up Subform - Part 3
    • Lecture 4 :
    • Exercise 06
  • Section 15 : Chapter 15: Queries 4 Lectures 00:50:40

    • Lecture 1 :
    • Creating a Query
    • Lecture 2 :
    • Joins
    • Lecture 3 :
    • Query Wizard
    • Lecture 4 :
    • Exercise 07
  • Section 16 : Chapter 16: Expressions 2 Lectures 00:21:41

    • Lecture 1 :
    • Setting up Validations
    • Lecture 2 :
    • Calculation using Expressions
  • Section 17 : Chapter 17: Reports 4 Lectures 00:44:35

    • Lecture 1 :
    • Basic Report
    • Lecture 2 :
    • Report Design
    • Lecture 3 :
    • Complex Report
    • Lecture 4 :
    • Exercise 08
  • Section 18 : Chapter 18: Printing 1 Lectures 00:09:28

    • Lecture 1 :
    • Printing and Print Properties
  • Section 19 : Chapter 19: More Data Types 1 Lectures 00:12:23

    • Lecture 1 :
    • Yes/No, OLE Object, and Hyperlink Data Types
  • Section 20 : Chapter 20: More About Forms 3 Lectures 00:37:48

    • Lecture 1 :
    • Form Controls
    • Lecture 2 :
    • Form Themes
    • Lecture 3 :
    • Form Navigation
  • Section 21 : Chapter 21: Modal, Dialogs, and Macros 5 Lectures 01:00:40

    • Lecture 1 :
    • Introduction to Model Dialog and Macros
    • Lecture 2 :
    • Model Dialog and Macros Continued
    • Lecture 3 :
    • Form Validation
    • Lecture 4 :
    • Adding a Command Button to a Form
    • Lecture 5 :
    • Exercise 09
  • Section 22 : Chapter 22: Web App Basics 3 Lectures 00:28:55

    • Lecture 1 :
    • Creating an Access Web App
    • Lecture 2 :
    • Importing an Access Database to a Web App
    • Lecture 3 :
    • Exercise 10
  • Section 23 : Chapter 23: Exporting 1 Lectures 00:04:55

    • Lecture 1 :
    • Exporting an Access Database
  • Section 24 : Chapter 24: Application Parts 1 Lectures 00:05:07

    • Lecture 1 :
    • Adding Application Parts to a Database
  • Section 25 : Chapter 25: More Access Options 1 Lectures 00:07:13

    • Lecture 1 :
    • Additional Access 2016 Options
  • Section 26 : Chapter 26: Info Tab 1 Lectures 00:07:27

    • Lecture 1 :
    • View and Edit Database Properties, and Encrypt with Password
  • Section 27 : Chapter 27: Security 1 Lectures 00:08:16

    • Lecture 1 :
    • Trust Center Settings
  • Section 28 : Chapter 28: Conclusion 1 Lectures 00:01:12

    • Lecture 1 :
    • Closing
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

147037 Course Views

2 Courses

Simon Sez IT has been teaching online for over ten years. It all started when the owner, Chris “Simon” Calder was working as a Project Manager in IT. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel. ®️ Our approach to teaching comes from our passion to fully explain how something works. We don’t skirt around the edges. We think that if you’re going to teach something, teach it right. Take the time to explain the ins and outs, back it up with practice exercises and tests and always teach in a visually easy to follow way - video. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you’re new to a certain technology or just technology shy in general. Simon Sez IT makes business and technical software simple to learn. We are experts in teaching people how to use the world's most popular software including Microsoft Office, Adobe Photoshop Elements and QuickBooks. We help people increase their productivity, achieve their personal and professional goals and get home from work that little bit earlier.
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • cisco-ccna-r-s-200-125-the-complete-course

    Cisco CCNA R/S (200-125): The Compl...

    By : Lazaro (Laz) Diaz

    Lectures 153 Beginner 16:30:13
  • implementing-configuring-cisco-routers-part-1

    Implementing & Configuring Cisco Ro...

    By : Dariusz Lipski

    Lectures 10 Beginner 0:40:56
  • ccnp-switch-300-115-the-complete-course

    CCNP Switch (300-115): The Complete...

    By : Lazaro (Laz) Diaz

    Lectures 93 Beginner 7:58:8
  • ccnp-route-300-101

    CCNP Route (300-101)

    By : Lazaro (Laz) Diaz

    Lectures 91 Beginner 8:36:24
  • ccna-wireless-200-355-the-complete-course

    CCNA Wireless (200-355): The Comple...

    By : Lazaro (Laz) Diaz

    Lectures 41 Beginner 3:51:39
  • odoo-the-complete-master-class-beginner-to-professional

    Odoo: The complete Master Class: B...

    By : Abhilash Nelson

    Lectures 32 Beginner 3:52:14

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.