Master Microsoft Access 2013 & 2016 for Beginners
3.9 (30 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Master Microsoft Access 2013 & 2016 for Beginners to your Wishlist.

Add to Wishlist

Master Microsoft Access 2013 & 2016 for Beginners

Everything you need to know to fully understand MS Access 2013 & 2016. 28 hours of helpful professional training.
3.9 (30 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Created by Simon Sez IT
Last updated 1/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 31 hours on-demand video
  • 7 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Using touch devices
  • Sorting information and running queries
  • Safeguards and restrictions
  • 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
View Curriculum
Requirements
  • Microsoft Access 2013 or Microsoft Access 2016
Description

Become a super star Access 2013 & 2016 user everyone relies on with this big 29-hour course with 3 courses, over 160 video tutorials.

  • Starts from the very beginning
  • No Microsoft Access experience needed
  • 3 courses for learning Microsoft Access
  • 160+ expertly produced videos
  • A full 28 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

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 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 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 Access 2016 beginner course

Microsoft Access 2016 For Beginners starts at the very beginning show you where to get your copy of MS Access and how to install it on your computer. Before we go further, you get a quick tour of all the new features and improvements in 2016.

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

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

Now it's time to create your own working database. Videos step you through the process helping you master details while understanding the big picture.

Later the course goes into importing data from Excel, creating and working with forms, and lots of great information on sub-forms. As you become more advanced, you learn Queries, using Validations, how to create Reports, and Printing your projects.

This course contains a big 10 Chapters with multiple videos in each chapter for a total of 70 videos. Get started with this course now to easily become expert at MS Access 2016.

Who is the target audience?
  • Anyone new to Microsoft Access
  • Users new to Microsoft Access 2013 or 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
172 Lectures
31:12:11
+
Access 2013: Introduction
4 Lectures 25:58

Essential Information for a Successful Training Experience
01:36

Access 2013 Exercise Files
00:25

What's New in Access 2013
09:26
+
Access 2013: Using Touch
1 Lecture 05:53
Using Touch
05:53
+
Access 2013: Getting Started
2 Lectures 21:57
Database Templates; Creating, Opening and Saving Databases
11:26

Workspace and Backstage View
10:31
+
Access 2013: Help
1 Lecture 05:49
Online, Offline, and Contextual Help
05:49
+
Access 2013: Keyboard Shortcuts and Key Tips
1 Lecture 05:57
Finding Keyboard Shortcuts and Key Tips
05:57
+
Access 2013: Access Options
1 Lecture 11:23
Customizing the Settings and Use of Access 2013
11:23
+
Access 2013: The Ribbon and Toolbars
2 Lectures 16:11
The Ribbon
11:22

Quick Access Toolbar
04:49
+
Access 2013: Status Bar
1 Lecture 03:42
Customizing the Status Bar
03:42
+
Access 2013: Database Basics
2 Lectures 27:25
Overview of the Main Features of Access Database
16:43

Web App Basics
10:42
+
Access 2013: Tables
4 Lectures 53:24
Creating Tables - Part 1
15:29

Creating Tables - Part 2
14:46

Relationships Between Tables - Part 1
14:32

Relationships Between Tables - Part 2
08:37
59 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,456 Reviews
302,971 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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 80+ courses and 4,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.