In this Microsoft Access 2016 tutorial, I demo concepts and skills you’ll need to pass your Microsoft Office Specialist Certification Exam. This Office 365 tutorial on Windows 10 covers all of the different tabs, and objects you’ll need to use during the exam. By applying what you learned in this video you’ll be on your way to passing the MOS exams. I go over specific examples of what you’ll see, so that you can practice on your own. I cover all of the access objects you’ll see like tables, forms, queries, reports, and relationships. This is meant for beginners who want to learn how to use Microsoft Access Database Management software, so please feel free to add a comment below if you have any questions or requests.

My goal is to provide you with the best learning experience possible, for all beginners of technology. Please see a list of topics below that my various playlists cover, and don’t forget to like and subscribe!

Computer Fundamentals:
Computer Case Types – Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive – Creating Uploading Downloading and Syncing

Also, check out these other playlists to improve your Office 365 and Job Search Skills

Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format from Default Formatting
Table of Contents Tutorial

Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep – Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The Vlookup Function
The MIN or MINIMUM Function
Histogram Charts

Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
Import Excel Spreadsheet into Access
Create a Table in Design View
Modify the Structure of a Table
Create a Subform
MOS Prep – Basic Certification Exam Practice Study Guide

PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists

Outlook 2016
Basic Tutorial

YouTube Analytics:
100 Subscribers
200 Subscribers

Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites

Video Requests:
Download GMetrix Test Preparation Software

Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you’d like to learn in our class. So, I encourage you to make a request. I also YouTube Live Stream once a week to answer your questions!

Instructor A Morgan

Nguồn:https://madisonrep.org/

27 Comments

Pedro Ferreira

February 22, 2020

Dear Professor, have you any video with the book guide exercises properly solved? Thank you very much.

Reply

The Brown Babe

February 22, 2020

Why can't you just do a step by step of the actual tasks? you could have covered objective 1-1 in less time than the length of this video. Then a video for objective 1-2, 1-3, etc. Cover each section and each segment within them, (objectives: 1-1, 1-2, etc.). At the end of said segments, Provide some insight and maybe clarification on things you know might be confusing or show easier, real life ways to accomplish the covered tasks, that differ from the specific steps the exam calls for.

Reply

Rishit Jajoo

February 22, 2020

Thank you for your videos and playlist! Thanks to you, I received a 977 on my MOS access exam!

Reply

Pavan Jajoo

February 22, 2020

Can you make a video on how to use the query wizard(crosstab and simple). Thanks

Reply

La Porta D

February 22, 2020

This guy is flying through everything and doing the opposite of what he said. Like, how do you repair and save files and databases? He just skipped over it.

Reply

lord

February 22, 2020

Hi, I've a question, how do I add some size of separation between rows in a report? Like margin between rows

Reply

Christocream

February 22, 2020

Why do I get put into these horrible word, excel, pp, access classes every year. 4th time I have to pass all of this. Someone make a gmetrix access all projects complete for training 1 and 2 so I can stop getting my time wasted and finish important hw

Reply

The Quad Spot with Jessica Kennedy

February 22, 2020

MS ACCESS 2019 Error Message : The table is already in use
exclusively  by another user or it is
already open thru the user interface 
& can't be manipulated programmatically.

That doesn't make sense. I am a single user and
not attached to a network and get this message often.

Reply

Amy E Gunn

February 22, 2020

Hello Adam! I teach high school business education classes and am currently working to MOS certify in Access 2016 after earning Word, PPT, and Excel in previous years. Your videos have been very helpful, especially to make Access seem much less daunting. Taking GMetrix practice exams is my next step to prepare and then hopefully by the end of April I'll be ready to certify!

Reply

Nuf

February 22, 2020

Thank you. Great video helped me pass my exam today. Advice about jumping ahead is spot on 👍 time goes really fast

Reply

Thomas Srail

February 22, 2020

Thanks for this! I scored 724

Reply

Modhumita mondal

February 22, 2020

very helpful

Reply

Melissa Brown

February 22, 2020

This was a GREAT video. I've never taken a MOS exam and am prepping for this one. Do you also teach advanced MS Access Classes?

Reply

iamjohngalt

February 22, 2020

Just found this video series and I'm going to be taking the exam soon! Do you have any advice on the exam itself? Format, what we have to do and how much time we have to do it?

Reply

Sierra

February 22, 2020

Hi Professor Adam Morgan, Today I have completed Access Tutorial with the help of your videos . I wanted to thank you. You taught very well and shared your knowledge and expertise with everyone. Its really appreciated. After few days I'm going to start my college and I have done this subject already with your help. Thank you very much.
God Bless You and will give you reward. Aamen.

Reply

Shayan Dossani

February 22, 2020

How to design a query that can only take active checks from datatype checkbox

Reply

Angela Glinskie

February 22, 2020

Professor, I really appreciate your videos. They are very informative. I have found however, that it can be difficult to practice these skills if you don't have files, a document, spreadsheet etc to work with. Would you have any practice files you could share so that we could practice our skills as we go?

Reply

Jacqueline Wellington

February 22, 2020

Is there a training program for MS Access course online

Reply

craigslist176

February 22, 2020

Can you please do a MOS Exam for Outlook video? Thank you for your time.

Reply

Amy Muscat

February 22, 2020

Very helpful, thank you. Much appreciated.

Reply

John Davy

February 22, 2020

Very well done! Thanks, I look forward to watching more.

Reply

Cristina Gonzalez

February 22, 2020

Hello. This is one of the Gmetrix skills, I know how to work it out on the gmetrix. But I got one similar on the test.
Append all of the records from the Q2sales.xlsx file located in the Gmetrix Templates folder into Q1 Sales.
1). On the external data tab, in the Import & links group click excel.
2). Excel spreadsheet pop-up window click browse.
3). Browse to the gmetrix templates folder and select Q2 salesxlsx click open.
Their are more 4 steps.

When I was doing it on my test (step3) the excels spread sheet pop-up window was white with out gmetrix files and there were no doc on documents.

I didn't know why it was like that.
I did at my house and I got it right.

Reply

LittleBoxxx x

February 22, 2020

Is there any reason at all to learn MS Access vs MySQL?

Reply

lmk001

February 22, 2020

Passed. Weird question I got about adding a shortcut like Alt+R to a Form control. I have no clue how to solve that. Maybe add that in one of your videos.

Reply

lmk001

February 22, 2020

Very good! Thanks!

Reply

Karen F

February 22, 2020

Hi please can you do a video on the properties sheet and use of this. I am finding your videos REALLY helpful. Thank you. 🙂

Reply

Julia wang

February 22, 2020

Hi, I remembered there was a question asked me to unhide a table, so I check the "Show Hidden Objects" box in the Navigation Options", and the previously hidden table was shown but it was color grey, and next step was to right click and click "unihide in this group", i did this on my laptop and there was no problem, but during the exam, when I right clicked, there was no 'unihide in this group' option, so the "grey" table stayed "grey" (not unhide completely). Do you know how to completely unhide a table if there is no "unihide in this group" option? Thank you

Reply

Leave a Reply