Udemy

The Ultimate Microsoft Access 2013 & 2016 Mastery Course

Enroll Now
  • 2,319 Students
  • Updated 3/2024
  • Certificate Available
4.4
(81 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
22 Hour(s) 44 Minute(s)
Language
English
Taught by
Simon Sez IT
Certificate
  • Available
  • *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
4.4
(81 Ratings)

Course Overview

The Ultimate Microsoft Access 2013 & 2016 Mastery Course

37 Hours of Training. The Most Convenient Way to Boost Your Confidence And Learn Access Databases Inside And Out—Quickly

Become a super star Access 2013 & 2016 user everyone relies on with this mega 37-hour course with 4 courses, over 200+ video tutorials.  

  • No Microsoft Access experience needed

  • 4 courses for learning Microsoft Access 2013 & 2016

  • 200+ expertly produced videos

  • A full 37 hours of instruction

  • Makes all aspects of Access easy to master

  • Covers exciting features new for 2013 & 2016

  • Learn to use full program, not just basics

  • Get up and running quickly

  • Immediately learn things you can use at work

  • Supercharge your personal projects

  • Become the MS Access expert everyone appreciates

  • Work at your own pace in your spare time

  • Practice what you learned with      included exercise files

Contents and Overview

Through 200+ lectures, 37 hours of quality content, and quizzes, this 37-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 & 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 Access 2013 beginner and advanced courses

Through 96 lectures, 19 hours of quality content, this training  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.

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!      

Here’s what our students are saying…

“First course I completed on Udemy. The package of lessons are well thoughout and to the point. Great instructor. Set the bar high for other instructors on this site"

– John Meaney

"I took this class as a requirement for a new job. I have never touched access before and I was able to pick it up very quickly with this video. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks. The instructor was very easy to understand and everything was presented at great pace. Since learning how to use access with this class, I have been to create my own database to practice my skills and learn new ones. I would recommend this class to anyone who would like to get a great understanding of access."

– Greg Wehner

"I've taken both the basic and advanced course and found both very helpful in refreshing my Access skills and introducing techniques that were very useful in my actual work situation"

–  Ron Woods




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!

Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.

Course Content

  • 83 section(s)
  • 225 lecture(s)
  • Section 1 Introduction
  • Section 2 Using Touch
  • Section 3 Getting Started
  • Section 4 Help
  • Section 5 Keyboard Shortcuts and Key Tips
  • Section 6 Access Options
  • Section 7 The Ribbon and Toolbars
  • Section 8 Status Bar
  • Section 9 Database Basics
  • Section 10 Tables
  • Section 11 Datasheet View
  • Section 12 Table Design
  • Section 13 Forms
  • Section 14 Queries
  • Section 15 Reports
  • Section 16 Printing
  • Section 17 Importing and Exporting Data
  • Section 18 Templates and Application Parts
  • Section 19 More on Forms
  • Section 20 Macros and VBA
  • Section 21 Additional Topics
  • Section 22 Security
  • Section 23 Conclusion
  • Section 24 Microsoft Accesss 2013 Advanced Course - Introduction
  • Section 25 Indexes
  • Section 26 Datasheet View
  • Section 27 Linking Access Databases
  • Section 28 ODBC and SQL Server
  • Section 29 Splitting an Access Database
  • Section 30 Multi-user Aspects
  • Section 31 Macros
  • Section 32 The Ribbon
  • Section 33 Visual Basic for Applications
  • Section 34 Events
  • Section 35 Forms
  • Section 36 SQL
  • Section 37 Joins
  • Section 38 Action Queries
  • Section 39 Packaging your Application
  • Section 40 Web Apps
  • Section 41 Conclusion
  • Section 42 Access 2016 Beginners - Introduction
  • Section 43 Using Touch
  • Section 44 Getting Started
  • Section 45 Help
  • Section 46 The Ribbon and Toolbars
  • Section 47 Keyboard Shortcuts and Key Tips
  • Section 48 Access Options
  • Section 49 Tables
  • Section 50 Importing Data
  • Section 51 Backup, Restore, and Repair
  • Section 52 Datasheet View
  • Section 53 Relationships
  • Section 54 Forms
  • Section 55 Subforms
  • Section 56 Queries
  • Section 57 Expressions
  • Section 58 Reports
  • Section 59 Printing
  • Section 60 More Data Types
  • Section 61 More About Forms
  • Section 62 Modal, Dialogs, and Macros
  • Section 63 Web App Basics
  • Section 64 Exporting
  • Section 65 Application Parts
  • Section 66 More Access Options
  • Section 67 Info Tab
  • Section 68 Security
  • Section 69 Conclusion
  • Section 70 Access 2016 Intermediate/Advanced - Introduction
  • Section 71 Primary Keys and Indexes
  • Section 72 Using Datasheet View
  • Section 73 Linking to Other Access Databases
  • Section 74 Using ODBC and SQL Server
  • Section 75 Splitting An Access Database
  • Section 76 Macros
  • Section 77 The Ribbon
  • Section 78 Visual Basic for Applications in Access 2016
  • Section 79 Access Events Model
  • Section 80 Forms
  • Section 81 Advanced Use of Queries
  • Section 82 Packaging Your Application
  • Section 83 Conclusion

What You’ll Learn

  • Sorting information and running queries
  • Creating tables and relationships
  • Navigating the Access Interface
  • Designing forms
  • How to use queries
  • Generating reports
  • Discover how to effectively link to other data sources
  • Learn how to split a database by splitting the frontend and backend
  • Find out about the use of macros
  • 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 what you learned with included exercise files
  • Sorting information and running queries
  • 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 advanced options for the use of forms
  • Dive into options for packaging your application for distribution


Reviews

  • C
    Carlos A Maestre Silva
    5.0

    Excellent. The quantity of covered material is amazing. The courses files are excellent. You can use for reference or even copy and paste and use in your own databases. But if you really want to learn you must do the exercises, they are not easy but if you have pay attention to the course, you can do it. Don't go forward without.

  • A
    Aydın Saygın
    3.0

    Kursu kapsamlı ve faydalı buldum, Aslında 5 yıldız vermeyi düşünüyordum fakat sormuş olduğum soruya cevap verilmediğinden dolayı daha düşük not verdim. Eğer soru sormayacaksanız kursu almanızda fayda var. Fakat ben bunu önemli bir eksiklik olarak görüyorum. Kurs oluşturucusu daha yüksek ve satılabilir olmasını istiyorsa lütfen kurslarıyla biraz ilgilensin sorulan sorulara cevaplarını versin.

  • P
    Pierre de Man
    4.5

    So far, I did the first quarter of the course. It is nice, but sometimes near the end of a sentence, the instructor lowers his voice and speaks softer and sometimes it is difficult to understand. You need to listen very careful.

  • G
    Giovanni Vignato
    5.0

    This course is really well made.

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed