Course Information
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Course Overview
Learn the essentials of Microsoft Access 2016 in easy to follow steps
During this introductory course on using Microsoft Access 2016, we'll teach the basics of using Microsoft Access 2016.
We'll start with navigating the Access 2016 interface, including the Ribbon, Backstage View and the Quick Access Toolbar.
Discover concepts to help you understand how to create database fields and tables, using numeric and indexed fields, and importing data from Excel into your database.
Contents and Overview
This easy to understand course starts at the very beginning, specifically designed for those with little or no Microsoft Access experience. The first task is to find the software and install it on your computer.
Then we discover the new and improved features added to the 2016 version. There are new features that could be a big help in your job, your business, or in personal projects.
We start with essential first steps. You will learn to create an Access database, save it, then open it. We show you simple ways to use Microsoft's powerful online and contextual help, so you are never left wondering when you have a question or encounter a challenge.
Along the way we keep in mind you will want to personalize Access to accomplish the things you want. We learn all about Ribbons and Toolbars that make Access extremely flexible.
Next, we move on to create tables and fields to store your data, in addition to discussing the use of indexed and numeric fields.
All along the way there are plenty of exercises and quizzes that help you fully understand all the concepts and solidify them in your memory.
This is the course you need to learn the most important ways to expertly use MS Access 2016. It assumes you are just beginning with Access and easily steps you through the process of being highly proficient with this widely used tool.
This course is for absolute beginners, thus is appropriate for those new to Access and who appreciate a methodical, patient and conversational pace.
Here’s what our students are saying…
“I am using access and this course is very informative. I want to say think you for taking your time and explaining each step. I recommend this course to everyone who wants to improve their access knowledge.”
- Adam Hanek
“As a Windows users for a number of years, I have never used the Access database program. having the opportunity to begin to learn how it works is very useful; to to me. The instructor was very good and clear and understandable. I am now taking his advanced course.
- Daryl Beecham
“Outstanding course! I will use the as a reference for years to come. I am 100% satisfied.
- Larry Reid
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!
** Updated July 2017. English close captions added
Course Content
- 13 section(s)
- 38 lecture(s)
- Section 1 Introduction
- Section 2 Using Touch
- Section 3 Getting Started
- Section 4 Help
- Section 5 The Ribbon and Toolbars
- Section 6 Keyboard Shortcuts and Key Tips
- Section 7 Access Options
- Section 8 Tables
- Section 9 Importing Data
- Section 10 Backup, Restore, and Repair
- Section 11 Datasheet View
- Section 12 Relationships
- Section 13 Bonuses
What You’ll Learn
- Practice what you learned with included exercise files
- Creating tables and relationships
- Navigating the Access 2016 interface
- Learn valuable new skills for complex data projects at work
- Discover how to into import data from Excel into your database
- Creating, saving and opening an Access 2016 database
- Working with and using index fields
- How to backup and repair your database
Skills covered in this course
Reviews
-
HHoward Samuels
It gives a lot of theory and not enough practical in my opinion. Probably I need to get the advance course to get more practical help I think I would benefit from.
-
KKashif Ahmed
It is a good course for absolute beginners. However, I didn't like the fact that at few places, it was very slow and few sections were explained with the help of Access 2016 Help. Instead of just showing the reference, but explaining the topic without Access Help.
-
BBian Tagal
Course instructor delivers in a clear manner, seems really into it, and of last but not least the course is free.
-
HHesham Hamdy
It's really a great start for any one new to Access, especially 2016 version. I have got all fundamentals to build my first simple database