Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 20.5 hours on-demand video
  • 7 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Microsoft Access

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.
Rating: 4.4 out of 54.4 (633 ratings)
4,354 students
Created by Simon Sez IT
Last updated 5/2020
English
English [Auto], Indonesian [Auto], 
30-Day Money-Back Guarantee

What you'll learn

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

Requirements

  • A working knowledge of Microsoft Acccess 2016 and including how to create and manage databases.
  • Microsoft Access 2016

Description

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!

Who this course is for:

  • 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

Featured review

Paul Mitchell
Paul Mitchell
22 courses
7 reviews
Rating: 5.0 out of 5a year ago
Toby! hope you don't mind me calling you Toby. Your Course was 1st Class, well put together and your explanations were easy to understand. The speed of your course for me was good, and I was able to understand you, me being an older person. Well done and Thank You.

Course content

43 sections • 126 lectures • 20h 34m total length

  • Preview06:19
  • Essential Information for a Successful Training Experience
    01:19
  • Course Exercise Files
    00:23
  • Course Demo Files
    00:23
  • Preview08:44
  • Preview02:17
  • Preview02:32
  • Section 1 Quiz
    1 question

  • Using Access in a Touch Device
    07:05
  • Section 2 Quiz
    1 question

  • Preview14:46
  • Preview08:45
  • Preview13:44
  • Section 3 Quiz
    1 question

  • Online Help and Tell Me
    09:17
  • Section 4 Quiz
    1 question

  • The Ribbon
    09:53
  • The Quick Access Toolbar
    05:31
  • Contextual Menus
    03:51
  • The Status Bar
    04:05
  • Section 5 Quiz
    4 questions

  • Keyboard Shortcuts
    03:34
  • Key Tips
    03:10
  • Section 6 Quiz
    1 question

  • General, Current Databases, and Language Options
    12:03
  • Section 7 Quiz
    2 questions

  • Preview14:45
  • Indexed Field
    11:37
  • Lookup Wizard
    14:31
  • Numeric Fields
    10:43
  • Exercise 01
    04:22
  • Section 8 Quiz
    6 questions

  • Importing Data from Excel
    14:59
  • Excercise 02
    05:19
  • Section 9 Quiz
    2 questions

  • Backing up your Database
    06:45
  • Compact and Repair
    07:19
  • Section 10 Quiz
    1 question

Instructor

Simon Sez IT
460,000+ Students | Wordwide Use 180 Countries |150+ Courses
Simon Sez IT
  • 4.4 Instructor Rating
  • 46,299 Reviews
  • 477,804 Students
  • 168 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.