Access 2016 – MOS Exam – Microsoft Office Specialist Certification Test – How to Pass Using MS 365

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/