Access 2016 - MOS Exam Tutorial Playlist - MS Database for Beginners, Microsoft Office Certification

This tutorial goes over the basics of the Microsoft Access Start Screen, as well as some of the buttons and tools that you'll see upon opening the program. This is not a full Access tutorial, but covers some key concepts of setting up a Database.

Here is a full list of tutorial videos available on my channel:

Windows 10:
Perform Basic Mouse Operations
Create Folders
Explore the Windows 10 Desktop, Taskbar, and Start Menu
Select Multiple Files and Folders
Download a File From a Website
Use File Explorer to Access OneDrive and Upload Student Data Files
Capture an Image of the Entire Screen
Explore the Control Panel and the Settings App
Personalize the Desktop
Modify Screen Brightness and Resolution
Explore the Control Panel and the Settings App
Personalize the Desktop
Adjust the Sound
Plan the Organization of Files and Folders
Run an App

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
Format Paragraphs
Create a Custom Word Template
Preview and Print a Document
Change Document and Paragraph Layout
Use AutoComplete and AutoCorrect
Correct and Reorganize Text
Header and Footer Tutorial
Page Numbers Tutorial
Captions in Word
Review Document Headings in the Navigation Pane
Reorganize Document Text Using the Navigation Pane
Collapse and Expand Body Text in a Document
Use Continuous Section Breaks for Page Layout
Insert Page Numbers Starting from a Specific Page
Format Text
Undo and redo Commands or Actions

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
Use the Sum Button to Sum a Range of Cells
Enter Formulas Using the Keyboard
Format Cells with Merge & Center, Cell Styles, and Themes
Chart Data to Create a Column Chart & Insert Sparklines
Select Cells and Ranges
Use CountIF and IF Functions and Apply Conditional Formatting
Use Date &Time Functions and Freeze Panes
Use Goal Seek to Perform What-if Analysis
Add Fill Colors and a Background Image
Insert Functions from the Formula Library
Use the PMT Function to Calculate a Loan Payment

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
Add Existing Fields to a Form
Create a Query, Form, and Report
How To Use the Property Sheet
Open and Save an Existing Database
Create Table Relationships
Learn Basic Database Concepts and Terms

PowerPoint 2016:
Create a New Presentation
Edit a Presentation in Normal View
Add Pictures to a Presentation
Format Numbered and Bulleted Lists
Customize Slide Backgrounds and Themes
Animate a Slide Show
Apply a Theme Used in Another Presentation
Search for and Download an Online Theme
Microsoft Office Specialist Exam Certification
Print and View a Presentation
Lighten Background Images in Microsoft Office

Outlook 2016
Basic Tutorial

Office 2016:
Identify the Components of the Microsoft Office Ribbon

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
Explain the Importance of File Management
Troubleshoot Common Computer Problems

Job Search Skills:
Values, Attitude, and Goals
Top 5 Job Search Websites
Prepare For Your Interview
Negotiating Your Salary
7 Steps of Goal Setting
Resume Writing - Final Draft
The Importance of Networking

Instructor A Morgan

[steve]

Best tutorials on the web, clear, concise and to the point thanks!

[mikyongphilson]

I love how he explains things... easy to understand. Thank you so much!

[NazMash-hu]

I have watched many access tutorials ...most are long and boring, ,,this one is amazing, , , go to point and very helpful

[bambynaa]

Professor - This is a great tutorial! Much better and clearer than my book! Thank you so much.

[victorvonderkrausse]

There is possible to add a a empty record in datasheet view and how ?
I mean like in excel adding a row in between, I have a table with data and I want to introduce a empty record between the months, like introducing a empty row in excel for differentiate the data !

[YeseniaLopez-dd]

Thank you so much this is so helpful my professor didn't even do any videos

[RafaelBCastillo]

Thanks. This is the only video that gets to the point of "doing". I am learning MS access and I like doing. I don't see that you have any more MS Access videos.

[ezeamadelightchika]

🎉❤ thank you my professor please keep sending me your tutorials your the best

[sallycrompton]

Hi. I'm wondering how best to include a list of project delivery dates (agreed with client) and record/find which Associates have committed to work these. Any advice would be very welcome. Thank you

[mirandagrowe]

Hello, I am having trouble figuring out what the difference between importing a excel file is and appending an excel file?

[melindasfamily]

thank yo so much. you helped me understand.

[tbztbz]

1st, great job on presenting your information; I do have a question on importing excel files to existing Access table. The Access table uses a self numbering key, thus the excel file does not have the key in it. The file I am importing is for a club, the club holds 5 events during the year, so I have an event No field, competitors ID and 7 more fields which are times for stages. what I am looking to do is import the file in to the access table for each event and the issue is the key field numbering, someone told me you might want to use the event number combined with the member id to produce the key field, but I don't fully understand how to accomplish that either. Are you able to explain how to import an excel file to access with either no key field on the import or using 2 fields to create the key? Thank you

[ccyfurniture]

how to create the qr code at accesss? from microsoft excel to access?

[lilyali]

My tool bar keeps moving up and down. How can I fix it

[pokemonunitewithak]

Do video on ime mode, ime sentence and smart tags in ms access

[DaleDansie]

Hope you can help me. About 10 years ago I used one of the really early MS Acces. I was able to create a form where the user could start entering in a location and it would automatically pull from a different table the location. I can't figure out how to do that in Access 2016. Please help if you can. Thank you

[berhaneashenafi]

How to modify the report in Design View by completing the following:
a. Add a rectangle control around the two labels in the Page Header section.
b. Change the shape fill of the rectangle control to transparent. in access
thank you

[marvinmckinney]

Hi, I'm looking to group dates into weeks, then have the week begin on a Monday then end on Sunday. I've determined how to group the weeks to display Week 1, Week 2 etc. I'm just having an issue with starting the week on Monday. Thanks!

[LoyolaLauv]

I have some tests on this. Thank you so much