Microsoft Access 2016: Beginner to Intermediate Course

Microsoft Access 2016 Course - Beginner to Intermediate

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

Created by : Rated :4.1 57870 views

Last Updated: 2024-11-21 07:11:36 English Course Type: Self Learning

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

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?

Simon Sez IT,

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